Use this worksheet to calculate the payback period of an investment. The payback period is the number of periods (usually years) that it takes to recover the initial investment from the operating cash flows. Be sure to enter the initial investment as a negative cash flow. You should use caution when evaluating an investment by using the payback period calculation since it does not utilize time value of money calculations and therefore assumes that a present day dollar is equal to a future dollar. The payback period calculation should be used in conjunction with time value of money calculations such as Net Present Value To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.

 

Payback Period

Microsoft Excel 2010
Family Budget Planner Spreadsheet
Payback Period
Download Download

Created On

Template Details

Created By: Admin
License: Public Use
(Distributable)

Description

Download free excel template and don't forget to like our Facebook page for latest updates.

 

Write a comment for this product!

Please Write your Comments
Rating for product: