ABCDEFGHIJKLMNO
1
INSTRUCTIONS
2
1. Enter values in Yellow cells A2-A4
3
2. You should not need to override the orange cells
4
3. Look at green cells below to see the best option (lower is better)
TEST
5
6
Enter Variables in Yellow Cells only
7
$300.00
Cash cost of stay per night, including taxes
NAXON award?
8
95,000
Points Cost per night
7
Category (used for AXON only)
9
1Nights$300.00Total Cash Cost
AXON (discounted 4 nights only and need AMEX HH card)
10
95,000
Total Point Cost (5th night free accounted for)
CategoryCost
11
5130000
12
$0.0100
Value of HH points (default is the CPM for the redemption). Default cell value is "=E2/E3" without quotes
6160000
13
0
Hilton Member status Enter 0% for None, 25% for Gold, 50% for Diamond (Surpass gives you GOLD level btw)
7190000
14
0
Card Bonus when BOOKING room (Citi HH - 6, Citi HH Reserve - 10, AMEX HH - 7, AMEX Surpass - 12)
8220000
15
0.03
Opportunity Cost Cashback card (Enter 2% or 3%)
9260000
16
$1.00
Cost of $1,000 MO
10300000
17
0
Portal Rebate for cash stay (e.g. Topcashback)
18
19
-- Protected area below --
20
21
Manuf with Hilton AMEX at 6X Grocery -> Unload VGC to BB/Serve -> Redeem points for stay
22
Amount of Spend at GrocHH pts per $500 VGCVGC Cost# of VGC to buyTotal Cost for stay
23
$15,833.333035.7$5.9531.3$186.20
24
25
Manuf with Hilton AMEX at 6X Grocery -> Unload VGC as MO -> Redeem points for stay
26
Amount of Spend at GrocHH pts per $500 VGCVGC Cost# of VGC to buyMO costTotal Cost for stay
27
$15,833.333035.7$5.9531.3$15.65$201.85
28
29
Manuf with Hilton AMEX at 6X Grocery -> Unload VGC as MO -> Redeem points for stay ($3.95 VGC fee)
30
Amount of Spend at GrocHH pts per $500 VGCVGC Cost# of VGC to buyMO costTotal Cost for stay
31
$15,833.333035.7$3.9531.3$15.65$139.26
32
33
34
Manuf with CB card -> VGC -> WM MO -> pay for room using a Hilton credit card
35
Amount of Spend at GrocCB Card %VGC Cost# of VGC to buyMO CostTotal FeesCB Card RebateProfit/loss from CB rebate and room costPortal Rebate on cash stayPortal RebateHH pts earned for stayValue of HH ptsHH rebateTotal Cost for stay
36
$15,833.333%$5.9531.3$15.65$201.85$475.00$175.000%$0.004,500.00$0.010$45.00-$18.15
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100