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?

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