The World's #1 Russian, Ukrainian & Eastern European Discussion & Information Forum - RUA!

This Is the Premier Discussion Forum on the Net for Information and Discussion about Russia, Ukraine, Eastern Europe and the Former Soviet Union. Discuss Culture, Politics, Travelling, Language, International Relationships and More. Chat with Travellers, Locals, Residents and Expats. Ask and Answer Questions about Travel, Culture, Relationships, Applying for Visas, Translators, Interpreters, and More. Give Advice, Read Trip Reports, Share Experiences and Make Friends.

Author Topic: Help With An Excel Spreadsheet  (Read 193 times)

0 Members and 1 Guest are viewing this topic.

Offline shakespear

  • Supporting Member
  • Moderator
  • Member
  • *
  • Posts: 8027
  • Country: us
  • Gender: Male
  • Status: Just Looking
  • Trips: 20+
Help With An Excel Spreadsheet
« 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 draw-down 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), (0-CV) )

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?       
"If you obey all the rules, you miss all the fun" - Katharine Hepburn

Online yankee

  • Member
  • *
  • Posts: 1252
  • Country: us
  • Gender: Male
  • Spouses Country: Russia
  • Status: Married
Re: Help With An Excel Spreadsheet
« Reply #1 on: May 06, 2019, 05:12:52 PM »
Anybody good with excel spreadsheets?

I'm trying to develop a spreadsheet that will tell me the draw-down 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), (0-CV) )

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 worse than not being able to get what you don't even want?

Offline shakespear

  • Supporting Member
  • Moderator
  • Member
  • *
  • Posts: 8027
  • Country: us
  • Gender: Male
  • Status: Just Looking
  • Trips: 20+
Re: Help With An Excel Spreadsheet
« Reply #2 on: May 06, 2019, 10:21:48 PM »

what is the equation?

Don't know.  Excel does the formula for me.
"If you obey all the rules, you miss all the fun" - Katharine Hepburn


Offline shakespear

  • Supporting Member
  • Moderator
  • Member
  • *
  • Posts: 8027
  • Country: us
  • Gender: Male
  • Status: Just Looking
  • Trips: 20+
Re: Help With An Excel Spreadsheet
« Reply #3 on: May 07, 2019, 09:09:28 AM »
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
"If you obey all the rules, you miss all the fun" - Katharine Hepburn


 

 

Registration