ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   exponential growth & Break-even (https://www.excelbanter.com/excel-programming/333663-exponential-growth-break-even.html)

sirsoto

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.




All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com