1. You know the number of payments required and the $ amount from the PMT function.

2. Add $100 to that payment and use the NPER function to

determine the new number of payments required.

3. Subtract number of payments in #2 from number of payments in #1.

'--

Sample data using PMT function...

Loan: $25,000

Interest rate: 6.00 %

Term: 5 years

Payments per year: 12

Number of payments: 60

Payment at end of period.

Payment: $483.32

Total payments: $28,999

--

Sample data using NPER function...

Loan: $25,000

Interest rate: 6.00 %

Term: 4 years

Payments per year: 12

Number of payments: 48.4 '<<<<<Result

Payment at end of period.

Payment: $583.32 '<<<<<$100 more

Total payments: $28,206

'--

Jim Cone

San Francisco, USA

http://www.realezsites.com/bus/primitivesoftware
(I used the Calculate Payments Excel add-in)

"rayteach"

wrote in message

Thank you for your response but I don't see how the NPER function goes beyond

the PMT. I could not see how to make addition payments using the NPER

function. Ray