background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Average Revenue Per Account (ARPA)

Guide to Understanding Average Revenue Per Account (ARPA)

Last Updated January 31, 2024

Learn Online Now

Average Revenue Per Account (ARPA)

How to Calculate Average Revenue Per Account (ARPA)

The ARPA, or “Average Revenue Per Account,” is the subscription-based or contractually recurring revenue generated per account.

Like most SaaS KPIs, the ARPA metric is one method for software companies to develop a better sense of their customer base and their spending patterns.

Usually, ARPA is expressed on a monthly or annual basis and is calculated by dividing a company’s monthly recurring revenue (MRR) by the total number of active accounts.

In practice, the primary use case for calculating the ARPA is comparing cohorts of accounts, which can be categorized by customer type, the month onboarded, and various other factors.

High-growth SaaS companies frequently implement changes to maintain growth (and increase expansion revenue), so tracking ARPA in segments can bring attention to growth or contraction MRR.

The steps to calculate the average order value (AOV) are as follows:

  • Step 1 → Determine the Monthly Recurring Revenue (MRR)
  • Step 2 → Count the Total Number of Active Accounts
  • Step 3 → Divide MRR by the Number of Active Accounts

ARPA Formula

The formula to calculate average revenue per account (ARPA) is the ratio between monthly recurring revenue (MRR) and the total number of active accounts.

ARPA = Monthly Recurring Revenue (MRR) ÷ Total Number of Active Accounts

The monthly recurring revenue (MRR) can also be replaced with annual recurring revenue (ARR), i.e. the MRR is converted into an annualized metric.

The period chosen (i.e. monthly vs. annual) should depend on how the subscription businesses being assessed operate (monthly vs. longer-term contracts) and the purpose of the analysis (i.e. customer cohort analysis, long-term revenue forecasting).

Note: The customers offered a free trial must be excluded from the calculation – otherwise, ARPA will be unnecessarily weighed down by a freemium strategy.

ARPA vs. ARPU: What is the Difference?

Often, ARPA is used interchangeably with average revenue per account (ARPU).

While the distinction is usually negligible, the distinction can be quite significant in certain cases as a single customer can be the owner of multiple accounts (i.e. per-user or per-seat pricing plans).

Having one customer owning multiple accounts is most common for B2B companies (i.e. a company purchasing licenses for multiple employees).

Since averaging the total revenue brought in can be overly simplistic – as in the case of ARPU –  SaaS companies can opt to segment them into two categories.

  1. New ARPA
  2. Existing ARPA

By doing so, a company can better understand the behavior of its customers and make appropriate adjustments to its business model, e.g. setting the pricing appropriately, targeting the right customers, and identifying common causes of customer churn.

The issue with the ARPU metric for SaaS companies is that an outlier – an account in which revenue is highly concentrated – can skew the average and potentially conceal a decrease in revenue per account.

What is a Good ARPA in the SaaS Industry?

Separating the two enables SaaS companies to obtain more granular insights into their recurring revenue trends on a more individualized basis.

If there is a large difference between new and existing ARPA, it could potentially signify that ARPA is trending in the wrong direction.

On the other hand, having a new ARPA that is higher than the existing ARPA clearly indicates that the company is monetizing its users more effectively than in the past.

Additionally, ARPA can show companies which specific products have the most demand, the end markets most receptive to the products, and which customer types to target to maximize profitability.

ARPA Calculator

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

SaaS ARPA Calculation Example

Suppose a SaaS company has 10,500 accounts in January 2022, with zero customer churn in the next month.

Based on a cut-off date, the company’s customers are split into existing and new accounts.

In January, the monthly recurring revenue (MRR) of both customer types is shown below:

  • Existing Accounts MRR = $240,000
  • New Accounts MRR = $20,000

For February, the MRR from existing accounts increases by $10,000, while the MRR from new accounts declines by $5,000.

  • Existing Accounts MRR = $250,000
  • New Accounts MRR = $15,000

Thus, the total MRR for the two months comes out to $260,000 and $265,000.

If we divide the MRR by the corresponding cohort’s number of accounts, we arrive at the following figures:

January 2022

  • Existing ARPA = $24.00
  • New ARPA = $40.00

February 2022

  • Existing ARPA = $25.00
  • New ARPA = $30.00

The ARPA from existing accounts grew by $1.00, while the ARPA from new accounts fell by $10.00.

However, the drop-off in revenue from new accounts is not reflected by the total MRR (if we did not segment the customers by type).

The increase in ARPA from existing accounts was insignificant, but still enough to offset the entirety of the lost ARPA from new accounts.

If the company’s new ARPA had increased over time, that would have been a positive indicator that the current go-to-market strategy and sales and marketing efforts were paying off.

But in this example, the opposite was observed, as the recent changes led to a decline in MRR per account and greater reliance on previously acquired accounts, which is not ideal.

ARPA Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.