Interest payment

[da]

For loan amount 12,000, interest rate 2%, loan term 3 years (36 payments),
how would you set up the columns and what would be the result in each cell
interest payment, principal payment, and loan balance each month and total
cost of the loan?
Thank you

 

[Xhawk57]

go look at the answer to your same question below.

 

[Elisabeth D]

this will walk you through it step-by-step

http://www.dailydoseofexcel.com/archives/2004/06/16/amortization-table/