Spreadsheet Warriors - how have you calculated the all in real cost?

[VGCgroupie]

AI engines do the math and spreadsheet setup - basically saving the time of setting up a spreadsheet. they are not "internet sourced"

So it will get the contract end dates accurately?

 

[Mouseforward]

So it will get the contract end dates accurately?

I had to train it that the contracts end EOM Jan or it was giving points in 2070 for RIV

 

[VGCgroupie]

I had to train it that the contracts end EOM Jan or it was giving points in 2070 for RIV

Was joking around since someone here posted AI cost breakdown and it said a resort had like 8 years longer on its contract than it actually was.

 

[Mouseforward]

Was joking around since someone here posted AI cost breakdown and it said a resort had like 8 years longer on its contract than it actually was.

Was it trying to get the cabins to break even?

 

[Tumnus]

I always try to book a cash room with whatever discount I can, record that point and track 'value of stay' vs points and my initial cost to see when I break even. Which is a fake break even because I stayed at marriotts on points and big discounts (RIP my swan and dolphin stays!) with one splurge deluxe trip a year before DVC.

 

[Rupert's Best Friend]

From my personal spreadsheet tab for DVC research, I have the following columns:

1. Home resort
2. UY
3. Years remaining
4. Annual dues
5. Price
6. Points
7. Listed $ per DVC pt

From these inputs, I have formulas generated in other columns to show:

• Estimated total dues (based on an assumed 2.7% annual increase)
• Estimated total cost (Estimated total dues plus Price)
• Total points (Points multiplied by Years remaining)
• Estimated price per point (Estimated total cost divided by Total points)

Resale contracts from Copper Creek, BLT, Sara Springs, and Poly can have an Est $/pt around $13.70 while Hilton Head, Vero Beach, and Beach Club can be much higher at $16.40 per point. Pretty much the contracts that expire in 2042 have much higher annual dues and the fewest years remaining. Contracts with more years remaining typically have lower annual dues.

On the direct sales side, Poly seems to have lower dues than Disneyland Villas and Aulani which could be quite significant over the years.

 

[Mousemath]

From my personal spreadsheet tab for DVC research, I have the following columns:

1. Home resort
2. UY
3. Years remaining
4. Annual dues
5. Price
6. Points
7. Listed $ per DVC pt

From these inputs, I have formulas generated in other columns to show:

• Estimated total dues (based on an assumed 2.7% annual increase)
• Estimated total cost (Estimated total dues plus Price)
• Total points (Points multiplied by Years remaining)
• Estimated price per point (Estimated total cost divided by Total points)

Resale contracts from Copper Creek, BLT, Sara Springs, and Poly can have an Est $/pt around $13.70 while Hilton Head, Vero Beach, and Beach Club can be much higher at $16.40 per point. Pretty much the contracts that expire in 2042 have much higher annual dues and the fewest years remaining. Contracts with more years remaining typically have lower annual dues.

On the direct sales side, Poly seems to have lower dues than Disneyland Villas and Aulani which could be quite significant over the years.

How did you get to the 2.7% dues increase? Seems to be lower than historical.

 

[Rupert's Best Friend]

How did you get to the 2.7% dues increase? Seems to be lower than historical.

I saw something that said the original dues in 1992 was $2.51 per point and then another article saying the dues were $3 per point in 1998. Now that I'm poking around, apparently there was a 7.6% increase in 2019 at some properties due to the increase in minimum wage?

I recalculated the original dues of $2.51 to the current rate of $9.08 some 33 years later and that yields an average annual increase of 4.1% which is more accurate.

Thanks for helping me fix my projections!

 

[CraigInPA]

I'm looking for a spreadsheet that includes the effects of Addonitis and the costs of the DVC specific merchandise that seems to invade the budget.

 

[Sandisw]

I'm looking for a spreadsheet that includes the effects of Addonitis and the costs of the DVC specific merchandise that seems to invade the budget.

This is why my analysis stopped after we bought contract one!!

I don’t need a spreadsheet to tell me I spend way too much on my trips to Disney!!

 

[Mouseforward]

I found tracking expenses at Disney to be a waste of time, My food and incidentals are within $100 on each trip so I just put $800 on a gift card and that is all I need.

I was tracking the first 3 years to see if the dining and merch discounts for direct add up but for one person they are not really relevant. I stopped purchasing any significant amount of disney stuff after the first year anyway.

This month may be the first trip where the dining discount matters as I booked 4 of the 40% off restaurants.

 

[VGCgroupie]

How did you get to the 2.7% dues increase? Seems to be lower than historical.

This is where I got my historical dues and then we converted it to a spreadsheet to predict future increases. https://dvcnews.com/dvc-program-menu/financial/annual-dues-by-resort

 

[Mousemath]

This is where I got my historical dues and then we converted it to a spreadsheet to predict

Yea I modelled off of that. 4-5% seems to be the norm for most resorts, but I did get specific by resort.

 

[Mouseforward]

Yea I modelled off of that. 4-5% seems to be the norm for most resorts, but I did get specific by resort.

Agree on that number I use 4.5%. The real challenge is what percent do you use for the change in hotel cash rates , I assume a 30% discount off rack and I do not use RIV cash rates at all since when booking a cash trip I would never pay their rates when BC /YC and BW are less. I have been using 3% for my numbers but that may be a bit conservative.