Chase Sapphire Reserve - ROI Analysis

	A	B	C	D	F	G	H
1	AskSebby
2	Read our analysis here: http://bit.ly/2yB17zJ
3	Chase Sapphire Reserve Referral Link: https://asksebby.com/csr2
4
5
6	To use this tool, click "File" (top left) > "download as Excel" and modify the GREEN fields
7
8
9	This spreadsheet will help you determine if the Chase Sapphire Reserve (CSR) makes sense for you. The annual fee is hefty but, depending on your spend and how you value Chase's Ultimate Reward (UR) points, it can easily be worth more than $3,500 after the annual fee!
10
11	Application date	9/18/2024
12
13		Year 1			Year 2
14			UR	Cash		UR	Cash
15	UR Benefits
16	Sign up bonus of 50k Ulimate Reward (UR) points
17	Are you able to spend $4,000 in the first 3 months?	Yes	50,000
18	3x points on travel and dining
19	How much travel and dining will you put on this card per year?	10,000	30,000		10,000	30,000
20	1x points on everything else
21	How much other spend will you put on this card?	1,000	1,000		1,000	1,000
22	Total UR points		81,000			31,000
23
24	How would you redeem UR points? (Put an "X" on only one choice)
25	Cash (1 CPP)
26	Travel on Chase portal (1.5 CPP)	X			X
27	Transfer partners (2 CPP)
28	Value of redemption			1,215			465
29
30	$300 Travel Credit
31	You'll get $300 per calendar year for anything that codes as travel
32	For the first year, that means you'll get $600 in value (2017 and 2018)
33	Will you spend at least $300 in travel from today until 12-31-2017?	Yes		300
34	Will you spend at least $300 in travel from 01-01-2018 until 09-17-2025	Yes		300
35	Will you spend at least $300 in travel from 01-01-2019 until 09-17-2026				Yes		300
36
37	$100 Global Entry credit
38	You'll get a $100 credit for global entry every 4 years
39	Are you planning to sign up for Global Entry for yourself or your family?	Yes		100
40
41	Priority Pass
42	How do you value Priority Pass?			120			120
43
44	Chase Perks
45	How do you value Chase perks?			100			100
46
47	Total Benefit			2,135			985
48	Total Cost			(450)			(450)
49	Net Value			1,685			535
50	Should you get it?			Yes, you're getting value			Yes, you're getting value
51
52	Glossary
53	UR = Chase "Ultimate Reward" points
54	Travel and dining = Any transactions that code as these two items
55	CPP = Cents Per Points; if you have 10,000 points and you redeem it for 1 CPP, you're getting $100 in value
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