Loan Calculator for more than 30 years

#1 March 30th, 2005, 08:01 PM

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

#2 March 30th, 2005, 08:01 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
loan calculator cells, P&I formulas do not copy to second cloumn	Mr. C	Worksheet Functions	4	March 5th, 2005 03:45 PM
Adding a year(s) to a specific date	Rene	General Discussion	4	October 29th, 2004 03:20 AM
CUMPRINC Function Returns #N/A	George Sullivan	Worksheet Functions	14	August 9th, 2004 04:43 PM
Comparing y-t-d average between 2 years for each year without surpassing present year's week	Yvon	General Discussion	3	July 13th, 2004 04:07 PM
Calculating Time employeed	Mark Graesser	Worksheet Functions	4	December 22nd, 2003 09:18 PM