With so many choices out there, which credit card fits your spending habits to maximize value?  Use this tool to compare 20 of the most popular beginner to mid-tier credit cards out there!

The credit card list includes:

Nov18CC_List

The breakdown by bank is as follows:

Nov18CreditCards_BreakdownbyBank.png

How to use the tool:

  1. Click the OneDrive Link above or here
  2. Click “Download” at the top right corner of the screenNov18CCDownload1.png
  3. Once downloaded, click “Enable Editing” to activate the workbookNov18CCEnable2.png
  4. The workbook is split up into 5 sections:Nov18CC4Sections.png
    1. Enter your monthly expenses by bucket:Nov18CC_Expenses
    2. Select limiting criteria (i.e. I only want to return cards with no annual fee or only Visa cards)Nov18CCSection2
    3. Refresh PivotTables and analyze cards available (Click here to learn more about PivotTables)Nov18CCRefresh
    4. After the refresh, the stacked bar chart should update automatically to show the breakdown of rewards by category:Nov18CCReturns.png

There are some assumptions:

  • It’s hard to compare membership points in an apples to apples comparison; some membership points may have more value than others
  • Some cards offer rotating categories; in these cases, points awarded may not be perfect
  • Chase Ultimate Rewards points are counted with multipliers for that specific card; using them in tandem will boost rewards.
    • Reserve has a 1.5x multiplier (factored in)
    • Preferred has a 1.25x multiplier (factored in)
    • All others are 1x multiplier (unless otherwise stated)
  • With some cards, especially higher end cards, there may be hard to quantify perks such as dining/travel credits.  The value may not be consistent from person to person.  That being said, any credits are factored into the annual returns.  Examples:
  • With some cards, especially higher end cards, there are other hard to quantify perks such as access to priority pass airport lounges, hotel statuses, car rental insurance, cell phone insurance, trip cancellation services, concierge services, etc.  These have not been factored into the calculations.

Please keep in mind…

This tool is merely to give an idea of how some cards can shine over others depending on the inputs given.  Please do not let this tool completely dictate your decision, as there are numerous other factors that this model does not take into consideration (i.e. how many hard inquiries you have, long term strategy, other cards you hold, what you value, etc.)