Russian, Ukrainian & FSU Information & Discussion Forums
General Discussion => General Chat => Topic started by: shakespear on May 06, 2019, 04:19:53 PM

Anybody good with excel spreadsheets?
I'm trying to develop a spreadsheet that will tell me the drawdown of a portfolio
value considering the continuing annual rate of return and the size of the monthly
withdrawal.
I believe I've done that with the following formula 
FV = ( (a/12), (H), (F), (0CV) )
FV = future value
A = annual rate of return, compounded monthly
H = number of draw down months
F = monthly draw down
CV = current value
I'd like to add in a calculation for inflation  figuring how much I'd need to increase my
monthly draw down to account for a certain percentage of inflation annually and the
impact that would have on my future value of investment.
Can anyone suggest to to incorporate that into my original calculation?

Anybody good with excel spreadsheets?
I'm trying to develop a spreadsheet that will tell me the drawdown of a portfolio
value considering the continuing annual rate of return and the size of the monthly
withdrawal.
I believe I've done that with the following formula 
FV = ( (a/12), (H), (F), (0CV) )
FV = future value
A = annual rate of return, compounded monthly
H = number of draw down months
F = monthly draw down
CV = current value
I'd like to add in a calculation for inflation  figuring how much I'd need to increase my
monthly draw down to account for a certain percentage of inflation annually and the
impact that would have on my future value of investment.
Can anyone suggest to to incorporate that into my original calculation?
what is the equation?

what is the equation?
Don't know. Excel does the formula for me.

Ya think this might work?
FV = CV*(1+A/12)^H – F*((1+A/12)^H – (1+Q)^H))/(A/12 – Q)
FV = future value
CV = current value
A = annual rate of return
H = number of draw down months
F = first monthly draw down amount
Q = monthly rate of inflation