| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||||
2 | Savings Earned By Buying Disney Annual Passes In Advance | Check out my Touring Plans Forum Post for more info on this tool. | |||||||||||||||||||
3 | See my YouTube video on how to use this sheet. | ||||||||||||||||||||
4 | SADLY, LATEST REPORTS ARE THAT NEW AP VOUCHERS HAVE A 1 YEAR EXPIRATION DATE, SO THIS TACTIC MAY BE DEAD. | ||||||||||||||||||||
5 | Estimated AP Cost By Year | Years Selected Are Not Sequential | |||||||||||||||||||
6 | Enter values in RED Cells Below Then select which years to use your APs at right | Choose Years to Use AP | Year | Trip Index | Interest Missed | AP Cost Over Time | AP Cost Override | Renewal Costs | Pre-Purchase AP Voucher Savings | AP Renewal Cost Compared to Buying Multiple Vouchers | |||||||||||
7 | Years of AP Vouchers to Buy Now | 3 | 2022 | $ (41) | $ 1,379 | $ 1,172 | Current $ Outlay for 3 AP Vouchers | $ 4,137 | 1 AP Now | ||||||||||||
8 | Starting Year For Model | 2022 | 2023 | 1 | $ (28) | $ 1,476 | $ 1,254 | Future Cost if Buying A New AP Each Year | $ 5,099 | Renewals | |||||||||||
9 | 2024 | $ (28) | $ 1,579 | $ 1,342 | Investment Loss of Initial $ Outlay | $ (124) | Interest Lost | ||||||||||||||
10 | Estimated Annual AP Increase | 7.00% | 2025 | 2 | $ (14) | $ 1,689 | $ 1,436 | Net Cost | $ 4,261 | Net Cost | $ - | ||||||||||
11 | 2026 | $ (14) | $ 1,808 | $ 1,536 | Total Savings/(Loss) vs Future Purchases | $ 838 | Savings/(Loss) | ||||||||||||||
12 | Investment Interest Rate Return | 1.00% | 2027 | 3 | $ - | $ 1,934 | $ 1,644 | Percentage of Initial Outlay Saved | 20.3% | Only Used if Sequential Years | |||||||||||
13 | 2028 | $ - | $ 2,070 | $ 1,759 | |||||||||||||||||
14 | Current AP Cost (Inc Tax) | $1,379 | 2029 | $ - | $ 2,214 | $ 1,882 | The table above tells you the Summary savings for the trip years you selected at left. | The above table is only valid if your selected years are sequential (or nearly so.) | |||||||||||||
15 | Current Renewal Cost | $1,172 | 2030 | $ - | $ 2,369 | $ 2,014 | |||||||||||||||
16 | The Starting Year you entered is not the current year. Just warning in case that was not your intention. | 2031 | $ - | $ 2,535 | $ 2,155 | ||||||||||||||||
17 | 2032 | $ - | $ 2,713 | $ 2,306 | |||||||||||||||||
18 | Notes | 2033 | $ - | $ 2,903 | $ 2,467 | Below is Reference Only -- Not Used in Calcs | |||||||||||||||
19 | *Hover your mouse over boxes with triangles in corner for notes. *If you skip years or just started each subsequent AP a few months later than the last AP ends, the savings would increase since you'd be using a cheaper AP in a more expensive year. This sheet estimates that savings, but to be exact I'd have to ask you what exact dates you were starting vs when possible increases might occur and ain't nobody got time for that. *Only calculating savings for a single person's AP. *Check out the Multiple AP Purchase chart for a simple way of seeing how much you'd save using general amounts and your starting year. * I like birds. | 2034 | $ - | $ 3,106 | $ 2,640 | ||||||||||||||||
20 | 2035 | $ - | $ 3,323 | $ 2,825 | Last 6 AP Prices | Average AP Increases Over Number of Years | |||||||||||||||
21 | 2036 | $ - | $ 3,556 | $ 3,022 | Feb, 2017 | $869 | |||||||||||||||
22 | 2037 | $ - | $ 3,805 | $ 3,234 | Feb, 2018 | $949 | Years | Increase | |||||||||||||
23 | 2038 | $ - | $ 4,071 | $ 3,460 | Oct, 2018 | $994 | 3 | 11.72% | |||||||||||||
24 | 2039 | $ - | $ 4,356 | $ 3,703 | Jun, 2019 | $1,219 | 5 | 15.84% | |||||||||||||
25 | 2040 | $ - | $ 4,661 | $ 3,962 | Feb, 2020 | $1,295 | 7 | 16.32% | |||||||||||||
26 | 2041 | $ - | $ 4,987 | $ 4,239 | Sep, 2021 | $1,379 | 10 | 11.97% | |||||||||||||
27 | 2042 | $ - | $ 5,336 | $ 4,536 | 20 | 8.31% | |||||||||||||||
28 | 2043 | $ - | $ 5,710 | $ 4,853 | 2021 AP Prices | Full | Renewal* | ||||||||||||||
29 | 2044 | $ - | $ 6,110 | $ 5,193 | Incredi-Pass | $1,379 | $1,172 | Average | Median | ||||||||||||
30 | 2045 | $ - | $ 6,537 | $ 5,557 | Platinum Plus | Is No More | 8.0% | 5.4% | |||||||||||||
31 | 2046 | $ - | $ 6,995 | $ 5,946 | *Renewal is estimated at 85% full price | Over All Increases | |||||||||||||||
32 | Total Interest | $ (124) | |||||||||||||||||||
33 | |||||||||||||||||||||
34 | |||||||||||||||||||||
35 | |||||||||||||||||||||
36 | |||||||||||||||||||||