Analyzing Return on Ad Spending

What is Return on Ad SpendingReturn on Ad Spend (ROAS) is one way to help advertising and marketing professionals and investors analyze how well promotions do (or don’t) produce sales. It helps advertisers develop data based on their campaigns’ revenue production (or lack thereof). Understanding how this metric is calculated and how to analyze ROAS is essential for businesses to monitor and increase their advertising performance.

Known as a Key Performance Indicator (KPI), ROAS determines how much sales are generated per dollar invested on advertising outlays. It separates advertising costs from the company’s costs, and it focuses on:

1. The differences between advertising income and advertisement expenses

2. Assisting companies with creating efficient budgets

3. Identifying unprofitable campaigns

How ROAS is calculated:

Return on Ad Spend (ROAS) = Revenue generated from ad campaign/Total advertising costs for a specific campaign

The revenue generated from an ad campaign is the revenue immediately assignable to promotions utilizing a tracking tool.

Total advertising costs for a specific campaign are expenses explicitly connected to the advertising platform.

The resulting calculation determines the business’ return on ad spend, giving owners and managers an idea of how well (or not) ad spending impacts the company’s sales. It similarly enables business owners to reconcile the company’s budgeted advertising costs against growing sales metrics. The following hypothetical breakdown shows what a positive scenario looks like:

A ROAS of 10 = $10 of revenue was earned for every $1 spent on ads. This would translate into:

Total Ad Spend: $10,000

Revenue Generated: $100,000

ROAS = $10

ROAS = 10:1

Important considerations when calculating this include factoring in merchant expenses, costs for digital content production, and costs incurred from media platforms. It’s also important to consider that it’s not always cut-and-dry as to how and what specific ads convert potential customers into paying customers. Assigning the exact ad platform or campaign is a common problem when determining the exact ROAS.

Credit analysis conducted by lenders evaluates ROAS to determine the sales ability of companies seeking loans, especially with promotion-centric companies. The higher the ROAS, the less risk there is and the more reliable the revenue from each campaign. For merger and acquisition professionals, ROAS trends offer insight into a target company’s sustainability. It helps determine if a company’s advertising campaigns can sustain themselves and keep generating future growth.

It’s equally important to see how ROAS compares against other metrics. While ROAS focuses on revenue generated per dollar spent, the advertising-to-sales ratio looks at the total proportion of sales driven by advertising efforts. Similarly, while ROAS measures the revenue per ad spend, return on investment analyzes the comprehensive profitability for the complete level of marketing expenses – not exclusively advertising. While ROAS is a short-term measure on instant sales, Lifetime Value looks at the customer’s history with the company and the entire revenue the company earns from the relationship.

While this metric is helpful for many professionals, it’s important to ensure that only necessary data is included and customer conversion is monitored precisely in order to get the best output.

Calculating the CAC Payback Period

Calculating the CAC Payback PeriodThe CAC Payback Period looks at how a business needs to recover its investment in attracting new customers. It is especially crucial for companies that are in industries with large marketing and sales costs. It’s an important metric because it helps businesses measure their performance in a number of ways.

First, it shows how well a business is managing its budget. Based on the resulting figure of the CAC Payback Period, the shorter the time required to break even on its customer acquisition costs, the more efficient a company is with its sales and marketing expenses. If, however, the result is high, this signals the company is doing something wrong and needs to analyze its current approach.

Running this analysis can also identify a company’s financial perils. The more prolonged the CAC Payback Period, the more likely a company might be facing cash flow concerns. Whether it is caused by overall economic conditions or industry or company-specific challenges, this is another reason for a company to run the numbers to see how it can mitigate or turn around the costs associated with acquiring customers.

The calculation also can help a business determine if it is able to expand to new products and markets and scale up existing product lines. The shorter the time needed to acquire new customers, the more likely a business can grow.

When investors and lenders analyze a company’s financials, including this metric, the more efficient a company is, and the more likely it will attract investors or have lenders offer favorable financing terms.

How to Calculate the CAC Payback Period

This scenario looks at $300,000 in customer acquisition costs, such as marketing, sales, etc., for a three-month period. The company obtained 1,000 new customers and is expected to gain $200,000 in new monthly recurring revenue (MRR), with an estimated gross margin of 60 percent.

First Step: Calculate the CAC by dividing Sales and Marketing Expenses by the new customers (1,000). It’s expressed as follows:

CAC = Sales and Marketing Expenses/Number of New Customers

CAC = $300,000/1,000 = $300 per customer

Second Step: This is to determine the monthly recurring revenue (MRR) per customer. The new MRR amount is divided by the number of newly acquired customers. It’s calculated as follows:

MRR = $200,000/1,000 = $200 per customer

Third Step: Determine the gross margin or how much remains from revenue after subtracting direct costs. In this case, we’ll use 60 percent.

Fourth (and Final) Step: This step determines how many months it will take to recoup the customer acquisition costs from the profits generated by the newly acquired customer. It’s calculated as follows:

CAC Payback Period = $300/($200 x 0.60) = 2.5

