VPW calculator

Have a question about your personal investments? No matter how simple or complex, you can ask it here.
Post Reply
cliff
Posts: 64
Joined: Sun Mar 04, 2007 3:21 pm

VPW calculator

Post by cliff » Thu Jul 31, 2014 4:52 pm

On the early retirement web site there is a link to a VPW calculator developed by a Boglehead. The link, however does not work. It goes to dropbox as a dead end. Is it available anywhere?

Thanks

User avatar
Dutch
Posts: 1277
Joined: Thu Jun 27, 2013 2:12 pm

Re: VPW calculator

Post by Dutch » Thu Jul 31, 2014 4:57 pm

Yes, see the wiki right here on bogleheads

http://www.bogleheads.org/wiki/Variable_percentage_withdrawal

cliff
Posts: 64
Joined: Sun Mar 04, 2007 3:21 pm

Re: VPW calculator

Post by cliff » Thu Jul 31, 2014 5:01 pm

I do not have excel. That is why I was looking for the calculator. Any advice on a free program/app that would run this on a PC? Ipad?

User avatar
Dutch
Posts: 1277
Joined: Thu Jun 27, 2013 2:12 pm

Re: VPW calculator

Post by Dutch » Thu Jul 31, 2014 5:11 pm

From the wiki:
The spreadsheet is developed using the free LibreOffice Calc software.

Users have reported that some charts do not display as nicely with Microsoft Excel.
Google Docs is unable to correctly display the file.

User avatar
kramer
Posts: 1554
Joined: Wed Feb 21, 2007 2:28 am
Location: Philippines

Re: VPW calculator

Post by kramer » Thu Jul 31, 2014 11:57 pm

Yes, you can go to this site and get the same results as VPW with a simple calculator:

http://tcalc.timevalue.com/all-financia ... lator.aspx

Just enter the future real rate of return of your investments, the number of years that you will be withdrawing, and you will get the same value as VPW for your current year withdrawal.

Example:

Portfolio: $1,000,000
Rate of Return: 2%
Number of Withdrawals: 30
Withdrawal Period: Annual

You would be able to make 29 Annual withdrawals in the amount of $43,894.82 and one final withdrawal of $43,894.92.

Or you can just convert it to a percentage and get 4.39%

Post Reply