CSP to CSR Upgrade Analysis (by AskSebby.com)

	A	B	C	E	F	H	I
1	AskSebby
2	Want to see if it makes sense to product change your Chase Sapphire Preferred to a Chase Sapphire Reserve?
3	Read our analysis here:
4	https://www.asksebby.com/blog/does-it-make-sense-to-upgrade-to-the-chase-sapphire-reserve-from-the-preferred
5
6	1) Make an editable copy (File > Make a copy OR File > Download as)
7	2) Only change the GREEN cells; everything else is a formula
8	3) The difference calculator (bottom right) shows you what makes sense.
9
10
11		CSR		CSP
12		Year 1	Year 2	Year 1	Year 2
13
14	Year start (product change date)	9/30/2025	9/30/2026
15	Year end	9/29/2026	9/29/2027
16
17	Travel spend
18	How much will you spend on travel from Year 1 start until 12/31/2016?	2,000		2,000
19	How much will you spend on travel from 01/01/2017 until Year 1 end?	2,000		2,000
20	How much will you spend on travel from Year 2 start until 12/31/2017?		2,000		2,000
21	How much will you spend on travel from 01/01/2018 until Year 2 end?		2,000		2,000
22
23	Dining spend
24	How much will you spend on dining in Year 1?	1,000		1,000
25	How much will you spend on dining in Year 2?		1,000		1,000
26
27	Other spend
28	How much will you spend on other (non-travel and non-dining) in Year 1?	500		500
29	How much will you spend on other (non-travel and non-dining) in Year 2?		500		500
30
31	Ultimate Rewards (UR) redemption
32	How would you redeem UR points? [enter: cash, portal, or transfer]	transfer	transfer	transfer	transfer
33	Current UR points	200,000		200,000
34	UR points earned	15,500	15,500	10,500	10,500
35	Total UR points	215,500	15,500	210,500	10,500
36	Redemption multiplier (CPP)	2.10	2.10	2.10	2.10
37	Value from UR redemption	4,526	326	4,421	221
38
39	Travel credit
40	Travel credit for 2016	300
41	Travel credit for 2017	300	0
42	Travel credit for 2018		300
43	Value from travel credit	600	300	0	0
44
45	Global Entry
46	Would you take advantage of Global Entry [enter: yes or no]	no
47	Value from Global Entry	0	0	0	0
48
49	Priority Pass Select
50	How do you value Priority Pass Select?	0	0	0	0
51
52	Value before annual fee	5,126	626	4,421	221	DIFFERENCE
53	Annual fee	(450)	(450)	(95)	(95)	Year 1	Year 2
54	Net value	4,676	176	4,326	126	350	50
55
56						Year 1: You should PC your CSP to CSR for at least a year.
57						Year 1: You should PC your CSP to CSR for at least a year.
58
59						Year 2: You should keep the CSR.
60						Year 2: You should keep the CSR.
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