Go Back   FlyerTalk Forums > Miles&Points > Credit, Debit and Prepaid Card Programs > Credit Card Programs
Sign in using an external account

Reply
 
Thread Tools Search this Thread
Old Apr 2, 14, 3:06 pm   #1
 
Join Date: Oct 2013
Posts: 26
Credit Card Comparison Spreadsheet

I wanted to share comparative analysis tool I put together when I started evaluating different card products. It looks like a couple folks have shared spreadsheets in the past, but I've been surprised that there are not more templates around. Thought this might be useful to someone, and I was interested in confirming some of my estimates, so I've created a publicly editable Google Spreadsheet with some dummy spend figures:

Link to product comparison spreadsheet

I've got my own original copy. I'd suggest that if you want to actually use this, you make a copy of it. Otherwise, feel free to comment on formulas, add products, etc

1. The first sheet takes inputs from sheet 3 (spend) and gives a granular breakdown of rewards by category, signup and annual bonuses, fees, other benefits with cash value, etc. and aggregates into both initial and subsequent year "value," an effective rate of return based on cost, and a multi-year projection based on spending.

2. Sheet 2 is an attempt to aggregate all non-rewards benefits into one place, which has been frustrating for me to keep track of. I was curious to compare things like insurance coverage terms and limits, as well as more extensive and fringe perks for travel, transportation, lodging, all that good stuff--I have not seen this info captured in one place anywhere.

3. Sheet 3 is the actual spending variable, and valuations for reward program points. The values entered right now were focused on awards for cross-country and international airfare. Obviously you would want to update your own version with how you plan to redeem points.
SpunkyGD is offline   Reply With Quote
Old Apr 2, 14, 8:20 pm   #2
 
Join Date: Feb 2014
Posts: 79
It's a great start. I don't know why it's so quiet here. I guess just want to look and that's it.
Strawboy1230 is offline   Reply With Quote
Old Apr 3, 14, 6:41 pm   #3
 
Join Date: Oct 2013
Posts: 26
Heh, thanks Strawboy. I'm actually a little surprised too! Thought there would be more numbers geeks on here. I really think it would help cut through the subjective sense of valuation to punch in some concrete numbers and see how/where value really breaks down.

I'm noticing quite a bit of movement, mostly people playing with spend figures (cool) and for some reason creating lots and lots of new, blank sheets. Not sure what people are trying to do. Let me know if there would be any useful changes .(I had to lock the front page because a couple folks started directly entering rewards for some reason)

Hopefully someone is finding it useful to make their own copy and playing with that. I'd love to hear insights!

I for example am surprised frankly at how well stacked the Amex products seem to be (assuming you are targeting award travel) compared to Chase, even though the CSP seems to have stronger mainstream support.

The CSP can have a bit of an advantage at lower spend levels, but if you primarily use one card, it really loses ground quickly.

Why don't more people talk about the Mercedes Benz Amex revolver?

The Everyday cards are killer on paper. The Preferred version has such a lead I don't even bother comparing it.

It's also interesting to see how the cash cards cleanly take a back seat if you are planning award travel. Even the favored Barclay Arrival, which is cashback-like and sounds great for a simple flat 2%, doesn't actually stack up wonderfully compared to any of the travel cards--again, unless you specifically will not use award travel and just want generic statement credit.
SpunkyGD is offline   Reply With Quote
Old Apr 3, 14, 9:16 pm   #4
 
Join Date: Jan 2013
Posts: 77
super helpful, thanks for sharing!

does the "old" tab have any relevance?

Last edited by MDtR-Chicago; Apr 4, 14 at 8:07 am.. Reason: merge consecutive posts
bg26892 is offline   Reply With Quote
Old Apr 3, 14, 9:33 pm   #5
 
Join Date: Jan 2013
Posts: 77
Quote:
Originally Posted by SpunkyGD View Post
Why don't more people talk about the Mercedes Benz Amex revolver?
Very solid and thorough analysis! however if you change the "typical benefits" to $400 (2 x $200 per calendar year for airline reimbursement) - the value of this card increases quite a bit. however the long term analysis (beyond 1 year) is a bit trickier to calculate bc it depends on how many annual fees you pay and how many $200 reimbursements you receive.
bg26892 is offline   Reply With Quote
Old Apr 4, 14, 6:09 am   #6
 
Join Date: Feb 2014
Posts: 79
Quote:
Originally Posted by bg26892 View Post
Very solid and thorough analysis! however if you change the "typical benefits" to $400 (2 x $200 per calendar year for airline reimbursement) - the value of this card increases quite a bit. however the long term analysis (beyond 1 year) is a bit trickier to calculate bc it depends on how many annual fees you pay and how many $200 reimbursements you receive.
Newb question but what's the Mercedez Amex Revolver? Is that the normal card or the plat?
Strawboy1230 is offline   Reply With Quote
Old Apr 4, 14, 6:16 am   #7
mia
FlyerTalk Evangelist, Moderator: American Express, Diners Club
 
Join Date: Jun 2003
Location: Miami & London
Programs: AA 2MM Perpetual Platinum; HH & SPG Gold
Posts: 19,354
Quote:
Originally Posted by Strawboy1230 View Post
Newb question but what's the Mercedez Amex Revolver?
Revolver should = Credit Card (with a revolving credit line). This one:

https://www304.americanexpress.com/p...edit-apply-top
mia is offline   Reply With Quote
Old Apr 4, 14, 6:35 am   #8
 
Join Date: Feb 2014
Posts: 79
Quote:
Originally Posted by mia View Post
Revolver should = Credit Card (with a revolving credit line). This one:

