Calculate the first-year cost and ongoing monthly cost of two offers using the introductory price, its duration, the regular price and extra charges.
A discount for the first few months can hide a more expensive ongoing bill. Use this worksheet for an internet plan, subscription or membership with a monthly introductory price and a regular monthly price. Compare equivalent service and the same twelve-month period.
How the calculation works
The worksheet prices a twelve-month commitment. It applies the reduced monthly price for the introductory period, then the regular price for the rest of the year. It adds setup once and monthly extras twelve times. For weekly or annual billing, first convert the quote to a consistent monthly equivalent. A partial-month promotion needs a separate calculation.
A worked example
Hypothetical membership A charges $15 for three months, then $45, plus a $30 joining fee and $5 in monthly extras. Its first-year cost is $540 and its ongoing monthly cost is $50. Membership B at $40 a month with no extras costs $480 for the year. These illustrative figures are not available membership offers.
What to check before deciding
Check whether you will use the service often enough to justify the commitment. Compare pause, cancellation and renewal terms, not only the first-year total. Keep taxes consistent across the figures and ask about charges that fall outside the monthly fee. The model assumes you keep the service for twelve months; it does not calculate an early exit or an annual price increase. For phone-specific costs and device charges, use the phone-plan calculator.
For the wider context, use Making a budget — FCAC. The arithmetic here compares your inputs; it does not recommend or approve a provider.
