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

Average Revenue Per User (ARPU)

Step-by-Step Guide to Understanding Average Revenue Per User (ARPU)

Last Updated December 6, 2023

Learn Online Now

Average Revenue Per User (ARPU)

How to Calculate ARPU?

The term ARPU stands for “Average Revenue Per User” and quantifies the typical revenue generated from each user.

The ARPU is useful for determining if the current monetization strategies are working as intended, which would be reflected by the ARPU trending upward over time as improvements are implemented.

For all companies, regardless of industry or size, long-term profit generation boils down to one question: “How much is a single customer worth to a business?”

The go-to-market strategies employed to achieve growth (e.g. sales & marketing, product development) depend on the answer to the question stated above.

A rational, well-run company should be reluctant to continue spending significant amounts of capital if the potential return from customers is insufficient. The exception is if growing the user base takes precedence over monetizing the users for the time being, but eventually, the company must become more profitable.

Therefore, a company’s ARPU essentially sets a ceiling on the amount that can be spent to fund growth and expansion plans.

ARPU Formula

The formula for calculating the average revenue per user (ARPU) is as follows.

Average Revenue Per User (ARPU) = Total Revenue ÷ Total Number of Customers

For example, if a company has produced $10 million in revenue with 10,000 customers, the ARPU is $100.

  • Average Revenue Per User (ARPU) = $10 million Revenue ÷ 10,000 Customers
  • ARPU = $100.00

So, what does the $100 ARPU mean?

Each of the company’s customers contributed $100 in revenue.

Taking it a step further, there are numerous variations of the rather basic ARPU calculation, which has many shortcomings.

In particular, one common variation of the ARPU metric is the average revenue per paying user, or “ARPPU”, which is predicated on the notion that only paying customers should be included to better understand the true amount of spending per customer.

ARPPU = Total Revenue ÷ Total Number of Paying Customers

The premise of the ARPPU is similar to that of popular metrics for internet companies, such as daily active users (DAU) per month. The objective is to count only those users that are “active” on the platform.

If “inactive” users (or non-paying customers) are included, the average payment value can easily become skewed, so splitting up customer types allows companies to better grasp spending patterns and amounts.

However, note that many companies use the “ARPU” and “ARPPU” interchangeably, so it is crucial to confirm how the company calculates each metric.

What is a Good ARPU?

It should go without saying that a higher ARPU (and year-over-year growth) is clearly going to be beneficial for a company over the long run.

  • Increasing ARPU → Improvement in Monetization of User Base
  • Decreasing ARPU → Deterioration in Monetization of User Base
Increasing ARPU Decreasing ARPU
  • Increased Average Selling Price (ASP) Per Unit – i.e. Significant Market Share with Pricing Power
  • Forced Reduction in Pricing to Increase Customer Demand – e.g. Threat of New Market Entrants
  • Strategic Customer Targeting – e.g. Low Churn, Affluent Customer Base
  • Difficult to Monetize Customer Base – e.g. B2C, Younger Demographic with Minimal Discretionary Income
  • Extensive Upselling/Cross-Selling Opportunities
  • Standalone Product with Few Upselling/Cross-Selling Opportunities
  • Differentiated Product/Service Offering with Strong Branding Leading to Premium Pricing
  • Weak Branding Strategies (i.e. Forced to Offer Discounts)
  • Lack of Market Competition and/or Threat of Undercutting by New Entrants
  • Overcrowded Market with Low Differentiation

ARPU 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...

1. Customer and Subscription Price Assumptions

Suppose we’re tasked with calculating the ARPU of a subscription streaming service company with the following product and customer data points in the fiscal year ending 2021.

  • Average Monthly Subscription Price = $12.50
  • Total Number of Paying Customers = 400k
  • Total Number of Non-Paying Customers = 600k

From the assumptions listed above, we can see that of the total customer base, 40% are on paid subscription plans whereas 60% are on the “freemium” plan (or are inactive accounts – i.e. a customer created an account but is not actively using it).

If we multiply the average monthly subscription price by the number of users on the paid subscription tier, we arrive at $5 million for our company’s monthly revenue.

  • Monthly Revenue = $12.50 × 400k = $5 million

Since we are calculating ARPU (and ARPPU) on an annual basis, the next step is to convert the company’s monthly revenue into an annualized metric by multiplying it by 12 months.

  • Total Annual Revenue = $5 million × 12 = $60mm

2. ARPU Calculation Example

Since we have the company’s annual revenue, we can compute the average revenue per user (ARPU) by dividing the annual revenue by the total number of users, inclusive of both paying and non-paying users.

  • Average Revenue Per User (ARPU) = $60 million ÷ 1 million = $60.00

How to Calculate ARPU in Excel

In the subsequent step, we’ll calculate the average revenue per paying user (ARPPU), which only includes customers that are on paid monthly subscription plans.

The ARPPU formula consists of dividing the total annual revenue by the total number of paying users, as shown below.

  • Average Revenue Per Paying Customer (ARPPU) = $60 million ÷ 400k = $150.00

We can now compare the two values:

  • Average Revenue Per User (ARPU) = $60.00
  • Average Revenue Per Paying Customer (ARPPU) = $150.00
  • Differential = $150.00 – $60.00 = $90.00

The difference between our hypothetical company’s ARPU and ARPPU is $90.00 ($150 – $60), which implies the company might want to ask itself how to convert more non-paying users into paying users, as well as methods to derive further revenue from its existing paying customer base.

ARPU 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
2 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Devin Miles
August 17, 2022 10:06 am

Where would you find the amount of users a company has? (e.g; Shopify)

Last edited 1 year ago by Devin Miles
Brad Barlow
August 17, 2022 9:29 pm
Reply to  Devin Miles

Hi, Devin,

First, check their filings to see if they disclose it or if you can back into it using other numbers. Or check equity or industry research if you have access to it.

BB

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.