cfw213

04-25-2012, 08:00 PM

I made the following spreadsheet to analyze the best resort to buy into and the best way to finance it (obviously paying cash would be best but...). It looks kind of crazy without spacing - obviously looks better in an excel spreadsheet!

Column 1 - Resort

Column 2 - Number of pts

Column 3 - Average resale value of points

Column 4 - Total cost for points

Column 5 - Estimated closing Costs

Column 6 - Total amount financed

Column 7 - Total cost including financing (this particular equation assumes 9.74% over 60 months, except for BLT which is 7.99% - I ran the spreadsheet using several different financing options). I used myamortizationchart.com to get this total amount and the amount for column 8.

Column 8 - Monthly loan payment

OKW 110 53.00 5,830.00 500.00 6,330.00 8,021.40 133.69

BWV 110 59.00 6,490.00 500.00 6,990.00 8,857.00 147.62

BCV 110 71.00 7,810.00 500.00 8,310.00 10,530.00 175.50

AKL 110 64.00 7,040.00 500.00 7,540.00 9,554.00 159.24

WL 110 62.00 6,820.00 500.00 7,320.00 9,275.40 154.59

SSR 110 57.00 6,270.00 500.00 6,770.00 8,578.80 142.98

BLT 110 84.00 9,240.00 500.00 9,740.00 12,163.00 202.72

Column 1 - Resort

Column 2 - Number of points

Column 3 - 2012 maintenance fees

Column 4 - Total Maintenance Fees

Column 5 - Monthly maintenance fees

Column 6 - Total monthly payment for maintenance fees and loan payment

OKW 110 5.2035 572.39 47.70 181.39

BWV 110 5.616 617.76 51.48 199.10

BCV 110 5.5043 605.47 50.46 225.96

AKL 110 5.4356 597.92 49.83 209.07

WL 110 5.6096 617.06 51.42 206.01

SSR 110 4.7309 520.40 43.37 186.35

BLT 110 4.2219 464.41 38.70 241.42

Column 1 - Resort

Column 2 - Number of pts

Column 3 - Years remaining on contract

Column 4- Total cost of financing (includes dues at 2012 rate for number of years remaining on contract and total cost of buy-in including financing)

Column 5 - Yearly cost of DVC, all factors included, per resort.

OKW 110 30 25,192.95 839.77

BWV 110 30 27,389.80 912.99

BCV 110 30 28,694.19 956.47

AKL 110 45 36,460.22 810.23

WL 110 30 27,787.08 926.24

SSR 110 42 30,435.56 724.66

BLT 110 48 34,454.63 717.80

Of course this doesn't include the opportunity cost of what you could do with the buy-in money and the fact that the dues will increase yearly. But you could assume that the rate of just renting a room in WDW will increase approximately the same rate.

After this, I compared the total cost of the DVC room + tickets and dining to other options (value with FD, value with no FD, moderate with FD, moderate with no FD, renting DVC pts) to see if it was worth it.

According to my calculations, even financing between 8-10% interest rate has a relatively low cost per year as compared to paying OOP. If I did decide to buy-in I would do it at BLT - the resort with the lowest cost per year.

If anyone wants the spreadsheet or thinks I'm missing any vital part of the calculation let me know! Hope my nerdy-ness can help someone else. :goodvibes:goodvibes

Column 1 - Resort

Column 2 - Number of pts

Column 3 - Average resale value of points

Column 4 - Total cost for points

Column 5 - Estimated closing Costs

Column 6 - Total amount financed

Column 7 - Total cost including financing (this particular equation assumes 9.74% over 60 months, except for BLT which is 7.99% - I ran the spreadsheet using several different financing options). I used myamortizationchart.com to get this total amount and the amount for column 8.

Column 8 - Monthly loan payment

OKW 110 53.00 5,830.00 500.00 6,330.00 8,021.40 133.69

BWV 110 59.00 6,490.00 500.00 6,990.00 8,857.00 147.62

BCV 110 71.00 7,810.00 500.00 8,310.00 10,530.00 175.50

AKL 110 64.00 7,040.00 500.00 7,540.00 9,554.00 159.24

WL 110 62.00 6,820.00 500.00 7,320.00 9,275.40 154.59

SSR 110 57.00 6,270.00 500.00 6,770.00 8,578.80 142.98

BLT 110 84.00 9,240.00 500.00 9,740.00 12,163.00 202.72

Column 1 - Resort

Column 2 - Number of points

Column 3 - 2012 maintenance fees

Column 4 - Total Maintenance Fees

Column 5 - Monthly maintenance fees

Column 6 - Total monthly payment for maintenance fees and loan payment

OKW 110 5.2035 572.39 47.70 181.39

BWV 110 5.616 617.76 51.48 199.10

BCV 110 5.5043 605.47 50.46 225.96

AKL 110 5.4356 597.92 49.83 209.07

WL 110 5.6096 617.06 51.42 206.01

SSR 110 4.7309 520.40 43.37 186.35

BLT 110 4.2219 464.41 38.70 241.42

Column 1 - Resort

Column 2 - Number of pts

Column 3 - Years remaining on contract

Column 4- Total cost of financing (includes dues at 2012 rate for number of years remaining on contract and total cost of buy-in including financing)

Column 5 - Yearly cost of DVC, all factors included, per resort.

OKW 110 30 25,192.95 839.77

BWV 110 30 27,389.80 912.99

BCV 110 30 28,694.19 956.47

AKL 110 45 36,460.22 810.23

WL 110 30 27,787.08 926.24

SSR 110 42 30,435.56 724.66

BLT 110 48 34,454.63 717.80

Of course this doesn't include the opportunity cost of what you could do with the buy-in money and the fact that the dues will increase yearly. But you could assume that the rate of just renting a room in WDW will increase approximately the same rate.

After this, I compared the total cost of the DVC room + tickets and dining to other options (value with FD, value with no FD, moderate with FD, moderate with no FD, renting DVC pts) to see if it was worth it.

According to my calculations, even financing between 8-10% interest rate has a relatively low cost per year as compared to paying OOP. If I did decide to buy-in I would do it at BLT - the resort with the lowest cost per year.

If anyone wants the spreadsheet or thinks I'm missing any vital part of the calculation let me know! Hope my nerdy-ness can help someone else. :goodvibes:goodvibes