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
Lorenzo I appreciate your reply but I'm using a template because I don't have time to take a lesson on how to build something in Excel so my opinion is that the template should have been built to accommodate, and automatically include, whatever number of payments someone needs. I'll look at your attachment but I think I already found a better template.
- I understand your frustration. Fortunately, I happened to have an older version of the template saved on my computer, so I have been able to use that. The older version worked fine. I don't know why they changed it. If it ain't broke, don't "fix" it.
