Free · Works in FLYNT Sheets

SaaS Pricing & MRR Calculator Template

A real spreadsheet for modeling recurring revenue from seat-based pricing, not a full billing or analytics platform. Enter your monthly price per seat, average seats per customer, and number of customers, and it calculates monthly revenue per customer, then rolls that up into MRR and ARR — a quick planning model, built for pricing decisions and simple projections rather than live billing data.

Monthly Price per Seat$25.00
Seats per Customer (avg)8
Monthly Revenue per Customer$200.00
Number of Customers60
Monthly Recurring Revenue$12,000.00
Annual Recurring Revenue$144,000.00

Green rows calculate automatically from the values above them — change any number in FLYNT Sheets and they update.

Who it's for

Early-stage and small SaaS founders modeling pricing changes or projecting revenue at a given customer count, before or instead of standing up a dedicated billing analytics tool.

Key features

  • Monthly price per seat and average seats per customer fields
  • Monthly revenue per customer calculated automatically
  • Adjustable customer count
  • MRR calculated automatically
  • ARR calculated automatically
  • Exports to a real .xlsx file

How to use it

  1. Click "Use this template" to open it in FLYNT Sheets
  2. Enter your real monthly price per seat
  3. Enter your average seats per customer
  4. Enter your current or projected customer count
  5. Review the MRR and ARR it calculates

What's included

  • Price per seat, seats per customer, and customer count fields with example numbers
  • Monthly revenue per customer, MRR, and ARR formulas already wired up

Common use cases

  • Modeling how a pricing change affects MRR before rolling it out
  • Projecting ARR at a target customer count for a board update or investor conversation
  • A quick sanity check on revenue math without opening a full billing analytics tool

Frequently asked questions

Does this replace a subscription analytics platform?
No — this is a planning calculator built on assumptions you enter, not a live analytics tool connected to your actual billing data. If you need real churn, cohort, or expansion revenue tracking from live subscriptions, that's a job for a dedicated tool like ChartMogul, Baremetrics, or ProfitWell. This template does one thing: turn seat-based pricing assumptions into a quick MRR and ARR estimate.
Does this account for churn or expansion revenue?
No — it's a straight-line model based on price, seats, and customer count at a point in time. For a business with meaningful churn or expansion, treat this as a starting planning number, not a forecast.
Is this free to use?
Yes, on FLYNT's free plan — no credit card required.