| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Is It Worth It for Me to Upgrade to a Disney World Annual Pass? | You can only change values in RED cells. | ||||||||||||||||
2 | ||||||||||||||||||
3 | Annual Passes to Buy | Total Annual Pass Base Cost | If Bridging Tickets: Enter DISNEY FULL Price | This sheet does NOT take into account any unusual things such as Convention tickets or finding unused non-expiration tickets signed by Walt in a time capsule in the foundation of your house. | NOTES | |||||||||||||
4 | Adult | Child | Each | Family of 1 | Use the equivalent Disney Price for 1st trip's tickets | If you are taking multiple trips within a year, this sheet will let you enter trip info, estimated costs & discounts to see if you will save more by upgrading to AP on your first trip. Note: It is VERY hard to make an AP worth it for a single trip. Hover over cells with triangles in the corner for additional info. You should choose the type of ticket you normally buy to get the most accurate total. (Base tickets, e.g., will take more park days tickets to make an upgrade worth it.) If you do not choose either type of Tables in Wonderland, the cost of TiW will NOT be included in the overall totals. HOWEVER, You can still enter discount percentages in the Red Expense boxes since you will likely be using standard AP discounts. (Just remember those don't include adult beverages like TiW. Adjust your "Percent Eligible" estimate as needed.) The "OFF Site" totals include parking savings, while "ON Site" do not. | ||||||||||||
5 | 1 | 0 | $ 1,490 | $ 1,490 | $700 | |||||||||||||
6 | I'VE UPDATED TO THE NEW 2023 AP PRICES, BUT DO NOT HAVE ACTUAL NUMBERS FOR RENEWALS, SO JUST ESTIMATING THOSE WITH 15% DISCOUNT FOR NOW. | |||||||||||||||||
7 | Annual Pass Type | Options to Select | AP or DVC | FL Resident | Cost | Cost w/o AP | ||||||||||||
8 | Incredi-Pass | Tables in Wonderland (Not Avail) | ||||||||||||||||
9 | PhotoPass (Add-On) | $105 | ||||||||||||||||
10 | Water Parks & More (Add-On) | Note: You can play with your own copy of this file by clicking File... in the top menu, then Make a Copy. You have to be logged in to a Google account to do that. | ||||||||||||||||
11 | I am seeing a lot of people putting very unlikely ticket prices in their trips. If you do not put in actual prices this sheet will not give you a good estimate! | |||||||||||||||||
12 | Enter trip info for up to 4 Trips below. Then enter Food, Merchandise, Hotel & Parking Estimates & Discount Percentages | |||||||||||||||||
13 | If you'd like an overview of how to use this sheet, See my video over on The YouTube. | |||||||||||||||||
14 | Expenses Estimates | Asterisks | ||||||||||||||||
15 | Food* | Merchandise | Hotel** | Parking | *If purchasing Tables in Wonderland, be sure to include any alcohol costs in the Food estimate! **Is HOTEL useful to include? I am not sure about that. Can get many discounts WITHOUT an AP. ***Since not all Dining is eligible for Discounts, estimate the total % of your dining that will be. WITHOUT AP DISCOUNTS Totals do not include Food, Merch, Hotel Savings but DO include MM Savings & Parking in OFF SITE section. | |||||||||||||
16 | Enter AP Discount Percentages: | 10% | 20% | 25% | 100% | |||||||||||||
17 | ***Percentage Dining Eligible for Discount: | 80% | Price You Paid for Tix (Disney or Reseller) | |||||||||||||||
18 | Trips | Ticket Type | Park Days | Water Park Days | Memory Maker | |||||||||||||
19 | 1 | PH | 4 | 0 | $ 300 | $ 200 | $ 10 | $ 600 | ||||||||||
20 | 2 | PH | 2 | $ 200 | $ 100 | $ 10 | $ 315 | |||||||||||
21 | 3 | PH | 2 | $ 10 | $ 10 | $ 10 | $ 315 | |||||||||||
22 | 4 | PH | 7 | 0 | $ 10 | $ 10 | $ 10 | $ 175 | $ - | |||||||||
23 | Total Expenses | $ 338 | $ 520 | $ 320 | $ 40 | $ 175 | $ 1,230 | |||||||||||
24 | Total AP Discounts | $ - | $ 42 | $ 64 | $ 10 | $ 175 | ||||||||||||
25 | ||||||||||||||||||
26 | Savings or (Loss) Calculations | WITH AP Discounts | WITHOUT AP Discounts | |||||||||||||||
27 | Item | ON Site | OFF Site | ON Site | OFF Site | |||||||||||||
28 | AP Discount Savings | $116 | $291 | $0 | $175 | |||||||||||||
29 | Bridging Ticket Savings | $100 | $100 | $100 | $100 | |||||||||||||
30 | AP Add-On Savings (Loss) | $233 | $233 | -$105 | -$105 | If you are new to this sheet and a little befuddled by it, Click here OR on the How To Use This Sheet tab at the bottom of the window. | Reference Links | |||||||||||
31 | Total Savings | $448 | $623 | $333 | $508 | Related TP Blog Post | ||||||||||||
32 | NET Total Annual Pass Cost | $1,042 | $867 | $1,157 | $982 | Current TiW Benefits | ||||||||||||
33 | Savings or (Loss) By Upgrading to AP | $188 | $363 | $73 | $248 | Touring Plans Tickets Calculator | ||||||||||||
34 | A Positive Number means you will likely save money by upgrading. A Negative Number means it will cost you more to upgrade. | |||||||||||||||||
35 | ||||||||||||||||||
36 | Because there is an amount in the Bridging box, that additional savings is included. Please make sure you entered a valid amount there or clear the cell if not bridging tix. | |||||||||||||||||
37 | I Hope This Helps You Have Many More Awesome Trips To Disney World! | |||||||||||||||||
38 | ||||||||||||||||||
39 | ||||||||||||||||||
40 | ||||||||||||||||||
41 | ||||||||||||||||||
42 | ||||||||||||||||||