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


labor quantity variancedeferred tax asset exampleexcel pmt function examplehow to record accrued expensevariable cost per unit formulapresent value tables annuityinventory held on consignmentmargin and markup formulasformula of debt equity ratiosimple balance sheet format excelhow to calculate common size percentage income statementperpetual system accountingbookkeeping stepsperpetuity factorbreak even lease payment formulareceived cash from customers on account journal entryall types of accounting entriesnet realizable value inventoryperpetuity present value formulawrite off obsolete inventoryadjusting entries practice questionsaccounts receivables turnover ratioaccounts receivable accounting entriesexample of chart of accounts in general ledgerdefine deferred revenuefv annuity formulacost of goods sold chart of accountsmarkup to margin chartsimple bookkeeping templatehow to calculate interest rate on a loan in excelaccounting for insurance recoveriespurchase accounting journal entriesclosing entries income summaryperiodic inventory examplecalculation of inventory turnoverjournal entry capital leasesimple interest formula excelhow do you compute gross profithow to reconcile accounts payablematerial requisition slip formatdiscounted note payablebookkeeping to trial balance examplesstraight line balance methodsalaries and wages payable journal entrycontinuos compoundingexample of trial balance worksheetaccounts payable test questionsdebit and credit quizpv annuity tablepetty cash imprestcomputation of payback perioddupont formula roegp percentage formulaperpetuity equationexamples of revenue expenditure and capital expenditurepv growing perpetuitynpv excel calculationexamples of revenue receipts and capital receiptsaccumulated depreciation adjusting entrydeferred tax accounting entriesmulti step income statement formataccrued interest adjusting entrydeferred revenue expenditure written offjournal entry for sale of assethow to calculate percentage of completion in excelunits of output depreciationaccrual based accounting examplehow to calculate common size percentage income statementtutorial for accounting for beginnersposting entries to the general ledgerinventory on hand adjusting entryexample of trial balance worksheetzero coupon bonds formulaproveit test answerscapital asset gearing ratiowhats a debtor