If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Iterative Calculation help needed
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/ |
#3
|
|||
|
|||
Iterative Calculation help needed
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/ |
#4
|
|||
|
|||
Iterative Calculation help needed
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/ |
Thread Tools | |
Display Modes | |
|
|