Forum Discussion
excel amortization schedule issue
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!
- i cannot fix the formulas. It is like they are hardcoded or something.
consultantsandy Then please upload or share your file. Can't tell otherwise what the problem is.