After Retirement calculator

[rvenky]

1​	EXPENES	125,000
2​	INFLATION	7%​
3​	After Retirement years	30​

4​	investment	50,000,000
5​	ROI	12%​

I would like to have matrix(data table) to show when the original investment amount will be exhausted for each level of expenses & different ROI . I am not able to use PV as there is no provision for inflation(in the formulae).

 

[KRice]

You can use the standard finance equations in Excel, but account for the effect of inflation with:

real rate of return = ((1 + nominal rate)/(1 + inflation rate)) - 1