Understanding the cell phone plan calculator — concept and principle
Comparing phone deals is confusing when one offers a discounted phone with an expensive plan and another a cheap plan with a full-price phone. This calculator puts two options on the same footing by adding up the plan fees and the phone cost over the same period, including discounts, trade-in credits and instalment interest, and tells you which is cheaper and by how much.
How it is calculated
Plan cost = monthly fee × (1 − discount ÷ 100) × months
Phone financed = phone price − discount or trade-in credit
Interest-free: phone cost = financed amount
With interest: monthly payment = P × i ÷ (1 − (1 + i)^(−n)), i = yearly rate ÷ 12, n = months
Total = plan cost + payments; instalment interest = payments − financed amount
Saving = |total A − total B|
The principle
The fair way to compare deals is total cost of ownership over the same period. A large phone discount can be outweighed by a higher monthly fee, because the fee repeats every month. When a phone is paid in instalments with interest, each equal payment covers interest on the remaining balance plus some principal; the annuity formula gives that level payment. Adding everything over the contract turns two different-looking offers into two comparable numbers.
Worked example
Default inputs: 24 months; A: $80 per month, $1,000 phone with $400 credit; B: $30 per month, $1,000 phone, no credit; no discounts or interest.
- A plan = 80 × 24 = $1,920; phone = 1,000 − 400 = $600; total = $2,520.00.
- B plan = 30 × 24 = $720; phone = $1,000; total = $1,720.00.
- Averages: A $105.00, B $71.67 per month.
- Instalment interest: $0.00 for both.
- Cheaper option = Option B, saving $800.00.
| Option A: monthly plan fee | Saving with the cheaper option |
|---|---|
| 20 | $640.00 |
| 40 | $160.00 |
| 60 | $320.00 |
| 80 | $800.00 |
| 100 | $1,280.00 |
| 120 | $1,760.00 |
| 160 | $2,720.00 |
How to read the result
The cheaper option over the period is the better deal on cost, but also consider data allowance, network coverage, what happens at the end of the contract and whether you keep a phone with resale value. A low-cost plan with an unlocked phone often wins over two years, but promotions vary, so recalculate with your actual offers.
Common mistakes
- Comparing periods of different lengths.
- Forgetting one-off fees such as activation or SIM charges.
- Ignoring the plan price after a promotional period ends.
- Treating a monthly "phone credit" as a discount when it only applies if you keep the plan.
Frequently asked questions
Is buying the phone outright cheaper?
Often, if you pair it with a cheaper plan, but compare totals with your real offers.
How is instalment interest calculated?
With the level-payment loan formula, using the yearly rate divided by 12.
Should I include trade-in value?
Yes, enter it as a credit on the phone price for the option that gives it.
What period should I use?
Use the contract length, or how long you expect to keep the phone.
Sources: R. Sekhon & R. Bloom, Applied Finite Mathematics (De Anza College, LibreTexts), "Installment Loans" (level-payment formula)