Prev: Use CountIf for a literal string
Next: What caused my paste function not to work?
From: jjbud44 on 18 Mar 2010 17:44
I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?

Thanks
--
Sue W.
From: Joe User on 18 Mar 2010 18:28
"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?(!)
From: Dana DeLouis on 18 Mar 2010 19:44
On 3/18/10 5:44 PM, 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?
>
> Thanks


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

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

= = = = = = =
HTH
Dana DeLouis
 | 
Pages: 1
Prev: Use CountIf for a literal string
Next: What caused my paste function not to work?