Accounting Rate of Return Calculator

The accounting rate of return calculator or ARR calculator, is used to calculate a projects net income as a percentage of the investment in the project.

The calculation is carried out using the accounting rate of return formula, which takes the average annual net income over the term of the project and divides it by the average investment in the project.

ARR = Average annual net income / Average investment

Full details of how the method is used can be found in our accounting rate of return tutorial.

accounting rate of return calculator v 1
Accounting Rate of Return Calculator Preview

Using the Accounting Rate of Return Calculator

The Excel accounting rate of return calculator, available for download below, is used to compute the accounting rate of return by entering details relating to the net income and investment in the project.

The calculator is used as follows:

  1. Enter the total net income. The total net income is the income net of all expenses (including depreciation) over the term of the project.
  2. Enter the investment term. The investment term is the number of years over which investment in the project takes place. The accounting return calculator works out the average annual net income.
  3. Enter the initial investment, working capital and scrap value. Enter the monetary amounts invested at the start of the project and the working capital used during the project term. The scrap value is the amount the investment is worth at the end of projects useful life.

    The calculator uses the ARR formula to calculate the average investment over the term of the project, and the accounting rate of return percentage.

Accounting Rate of Return Calculator Download

The accounting rate of return spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this accounting rate of return calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an ARR calculator that you might use when using the ARR method of capital budgeting. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this average accounting return calculator, please let us know and we will try to fix it.
Accounting Rate of Return Calculator November 6th, 2016Team

You May Also Like

Related pages

accounting xls templatesinventory turnover ratio calculation examplenper function exceljournal entry for car loandebit note definition accountingdouble entry for fixed assetsbookkeeping transactionsjournal entry for amortizationfob destination and fob shipping pointdeferred revenue journal entrycalculating lifo reserveinsurance accounting basicshow to calculate markup percentage formulajournal entry for applied overheadinventory value methodsweighted average formula accountingbank leverage ratio formulacalculating stockholders equityincreasing annuity due formulaexcel npv calculationexcel spreadsheet for bookkeepingexamples of deferred tax liabilities and assetsunderstanding accruals and prepaymentscorrecting entries accountingifrs bad debt provisionaccruals entriescorrecting journal entriesdiminishing depreciation method formuladebtors account definitionfactoring of accounts receivable definitiongaap stand foreir calculationadjusting entries for accrualstrade receivables control accountbasic accounting quizjournal entry for accrued expenserental ledger templateuses of trial balanceaccrued wages payableprepaid insurance accounting entrydepreciation templatedepreciation calculator straight lineconsumable storesfactoring account receivablespresent value of cash flows in excelwhat is unearned revenue classified ascalculate ending finished goods inventoryretained earnings equationtypical journal entries accountingfinance annuity formulapresent value of annuity calculationexcel pv formula exampleincome received in advance journal entrycalculate depreciation expense straight line methodnominal interest rate formulaperiodic vs perpetual inventory systemdepreciation definition wikipediabank reconciliation statement definitioncompute gross margindupont equationhow to find fixed cost formulacapital turnover ratio formulaturnover ratio calculatornper 3types of accounting erroryear end closing entries accountingbookkeeping suppliesconsumable assetsmanufacturing overheadcontribution margin and gross marginhow to calculate debtor dayssimple balance sheet format excelpredetermined overhead allocation ratetemplate for income statement and balance sheet