Cost comparison spreadsheet

Discussion in 'Purchasing DVC' started by cfw213, Apr 25, 2012.

  1. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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
     
  2. Avatar

    DIS Sponsor The Official Ticket Center is Orlando’s #1 discount attraction ticket agency, selling millions of Walt Disney tickets around the world.



    to hide this adverts.
  3. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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.
     
  4. DougEMG

    DougEMG DIS Veteran

    Joined:
    Aug 14, 2008
    Messages:
    1,909
  5. DougEMG

    DougEMG DIS Veteran

    Joined:
    Aug 14, 2008
    Messages:
    1,909
  6. Tunseeker1

    Tunseeker1 Mouseketeer

    Joined:
    Apr 6, 2012
    Messages:
    312
    Can you upload a copy of the spreadsheet?
     
  7. Kathymford

    Kathymford A little obsessed is ok....right?

    Joined:
    Jan 3, 2011
    Messages:
    1,812
    I would love a copy also!
     
  8. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
  9. Kathymford

    Kathymford A little obsessed is ok....right?

    Joined:
    Jan 3, 2011
    Messages:
    1,812
  10. WRWDisney

    WRWDisney Mouseketeer

    Joined:
    Jul 21, 2008
    Messages:
    76
    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.
     
  11. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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.
     
  12. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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.
     
  13. Tunseeker1

    Tunseeker1 Mouseketeer

    Joined:
    Apr 6, 2012
    Messages:
    312
    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
     
  14. RhettsMom

    RhettsMom HAKUNA MATATA

    Joined:
    Jul 13, 2011
    Messages:
    92
    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!
     
  15. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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.
     
  16. DougEMG

    DougEMG DIS Veteran

    Joined:
    Aug 14, 2008
    Messages:
    1,909
    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
     
  17. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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.
     
  18. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    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)
     
  19. McCrae

    McCrae Mouseketeer

    Joined:
    Aug 29, 2009
    Messages:
    382
    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
     
  20. cfw213

    cfw213 DIS Veteran

    Joined:
    Jun 20, 2011
    Messages:
    854
    That makes sense but it doesn't factor in different types of financing which is the whole point of my spreadsheet.
     

Share This Page