pingreeman

Marriott Points - just how much are they worth - an analysis - 2013

Discussion created by pingreeman on Mar 14, 2013
Latest reply on Dec 22, 2013 by spoonplugger

I thought everyone would enjoy an update to my original post at Marriott Points - just how much are they worth - an analysis

 

The original post was from an analysis done on 12/09/2010 (despite the date shown on the original post as Apr 28, 2012 5:07 PM). Below is a near copy/paste of the original post (different dates in blue):

 

Assumption: You want a hotel room in Illinois for 5 nights on the following dates: 2014-01-19 through 2014-01-23. Your choice is to:

* use points (category X points/night X 4 nights = total points needed as fifth night is free) -or-

* pay cash (rate/night X 5 nights)

* Taxes are not included in the calculations (potentially 10-15% more cash value for the points)

I created a spreadsheet for all 104 hotels in Illinois:

 

Some key items worth noting:

  1. Same number of hotels in Illinois between Jan 2011 & Jan 2014
  2. Venues: 5 fewer Cat 1, 2 fewer Cat 2; however 6 more Cat 3 and 3 never-before Cat 7
  3. The average cost per night over all categories will now set you back $39 more per night
  4. With the average cost per night up by >$39, a 5-night stay will now cost you >$195 over 2011
  5. Despite the category increases, points are actually worth MORE in 2014 as cash cost of rooms went up faster than point decreases!

 

From 03/14/2014 analysis:

Cat#Points5 nightsAve$ NightTotal $Cents/point
110750030000$113.30000$566.50000$0.01888
2361000040000$127.33333$636.66667$0.01592
3361500060000$167.97222$839.86111$0.01400
4102000080000$208.00000$1,040.00000$0.01300
5525000100000$241.00000$1,205.00000$0.01205
6430000120000$212.75000$1,063.75000$0.00886
7335000140000$255.66667$1,278.33333$0.00913
8040000160000n/an/an/a
All10422812.591250$189.43175$891.96296$0.01379

 

From 12/09/2010 analysis:

Cat#Points5 nightsAve$ NightTotal $Cents/point
115750030000$91.53200$457.66000$0.01526
2381000040000$109.70526$548.52632$0.01371
3301500060000$137.59000$687.95000$0.01147
4102000080000$172.00000$860.00000$0.01075
5725000100000$133.42429$667.12143$0.00667
6430000120000$191.50000$957.50000$0.00798
7035000140000n/an/an/a
8040000160000n/an/an/a
All10422812.591250$139.29192$696.45962$0.01097

 

Deltas:

Cat#Points5 nightsAve$ NightTotal $Cents/point
1500$21.76800$108.84000$0.00363
2200$17.62807$88.14035$0.00220
3600$30.38222$151.91111$0.00253
4000$36.00000$180.00000$0.00225
5200$107.57571$537.87857$0.00538
6000$21.25000$106.25000$0.00089
7300n/an/an/a
8000n/an/an/a
All000$39.10067$195.50334$0.00281

Outcomes