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