Forum Discussion
Loan Amortization template
Hi MMoorman11, Pat_Mutzabaugh, Bk4hire
If you talk about the following Loan Amortization Schedule template:
IMHO the template works as expected. BUT, the Table (starting row #13) initially consists of 10 rows + the header (Payment Number, Payment Date...), hence the only 10 payments you get by default
If you have more than 10 payments, just increase the number of rows of that Table by resizing it (see para. Resize an entire table manually in Resize a table, column, or row), that's it 🙂
A 36 months loan amortization ex. is attached (No change applied, just resized the Table)
2022-07-24 Edit: Added a Conditional Formatting rule + a note on Actual number of payments. If the cell is highlighted there's not enough rows in the table ==> Resize it
- LorenzoJul 24, 2022Silver Contributor
TyBedrock Thanks for the positive feedback. Please take a look at the Edit on previous poste from Apr 27 2022. Hope this helps
- onelikeseanJan 26, 2023Copper Contributor
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.
- LorenzoJan 27, 2023Silver Contributor
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)