Wall Street Prep

Average Revenue Per Account (ARPA)

Guide to Understanding Average Revenue Per Account (ARPA)

Learn Online Now

Average Revenue Per Account (ARPA)

How to Calculate ARPA

ARPA, short for “average revenue per account,” refers to the subscription or contractually recurring revenue generated per account.

Like most SaaS KPIs, ARPA is one method for companies to develop a better sense of their customer base and how their spending reacts to specific changes.

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.

ARPA Formula

The formula to calculate average revenue per account is as follows.

Formula
  • ARPA = Monthly Recurring Revenue (MRR) / Total Number of Active Accounts

MRR can also be replaced with annual recurring revenue (ARR) to annualize the 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).

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.

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

ARPA vs. ARPU

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.

How to Interpret Average Revenue Per Account

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 – Excel Model Template

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

Submitting ...

SaaS ARPA Example Calculation

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
guest
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
X

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.