Forum Discussion
Loan Amortization template
TyBedrock Thanks for the positive feedback. Please take a look at the Edit on previous poste from Apr 27 2022. Hope this helps
Lorenzo, mathetes Is it possible to have different "Extra Payment" amounts rather than the static option amount which the entire ExtraPayment column depends? I've found an Amortization Schedule w/Irregular Payments calculator, but the irregularity is limited to week, month, quarter, etc.. I need the irregularity capability to be per-payment for the life of the loan, whether that means an early pay-off or not.
I've been careful to not overmanipulate the data/formulas by using the Show Formulas option and stay within the confines of the template, but there's a LOT going on here behind the scenes.
No time to look at this these days + I'm not sure I fully understand what you exactly mean with "I need the irregularity capability to be per-payment for the life of the loan, whether that means an early pay-off or not"
A sample showing exactly what you expect would help (if you can't attach it, share it with i.e. OneDrive or any other file sharing service)
And please mention your Excel version + Operating System (Windows vs MacOS)
