Anyone who knows an existing formula or VBA on solving the following:
I will put an amount of "cell A1" given dollars on my bank account for a "cell b1" given number of years (n-times). I know that I want to save money until it reaches "cell c1" given total amount.
What % need the intrest rate "to find" need to be to achieve my goal (cell d1).
I know it probably will have to find it's way around and resolve for each further decimal needed until it reaches an amount greater than that needed in (cell c1).
Any help would be greatly appreciated.
I will put an amount of "cell A1" given dollars on my bank account for a "cell b1" given number of years (n-times). I know that I want to save money until it reaches "cell c1" given total amount.
What % need the intrest rate "to find" need to be to achieve my goal (cell d1).
I know it probably will have to find it's way around and resolve for each further decimal needed until it reaches an amount greater than that needed in (cell c1).
Any help would be greatly appreciated.