on what I want but something along the lines of cost paid, nights used, points per night. 
)
This is what I was thinking but I am definitely not sophisticated enough to make that myself! Great stats and I'll try to do as much of that as I'm able.I have one (but I stopped updating it once we decided to just switch over to direct since at that point it was no longer a rational break-even decision as much as a "we just want this" decision
Mine has 4 tabs:
Tab 1: Point $$ Per Year
Initial contract cost is spread out over years on contract to get the base price/point/year
Annual fees/point are added to the base price every year to get total cost to me of that point in each year
***You need this tab because if you have bookings using banked or borrowed points, the cost/point is different each year and you will need to account for that
Tab 2: Total Cost of Ownership
Includes Purchase price plus annual dues each year as a running total
Has a cell for Cost Less Savings (savings comes from next tab)
Tab 3: Cash Price of Bookings
Column headings for: Trip Date, Cash Value of Room, # Points Used, Point Cost, Savings
**point cost comes from tab #1 times the number of points used (make sure you are taking into account which UY your points are coming from), savings is obviously cash cost less point cost and this is the number carried to Tab 2 to work out cost of ownership less savings
Tab 4: Breakeven Analysis
Total Cost to Date
LESS: Total Savings to Date
----------------------
Sum/# of Points = Breakeven Price/Point if I were to sell
My chart assumes we would be staying in the same room whether or not we were DVC members, which is true for our family. If you would normally stay somewhere else, you would need to change the cash cost for booking to match wherever you would stay instead of the DVC room cost.
This sounds really great and something I should start doing. I did a quick calculation on my Disney planning spreadsheet for this years trip to figure out what our hotel stay "cost" us as part of my budgeting. But setting this up properly would make it easier for all the years I have to come. (We just bought in November and just completed our first stay!)I have one (but I stopped updating it once we decided to just switch over to direct since at that point it was no longer a rational break-even decision as much as a "we just want this" decision
Mine has 4 tabs:
Tab 1: Point $$ Per Year
Initial contract cost is spread out over years on contract to get the base price/point/year
Annual fees/point are added to the base price every year to get total cost to me of that point in each year
***You need this tab because if you have bookings using banked or borrowed points, the cost/point is different each year and you will need to account for that
Tab 2: Total Cost of Ownership
Includes Purchase price plus annual dues each year as a running total
Has a cell for Cost Less Savings (savings comes from next tab)
Tab 3: Cash Price of Bookings
Column headings for: Trip Date, Cash Value of Room, # Points Used, Point Cost, Savings
**point cost comes from tab #1 times the number of points used (make sure you are taking into account which UY your points are coming from), savings is obviously cash cost less point cost and this is the number carried to Tab 2 to work out cost of ownership less savings
Tab 4: Breakeven Analysis
Total Cost to Date
LESS: Total Savings to Date
----------------------
Sum/# of Points = Breakeven Price/Point if I were to sell
My chart assumes we would be staying in the same room whether or not we were DVC members, which is true for our family. If you would normally stay somewhere else, you would need to change the cash cost for booking to match wherever you would stay instead of the DVC room cost.
I'd be happy to send it to you!
Would you be able to send me a stripped version as well?I have one (but I stopped updating it once we decided to just switch over to direct since at that point it was no longer a rational break-even decision as much as a "we just want this" decision
Mine has 4 tabs:
Tab 1: Point $$ Per Year
Initial contract cost is spread out over years on contract to get the base price/point/year
Annual fees/point are added to the base price every year to get total cost to me of that point in each year
***You need this tab because if you have bookings using banked or borrowed points, the cost/point is different each year and you will need to account for that
Tab 2: Total Cost of Ownership
Includes Purchase price plus annual dues each year as a running total
Has a cell for Cost Less Savings (savings comes from next tab)
Tab 3: Cash Price of Bookings
Column headings for: Trip Date, Cash Value of Room, # Points Used, Point Cost, Savings
**point cost comes from tab #1 times the number of points used (make sure you are taking into account which UY your points are coming from), savings is obviously cash cost less point cost and this is the number carried to Tab 2 to work out cost of ownership less savings
Tab 4: Breakeven Analysis
Total Cost to Date
LESS: Total Savings to Date
----------------------
Sum/# of Points = Breakeven Price/Point if I were to sell
My chart assumes we would be staying in the same room whether or not we were DVC members, which is true for our family. If you would normally stay somewhere else, you would need to change the cash cost for booking to match wherever you would stay instead of the DVC room cost.
I do tab 1, but then next I use that info to calculate cost per stay, paying attention to which contract/year's points were used (since as you noted, the cost/pt will be different with borrowed/banked points, plus I have 3 contracts, 2 resorts). I divide that by number of nights to get cost per night. Then I have a running list of most to least expensive stays (by nightly average rate), since I know I wouldn't be staying in the same room without DVC. Though perhaps I should compare to current year data as opposed to past stays. FWIW, my most expensive stays were AoA, POR, and CBR, all more expensive than any DVC trips so far (though we've only stayed in studios, with the exception of RCI trades into 1 bedrooms).I have one (but I stopped updating it once we decided to just switch over to direct since at that point it was no longer a rational break-even decision as much as a "we just want this" decision
Mine has 4 tabs:
Tab 1: Point $$ Per Year
Initial contract cost is spread out over years on contract to get the base price/point/year
Annual fees/point are added to the base price every year to get total cost to me of that point in each year
***You need this tab because if you have bookings using banked or borrowed points, the cost/point is different each year and you will need to account for that
Tab 2: Total Cost of Ownership
Includes Purchase price plus annual dues each year as a running total
Has a cell for Cost Less Savings (savings comes from next tab)
Tab 3: Cash Price of Bookings
Column headings for: Trip Date, Cash Value of Room, # Points Used, Point Cost, Savings
**point cost comes from tab #1 times the number of points used (make sure you are taking into account which UY your points are coming from), savings is obviously cash cost less point cost and this is the number carried to Tab 2 to work out cost of ownership less savings
Tab 4: Breakeven Analysis
Total Cost to Date
LESS: Total Savings to Date
----------------------
Sum/# of Points = Breakeven Price/Point if I were to sell
My chart assumes we would be staying in the same room whether or not we were DVC members, which is true for our family. If you would normally stay somewhere else, you would need to change the cash cost for booking to match wherever you would stay instead of the DVC room cost.
That was ours as well in 2006.,,,,,And now that we have grand princesses we enjoy it even more.
I am interested, can you PM it ? Thanks
I have run similar analyses, and get similar results. I like the >$500K figure you show as potential savings after 50 years!
That's based on the 200 points you input. I'm now at 920 points, and my "potential" savings using a similar model actually exceed $750K by 2054. The biggest underlying assumption in this type of extrapolation is that we continue to use these points at the same rate, every year, until 2054. That's our GOAL! 
Thanks for posting this. Saves me some work. I will use this and duplicate for my different resales. I have a lot of them and tend to buy the smaller ones with the idea of easy disposal at some point, should it come to that. Also, much easier to give a small contract to my nieces and nephews (or the grands) then a large one.
Thanks for doing this and sharing. I am back and forth on DVC and today is a day where I want to buy. For Column G [
