Iterative Calculation help needed

[rkerbrat]

I have the following information
A1 - Balance at the beginning of calculation
A2 - Annualized payment
A3 - Interest rate divided by # of payments per year
A4 - Number of years * # of payments per year


I'm trying to calulate the total

((A1-A2)*(1+A3)) - I need to do this over and over up until I've don
it A4 times.

I can do it for each period but I want to do it all in one cell, i
possible. How can I have it plug the new number into A1 and repeat th
calculation A4 times.

Thanks

 

[tghcogo]

Hi there

You might find that the PMT function could do the job you want on th
initial cell, then just cumulate it

TGHCOG

 

[JE McGimpsey]

One way:

=FV(A3,A4,A2/<# of payments per year>,A1)

 

[rkerbrat]

Thanks for the suggestions - I think the FV is close but I forgot
couple of pieces of information.

1. I have an amount of money in the account at the beginning of th
calculation.
2. I am earning 5% on the balance of the fund until it goes negative.

This is for a repetitive payment calculation (annuity payout). Th
client has promised to pay a certain amount over a lifetime and has t
keep paying even if all the money in the account is gone.

Thanks again