If you are at 55,000,000 million dollars at the end of year 2016 and you need to reach 100,000,000 but you plan on increasing by a set percentage each year by the previous years number then what formula do you use to calculate what that fixed percentage is each year. Formula can be excel or math formula Thanks.
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Growth B4: =(B3/B2) ^ (1/(A3-A2)) - 1 Check: B8: =$B$2 * (1+$B$4) ^ (A8 - $A$2)
Entia non sunt multiplicanda sine necessitate
This is a goal seek problem. Basically you want to say "I have $55M invested now. If I want $100M after X years, then what rate of return do I need to earn in order to meet my goal?" I've attached a super simple example.
Let me know if you have any questions. Goal Seek can be found on the Data tab under "What-If Analysis". Set cell F5 (your ending year) to $100M by changing cell C2 (your rate).
shadow i want to be able to put in the year1 on your spreadsheet and the year 5 and the interest rate would auto populate with a fixed rate. Right now if I type in 100 dollars on year 1 I don't get some astronomical interest rate to compound over fire years to get to 100 million.
Shg thanks. I believe thats what i needed.
Give shg's solution a shot, as it will probably be more autonomous than mine. With my solution, you would have to rerun goal seek each time you want to change your beginning balance.
You're welcome.
[.... deleted by me ....]
Last edited by joeu2004; 11-18-2016 at 06:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks