Loan Calculator for more than 30 years

[Guest]

I'm using the Loan Calculator (Amortization Schedule) that comes with
Microsoft Excel (I'm running Excel XP).

I need to change it so that it will allow more than 30 years.

I've changed the data validation in cell D8 (Loan Payment in Years) to allow
for more than 30 (I set it at 100). What is the cell that's causing the
problem that it still won't allow more than 30 years to calculate?

I see the "Actual Number of Payments" never goes to more than 361 payments.

Help, please!!

-Ray

 

[Guest]

I'm using the Loan Calculator (Amortization Schedule) that comes with

Microsoft Excel (I'm running Excel XP).

I need to change it so that it will allow more than 30 years.

I've changed the data validation in cell D8 (Loan Payment in Years) to allow
for more than 30 (I set it at 100). What is the cell that's causing the
problem that it still won't allow more than 30 years to calculate?

I see the "Actual Number of Payments" never goes to more than 361 payments.

Help, please!!

-Ray

I forgot to mention that I've unprotected the worksheet and copied cells
past the 360th payment. That's not what's causing the problem.