Detailed Excel template for calculating regular and discounted payback periods based on cash flow.

All Industries, Financial Model, General Excel Financial Models

Excel, Financial Modeling, Financial Planning, Free Financial Model Templates, Payback Period

What is payback period?

The payback period helps to determine the length of time required to recover the initial cash flow outlay in the project or investment, simply it is the method used to calculate the time required the earn back the cash invested through the successful cash inflows

Why payback is important

The payback period is an effective measure of investment risk. The period with a shorter payback period has less risk than with the project or investment with a longer payback period. The payback period is often used when liquidity is an important criterion to choose a project

Payback in capital budgeting

In capital budgeting, the payback period is the selection criteria, or deciding factor, that most businesses rely on to choose among potential capital projects. Small businesses and large alike tend to focus on projects with a likelihood or faster, more profitable payback.

The template includes regular and discount payback

The regular payback period is the number of years necessary to recover the funds invested without taking the time value into accounts
The discounted payback is the number of years necessary to recover the funds invested taking into consideration the time value of the money

Key inputs in the green tabs

Fill the green cells only

Key outcome in the dark blue tabs
The inputs in the green cells will dynamically flow into the following below:
-Regular payback period
-Discounted payback period
-Dashboard

Conclusion and customization
Highly versatile, very sophisticated financial template and friendly user
If you have any inquiry, modification or to customize the model for your business please reach me through: [email protected]