## Excel function

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

discounted payback period

As there aren't any financial functions in Excel itself to find the discounted payback period thus it would take 3rd party programs such as tadXL to bridge the gap. Excel has been around since 1990 when Windows v3.0 was first launched and GUI based operating systems became commonplace. Even the graphical user interface offered by Windows v3.0 had already been around with programs such as Mac OS. Now speaking of the upcoming Excel 2015 or 2016, the word has it that Microsoft is planning to release its own set of financial functions to the Excel users. But if the story is infact true then more than likely most if not all of the new financial functions will be based on or taken from the tadXL add-in for Excel 2007, 2010 and 2013. I got to hear about Microsoft plans while answering a question about the Excel XIRR function on Bytes magazine site where a high ranking contributor justified the copied work that Microsoft is undertaking by saying that author of the original work, yours sincerely does not have the authority on the subject of finance as he lacks a degree. But you know those who steal will cook up excuses to justify the deed they had done. Having or not having a degree is not an issue here, what is at stake is one persons intellectual copyrights and you would think a company such as Microsoft who cries foul that it loses out on millions of dollars of revenue due to piracy would at least think twice before trampling upon someone else's work. But who cares I suppose when you have one billion installation of Microsoft Excel around the world, cooking up new financial functions for hungry masses brings in quite a lot of dough. Who loses out in the end is the one who invested his time and efforts to research, design and develop the set of financial functions that is called tadXL add-on.

Now back to the topic of finding discounted payback period in Excel, the DPP as it is called is the time period required to recover the initial cost incurred in undertaking the capital investment. If you were to be concerned about recovery of all costs incurred in undertaking an investment then you are seeking the real discounted payback period instead. The task of finding the payback period is quite cumbersome as there are no formulas to find it and analsyt has to make use of tables to find it. Excel is a good fit product for crunching numbers and here one can exploit the programming capabilities of Excel engine to create the financial functions that are not native to Excel. 3rd party solutions such as tadXL offer series of financial functions to find the discounted payback period depending upon how much of information is available about the investment. There are 8 different financial functions in tadXL to find the discounted payback period namely tadDPP, tadDPPSchedule, tadTDPP, tadTDPPSchedule, tadXDPP, tadXDPPSchedule, tadXTDPP and tadXTDPPSchedule. So which one of these functions should you use, the answer depends upon how much information do you have about the cash flows from the investment. For the simplest of payback period calculations, you would be using the tadDPP function that will take a series of cash flows and the discount rate. Yet if you have a term structure for interest rates then finding the payback period is made easy by using tadDPPSchedule that not only accepts the series of cash flows but also a schedule of discount rates. But if you have access to a schedule of transaction dates for the cash flows then the tadXDPP function would take care of the payback period calculations. However if you happen to have a schedule of discount rates along with schedule of transaction dates then the tadXDPPSchedule is the function required. There are four other financial functions the list that allow you to find the real discounted payback period that ensure recovery of all the costs as opposed to just the initial cost.

In addition to the 8 different financial functions mentioned thus far, there are even more financial functions found in tadXL add-in to find the discounted payback period when comparing investments that have unequal life spans. For example finding incremental and decremental discounted payback period is possible by using the tadIncDPP and tadDecDPP functions found in tadXL. On the same lines it is also possible to find the incremental and decremental real discounted payback period using the tadIncTDPP and tadDecTDPP functions. And if you haven't already guessed the other variants of incremental and decremental discounted payback period functions will allow for schedule of discount rates and transaction dates. And for sensitivity analysis, a number of financial functions in tadXL will allow for expected values when discounted payback period is considered as a random variable. An example of such as financial function in tadXL is the tadeDPP and tadeTDPP functions that accept the values for discounted payback periods of series of investmenst and their respective probability values to find the mean or average discounted payback period.

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 calculator | Download | Buy Now |

Now that you have used the Excel add-in and the windows calculator to find the discounted payback period, we will now offer you a study guide that will teach you the basics of finding the discounted payback period. It will begin by defining the discounted payback period and its uses in financial analysis and then to present you with the formula needed to find the discounted payback period. An example calculation will make it possible for you to see the steps required in finding the discounted payback period with paper and pencil. Information about Excel functions that find the discounted payback period will be provided. The study guide may be downloaded from the following shopping cart for your personal or corporate use.

Item | Trial version | Full version |

discounted payback period e-Book | Download | Buy 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.

%