Interest payment
 

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

Interest payment
 

go look at the answer to your same question below.

"da" wrote:

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

Interest payment
 

this will walk you through it step-by-step

http://www.dailydoseofexcel.com/arch...ization-table/

"da" wrote:

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