Based on the resulting 2.5 figure, it takes, on average, 2.5 months of profit from the newly acquired customers to pay for the customer’s acquisition cost.

Understanding CAC Payback Period Efficiency

If it’s less than 12 months, it’s favorable. This implies a business has an efficient approach to profitability and growth. However, it’s not a hard and fast rule because the repayment time frame can fluctuate based on the economy and the business operations. If a company is a low-margin business or industry (e-commerce, groceries, etc.), a far tighter payback time frame would be necessary to be viable.

There are many factors that can affect this company-specific measurement, such as the industry or sector, current economic conditions, or the business’ approach to gaining new customers. If a company has a shorter CAC Payback Period in an industry that has a generally accepted longer one, this can imply that the company is more efficient in its operations.

This metric is another tool in a financial analyst’s toolbox that can measure and identify efficiency (or lack thereof) and help put businesses back on track for greater financial health.

Common Business Accounting Calculations

Common Business Accounting CalculationsNo matter the type of business or industry, being able to analyze and deduce patterns is essential to discovering a business’ financial health. Here are four commonly used calculations to help internal and external stakeholders determine an organization’s ability to manage its finances.

Break-Even Analysis

This formula analyzes fixed costs versus the profitability a business earns for every extra item it creates and sells.

Businesses that have smaller thresholds to meet their fixed costs to realize profitability have an easier break-even point to meet and exceed. Once the fixed costs threshold is satisfied and sales revenue outpaces variable costs, a business will know when it hits the break-even point.

Break Even Point (BEP) = Total Fixed Costs/(Price Per Unit – Variable Cost Per Unit)

This takes the total fixed costs divided by the price per individual unit minus each unit’s variable cost.

Examples of fixed costs are rent, taxes, insurance and wages. Examples of variable costs are raw materials, production supplies, utilities and packaging.

Another way to determine a company’s break-even point is as follows:

Contribution Margin = Item Price – Variable Cost Per Unit

This is illustrated by: $55 = ($85 – $30)

The item’s priced at $85, with a variable cost of $30, the contribution margin is $55 of how much revenue a company earns to pay for the remaining fixed costs.

Cash Ratio Formula

The cash ratio formula offers one way to look at a company’s liquidity position by comparing a company’s cash and cash equivalents to its current liabilities or debts due within the next 12 months. It shows how well positioned a business is (or is not) able to pay debts due within 12 months, and to satisfy the near-term obligations of its long-term debt.

It’s an important ratio that lenders look at when evaluating a company’s loan application. Instead of including assets such as accounts receivables, it factors in a business’ ability to take care of its financial obligations. It’s thought of as being a more real world look at how financially stable a business is.

It’s calculated as follows: Cash Ratio: Cash + Cash Equivalents/Current Liabilities.

Gross Profit Margin

This is defined as all income minus the cost of goods sold (COGS). COGS is comprised of expenses attributable to the creation of products, which include input materials and salaries for workers to produce such goods. However, it excludes expenses for taxes, overhead, debt, asset acquisitions, etc., among others. Another way to explain this calculation is to ask how much a business retains as profit once production costs are accounted for.

It’s calculated as follows: Gross Profit Margin = [(Net Sales – Cost of Goods Sold)/(New Sales)] x 100

Debt-to-Equity (D/E) Ratio

This is used to determine how much debt or financial leverage a company has on its books. It tells internal stakeholders and external parties what percentage of debt a company is using to operate compared to the business’ available operating reserves. This ratio contrasts a business’ complete financial obligations against its shareholder equity. Its primary use is to see how extensively it uses debt to operate.

It’s calculated as follows: Debt/Equity Ratio = Total Liabilities/Total Shareholders’ Equity.

While these calculations may seem straightforward, these are only a few examples of how businesses can calculate and analyze a company’s position – be it the owner, an employee or an outside lender or investor.

Cash Conversion Cycle (CCC) Defined

Cash Conversion Cycle (CCC) DefinedThis metric, which is also referred to as the cash cycle or the net operating cycle, looks at the time a business takes to recover its investment in inventory to eventually sell. The process starts from selling its goods, collecting on outstanding receivables or invoices, and satisfying its operating costs with the sale proceeds. It’s normally measured in days to determine the company’s financial health.

The less time necessary to complete the CCC, the healthier a company is financially because it means the business’ money spends less time tied up in inventory or collecting on outstanding inventory. It’s important to be mindful that different industries have different CCC time frames. Generally speaking, most calculations are done on either a quarterly (90 day) or an annual basis (365 days).

How to Calculate CCC

The formula is as follows:

(CCC) = Days Inventory Outstanding (DIO) + Days Sales Outstanding (DSO) − Days Payable Outstanding (DPO)

It can be broken down into three different stages:

Stage 1

Days Inventory Outstanding (DIO) looks at how many days the inventory takes to sell to customers. It’s calculated as follows:

DIO = (Average Inventory (AI) / COGS) x Time-Frame (In Days)

AI = 1/2 x (BI + FI)

BI = Beginning Inventory

FI = Final Inventory

It’s important to define COGS, taken from the Income Statement, which is Cost of Goods Sold or the costs personally connected to creation of goods or services (raw materials, labor or electricity). The lower the number, the faster a business is selling its goods.

