How to Calculate Return on Assets (ROA) in QuickBooks

published on 21 December 2023

Calculating key financial metrics can be confusing for many small business owners.

Luckily, with QuickBooks, you can easily determine your business's Return on Assets to measure profitability and make smart decisions.

In this post, you'll learn step-by-step how to locate the data in QuickBooks and perform the ROA calculation. You'll also discover how to interpret the result to assess your company's financial health.

Introduction to Calculating Return on Assets (ROA)

Return on assets (ROA) is an important profitability metric that measures how efficiently a company uses its assets to generate profits. By calculating a company's ROA, businesses can assess overall profitability and determine how well they are converting investments in assets into profits.

The main steps to calculate ROA are:

  • Find net income on the income statement
  • Determine total average assets from the balance sheet
  • Divide net income by average total assets

This metric shows how much profit is being produced per dollar of assets. A higher ROA indicates greater efficiency in using assets to produce profits. Understanding and tracking ROA over time helps businesses evaluate financial performance.

Understanding Return on Assets (ROA)

Return on assets (ROA) measures a company's profitability relative to its total assets. It is calculated by dividing net income by average total assets. This shows how efficiently a business uses assets to generate profits.

ROA shows how much net income is produced per dollar of assets. A higher ROA means a company is using its assets more efficiently to generate profits.

ROA provides valuable insights because it shows how well a company's assets are being used to produce profits. Companies aim to improve ROA over time as it indicates greater profitability from the asset base.

Finding the Data Needed to Calculate ROA in QuickBooks

To calculate ROA, you need to locate net income and total assets data within QuickBooks.

Net income can be found on the profit and loss statement under the net income line.

Total assets are found on the balance sheet under total assets. Since ROA uses average total assets, you must sum the last two year's total assets and divide by two.

Using QuickBooks reports simplifies gathering the necessary income statement and balance sheet data to determine inputs for calculating a company's ROA.

What is the rate of return on assets?

ROA is calculated by dividing a firm's net income by the average of its total assets. It is then expressed as a percentage. Net profit can be found at the bottom of a company's income statement, and assets are found on its balance sheet.

To calculate ROA:

  • Find net income on the income statement for the period
  • Find total assets on the balance sheet for the same period
  • Divide net income by total assets
  • Multiply result by 100 to get a percentage

For example, if a company had $1 million in net income last year and average assets of $10 million, its ROA would be:

$1,000,000 / $10,000,000 = 0.1 = 10% ROA

A higher ROA indicates a company is generating income more efficiently from its assets. This makes ROA a useful metric for comparing profitability between companies.

When calculating ROA in QuickBooks, you can easily pull the required figures from the software's financial reports. Just divide the net income by average total assets for the same timeframe to measure how well the company is using assets to generate profits.

Monitoring ROA over time can also show if a business is becoming more or less profitable. For example, an increasing ROA indicates management is making good decisions in using company assets.

How do you calculate rate of return on total assets?

The return on total assets (ROA) ratio measures a company's profitability and efficiency in generating profits from its total assets. Here is the formula to calculate ROA:

ROA = Net Income / Average Total Assets

Where:

  • Net Income: A company's total earnings after taxes and expenses have been accounted for. This can be found on the income statement.
  • Average Total Assets: The average of a company's total assets from the beginning to the end of the period being measured. Total assets include current assets like cash, accounts receivable, inventory, etc. along with long-term assets like property, plant, and equipment. To calculate the average, sum the total assets from the beginning and ending balance sheets for the period and divide by two.

For example, if a company had:

  • Net income of $1,000,000
  • Total assets at the beginning of the year of $5,000,000
  • Total assets at the end of the year of $6,000,000

The average total assets would be ($5,000,000 + $6,000,000) / 2 = $5,500,000

Applying this to the ROA formula:

ROA = $1,000,000 / $5,500,000 = 18.2%

An 18.2% ROA means the company generates $0.182 of net income for every $1 of assets. This evaluates how efficiently a company can manage its assets to produce profits. Comparing ROA over time or against industry benchmarks helps assess management’s operational efficiency and use of financial leverage.

What is an example of calculating return on assets?

Here is an example ROA calculation:

Q: If a business posts a net income of $10 million in current operations, and owns $50 million worth of assets as per the balance sheet, what is its return on assets?

A:

  • Net Income = $10 million
  • Total Assets = $50 million
  • ROA Formula: Net Income / Average Total Assets
  • Plug in the numbers: $10 million / $50 million = 0.2
  • Therefore, the business's ROA is 20%

This shows that for every $1 of assets the company owns, it generates $0.20 in profit. A 20% ROA is considered quite good. The higher the ROA, the better a company is at using its assets to generate income.

Some key things to note about ROA:

  • It measures how efficiently a company can manage its assets to produce profits
  • It is expressed as a percentage
  • Higher ROA generally indicates better management and operations
  • Can be used to compare profitability across companies, even of different sizes

So in summary, ROA gives investors and analysts an idea of how competent executives are at deploying the company's assets to pursue growth and sustain profits. Tracking ROA over time can show improving or worsening financial performance.

