Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Amortization Schedule
Is there someplace where I can get instructions on creating an Amortization
Schedule without using the template? I'm using Office 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help making an amortization schedule | Excel Discussion (Misc queries) | |||
amortization schedule | Charts and Charting in Excel | |||
Amortization Schedule | Excel Worksheet Functions | |||
amortization schedule | Excel Discussion (Misc queries) | |||
Amortization Schedule | Excel Worksheet Functions |