View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default loan amortization loan in months

It's (almost) the same as in years, just use the number of months for duration and adjust the rate to a monthly rate.

Look at templates he

http://office.microsoft.com/en-us/ex...346401033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"weisse" wrote in message ...
|I do not understand accounting, however, I need to create/obtain a loan
| amortization in months, not years. Is there an easy way to create or does
| anyone know where I can obtain one?