discounted payback period

Excel function

tadDPP | Excel function finds discounted payback period in Excel 2007, 2010 and 2013

Windows calculator

tadDPP | Windows calculator computes discounted payback period

e-Book article

tadDPP | e-book offers indepth analysis of the discounted payback period
Discounted payback period calculator

In finance, the discounted payback period is one of the key measure that determines the investor's return on investment. A simple discounted payback period is the time needed to recover the initial cost of the investment whereas the discounted payback period ensures that such cash flows are discounted to reflect their present value when finding the payback period. Finding the discounted payback period is however not that easy as there are no formulas to find the discounted or simple payback period. Thus to find the discounted payback period, an analyst would draw up a table of data showing the timings of the cash flows, the cash flows, the discounted amounts and the running sum of the discounted amounts. The analyst would watch out for the row where the running sum of discounted amounts turns positive thus resulting in the time period for the recovery of the initial cost incurred in undertaking the investment.

A sample discounted payback period calculation is provided herein illustrating the steps taken in computing the time period required to recover the initial expense incurred in an investment when the cash flows are discounted to reflect their present value. This example assumes that you had invested an amount of $100 million dollars and expected four annual receipts of $70 million. Your cost of capital is 4% and the task is to find the discounted payback period that ensures the recovery of the $100 million.

Now that you have seen the steps required for finding the discounted payback period, it is time for us to provide you with a study guide that will explain the topic indepth. Please feel at home to download this study guide from the shopping cart that is found following this text.
Item Trial version Full version
discounted payback period e-BookDownloadBuy Now

Finding discounted payback period in Excel

Up until Excel 2013, there were no native financial functions in Excel to find the discounted payback period. It is unclear as to what Microsoft is planning with its upcoming Excel 2015 or 2016, yet if it does introduce a new set of financial functions in the new release of Excel then more than likely such financial functions will be based up the tadXL series of financial functions. tadXL add-in for Excel 2007, 2010 and 2013 were released to the market in March of 2012 and it offered a large number of financial functions for Excel users. One of these financial functions is the tadDPP financial function that accepts a discount rate and series of cash flows to find the discounted payback period. There are other options that are part of this function that allow you to use compounding frequencies of interest and to define the payment period's length in addition permits the use of discounting conventions such as mid-year discounting.

Using tadXL functions such as tadDPP, finding discounted payback period in Excel 2007, 2010 and 2013 becomes really easy. Let us take the cash flows from our previous investment, to find the discounted payback period in Excel we would type the following:
=tadDPP( 4%, {-100, 70, 70, 70, 70} )
1.505142857

or
=tadDPP( A2, A1:E1 )
That is all that would be required, and the tadDPP function will return the discounted payback period.

Now let us say that we were interested in finding the real discounted payback period to determine the time period required to recover "all" costs incurred during the project. Say that the cash flows for such as investment were -150, 70, 70, 70, -70, 70 where there is an interim outgoing amount of $50 million. To find the discounted payback period in Excel we would now use a different financial function from tadXL called tadTPP where TDPP stands for true discounted payback period. Here is how:
=tadTDPP( 4%, {-150, 70, 70, 70, -70, 70} )
4.270790802

Now the discounted payback period is quite different from the earlier investment where we were only concerned with recovering only the initial cost as compared to all costs.

The tadXL add-in is available for 32-bit Excel 2007, 2010 and 2013 and for 64-bit Excel 2010 and 2013. You will find the links to download the latest version of tadXL v2.5 from the following download cart that will permit you to find the discounted payback period using all of the financial functions that were discussed earlier. Please feel at home and get yourself copy of this unique, quality Excel add-in.
If you thought that was the last of the financial functions in tadXL to find the discounted payback period then you are dead wrong, there are financial functions in the latest version of tadXL that permit you to find the discounted payback period for a porfolio of investments. This would require you to enter the series of data for each of the investments and their respective discount rates to find the discounted payback period of a portfolio of investments. The version of tadXL offering incremental, decremental discounted payback period and the options for portfolio analysis is currently under development and will be released soon. However you are free to download the latest of the currently available tadXL v2.5 from the following cart that offers the 32-bit tadXL and 64-bit tadXL for Excel 2007, 2010 and 2013 for Windows.
Item Trial version Full version
32-bit tadXL v2.5 Download Buy Now
64-bit tadXL v2.5 Download Buy Now
Well if you do not have Microsoft Excel installed on your Windows based computer, then we will still offer you the tools that help find the discounted payback period. The tadBCR Windows 7 and 8 calculator runs on the desktop without requiring an installation file. Simply download this discounted payback period calculator from the shopping cart listed below and copy it onto your Windows desktop. Run the program by double clicking on the file icon to launch the program, once the calculator area is displayed you may enter the series of cash flows and the discount rate before clicking on the calculate button to find the discounted payback period. As usual it is free of cost and is available to download from the following shopping cart.
Item Trial version Full version
discounted payback period calculatorDownloadBuy Now
What if you haven't got Windows running on your computer and are using operating systems such as Mac OS, Linux or are connecting to this website from a smart phone. Obviously you have come here to find the discounted payback period, and we will be happy to assist you in finding the discounted payback period while you stay with us. Following this announcement you will notice an online discounted payback period calculator that accepts a series of cash flows and the discount rate to find the discounted payback period. Please feel at home and move ahead with using this online calculator to compute the discounted payback period.

Data input




%

Data output

discounted payback period = years