excel amortization schedule issue

[consultantsandy]

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

[#2]

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

[#3]

@Riny_van_Eekelen 

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.

[#4]

@consultantsandy Not sure what you mean. Sorry!

[#5]

i cannot fix the formulas. It is like they are hardcoded or something.

[#6]

@consultantsandy Then please upload or share your file. Can't tell otherwise what the problem is.

[#7]

How do I change the payment type to daily and not monthly? 

I have a business daily payment @consultantsandy