Excel 30 year problem

MiCr0

Hi All,
hopefully some one can help with this problem
i've found (somewhere??) an excel spreadsheet that helps forecast future savings based on overpayment of a mortgage.
it works perfectly for mortgages up to 30 years, but fails beyond that.
i can't see to find where this magic 360 month figure is mentioned.
any help greatly appreciated.

i've attached it here.

cheers,
MiCr0

whiskeyman

seems to work grand if you copy and paste it into a new sheet.
Looks like something has been applied to the cells below, where #VALUE! (row 377) is.
Not sure exactly why either, but doubt it's a formula thing... more cell format / protection issue

Wolff

PAY_NUM is the problem - stops at 360

seamus

The formulas make use of a number of defined ranges in the sheet. These ranges are static references, many of them only reference as far as row 377 - the last month of the 30th year

To change these, you need to go Insert > Name > Define...

For all of the defined ranges you'll see stuff like
='Loan Calculator'!$H$18:$H$377

for each one, change the 377 to 497 and you should be able to go to 40 years.

MiCr0

you're a genuis
any one who says excel is simple.....