beprofit logo
Features
Resources
Partners
PricingAbout UsCareers

How to Calculate Revenue in Excel (Simple Formulas + Templates)

Ashley Stander
By Ashley Stander
Head and shoulders photo of Michelle Meyer
Reviewed by Michelle Meyer

Updated March 23, 2023.

An analyst calculating the revenue in Excel on a tablet.

Every seasoned business owner knows the value of revenue calculation as it helps them assess their profit, perform financial analysis, and do forecasting. So, how is sales revenue calculated? This article offers start-ups and established businesses alike straightforward Excel revenue calculation templates.

» Book a demo with BeProfit to learn more about the advantages of our revenue calculation solutions

5 Types of Revenue and Their Exemplified Calculations

This post will address the following revenue categories and provide a revenue formula in Excel for each:

  1. Incremental revenue
  2. Average revenue
  3. Gross revenue
  4. Quarterly revenue
  5. Marginal revenue


Calculate Your Revenue Effectively

Save time and effort by having your revenue calculated automatically.

BeProfit Profit Analysis CalculatorBeProfit - E-Commerce Profit AnalysisBeProfit - E-Commerce Profit AnalysisBeProfit - E-Commerce Profit Analysis
Automate Your Revenue
BeProfit Profit Analysis Dashboard

4.9


  • Analyzes data to guarantee constant, precise revenues.
  • Integrates your stores into a single management system.
  • Compatible with both desktop and mobile devices.

BeProfit offers an accurate and easy-to-use tool that will eliminate all the stress and strain associated with performing revenue calculations on your own.

BeProfit Profit Analysis Dashboard

4.9/5(300 reviews)




1. Incremental Revenue

Incremental revenue is the profit a business receives from a certain increase in sales. This can refer to the additional revenue received from releasing a new product or service or trying new marketing strategies.

Therefore, the original revenue that would have been generated before the additional product or service was introduced in that period must be subtracted from the adjusted revenue that includes the new product or service.

Formula

A formula can therefore be constructed as follows:

Adjusted Revenue - Original Revenue

Adjusted Revenue = adjusted number of units sold x adjusted selling price

Original Revenue = original number of units sold x original selling price

When using Excel, the calculation can be set up as follows:

  1. Original Revenue and Adjusted Revenue are listed separately.
  2. Incremental Revenue is calculated by subtracting the totals (=D3-D2).
Calculating Incremental Revenue in Excel

2. Average Revenue

Average revenue is earned for each unit, product, or service you sell. People also refer to it as average revenue per unit or per user (ARPU).

Formula

Average Revenue (AR) is calculated by dividing the Total Revenue (TR) by the Quantity sold (Q):

AR = TR / Q

So, if a company's total revenue is $5 000 and the quantity sold is 1 000, then the average revenue per unit is $5 000 ÷ 1 000 = $5.

In Excel, the calculation can be set up as follows:

Calculating Average Revenue in Excel

3. Gross Revenue

Your gross revenue is the total amount of money your company makes before expenses are deducted. This includes the sale of shares, property, and equipment, as well as interest and exchange rates.

Knowing your gross revenue will help you analyze your financial statements, track your sales volumes, and identify high-impact revenue channels to understand how well your business is doing.

Formula

There are two types of gross revenue, each calculated as follows:

Product Revenue = the number of units sold x average price

Service Revenue = the number of customers x average price of service

In Excel, the calculation can be set up as follows:

  1. Products and Services are listed separately.
  2. Quantities sold, Prices, and any Discounts provided are used to calculate the final total selling price of each product and service.
  3. Total Revenue is calculated by adding the final totals of products and services (=E6+E10).
Calculating Gross Revenue - Credit: Excel Spy

BeProfit Profit Analysis Dashboard

4.9/5(300 reviews)



4. Quarterly Revenue

Quarterly revenue measures the increase in your sales from one quarter to the next. You would use it to review the sales of successive quarterly periods or compare the sales of the same quarter in different years.

It's important to note that quarterly revenue can be influenced by seasonal sales. For example, if the Olympics is hosted in a certain country, it may skew quarterly results and give you an inaccurate view of your company's quarterly revenue.

Formula

You can calculate quarterly revenue growth as follows:

[(Q2 - Q1) / Q1] x 100

In Excel, the calculation can be set up as follows:

  1. Q1 and Q2 sales are listed separately.
  2. The formula is applied at the bottom before it's converted to a percentage.
Calculating Quarterly Revenue in Excel

5. Marginal Revenue

Marginal revenue is the increase in revenue that you get from the sale of each extra unit of output. While marginal revenue can stay constant over a specific output level, it follows the law of diminishing returns and will eventually slow down as your output level increases.

As a business owner, you can use historical marginal revenue data to analyze customer demand for your products and determine your most efficient and effective prices. Finally, this calculation helps you to understand your forecasts because it determines future production planning and schedules.

Formula

This is the formula you can use to calculate your marginal revenue:

Change in Revenue / Change in Quantity

=

(Total Revenue - Old Revenue) / (Total Quantity - Old Quantity)

Let's look at a quick example:

Your company sells its first 100 products for $1 000. You sell the next products for $8. This means that your marginal revenue for product number 101 is $8.

It's important to note that marginal revenue disregards the previous average price of $10. This is because it only analyzes incremental change. If you sell 115 units for $1 100, your marginal revenue for products 101 through 115 is $100, or $6.67 per unit.

In Excel, the calculation can be set up as follows:

Calculating Marginal Revenue in Excel

Save Time With Precise Tools

There are profit calculation mistakes to avoid if you use the formulas and spreadsheets provided in this article. If you're not confident about how to calculate monthly revenue in Excel on your own, using the Profit Analysis Dashboard by BeProfit can save you time while ensuring your results' accuracy.

Once the revenue has been calculated, the next step is to analyze and measure it using metrics such as net, gross, and operating profit margins. Knowing how to calculate net profit margins is essential because it provides insight into how effectively your business is running overall.

» Want to know how profitable your store is? Learn how to perform an e-commerce profitability analysis

Can't find what you're looking for?