Stage 2

Days Sales Outstanding (DSO) measures the time it takes the business to collect payment from all outstanding sales completed.

DSO = Average Accounts Receivable (AAR) / Daily Revenue

AAR = 1/2 x (SAR + FAR)

SAR = Starting AR

FAR = Final AR

Accounts Receivable are what companies record on their balance sheet to keep track of what customers owe for the goods delivered or services rendered. The lower the results, the better the company’s cash position is because they’re able to satisfy outstanding invoices.

Stage 3

Days Payable Outstanding (DPO) is the third and final stage that calculates how much businesses owe to their suppliers the business has sourced input materials from, within the time frame the suppliers’ invoices are due.  

DPO = Average Accounts Payable (AAP) / Daily COGS

Where:

AAP = 0.5 x (SAP + FAP)

SAP = Starting AP

FAP = Final AP

COGS = Cost of Goods Sold

There are different ways to interpret the DPO result. A low DPO means the business is taking care of its bills from suppliers. However, potential investors, internal managers, and supervisors can see if the business can either negotiate lengthier payment terms while still maintaining good terms or if the company negotiates early payment terms or invests the money on a short-term basis to earn more for the company before paying suppliers’ bills. A high DPO, after an investigation of a company’s financials, might show the company is taking longer than its peers to pay creditors.

While calculating the CCC is relatively straightforward, the more complex process is interpreting it correctly and using judgment for a business based on industry averages and how the numbers relate to current economic conditions.

How to Measure the Quality of Accounts Receivable

How to Measure the Quality of Accounts ReceivableAnalyzing a company’s Accounts Receivables is an effective way to measure its current cash flows and the likelihood of maintaining healthy cash flows. According to the U.S. Chamber of Commerce’s Small Business Index (Third Quarter 2024), 68 percent of small business owners reported being content with their third quarter cash flow performance. This illustrates the importance for small business owners to do everything possible to maintain healthy cash flows, including evaluating the quality of accounts receivables (A/R).

Defining Accounts Receivables

This account or line item on the balance sheet gives the business’ managers/owners and investors a measure on how much money a business expects to receive from selling goods or services. It’s an important metric because it’s a measure of what’s owed, but not yet collected from rendered services/goods.

Consideration for Uncollectable Accounts Receivables

While businesses hope to collect 100 percent of their A/Rs, businesses take a realistic view that not everyone will pay up. For whatever reason, A/Rs aren’t always collected and must be accounted for as uncollectable. Therefore, a contra account is setup to account for accounts receivables that turn into bad debt. This contra account is linked to the accounts receivable, an asset reported on the balance sheet, offsetting the accounts receivable balance. However, there are many metrics for companies to manage their health internally, and some of these metrics are discussed below.

Accounts Receivable-to-Sales Ratio

This is determined by taking a “snapshot” of the ratio or division of the accounts receivables divided by sales over a period of time. The resulting calculation is the percentage of a business’ unpaid sales. The higher the accounts receivable-to-sales ratio, the riskier the company’s financial health. It indicates a business has accounts receivables with a low likelihood of being collected. It’s calculated as follows:

AR to Sales = AR / Sales

Since it measures the mix of how much a business relies on cash versus credit, it can prompt an analyst to determine whether a company is able to operate on minimal cash with low fixed costs and limited outstanding debt. It can also prompt an analyst to determine if a company is subject to cyclical sales and is dependent on the business cycle and whether it’s the right time to invest in a company or hold off until a better entry point is established.

Accounts Receivable Turnover Ratio

This calculation determines how fast a business can convert its accounts receivables into cash. It calculates this over a discrete period, be it a month, quarter, year, etc. It’s calculated as the sales over a period divided by the average accounts receivables balance over the same period. It’s calculated as follows:

ARTR = Net Credit Sales / Average Accounts Receivable

Net Credit Sales = Sales on Credit – Sales Returns – Sales Allowances

Average Accounts Receivable = (Starting + Ending A/R Over a Fixed Time) / 2

The higher the ratio, the less friction businesses have in converting their accounts receivables into cash. One important consideration to keep in mind is that if total sales are used for this calculation, which some business do, the results don’t reflect the original formula because it doesn’t remove the sales on credit or sales allowances.

Days Sales Outstanding (DSO)

This metric reveals how fast (in average number of days) a company is able to turn its receivables into cash. It’s the average accounts receivables divided by net credit sales multiplied by 365. It’s calculated as follows:

DSO = (A/R / net credit sales) x 365 days

The lower the DSO, the better quality and the more efficient a company is in converting its accounts receivables into cash. The higher the DSO, and especially when it goes beyond 90 days, can represent two different financial measures. The first is that the business’ accounts receivables might not be collectable. The second is that the company might be able to make sales but with deteriorating earnings.

While there are many ways to analyze a company’s health, along with many ways to analyze the quality of existing and future accounts receivables, these are a few ways to evaluate a company’s present financial health and prospects for the future.

Sources

https://www.uschamber.com/sbindex/key-findings