Forum Discussion
excel amortization schedule issue
the excel amortization schedule will only calculate through payment 10, with the "actual number of payments" defaults to 11. I can change that number to the real actual number of payments, but the table itself will go no further than 10 payments
consultantsandy First you need to dive in to all the named ranges and named formulas and understand how they impact the amortisation schedule.
When you set the parameters to 2 years with 12 payments per year and no extra payments you can drag cell B23 down as far as needed (that is to period 24). All the formulas will update automatically. The payment number and all other formulas will be left blank once the ending balance is zero.
Example attached.
It won't let me change a formula. The month of Aug has the correct date, then the next month goes to October 1, and the following month to October 31. that is why i cannot go any further.
However, copying the formula from July (in case Aug formula was corrupted), does not change anything. I think because the Oct 1 date is not September 30, is causing me the problem.
I then tried to delete the spreadsheet. But when i access the Xcel amortization template, it is still wrong.
consultantsandy Not sure what you mean. Sorry!
How do I change the payment type to daily and not monthly?
I have a business daily payment consultantsandy
