View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sirsoto sirsoto is offline
external usenet poster
 
Posts: 8
Default 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.