Post by Admin/YBB on May 20, 2024 16:50:53 GMT -6
Withdrawal Studies with Updated PV in 2 Steps
This 2-STEP trick will work with the updated PV. This month is 05/2024 (May), so the free PV will run without issue from 5/1/2014 - 4/30/2024 (the new 10-yr limit). But the PV will also run without limit for start and end dates prior to 5/1/14 (i.e. no limitations on older data beyond the recent 10-yr window; this was found by experimentation with the updated PV). So, the current month provides the unique break point (10 years ago) for these 2 steps.
In this demo, the PV run for Bengen-type 4% withdrawal with annual COLA will be from 1/1/1985 - 4/30/2024 (the maximum possible at PV) in 2 steps.
STEP 1, PV Run 1/1/1985 - 4/30/2014 (dates beyond recent 10 years)
www.portfoliovisualizer.com/backtest-portfolio?s=y&sl=3qDAqcuhRZT8zHPzoUQlPT
Initial Principal Amount $100,000, initial Monthly Withdrawal $333 (= 4,000/12 rounded).
A limitation of PV is that these inputs must be integers; to reduce the effect of rounding errors, $100,000 initial was used instead of the default $10,000. 3 funds used were VWELX, FPURX, DODBX and 1 benchmark used was VFINX.
STEP 2, PV Run 5/1/2014 - 4/30/2024 (recent 10 years), with VWELX only (asset % for FPURX and DODBX were cleared to avoid confusion). To start the 2nd PV run, use the VWELX balance and Monthly Withdrawal on 4/31/2014.
“Initial” Principal Amount $1,264,742, “initial” Monthly Withdrawal $745 (=$2,979/4 rounded; this is the payment for 4 months in 2014 divided by 4).
www.portfoliovisualizer.com/backtest-portfolio?s=y&sl=6Hbd9noxhDMxTtlIuqR4ns
On 4/30/2024, Final Balance $2,530,484, Monthly payment $978 (=$3,911/4 rounded; payment for 4 months in 2024 divided by 4).
Step 2 can be repeated for FPURX (Step 3), DODBX (Step 4), VFINX (Step 5).
This is more complicated and tricky than the old single-step PV runs. One can subscribe to PV to still have that capacity.
This 2-STEP trick will work with the updated PV. This month is 05/2024 (May), so the free PV will run without issue from 5/1/2014 - 4/30/2024 (the new 10-yr limit). But the PV will also run without limit for start and end dates prior to 5/1/14 (i.e. no limitations on older data beyond the recent 10-yr window; this was found by experimentation with the updated PV). So, the current month provides the unique break point (10 years ago) for these 2 steps.
In this demo, the PV run for Bengen-type 4% withdrawal with annual COLA will be from 1/1/1985 - 4/30/2024 (the maximum possible at PV) in 2 steps.
STEP 1, PV Run 1/1/1985 - 4/30/2014 (dates beyond recent 10 years)
www.portfoliovisualizer.com/backtest-portfolio?s=y&sl=3qDAqcuhRZT8zHPzoUQlPT
Initial Principal Amount $100,000, initial Monthly Withdrawal $333 (= 4,000/12 rounded).
A limitation of PV is that these inputs must be integers; to reduce the effect of rounding errors, $100,000 initial was used instead of the default $10,000. 3 funds used were VWELX, FPURX, DODBX and 1 benchmark used was VFINX.
STEP 2, PV Run 5/1/2014 - 4/30/2024 (recent 10 years), with VWELX only (asset % for FPURX and DODBX were cleared to avoid confusion). To start the 2nd PV run, use the VWELX balance and Monthly Withdrawal on 4/31/2014.
“Initial” Principal Amount $1,264,742, “initial” Monthly Withdrawal $745 (=$2,979/4 rounded; this is the payment for 4 months in 2014 divided by 4).
www.portfoliovisualizer.com/backtest-portfolio?s=y&sl=6Hbd9noxhDMxTtlIuqR4ns
On 4/30/2024, Final Balance $2,530,484, Monthly payment $978 (=$3,911/4 rounded; payment for 4 months in 2024 divided by 4).
Step 2 can be repeated for FPURX (Step 3), DODBX (Step 4), VFINX (Step 5).
This is more complicated and tricky than the old single-step PV runs. One can subscribe to PV to still have that capacity.
