| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
45 day Amortization Template
I am trying to create an amortization schedule with the first payment being
45 days instead of 30 days. I have tried manipulating the formulas but it doesn't seem to be working. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
45 day Amortization Template
Without more information, I have two suggestions:
1. Build your own table. 2. Calculate the amount owing 30 days before the first payment, and start from there. In other words, add 15 days interest to the principal, then use the standard amortization table. -- Regards, Fred "Leroy Grace" <Leroy wrote in message ... I am trying to create an amortization schedule with the first payment being 45 days instead of 30 days. I have tried manipulating the formulas but it doesn't seem to be working. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need CORRECT amortization template please | Excel Discussion (Misc queries) | |||
| Help with amortization template | New Users to Excel | |||
| Change years to months in loan amortization template | Excel Worksheet Functions | |||
| loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
| How do change the amortization of loan template to accommodate pa. | Excel Discussion (Misc queries) | |||
Linear Mode
