View Single Post
  #2  
Old March 18th, 2010, 11:28 PM posted to microsoft.public.excel.worksheet.functions
Joe User[_2_]
external usenet poster
 
Posts: 757
Default loan amortization template

"jjbud44" wrote:
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?(!)