This Accounting Rate of Return Template is an Excel template which helps you compute the return on an investment in project, asset or business. This is very simple-to-use template with the appropriate formulas set up. All you need to do is fill in the input cells in blue and the result will be generated for you.

What is Accounting Rate of Return?

Accounting rate of return (ARR) is calculated as the average net income generated by an asset divided by its average capital cost. This measure is usually expressed as an annual percentage figure and used to help companies decide the profitability of an investment (project, acquisition of assets/ business). This Accounting Rate of Return Template can be useful in determining whether or not to invest in a project. The implication of ARR is that when ARR of a project is equal to 10%, the project is expected to generate ten cents of net income for every dollar invested each year. By comparing ARR to the required rate of return (hurdle rate), a company can decide to accept the project if it's equal or greater than the rate or reject it if less than the rate.

Learn More About ARR

Read CFI's Accounting Rate of Return Guide to understand the concept of accounting rate of return, see examples of calculation, and watch the video explanation!
Reviews Add a review
Zulu Way

Nice ARR Excel file, thanks

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…