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.