| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ammortization Schedule
Hi!
I want to calcuate the yearly ammoritzation loan that has already been in place for 5 years and expect to last for another 5. So I want to create a annual ammortization schedule that will calculate the ammortization amounts for the next 5 years. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ammortization Schedule
hi
look up these 2 formulas in xl help. =CUMPRINC() =CUMIPMT() one minus the other = intrest. Regards FSt1 "dipsy" wrote: Hi! I want to calcuate the yearly ammoritzation loan that has already been in place for 5 years and expect to last for another 5. So I want to create a annual ammortization schedule that will calculate the ammortization amounts for the next 5 years. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Course Schedule | Excel Discussion (Misc queries) | |||
| mortgage ammortization schedule | Excel Worksheet Functions | |||
| Schedule help | Excel Discussion (Misc queries) | |||
| Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
| Help with schedule | Excel Worksheet Functions | |||
Linear Mode
