Iterative Calculation help needed

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 done
it A4 times.

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

Thanks.


---
Message posted from http://www.ExcelForum.com/

Hi there

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

TGHCOGO


---
Message posted from http://www.ExcelForum.com/

One way:

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

In article ,
rkerbrat wrote:

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 done
it A4 times.

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

Thanks.


---
Message posted from http://www.ExcelForum.com/

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

1. I have an amount of money in the account at the beginning of the
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). The
client has promised to pay a certain amount over a lifetime and has to
keep paying even if all the money in the account is gone.

Thanks again!


---
Message posted from http://www.ExcelForum.com/