Overview

 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 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 business rely
on to choose among potential capital projects. Small business and large alike
tend to focus on project with a likelihood or faster, more profitable payback.

 The
template includes regular and discount payback

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

The discounted payback is 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

Reviews Add a review
No reviews yet

More From ECF Consultancy

Browse our top rated business templates. See All
Financial Reporting Checklist Excel Template
211
0
 Looking for a working checklist that you can use as a template when conducting a financial report? If you are,…
Balance Confirmation
254
2
 Download balance confirmation letter 
Executive Financial Summary Excel with Power Point Template
314
0
 Overview The template provides a short financial description of the business that allow the reader to understand the highlights of…
Authority Matrix Excel Template
521
0
 Authorities and Responsibilities Matrices   Authorities and Responsibilities Matrices are considered important to organizations due to their role in identifying…
WACC Calculator
1,174
109
The free excel template help the user to calculates the weighted average cost of capital for the long-term funding used…
Business Review Meeting Excel Template
1,108
2
General overview The temple is a Business Review Meeting to be held monthly or quarterly. A business review meeting is…
See All