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


difference between imprest and petty cashstraight line depreciation equationhow to find the predetermined overhead ratecontra income accountmulti step income statementpetty cash accounting exampledirect labor rate formulatotal debt to equity ratio calculatorinventory turns ratioendowment fund definitiongrowing annuity formulastandard costing vs actual costingcash receipts journalaccounting entry for bad debtsmargin or markuptrial balance example ukif a company fails to record estimated bad debts expensetrade debtors accounts receivableaccount receivable calculationsteps of the accounting cyclepetty cash worksheetadjusted and unadjusted trial balanceimprest amountannuity functionstatement of retained earnings formulabank reconciliation statement proformadeferred perpetuitymargin & markupdebtors ratio formulawhat are depreciation expensescapital account journal entryexamples of comprehensive incomeblank worksheet templateover absorption of overheadsnet present value formula in excelcalculating accounts receivablegross profit calculation examplebookkeeper duties checklistwhat is acid test ratio formulabep formulapresent value of an annuity due tablehigh school accounting worksheetssmall business accounts spreadsheet templatecalculate gross margin formulanet purchases equationgrowing annuity formulaaccrued expenses and outstanding expensespayback method formulafuture worth formulawhat is efficiency ratiosinventory turnover is calculated by dividingjournal entry worksheet accountingbookkeeping exam questions and answersformula markuppetty cash vouchersis depreciation an accrued expensenet present value formula excel exampledebtor days calculation formuladeferred tax assets and liabilities examplescash conversion ratio formuladirect material usage variancedouble entry for goodwillprintable accounting ledgeraccount receivable turnover ratebalance sheet spreadsheethow to calculate days sales in inventoryexamples of owner's equity in accountingstraight line amortization of bond discountsample petty cash voucherpmt function in excelthe eight steps of the accounting cycledepreciation calculator excelhow to write a voucher for paymentcalculator for present value of annuitycash payback period formulacash journal templatetrade debtors ratioadjusting entries questionsdefinition of double entry bookkeepingdepreciation journal entries examples