Question

I need assistance to solve this problem:

On September 1, 2018, you bought a car for $23,000. You paid down $1,200, and finance the rest for 5 years at 6.5% compounded monthly. You paid the monthly payments from October 1, 2018 until October 2020. Then decided to payoff the loan. The bank charge you a 2% prepayment penalty.

- How much would you payoff the loan on November 1, 2020?

Step 1

**Calculation of payoff the loan on November 1, 2020:**

First it is required to calculate the total monthly payments of the car for the loan period of 5 years. Using an excel function =PMT, the monthly payment for 5 years is $426.54. The excel spreadsheet is shown below:

Step 2

**The excel spreadsheet workings are shown below:**

Step 3

**Calculate the amortization schedule for 24 monthly payments:**

We calculate the amortization schedule for 2 years or 24 months because the loan is paid from October 1, 2018 until October 2020, which have 24 months. In other words, th...

Tagged in

Q: If I have that the standard estimator of the volatility parameter is 0.2491, how can I estimate the ...

A: The geometric Brownian motion (BM), in stock prices is given by the relationship: S(t) = S0eX(t)wher...

Q: 2. Present value Aa Aa Finding a present value is the reverse of finding a future value. Which of th...

A: Present Value is a value of today for all the cashflows generated in the future period of time. The ...

Q: Mexican Motor's market cap is 200 billion pesos. Next year's cash flow is 8.6 billion pesos. Securit...

A: Mexican Motor's market cap, E = 200 billion pesos.Next year's cash flow, C = 8.6 billion pesos.Secu...

Q: A store will give you a 4.00% discount on the cost of your purchase if you pay cash today. Otherwise...

A: Let's assume the cost of purchase is C. On immediate payment,Discount = 4%Hence, the discounted cost...

Q: And what are the expected returns for stocks A and B if the conditions are as follows? A0 0.03...

A: Calculation of Expected Return for Stock A:

Q: Use the compound interest formula A = P(1 + i)n to find the indicated values A = $6,000; i = 0.03; n...

A: Compounded Interest: It is the method for computing interest at the initial amount of prin...

Q: What is the estimate of the marginal cost of the Phase 4 hospital servicesassuming, as given in the ...

A: Marginal costs are the incremental costs that will be incurred on hospital 4 services. The cost data...

Q: UBTECH Robotics is expected to generate the following free cash flows over the next fiveyears. After...

A: Let Ci be the free cash flow (FCF) for year i.Please note that the question talks about forecast of ...

Q: HBM, Inc. has the following capital structure: Assets $400,000 ...

A: a.Calculation of After-tax Cost of Debt:

Sorry about that. What wasn’t helpful?