Payback Period Calculator

This payback period calculator will help a business to calculate payback period in Excel.

The payback period is the time it takes a business to recover it’s investment in a project. Our tutorial on the payback period method gives full details about how to calculate and use the payback period.

The Excel sheet, available for download below, will help you calculate the payback period for a project by entering the initial cost of the project, and the cash inflows for the first ten years.

payback period calculator
Payback Period Calculator Preview
Payback Period Calculator Download

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

Notes and major health warnings
Users use this accounting template 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 accounting format that you might use. It is purely illustrative. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the template, please let us know and we will try to fix it.
Payback Period Calculator November 6th, 2016Team

You May Also Like


Related pages


balance formula calculatoruses of bank reconciliation statementmateriality constraintmicrosoft balance sheet templateadjusting entries prepaid insurancecalculating gross margin percentagecalculate mortgage constantemployee timesheet templatepost closing trial balance definitionpayroll quiz questions and answersmulti step income statement practicepresent value of annuity in excelbudget bookkeepingyear end adjustments journal entriesmark up ratioaccounting adjusting entries practice problemsbills payable journal entryrental ledger samplehorizontal analysis of income statementlease amortization schedule templatewhat does cogs meanddb depreciationdirect material cost variance formulanotes receivable meaningaccumulated depreciation on balance sheet examplefind future value of annuityhow to record adjusting entriescapital gearing formulamargin versus markup calculatorprofitability index calculationcash received receipt templatesimple bookkeeping spreadsheetdouble declining calculatortrial balance of totalscoupon bonds examplesaccount receivable turnover ratio formulaeffeciency ratiosfactoring trade receivablesmarkup formulashow to record unearned revenue journal entryfinancial forecast templatemonthly ledger templatehow to figure out lease paymentunrealized gain loss accountingcash flotbank overdraft liabilitycogs formula accountinggross profit percentage formula excelmonthly depreciation calculatorhow to calculate profit markupamortization expense formulatotal labor variance formulamarkup vs profitwhat is payroll liabilitiesformula for debtors collection periodannuity table pdfrumus discount factordouble entry accounting templatean example of deferred revenue is unearned rentaccounting equation for dummieshow to calculate depreciation with residual valuecontra revenuesconsignment sales accounting entriesexcel npv formulainfinite cash flowissuance of common stock journal entrypayback period online calculatordebtors journalcapital lease journal entries exampleimprest systemwhat is zero based budgeting definitionhow to work out retained profitinventory turnover formula exampleskillcheck online testingabsorption costing meaning