Skip to main content
8 events
when toggle format what by license comment
Feb 2, 2016 at 5:49 history tweeted twitter.com/StackFinance/status/694397114600812544
Feb 1, 2016 at 22:57 comment added Whirl Mind @Michael : Good point, using inflation-adjusted return rate.
Feb 1, 2016 at 22:30 answer added user662852 timeline score: 1
Feb 1, 2016 at 22:26 comment added Michael You can ignore inflation. You just use an inflation adjusted return on investment figure, so if you assume 3% inflation and 7% return, then just use 4%. As I said though, you can't develop a simple mathematical formula for this, you can develop a formula to calculate the sum of money you have from saving a given amount each month or year for a given time with a given return... but calculating the amount that taken out for a given number of years whilst adding the return and deducting the payout..... that is an iterative calculation. You could do it in excel/office but it's not a formula.
Feb 1, 2016 at 21:48 comment added user662852 The inflation appears to bake into the rate of return here. Have you tried using the Excel standard functions PV (to determine the constant dollar amount needed as present value on date A2 to pay out a function of local income until A3) and PMT (to determine the payments needed to achieve a future value of this amount on A2, between A1 and A2)?
Feb 1, 2016 at 19:53 comment added Michael The maths for this stuff is actually quite complicated, even with all the stuff you excluded, as you're into series' and iterative calculations. If you actually want to figure out how much to save, rather than the answer to your question, you could try some numbers in an online pension payout calculator, to see what pot gives you your target income, then try some numbers in an online compound interest calculator to see what you need to save monthly to get the required pot.
Feb 1, 2016 at 18:11 history edited Whirl Mind CC BY-SA 3.0
added assumption to the body
Feb 1, 2016 at 18:04 history asked Whirl Mind CC BY-SA 3.0