View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Amortization Schedule

hi
you can create your own by using the folowing formulas..
=cumprinc() - creates a decending princible balance
=cumipmt() - creates a decending intrest balance
you will have to copy down for the length of the loan for each formula
calculates off the previous loan balance. other amounts can be calculated.
for example...
principal payment this month = previous loan balance - current loan balance.
intrest payment this month = payment - principal payment this month.

I did this for my morgage and found it to be reasonably accurate. off from
the morgage company's numbers but only by pennys.
look up the 2 formulas above in xl help for details on how they work. Thats
what i did.

good luck
FSt1

"Richard" wrote:

Is there someplace where I can get instructions on creating an Amortization
Schedule without using the template? I'm using Office 2003.