PDA

View Full Version : Cost comparison spreadsheet


cfw213
04-25-2012, 07: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

cfw213
04-25-2012, 07:08 PM
Here is the cost comparison if paying 20% and financing through the timeshare store at 12.9%:
Columns are the same except column 6 is the total amount required to be put down (20% of closing costs + point cost)

OKW 110 53.00 5,830.00 500.00 1,266.00 5,064.00 6,898.00 114.97
BWV 110 59.00 6,490.00 500.00 1,398.00 5,592.00 7,617.00 126.95
BCV 110 71.00 7,810.00 500.00 1,662.00 6,648.00 9,055.00 150.92
AKL 110 64.00 7,040.00 500.00 1,508.00 6,032.00 8,216.00 136.93
WL 110 62.00 6,820.00 500.00 1,464.00 5,856.00 7,977.00 132.95
SSR 110 57.00 6,270.00 500.00 1,354.00 5,416.00 7,377.00 122.95
BLT 110 84.00 9,240.00 500.00 1,948.00 7,792.00 10,614.00 176.90


OKW 110 5.2035 572.39 47.70 162.67
BWV 110 5.616 617.76 51.48 178.43
BCV 110 5.5043 605.47 50.46 201.37
AKL 110 5.4356 597.92 49.83 186.76
WL 110 5.6096 617.06 51.42 184.37
SSR 110 4.7309 520.40 43.37 166.32
BLT 110 4.2219 464.41 38.70 215.60

OKW 110 30 29,133.55 971.12
BWV 110 30 31,741.80 1,058.06
BCV 110 30 33,867.19 1,128.91
AKL 110 45 41,154.22 914.54
WL 110 30 32,344.68 1,078.16
SSR 110 42 34,649.76 824.99
BLT 110 48 40,697.63 847.87

I am specifically looking at BLT - I want my home resort to be within walking distance to a park, and BWV and BCV are poor value. As you can see, it would be less expensive to finance 100% of the purchase through my bank (they offer a lower rate on any borrowings over $10,000) than the 12.9% with 20% down through the Timeshare Store.

DougEMG
04-25-2012, 08:22 PM
Cool

DougEMG
04-25-2012, 08:28 PM
Cool

Tunseeker1
04-25-2012, 10:27 PM
Can you upload a copy of the spreadsheet?

Kathymford
04-26-2012, 07:02 AM
I would love a copy also!

cfw213
04-26-2012, 07:04 AM
Can you upload a copy of the spreadsheet?

Try it here: https://www.dropbox.com/sh/20nqg9lnljvg1at/Ke3wWwANJQ

Not sure if it will work, have never used dropbox!

Kathymford
04-26-2012, 07:11 AM
Try it here: https://www.dropbox.com/sh/20nqg9lnljvg1at/Ke3wWwANJQ

Not sure if it will work, have never used dropbox!

Opened for me with no problem, and I'm just on my iPad. Question. What do te tab names mean?

WRWDisney
04-26-2012, 07:30 AM
The only thing I can see that you seem to be missing is the "buying power" of the points at their home resort. For example, at OKW, you can stay a week in a studio in Magic Season for 108 points. At BLT, those same accommodations will set you back from between 139 to 183 points, depending on the view. Making the median cost for a room 161 points, or 53 points more. In other words, at their home resorts, the BLT points only have 67% of the purchasing power of the BLT points. Not sure how to work this into your calculations since points can be used from one resort to the other, but since the contract states that the only thing guaranteed is stays at your home resort and the 11 moth vs. 7 month home booking advantage, it should count for something.

cfw213
04-26-2012, 08:09 AM
Opened for me with no problem, and I'm just on my iPad. Question. What do te tab names mean?

Sorry Should have specified! The first tab is 9.74% financing through my bank (7.99% BLT) and the second tab is financing through the timeshare store w/the required 20% down.

If you were to update it on your own you could just change the number of points and everything will flow except the "total amount financed". I used myamortizationchart.com to get this amount and the monthly loan payment.

cfw213
04-26-2012, 08:19 AM
The only thing I can see that you seem to be missing is the "buying power" of the points at their home resort. For example, at OKW, you can stay a week in a studio in Magic Season for 108 points. At BLT, those same accommodations will set you back from between 139 to 183 points, depending on the view. Making the median cost for a room 161 points, or 53 points more. In other words, at their home resorts, the BLT points only have 67% of the purchasing power of the BLT points. Not sure how to work this into your calculations since points can be used from one resort to the other, but since the contract states that the only thing guaranteed is stays at your home resort and the 11 moth vs. 7 month home booking advantage, it should count for something.

