Question

A loan is amortized over five years with monthly payments at an annual nominal interest rate of 9% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 2% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.

Answer 1

Answer:

$7,112.73

Explanation:

We can use the financial calcualtor and some formulas or use the easy way and use excel goal seek.

We contruct the table and find the value of the principal cell that makes the principal after 60 payment zero with payment of $1,000 decreasing 2% each month

the following is made:

A1 period    

1 to 60  

B1 couta

1,000 x (power(0.98;period cell)

C1 interest

previous principal x 9/1200

D1 amortization B1 - C1 that is installment less interest

E1 principal: previous principal - current period amortization

--loan schedule is attached to provide more help--