Understanding the cash back calculator — concept and principle
This calculator estimates the yearly cash back from a rewards credit card with a bonus category (with an optional cap), a second category and a base rate on everything else, then subtracts the annual fee. It shows net cash back, the effective rate on all spending, the first-year amount with a sign-up bonus and the amount from each category. Use it to compare cards or check whether a fee card pays off.
How it is calculated
- Yearly cash back = Σ monthly spending × 12 × rate for each category.
- Capped category: spending up to the yearly cap earns the bonus rate; spending above it earns the base rate.
- Net cash back = total cash back − annual fee.
- Effective rate = net cash back ÷ total yearly spending.
- First year = net cash back + sign-up bonus.
The principle
Rewards are a percentage of spending, so the value depends on how your spending matches the card's categories. A bonus rate only helps on the spending that falls in that category and under the cap. The annual fee is a fixed cost, so a fee card pays off only if your extra rewards exceed the fee compared with a no-fee card. Interest is not part of this: if you carry a balance, card interest is usually far larger than any rewards.
Worked example
Default inputs: category 1 $600/month at 3% with a $6,000 yearly cap; category 2 $200/month at 2%; other $1,200/month at 1%; fee $95; sign-up bonus $200.
- Category 1: $7,200 a year; 6,000 × 3% = $180 plus 1,200 × 1% = $12, total $192.
- Category 2: 2,400 × 2% = $48.
- Other: 14,400 × 1% = $144. Total before the fee = $384.
- Net cash back = 384 − 95 = $289.00; about $24.08 a month.
- Effective rate = 289 ÷ 24,000 ≈ 1.2%; first year with the bonus = $489.
| Category 1 cash back (%) | Net cash back per year |
|---|---|
| 0.75 | $154.00 |
| 1.5 | $199.00 |
| 2.25 | $244.00 |
| 3 | $289.00 |
| 3.75 | $334.00 |
| 4.5 | $379.00 |
| 6 | $469.00 |
How to read the result
Compare the effective rate with a flat-rate no-fee card. If a plain 1.5% card would earn more on your spending, the bonus structure is not worth the fee. The first-year figure includes the one-time bonus, so judge the card on the ongoing yearly amount.
Common mistakes
- Forgetting the cap on the bonus category.
- Ignoring the annual fee or counting the sign-up bonus every year.
- Spending more than planned to earn rewards.
- Carrying a balance, which turns a small reward into a large interest cost.
Frequently asked questions
Is a card with an annual fee worth it?
Only if its extra rewards over a no-fee card are larger than the fee for your spending.
What happens above the bonus cap?
Spending above the cap usually earns the base rate.
Does carrying a balance affect cash back value?
Yes. Interest charges usually far exceed rewards, so pay in full to benefit.
Sources: Consumer Financial Protection Bureau, "Credit Card Rewards" Issue Spotlight (May 2024)