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!