Hmm that is a good point. I guess I can mentally counter this by saying that at least most of the time my main priority is staying at a resort within walking distance to at least one park, so I probably wouldn't stay at OKW or SSR. So although I can get "more", I wouldn't be happy buying in and either or those resorts.

Tunseeker1
04-26-2012, 08:19 AM
I would also look at what the accommodations are and compare those rather then point total.

Pick a room type and season and use that for all resorts and for cash comparisons.

Ill do a quick edit today and shoot it back to you

RhettsMom
04-26-2012, 08:27 AM
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[/QUOTE]

Yes, Please!! I have been crunching numbers as well, and this would be awesome! Can you email the spreadsheet to me? jbgrunder @ yahoo . com (no spaces, obviously) :)

Thanks so much!

cfw213
04-26-2012, 08:40 AM
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

Yes, Please!! I have been crunching numbers as well, and this would be awesome! Can you email the spreadsheet to me? jbgrunder @ yahoo . com (no spaces, obviously) :)

Thanks so much![/QUOTE]

You can download from the Dropbox link I posted above! If it doesn't work let me know and I will email.

DougEMG
04-26-2012, 11:27 AM
Thanks for posting on that DropBox site, never knew that site was out there for doing stuff like that.

One thing you might want to add for other people is a column showing what the initial costs are for the first 5 years. As the costs are higher in this time period while the loan is being paid off, then after 5 years the costs will drop. But if someone can't make those initial higher load payments, it will not matter what the savings are over the life of the contract.

If I've done the numbers right it looks like this , so that Initial 5y Costs column is new and is equal to your monthly costs*12 + $1,500

Total Initial 5y Average LifeTime
Monthly Cost Costs Vacation Cost
OKW 181.39 3,677 2,339
BWV 199.10 3,889 2,412
BCV 225.96 4,211 2,456
AKL 209.07 4,009 2,310
WLV 206.01 3,972 2,426
SSR 186.35 3,736 2,224
BLT 241.42 4,397 2,217

cfw213
04-26-2012, 12:44 PM
Thanks for posting on that DropBox site, never knew that site was out there for doing stuff like that.

One thing you might want to add for other people is a column showing what the initial costs are for the first 5 years. As the costs are higher in this time period while the loan is being paid off, then after 5 years the costs will drop. But if someone can't make those initial higher load payments, it will not matter what the savings are over the life of the contract.

If I've done the numbers right it looks like this , so that Initial 5y Costs column is new and is equal to your monthly costs*12 + $1,500

Total Initial 5y Average LifeTime
Monthly Cost Costs Vacation Cost
OKW 181.39 3,677 2,339
BWV 199.10 3,889 2,412
BCV 225.96 4,211 2,456
AKL 209.07 4,009 2,310
WLV 206.01 3,972 2,426
SSR 186.35 3,736 2,224
BLT 241.42 4,397 2,217

That's a good, valid point. I didn't initially factor that in since I "budget" my finances for them separately. I just looked at the monthly payments to see if I could afford them outside the scope of my normal vacation expenses.

Thanks for bringing it up, I'll add it into my spreadsheet. I am also going to add in a "purchasing power" column like another user had mentioned.

cfw213
04-26-2012, 01:20 PM
I added in the purchasing power column, but I don't think I agree with it. The only way it is "valid" is if you always stay in your home resort, which is not likely (at least for me). For example, you can get 30% "more" for your points by staying at AKL rather than BCV, but that statement holds true no matter what your home resort is.

The way it stands now, the yearly cost is the yearly cost no matter where you stay (which is why, for me, BLT is the most cost -reasonable). You can get more or less "value" for your points if you stay at a relatively more/less "expensive" hotel, no matter what your home resort is. If we were only allowed to stay at our home resort the purchasing power would be more important.

If you were planning to buy for the rock bottom lowest cost and always willing to stay at your home resort to not lose any value of your points, OKW and AKL work out to be the most cost-effective, at least with the dates/scenario I looked at (7 nights in a standard view studio, sept 15-22)

McCrae
04-26-2012, 02:53 PM
I think you are over complicating this.

The guides use the following sum for each resort to give a comparison.

Price per point / length of contract

+ annual dues per point

cfw213
04-26-2012, 03:46 PM
I think you are over complicating this.

The guides use the following sum for each resort to give a comparison.

Price per point / length of contract

+ annual dues per point

That makes sense but it doesn't factor in different types of financing which is the whole point of my spreadsheet.