baf99
TUG Member
- Joined
- Apr 11, 2014
- Messages
- 171
- Reaction score
- 102
- Points
- 153
- Location
- Indiana
- Resorts Owned
-
Carlsbad Inn Beach Resort
Blue Whale
I have been considering a resale (of course) purchase of HGVC points. Ideally, to get the best points/dollar ratio I wanted to go with a 7K points purchase. I suspect the initial cost outlay per point would be higher, so I wanted to see the cost per point difference of some of the gold points packages would be so I put together a spreadsheet. I do that a lot.
Here’s what the spreadsheet does:
• Compares up to three scenarios
• Enter data in shaded areas (% increase in MF, resort(s) being compared, unit/season, points, cost, current MF)
• Total cost is shown for up to 20 years of ownership in rows 8-27
• Difference in cost of purchasing the first option of the scenario vs. the second (column B vs. D, column F vs. H, column J vs. L)
• Scroll down to rows 33-20 to see the cost difference per point vs. years of ownership
The first example in the spreadsheet: purchasing a 5000 point 2 BR at Las Vegas Boulevard (aka strip) vs. a 7000 point package at the same location. If you open either spreadsheet in the attached zip file you see that with a 5% per year increase in maintenance fees you are actually better off in cost per point if you purchase the 5000 point package through the first 14 years. After that the 7000 point package starts pulling ahead. The third scenario shows the comparison at the same location of the 5000 point package to the 4800 point package. This one shows that the break-even point is after the second year.
For costs, I used recent listings from sellingtimeshares.net. If you get a better or worse deal on initial cost that will change things a bit. I used TUG member reported maintenance fees from the sticky. I am not including the cost of HGVC membership in the maintenance fees. I think my math is correct, but if someone finds an error, feel free to let me know. I don’t know if anyone will find the spreadsheet useful, but I thought I would share it just in case. I also have a spreadsheet that compares the MF/point ratio for most of the 2016 fees that were posted. I will hold off on inflicting that one on TUG members for now.
Here’s what the spreadsheet does:
• Compares up to three scenarios
• Enter data in shaded areas (% increase in MF, resort(s) being compared, unit/season, points, cost, current MF)
• Total cost is shown for up to 20 years of ownership in rows 8-27
• Difference in cost of purchasing the first option of the scenario vs. the second (column B vs. D, column F vs. H, column J vs. L)
• Scroll down to rows 33-20 to see the cost difference per point vs. years of ownership
The first example in the spreadsheet: purchasing a 5000 point 2 BR at Las Vegas Boulevard (aka strip) vs. a 7000 point package at the same location. If you open either spreadsheet in the attached zip file you see that with a 5% per year increase in maintenance fees you are actually better off in cost per point if you purchase the 5000 point package through the first 14 years. After that the 7000 point package starts pulling ahead. The third scenario shows the comparison at the same location of the 5000 point package to the 4800 point package. This one shows that the break-even point is after the second year.
For costs, I used recent listings from sellingtimeshares.net. If you get a better or worse deal on initial cost that will change things a bit. I used TUG member reported maintenance fees from the sticky. I am not including the cost of HGVC membership in the maintenance fees. I think my math is correct, but if someone finds an error, feel free to let me know. I don’t know if anyone will find the spreadsheet useful, but I thought I would share it just in case. I also have a spreadsheet that compares the MF/point ratio for most of the 2016 fees that were posted. I will hold off on inflicting that one on TUG members for now.