All,
I'm interested in writing a clean monthly compounding formula that incorporates the following (I'm compounding cash flows):
* Compounding that starts on a particular month (say, for example, a construction start month).
* From the start month, compounding would be at a user defined rate for 12 mos. (e.g. 3%).
* Starting the 13th month, compounding would change to another user defined rate until the 24th month, it would change again in the 25th month and so forth.
* I want the user to be able to enter the following type of information, compounding start month, and then the rate for each of the 12 month periods.
E.g.
Start: June 09
Months 1-12: 2%
Months 13-24: 3%
Months 25-26: 4%
and so on...
My thoughts inculded using a vlookup or the count function, but wanted to see if any of you guys can think of something simple and clean.
I'm interested in writing a clean monthly compounding formula that incorporates the following (I'm compounding cash flows):
* Compounding that starts on a particular month (say, for example, a construction start month).
* From the start month, compounding would be at a user defined rate for 12 mos. (e.g. 3%).
* Starting the 13th month, compounding would change to another user defined rate until the 24th month, it would change again in the 25th month and so forth.
* I want the user to be able to enter the following type of information, compounding start month, and then the rate for each of the 12 month periods.
E.g.
Start: June 09
Months 1-12: 2%
Months 13-24: 3%
Months 25-26: 4%
and so on...
My thoughts inculded using a vlookup or the count function, but wanted to see if any of you guys can think of something simple and clean.