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