https://www304.americanexpress.com/p...edit-apply-top
Ah, understood. Thanks mia.
Strawboy1230 is offline   Reply With Quote
Old Apr 4, 14, 9:25 am   #9
 
Join Date: Oct 2013
Posts: 26
Quote:
Originally Posted by bg26892 View Post
super helpful, thanks for sharing!

does the "old" tab have any relevance?
Nope, forgot that was in there. It had been hidden, just a previous iteration of the sheet.
SpunkyGD is offline   Reply With Quote
Old Yesterday, 11:28 pm   #10
 
Join Date: Jun 2005
Location: Mountain View, CA (near SFO)
Programs: 1P on United, with bunches of miles strewn elsewhere
Posts: 341
Ah, interesting! I made (and shared on FT) my own CC sheet as well a year or two ago. It, too, got very little traction, and I haven't bothered updating it recently .

To answer your question about the fawning over the CSP card vs. less excitement over the Everyday cards...

CSP card:
- $95 annual fee (much cheaper than most for-fee Amex cards)
- Get a human immediately when you call
- Transfers 1:1 to United, which, well, used to be really valuable <sigh>.
- Neat looking, solid card.
- When coupled with the Freedom or Ink cards, you can earn 5x points pretty easily with little work.
- Earns 2x on all restaurant and travel spend, and with no caps! For those who travel for work a lot (e.g., a lot of FT'ers ), this = a lot of additional points.

Amex cards:
- Typically high annual fees
- Everyday cards are a pain in the tuckus... 20-30 charges/month to get the bonus? Sure, it's possible (hello, $1 Amazon gift cards!) but for busy people, meh.
- Everyday Preferred has a $6K annual cap on bonus spend (at least in the grocery store category). That seems not awful to me, but most Manufactured Spending fiends have dismissed it as pathetically small when they can easily churn that much monthly.
- And -- while it's kinda silly to note -- apparently the Everyday cards are uuuuuuugly.
__________________
"Being run over by a Zamboni would be flat-out cool" - Adam
ThatAdamGuy is offline   Reply With Quote
Old Today, 9:16 am   #11
 
Join Date: Oct 2013
Posts: 26
Oh, I didn't see this before. I might try to incorporate some of this into my own when I get a chance!

Did not know about the Chase service rep, that does count for a lot! I've only ever called into the card services number on my Plat with Amex so maybe my experience has been different.

I agree on paper the CSP looks strong, especially in combination with the Freedom and Ink... 7% dividend, 5x on select categories.... what's interesting is that in addition to Freedom's $1500 quarterly cap, and the rotating categories end up dictating your behavior rather than fitting your actual spending patterns (unless you devote the time to gaming the system).

Adding an Ink Plus/Bold puts annual fees into or beyond Amex territory, and unless you can really max out that office category (which I assume entails some MS or again, gaming the system) it seems pretty hard to offset the additional $95.

Personally I try to assume a ~3 year+ relationship in which the issuers address easily exploited loopholes, and I don't blow time trying to micro-manage rules (which at almost anyone's "market rate" is probably a losing effort!)

Totally agree on the travel categories if you fly around for work a lot, although these days the flights are so expensive, getting 3x or 4x on those can be a lot more significant than dining and hotels. Might be very different for extended stays, I tend to make fairly short trips.

I have to create some pretty contrived scenarios where the Chase combos come out ahead, so maybe I'm just calculating things wrong?
SpunkyGD is offline   Reply With Quote
Old Today, 4:43 pm   #12
 
Join Date: Feb 2013
Posts: 801
Quote:
Originally Posted by SpunkyGD View Post
I agree on paper the CSP looks strong, especially in combination with the Freedom and Ink... 7% dividend, 5x on select categories.... what's interesting is that in addition to Freedom's $1500 quarterly cap, and the rotating categories end up dictating your behavior rather than fitting your actual spending patterns (unless you devote the time to gaming the system).
I'm not sure I follow you here. CSP and Ink have fixed categories so the only time you have to spend "gaming the system" is pulling the right CC out when you purchase something. Freedom's 5x categories only change once a quarter, so not much time or effort required there either.

Quote:
Originally Posted by SpunkyGD View Post
Adding an Ink Plus/Bold puts annual fees into or beyond Amex territory, and unless you can really max out that office category (which I assume entails some MS or again, gaming the system) it seems pretty hard to offset the additional $95.
Chase is pretty consistent about giving retention bonuses on their Ink cards so I consider them no AF CCs for all intents and purposes. Even if I had to pay the $95 AF without an offsetting retention bonus, my cell phone and cable bills alone more than pay for the AF, and both of those are on auto-pay so no time or effort required.

Quote:
Originally Posted by SpunkyGD View Post
Totally agree on the travel categories if you fly around for work a lot, although these days the flights are so expensive, getting 3x or 4x on those can be a lot more significant than dining and hotels.
Is there a CC that earns 4x in flexible CC points on flights? I thought the best MR card for that was PRG at 3x, comparable to the CSP's 3.21x when you book through the UR website.

Quote:
Originally Posted by SpunkyGD View Post
I have to create some pretty contrived scenarios where the Chase combos come out ahead, so maybe I'm just calculating things wrong?
Can you describe some scenarios where a different combination (MR or otherwise) comes out ahead of the Chase Freedom/CSP/Ink combo?
bribro is offline   Reply With Quote
 
 
Reply

Bookmarks


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump


All times are GMT -6. The time now is 10:39 pm.




SEO by vBSEO ©2011, Crawlability, Inc.