View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DA DA is offline
external usenet poster
 
Posts: 104
Default 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