Step-by-Step Guide to Calculating ROA in QuickBooks

Locating Net Income on the Profit and Loss Report

To calculate ROA, you first need to know the company's net income for the period. To find this, open QuickBooks and go to Reports > Company & Financial > Profit & Loss. Select the date range to match the period you want to analyze.

Scroll down to the bottom of the report where you'll see the "Net Income" amount. Make a note of this figure to use in the ROA calculation.

Figure 1. Finding Net Income on the QuickBooks Profit & Loss Report

Obtaining Total Assets from the Balance Sheet

The next component needed is total assets. To locate this, open the Balance Sheet report in QuickBooks at Reports > Company & Financial > Balance Sheet.

The total assets number can be found at the bottom of the Assets section, as highlighted below. Note this figure down as well.

Figure 2. Identifying Total Assets on the QuickBooks Balance Sheet

Calculating Average Total Assets

The final step is to calculate average total assets. Since the balance sheet only represents a snapshot in time, we need to account for fluctuations over the year.

Here is the formula:

Average Total Assets = (Beginning Total Assets + Ending Total Assets) / 2

For example, if beginning total assets last year were $2,000,000 and ending total assets were $2,500,000, the average would be:

($2,000,000 + $2,500,000) / 2 = $2,250,000

Use this average total assets figure in the final ROA calculation.

sbb-itb-beb59a9

Understanding Profitability: ROA vs ROE

Comparing Return on Assets (ROA) and Return on Equity (ROE) provides insights into different aspects of a company's profitability and efficiency in using its assets and equity.

Basics of ROA and ROE

ROA measures how efficiently a company generates profits from its assets. It is calculated as:

ROA = Net Income / Average Total Assets

A higher ROA indicates the company is using its assets effectively to drive profits.

ROE measures how well a company generates profits from shareholders' equity. It is calculated as:

ROE = Net Income / Average Shareholders' Equity

A higher ROE shows the company is efficiently leveraging equity financing to generate income.

While related, ROA focuses on asset use and ROE on equity use for profitability. Comparing the two ratios helps assess overall financial performance.

Return on Equity Interpretation

ROE indicates how much profit is produced from each dollar of shareholders' equity. As a general rule:

  • ROE above 20% is considered good. It means the company generates $0.20+ profit for each $1.00 of shareholders' equity.
  • ROE between 10-20% is reasonable for most industries. $0.10-$0.20 profit per equity dollar.
  • ROE below 10% is low and may indicate inefficient use of equity financing. Below $0.10 profit per equity dollar.

When ROE is substantially higher than ROA, it may mean the company is taking on significant debt to finance growth. While this can boost ROE, high debt also increases risk. Evaluating debt levels provides context for interpreting ROE trends over time.

ROA Calculation Example and Analysis

Sample Calculation for a 12-month Period

Here is an example ROA calculation for a fictional company called ACME Inc. based on the numbers below from their QuickBooks income statement and balance sheet:

Income Statement (Trailing 12 Months)

  • Net Income: $120,000

Balance Sheet

  • Total Assets: $1,000,000

To calculate ROA, the formula is:

ROA = Net Income / Average Total Assets

For this example:

Net Income = $120,000
Total Assets = $1,000,000 (only one period, so average = $1,000,000)

ROA = $120,000 / $1,000,000 = 12%

So ACME Inc.'s ROA is 12% for this 12-month period.

Interpreting and Using the ROA Result

An ROA of 12% seems reasonable for ACME Inc. given they operate in the technology industry. This shows they are generating $0.12 of net income for every $1 of assets they control. The higher the ROA, the better the company is at using assets to drive profits.

Benchmarks vary by industry, but an ROA greater than 5% often indicates profitable and efficient use of assets. Since ACME Inc.'s ROA is quite good at 12%, this means their management team likely makes wise investment decisions and converts assets into profits better than competitors.

Going forward, ACME Inc. can use ROA trends year-over-year to measure profitability improvements. If ROA declines, it may signal poor asset utilization or investment choices requiring investigation. As long as ROA stays above the industry average, ACME Inc. can have confidence their assets generate sizable returns.

How to Measure Profitability of a Company Using ROA

Return on Assets (ROA) is a useful metric for determining a company's profitability and efficiency in generating profits from its assets.

Measure of Profitability Ratio: The Role of ROA

ROA serves as an important measure of profitability ratio. It indicates how well a company is utilizing its assets to generate earnings. Specifically, ROA measures the net income produced by total assets during a period by dividing net income by average total assets.

The resulting ROA ratio reveals how much profit a company earns for every dollar invested in assets. It shows management's ability to effectively employ the assets available to generate profits. A higher ROA indicates greater efficiency in using assets profitably.

As a measure of profitability ratio, ROA provides crucial insights into a company's financial health. It allows easy comparison across companies and industries to evaluate relative profitability performance. Tracking ROA over time for a single company also shows improving or worsening profitability.

