| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | FM's Cash or Points for Suites? | ||||||
2 | To use this worksheet, use the menu above to click File, then click "Make a Copy." Edit cells in blue to figure out which option is best for you. Copyright 2021 Frequent Miler | Tab version 1.0 | |||||
3 | |||||||
4 | About You | Your Answer | Notes | ||||
5 | Point Value | How much are Hyatt points worth to you? | 1.50 | Answer in cents per point. | |||
6 | Credit Card | How many points per dollar does your credit card earn at Hyatt hotels? | 4 | The World of Hyatt card earns 4 points per dollar. Some other examples: Chase Sapphire Reserve: 3 points per dollar Chase Sapphire Preferred: 2 points per dollar Citi Premier: 3 points per dollar Amex Green: 3 points per dollar | |||
7 | |||||||
8 | About Your Stay | Cash Only | Points Only | Points + Cash | Cash + Point Upgrade | Notes | |
9 | Cost of Stay | Cash cost of entire stay | $632 | $0 | $328 | $328 | If this is a points-only stay, put $0. For cash stays or cash+points stays, enter the total after-tax cash component for the entire stay |
10 | Point cost of entire stay | 0 | 24,000 | 12,000 | 9,000 | For cash-only stays, enter 0. For points stays or cash+points stays, or cash stays with points used to upgrade, enter the total number of points used for entire stay. | |
11 | Initial Results | Estimated points earned from stay | 3,158 | 0 | 1,641 | 1,638 | Assumes earning 5 points per dollar from Hyatt. This is just an approximation because it doesn't account for elite status or the fact that you won't earn points for taxes paid. |
12 | Credit card points earned | 2,527 | 0 | 1,313 | 1,310 | Calculated based on how many points per $ your credit card earns | |
13 | Net points earned (or spent) | 5,685 | -24,000 | -9,047 | -6,052 | A positive number means that you'll end up with more points than you started with. A negative number means that you'll have spent more points than you earned. | |
14 | Value of points earned (or spent) | $85.28 | -$360.00 | -$135.70 | -$90.78 | A positive number means that you'll end up with more points than you started with. A negative number means that you'll have spent more points than you earned. | |
15 | Final Result | $546.41 | $360.00 | $463.83 | $418.32 | This row shows your net cost of each option based upon how much you value points. | |
16 | |||||||