Return on Assets Template for Excel and Google Sheets

What is Return on Assets (ROA)?

Return on Assets (ROA) is a financial ratio that measures a company’s profitability relative to its total assets. It shows how effectively a business is using its assets to generate net income over a specific time period. ROA is a valuable tool for comparing performance across companies or tracking your own company’s return over time.

ROA Formula

ROA = Net Income / Average Total Assets

Where:

• Net Income = Net profits reported on the income statement
• Average Total Assets = (Beginning Assets + Ending Assets) / 2

A higher ROA indicates better efficiency, while a lower ROA may point to underutilized resources or high direct cost structures.

Here is an example of what the return on assets template looks like:

Download the Return on Assets Template

Fill in the form below to access the downloadable file instantly. No cost, no strings attached—just a professional-grade Excel template to help you calculate ROA quickly and accurately.

How Do You Use a Return on Assets Template?

This ROA Excel template makes it easy to calculate ROA in seconds. Simply input the required data into the highlighted fields:

• Net Income (from your income statement)
• Beginning and Ending Total Assets (from your balance sheet)

The template will automatically calculate:

• Average assets over the time period
• Your company’s return on assets ratio

This can help guide strategic decisions, identify performance trends, and benchmark against comparable companies.

• Available in both Excel and Google Sheets formats
• Easily calculate ROA across multiple business units
• Built-in formulas for quick insights

Who Should Use This Template?

This free return on assets template is ideal for:

• Finance professionals conducting ratio analysis
• FP&A teams evaluating profitability and efficiency
• Students learning how to calculate ROA in Excel
• Founders and operators reviewing business performance

Whether you’re analyzing your own business or comparing relative performance across competitors, this template simplifies the math.

Prerequisite Skills

You don’t need advanced Excel experience to use this template. However, you’ll benefit most if you:

• Understand how to read an income statement and balance sheet
• Know the basics of financial ratio analysis
• Are comfortable with simple formulas in Excel or Google Sheets

Need a refresher? Try our Excel Crash Course or explore the FMVA® Certification Program to deepen your skills.

More Free Excel Templates and Tools

Looking for more financial modeling resources? CFI offers a full library of downloadable tools, including:

• Excel Modeling Templates
• PowerPoint Presentation Templates
• Transaction Document Templates
• See all Excel resources
• See all Financial Modeling resources
• See all CFI Resources

Frequently Asked Questions

Is this really a free return on assets template?

Yes, it’s 100% free and available for immediate download.

Can I use this in Google Sheets?

Yes, the template is compatible with both Excel and Google Sheets.

What if I don’t know how to calculate ROA?

The built-in formulas will handle the math for you. Just enter your net income and total assets.

Will this help with FMVA exam prep?

Yes! This is the exact type of tool used in CFI’s FMVA coursework. It’s a great way to practice calculating and interpreting ROA.

Where can I learn more about financial ratios?

Explore CFI’s resources on Financial Analysis or enroll in a certification to master the full toolkit:

• What is Financial Modeling?
• How Do You Build a DCF Model?
• What is Sensitivity Analysis?
• How Do You Value a Business?