loan amortization template

[jjbud44]

I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?

Thanks

 

[Joe User]

I can't find a loan amortization table that will
accept a term of 40 years; the max is 30.
Can anyone help?

Usually that's just because they decided to copy their amortization schedule
formulas down only 360 rows or so. They might also have some validation
checks that would need to be tweaked.

But it should not be difficult to modify. If you wish, send me your
favorite template, and I'll see what I can do. Send an Excel file to
joeu2004 "at" hotmail.com.

Just curious: are they offering more-than-30-year loans these days?(!)

 

[Dana DeLouis]

I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?

Thanks

The one shipped with Excel 2007 appears to allow 40 years.

Office Button > New > Installed Templates > "Loan Amortization"

= = = = = = =
HTH
Dana DeLouis