How to Tell If a Company Is Profitable from Balance Sheet

While net income gives a sense of bottom line profitability, ROA analysis using the balance sheet provides deeper perspective. Examining assets on the balance sheet, especially in relation to liabilities, reveals information about profitability.

Higher asset balances relative to liabilities generally indicate greater profitability, especially for liquid assets like cash that directly drive profits. If liabilities exceed assets, producing negative equity, the company is likely struggling with profitability.

Comparing ROA ratios over time and against competitors also verifies if adequate profits are being produced from assets as the company scales. Improving ROA suggests assets are being used more optimally to drive profit growth.

In summary, ROA offers a useful measure of profitability ratio using balance sheet assets. Tracking it over time and against peers gives a robust view into whether assets are efficiently generating ample profits for a company's circumstances.

How to Calculate Profit Margin Alongside ROA

Understanding Profit Margin Calculation

The profit margin is a ratio that measures a company's profitability by showing how much net profit is generated for every dollar of revenue earned.

The formula to calculate profit margin is:

Profit Margin = (Net Income / Revenue) x 100

For example, if a company had $2 million in net income last year and $10 million in total revenue, its profit margin would be:

Profit Margin = ($2 million / $10 million) x 100 = 20%  

A 20% profit margin means that for every $1 earned, the company retains $0.20 in profit after accounting for all expenses.

The higher the percentage, the more profitable the company is relative to its revenue.

Integrating Profit Margin with ROA Analysis

While profit margin shows profitability relative to revenue, return on assets (ROA) measures how efficiently a company is using its assets to generate profit.

ROA can be calculated as:

ROA = (Net Income / Total Assets) x 100

Analyzing profit margin and ROA together provides a more complete picture of a company's profitability.

For example, Company A and Company B both have a 20% profit margin. However, Company A generates $2 million in profit from $10 million in assets while Company B generates $2 million in profit from $50 million in assets.

Although both companies have the same profit margin, Company A has a higher ROA of 20% compared to Company B's ROA of 4%. This shows Company A is more efficiently using its assets to make profit.

Looking at both metrics helps assess if a company's profits are due to efficient asset use or other factors like high margins. Companies aim for higher margins and optimal ROA to maximize profitability.

Tips for Improving Return on Assets

Improving return on assets (ROA) can help demonstrate a company's profitability and efficient use of its assets to generate earnings. Here are some tips:

Reducing Operating Expenses

Lowering operating expenses directly impacts net income and can boost ROA. Tactics include:

  • Review costs regularly and cut unnecessary expenditures
  • Renegotiate supplier and vendor contracts
  • Streamline operations and automate processes to reduce labor costs
  • Sublease unused office space to bring in rental income

Increasing Asset Turnover

Asset turnover measures how efficiently a company uses assets to generate sales. Improving turnover can directly lift ROA. Methods include:

  • Shorten cash conversion and inventory storage times
  • Upgrade technology to increase productivity capacity
  • Offer discounts to boost sales volume and revenue
  • Divest unused assets and invest proceeds to acquire higher-performing assets

Following these methods can improve asset utilization, lower costs, increase sales, and ultimately maximize return on assets. Monitoring metrics like turnover and operating margins can help assess progress.

Conclusion and Next Steps in Asset Management

Recap of ROA's Importance in Measuring Company Profitability

Return on Assets (ROA) is a crucial metric for assessing a company's profitability and how efficiently it utilizes its assets to generate earnings. By comparing net income to total assets, ROA gives insight into management's ability to wring profits from the assets at their disposal.

Monitoring ROA over time enables businesses to track trends and quickly identify any dips that may indicate problems. Declining ROA could signal issues like:

  • Increased expenses and overhead costs
  • Investing in unproductive assets
  • Poor pricing and sales strategies

Regularly measuring ROA also helps set performance benchmarks to motivate improvements. Companies can use their ROA ratios to:

  • Set profitability goals to aim for each quarter or year
  • Compare their ROA against competitors and industry averages
  • Assess the impact of strategic initiatives on profitability

Careful ROA analysis provides vital input for decisions on managing assets, controlling costs, setting prices, and directing investments to their optimal uses.

Strategies for Ongoing ROA Optimization

To continually maximize returns on assets, businesses should:

  • Set ROA targets: Establish specific ROA goals to strive for, based on past performance, competitors, and industry benchmarks. Review and update targets quarterly.
  • Trim excess assets: Evaluate asset utilization regularly. Eliminate unused, old, or unproductive assets dragging down ROA.
  • Enhance asset productivity: Invest to upgrade assets that improve process efficiency and output quality. Ensure assets are fully leveraged to drive profits.
  • Control costs: Closely monitor expenses and overheads to identify savings that can boost ROA. Maintain lean operations.
  • Optimize pricing: Use pricing analytics to find the optimum price point for maximizing profits from asset utilization and capacity.

Regularly measuring and analyzing ROA provides vital insights for operational and financial decision-making. By continually optimizing their asset productivity, businesses can maximize their profitability over the long-term.

Related posts

Read more