Forum Discussion
Loan Amortization template
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.
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.
- When I open Excel and go to templates, it is the template that says Loan Amortization template. There are not "many", only that one.
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 Lorenzo , saying that you've found a better one. I hope it is the turnkey solution you want.