Spreadsheet to track contract value

[WeIcomeHome]

The only thing you'd do differently is that for years you don't stay you'd enter zero for the cash room/Rental price. MF each year would still apply.

 

[DVCRookie2023]

The only thing you'd do differently is that for years you don't stay you'd enter zero for the cash room/Rental price. MF each year would still apply.

Ah ok I see. Seems if I skip that messes up the formula. Will need to figure out how to calculate every other year

 

[DVCRookie2023]

The only thing you'd do differently is that for years you don't stay you'd enter zero for the cash room/Rental price. MF each year would still apply.

Also forgive me - and don’t feel obligated to respond - but when I manually put zeroes in every other year my break even went up to 41 years (and I never broke even via opportunity cost) vs 8 with every year filled in for cost of hotel.

I’m not really understanding how those numbers are so off vs if I were to vacation every year. True I am not utilizing the output of the maintenance fees but I am also not hypothetically “spending” the cash to rent a room every year.

Wouldn’t that savings help the value of my overall contract purchase or at least not hurt it to the tune of breaking even on year 41 vs year 8?

 

[WeIcomeHome]

Also forgive me - and don’t feel obligated to respond - but when I manually put zeroes in every other year my break even went up to 41 years (and I never broke even via opportunity cost) vs 8 with every year filled in for cost of hotel.

I’m not really understanding how those numbers are so off vs if I were to vacation every year. True I am not utilizing the output of the maintenance fees but I am also not hypothetically “spending” the cash to rent a room every year.

Wouldn’t that savings help the value of my overall contract purchase or at least not hurt it to the tune of breaking even on year 41 vs year 8?

The orange columns are intended to be actual inputs over time to track your contact value. I have equations in there now as a place holder so you can't just delete every other value for the room rate without updating the room cost estimates manually for the years you do stay. Easiest way to do this is to apply a 5 percent price hike to the stay from 2 years prior.

Also, your cash room or rental costs should be double on the years you do stay which should offset the non stay years. So if you have 200 points but use 400 every other year then make sure the room cost is equivalent to the 400 point reservation room rate and not a 200 point reservation.

Your MF are annual costs whether you use your points or not for a given year and that is how the spreadsheet calculates them. If you wanted to do mental gymnastics and associate MFs with the years the points are used for bookings, you can do that but you're still paying the fees on a yearly basis.

This spreadsheet also ignores your savings by avoiding travel costs, park tickets, food, etc by traveling every other year. In reality, traveling this way has a way lower opportunity cost than going yearly although the overall cost of a DVC contract was outside the intentions of the spreadsheet because there is such a wide range of ways you can do disney trips.

 

[DVCRookie2023]

The orange columns are intended to be actual inputs over time to track your contact value. I have equations in there now as a place holder so you can't just delete every other value for the room rate without updating the room cost estimates manually for the years you do stay. Easiest way to do this is to apply a 5 percent price hike to the stay from 2 years prior.

Also, your cash room or rental costs should be double on the years you do stay which should offset the non stay years. So if you have 200 points but use 400 every other year then make sure the room cost is equivalent to the 400 point reservation room rate and not a 200 point reservation.

Your MF are annual costs whether you use your points or not for a given year and that is how the spreadsheet calculates them. If you wanted to do mental gymnastics and associate MFs with the years the points are used for bookings, you can do that but you're still paying the fees on a yearly basis.

This spreadsheet also ignores your savings by avoiding travel costs, park tickets, food, etc by traveling every other year. In reality, traveling this way has a way lower opportunity cost than going yearly although the overall cost of a DVC contract was outside the intentions of the spreadsheet because there is such a wide range of ways you can do disney trips.

Ah ok I knew I must have been doing something wrong. That was exactly it - I was not doubling the room rate! Thank you for responding.