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


straight line depreciation half year conventionwork in progress accounting entriesassets equals liabilities plus equitydouble entry bookkeeping booksformula of debt equity ratiocash flow perpetuityapplied fixed overheaddepreciation ddbpaid in capital in excess of par balance sheetverifiability principle accountingformula for overhead costcontrollable profitfob destination definitionquick assets ratio formulaaverage account receivable formulajournal entry for dividend paymentformula for dsoamortised cost meaninggeneral ledger sheetsstraight line amortization tablefinding irr in excelreplenishing petty cashtransposed numbers divisible by 9simple compound formulaan overstatement of beginning inventory results incompute inventory turnovereffective annual interest rate formulacompute accounts receivable turnoverformula for horizontal analysisissuance of treasury stockaccounting ledger formatpetty cash accountingpercentage markup on costgross profit lifonormal balance for assetsexcel loan functionsmeaning of fob shipping pointkenexa prove it tutorialswhat is an accounts receivable ledgervoucher templatesprepaid rent is an assetgearing ratio debt to equitywhich of these equations shows how installment loans are calculatedtwo column journal accountingexplain double entry bookkeepingcalculate annuity in excelaccounting principles and conventionsinvoice received journal entrywhat is operating cycle in accountingfinancial forecast templatefinancial ledger templatedefine suspense accountnominal interest rate formulaexpense payable journal entrydouble declining depreciation calculation formulaaccounting for accrued expensessales taxes collected by a retailer are recorded byredeemable convertible preferred stockperpetual inventory journal entriesthe calculation of depreciation using the declining balance methodoverhead variance formulalifo calculationpv tables annuitybalance sheet versus income statementstockholders equity formula balance sheetprovision of doubtful debts journal entriesrecording payroll journal entriesppv purchase price varianceallowance for bad debt accountpresent value of infinite cash flowgeneral journal closing entriesfactor account receivableexcel spreadsheet accountingsuspense account in trial balancebills payable meaninggross profit method inventory