ValueQuarry Pricing, profit, and payout tools

Calculator template

Subscription Revenue Template

Build a subscription revenue calculator with subscribers, price, churn, processor fees, and monthly costs.

Review the inputs and formulas below, then open this template in the calculator builder to customize the field names, values, result styles, and notes.

Open this template in the calculator builder Browse all calculator templates

Inputs

What people fill out

  • Subscribers

    Uses subscribers in formulas, starts as a number field, and begins at 100.

  • Monthly price

    Uses monthly_price in formulas, starts as a currency field, and begins at 19.

  • Churn rate

    Uses churn_rate in formulas, starts as a percent field, and begins at 5.

  • Processor fee rate

    Uses processor_fee_rate in formulas, starts as a percent field, and begins at 2.9.

  • Monthly costs

    Uses monthly_costs in formulas, starts as a currency field, and begins at 350.

Outputs

What the template calculates

  • Monthly recurring revenue

    Format currency

    Result style primary

    Formula subscribers * monthly_price

    Gross recurring revenue before churn and processing costs.

  • Churned revenue

    Format currency

    Result style metric

    Formula subscribers * monthly_price * churn_rate

    Revenue at risk from the current churn assumption.

  • Net monthly revenue

    Format currency

    Result style breakdown

    Formula (subscribers * monthly_price) - ((subscribers * monthly_price) * processor_fee_rate) - monthly_costs

    Revenue left after processor fees and monthly costs.

Use cases

When this template helps

  • Estimate monthly recurring revenue from subscribers and price.
  • Include churn and processor fees in a simple revenue view.
  • Create a reusable subscription planning calculator for memberships or paid communities.

Related

More ways to work with this math

FAQ

Quick answers

Short answers for the questions that usually come up first.

Can I edit this subscription revenue template?

Yes. Open the template in the builder, then change the labels, values, formulas, notes, or output display styles to fit your workflow.

Can I save a version after I change it?

Yes. Save it on this device, export JSON, or copy a share link after you make changes.

Can I use this as a starting point for a different calculator?

Yes. Templates are meant to be edited. Remove fields, add new ones, or swap formulas if you want a different custom calculator.