loan amortization template

  • Thread starter Thread starter jjbud44
  • Start date Start date
J

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
 
jjbud44 said:
I can't find a loan amortization table that will
accept a term of 40 years; the max is 30.
Can anyone help?
Click to expand...

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?(!)
 
I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?

Thanks
Click to expand...


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

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

= = = = = = =
HTH
Dana DeLouis
 
Back
Top