Loan Amortization template

%3CLINGO-SUB%20id%3D%22lingo-sub-2225281%22%20slang%3D%22en-US%22%3ELoan%20Amortization%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225281%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20loan%20amortization%20template.%20I%20entered%20all%20the%20information%20for%20the%20loan%2C%20but%20it%20only%20calculates%20and%20displays%2010%20payments.%20I%20can%20manually%20enter%20the%20next%20payment%20number%20and%20it%20calculates%20and%20displays%20the%20info%20for%20that%20payment.%20How%20can%20I%20get%20it%20to%20fill%20in%20the%20table%20without%20manually%20entering%20every%20payment%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2225281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2225343%22%20slang%3D%22de-DE%22%3ESubject%3A%20Loan%20Amortization%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225343%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1003618%22%20target%3D%22_blank%22%3E%40Pat_Mutzabaugh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ETake%20a%20look%20at%20this%20little%20example%20(file)%2C%20believe%20that%20this%20will%20help%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

10 Replies

@Pat_Mutzabaugh 

 

Take a look at this little example (file), believe that this will help you

 

 

I would be happy to know if I could help.

 

Nikolino

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.

@Pat_Mutzabaugh 

I'm looking for the same answer.  I want to see all of the payments for the duration of the loan.

@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. 

"the template"

There are many templates out there which purport to calculate payment schedules. I'd be happy to forward your suggestion to the Microsoft team responsible for templates that Microsoft produces or distributes--there are others that they don't, of course--but would need to know which template is the one you are talking of.

Hi @MMoorman11,  @Pat_Mutzabaugh@Bk4hire

 

If you talk about the following Loan Amortization Schedule template:

 

_Screenshot.png

 

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)

@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.  

When I open Excel and go to templates, it is the template that says Loan Amortization template. There are not "many", only that one.

@MMoorman11 

You hadn't named it before, not with caps, so the description was generic...and for what it's worth, there are many on the internet. You even acknowledge as much in your reply to @L z. , saying that you've found a better one. I hope it is the turnkey solution you want.

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.