I have the following formula for Quattro Pro for calculating tehoutstanding balance of a 40,000 fifteen year load with an interest rate of 3.19. I want to determine the balance after 10 years.

@AMRPRN(40000,(3.19/12)/100,180,120)

The correct result is 15,504.


I am trying to convert the formula for Excell. I have tried to do the following:

=CUMPR_ADD(3.19/12)/100;180:40000;1;120;1)

I get a result of -8400

I dont quite understand using the next to last two factors in the formula. I am trying to say this a 180 month (15 year) loan and I want to know the principle balance after 120 months (10 years.

I normall do not work with excel so I am not familar with its formulas. I would appreciate any assistance.