Mar 20 2021 12:23 PM
Mar 20 2021 12:23 PM
I am using the loan amortization template. I entered all the information for the loan, but it only calculates and displays 10 payments. I can manually enter the next payment number and it calculates and displays the info for that payment. How can I get it to fill in the table without manually entering every payment?
Mar 20 2021 01:53 PM
Take a look at this little example (file), believe that this will help you :)
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Apr 27 2022 05:40 AM
@Pat_Mutzabaugh I am also looking for the same thing and see no good answer yet! Seems like the template simply needs to be fixed. I suppose you could add a new tab for each set of 10 payments but that's a lot of work when the problem seems to be the person who created the template. I wish they'd get on here and answer the question. I have a 3 year loan with 12 monthly payments per year so I should have 36 payments and a 0 balance at the end but I only have 10 payments. It makes no sense.
Apr 27 2022 06:13 AM
Apr 27 2022 06:31 AM - edited Jul 24 2022 01:21 AM
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
Apr 27 2022 09:11 AM
@L z. 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.
Apr 27 2022 09:12 AM
Apr 27 2022 11:01 AM
May 31 2022 06:20 PM
Jul 23 2022 10:01 AM
Jan 26 2023 09:38 AM
@L z., @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.
Jan 27 2023 12:07 AM
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)
Sep 20 2023 09:27 AM
Easy fix, go to the empty cell just below your last month, in my case it went to month 10, in the box below 10, type in month 11, and repeat on down the column and it solves your problem. Have a great day. SOrry only a couple of years late on an answer.