exponential growth & Break-even
Hello,
I want to divide my initial investment by a number that increases annually
by 5%. However, I don't know which function to use in Excel. For example,
Initial Investment - {quantity that increases exponentially) = 0
$300,000 (divided by) {[(49)($150)(1.05)^0] +[(49)($150)(1.05)^1]+and so on}=0
I want the $150 to increase by 5% each year.
And, I am trying to solve for the exponent. Please advise.
|