Payback Period

Define Payback Period

The payback period is the time it takes to earn back the cash invested in a project. It allows a business to determine how long it will take before a project will recover it’s original investment.

The simple payback period, is a useful tool for a business to compare projects. Using the payback period method, the business would choose the project which has the shortest cash payback period.

Payback Period Calculation

The payback period formula is as follows:

Payback Period in years = Cost of project / Annual cash inflows

Payback Period Example

If a business invests in a project whose cost is 150,000 and expects to receive cash inflows of 32,000 per year, then the payback period is

Payback period = Cost of project / Annual cash inflows = 150,000 / 32,000 = 4.69 years.

It will take the business 4.69 years to recover the original investment of 150,000 in the project, as shown in the diagram below.

Pay back Period Example
Project Investment – 150
Year 1 Year 2 Year 3 Year 4 Year 5
+ 32 + 32 + 32 + 32 + 32
Payback Period = 4.69 years

If the business had another project requiring investment of 200,000 with annual cash inflows of 53,000 per year, the payback period of this project would be

Pay back period = Cost of project / Annual cash inflows = 200,000 / 53,000 = 3.77 years.

Using the payback period method, the business would choose the second project as this has the shorter payback period.

Calculating Payback Period for Uneven Cash Flows

To calculate pay back period for uneven cash flows which vary from year to year, calculate the cumulative cash flow at the end of each year until the cumulative cash flow turns positive.

Calculation of Pay back Period
Cash flow Cumulative
Year 0 -160,000 -160,000
Year 1 46,000 -114,000
Year 2 62,000 -52,000
Year 3 20,000 -32,000
Year 4 53,000 21,000

The cumulative cash flow turns positive in year 5, so the pay back period is somewhere between 3 and 4 years, depending on the timing of the final cash inflow of 53,000. At this point the cash inflows exceed the initial investment in the project of 160,000.

Advantages and Disadvantages of Payback Period

Advantages of Payback Period

  • Simple to calculate and easy to understand
  • Adjusts for uncertainty of later cash flows
  • Biased towards liquidity as the quicker the investment in a project is returned the higher rank it will be given

Disadvantages of Payback Period

  • Ignores the time value of money when calculating pay back
  • Requires an arbitrary cutoff point
  • Ignores cash flows beyond the pay back period
  • Does not allow for any risk associated with the cash flows

Payback Period Calculator Download

We have produced a pay back period calculator to enable a business to calculate the pay back period of a project with uneven cash flows on entering the initial project cost and up to ten annual cash inflows.

The Excel pay back period calculator is available for download in Excel format by following the link below.

Payback Period Calculator Spreadsheet Download Link

Payback Period November 6th, 2016Team

You May Also Like

Related pages

what are debits and credits accountingstatement of goods manufacturedjournalize accountingdupont turnovermark up to marginstandard general ledger chart of accountsexcel formula for irrweighted average cost of goods soldfixed asset inventory templatehow to calculate pbitpresent value lump sumyearly depreciation formulaaccounting concepts conventions and principlesdeferred tax liability accounting treatmentcalculate the contribution margin ratioledger book entrymeaning of cash floatap turnover calculationaccrued revenue journal entryinstallment payment formulanotes payable calculatorweighted average process costing examplelease amortization schedule templatedebtors days outstanding formulaprepaid rent balance sheetwhat is journal entry for prepaid expensestrial balance depreciationmodified irr calculatoraccounts payable aging report samplesmall business excel spreadsheetrecording petty cashacid test ratio formulamonth end closing journal entries exampleshow to calculate salvage value of an assetbookkeeping accounts payable and receivablestandard costing and variance analysiswhat is the formula for predetermined overhead ratehigh asset turnovercash turnover ratio formularetained earnings calculation examplebond amortization schedule examplefixed overheaddouble entry bookeepingexamples of accounting equationcalculate the payback periodcalculating depreciation straight linehow to calculate perpetual inventoryassigning accounts receivableconvertible bond accountingretained earnings formula on balance sheetwhen accounts receivable are collectedaccounts receivable accrualpresent value of annuity exampleamortization of premium on bondshow to calculate manufacturing overhead costsbasics of double entry bookkeepingexamples of leverage ratiosretained earnings cash flow statementgrn accounting definitionretained profits definitionmarketable securities accountinginternal rate of return formula accountingdouble column cash book examplemeaning of amortization in accountingformula for calculating profit percentagebad debt expense income statement exampledepreciation formulasgearing ratios definitionallowance for doubtful accounts is a contra asset accountpetty cash voucher definition