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


special journals and subsidiary ledgershow do you calculate ending inventorypresent value of annuity in excelhow to calculate mortgage balance remainingformula for ending inventoryconvert accrual to cashunderstanding debits and creditswhat is consignment inventorydiscounted cash flow perpetuityunearned revenue is liabilityroa ratiomanufacturing overhead cost formulaincome statement format xlsexcel pv formula examplethe balance in discount on bonds payableexamples of debits and credits in accountingimprestsales margin formula excelhow to perform vertical analysisinventories turnover daysmanufacturing overhead cost formulaweighted average ending inventorycredit debit ledgerperiodic perpetualcontribution margin in dollarsdouble entry bookkeeping pdfpv of lump sum tablepreparing a bank reconciliation statementapplying manufacturing overhead9 step accounting cyclegive journal entry for provisionaccounts receivables turnover ratiobank reconciliation tutorial pdfmarkup percentage equationaccumulated depreciation calculation examplewhat does return on capital employed mean200 declining balance methodis a trademark an intangible assetinternal controls for accounts payablecost accounting conceptscogs examplecogm cogsmargin markup formulapetty cash control accountfuture value calculator in exceldefinition of annuity duepmt in excelhow to prepare multiple step income statementamortization expense income statementcalculate finished goods inventoryincome tax payable journal entrysoftware amortisationaccumulated depreciation calculation examplehow to calculate purchase price variancestraight line depreciation rate formulaproperty plant and equipment journal entriestreatment of deferred tax liability in cash flow statementcommon size comparative statementsweighted average costingcalculate yield to maturity in excelbeginning bookkeepingformula for annuity duejournalizing accountingequation for interest compounded continuouslyaccounting double entry system examplegross margin per unit formulaprepayment journal entrynumber of compounding periodscash receipts accounting definitiondouble entry bookeepingcapital stock journal entrynotes receivable definitionpresent value calculator annuity due