There are no financial functions in Excel to find the discounted payback period, the good news however is the availablity of tadXL add-in that offers many financial functions including one to find the DPP. Here me, Abraham A. will take you on a guided tour to find the discounted payback period using the Excel tadDPP function.
Please go ahead and download InvAppraisal calculator that offers 10 financial functions to analyze investments including one to find discounted payback period. To find the discounted payback period with this calculator you may enter the series of cash flows, the discount rate and other information such as compounding frequency of interest, the length of the payment period and the discounting convention of your choice. Have a look at the screen shot of this robust, feature rich and easy to use calculator that is shown below. You may click on the discounted payback period calculator screenshot to download and use this calculator on Windows 7 and 8 operating systems. No installation is required, just copy the file on your Windows desktop and run the program file by double clicking the program icon.
A discounted payback period is used as a tool by an analyst to help find an investor's ROI - return on investment. It refers to the time period required to recover just the initial cost incurred in undertaking the project. Finding it manually is quite cumbersome and time consuming as there are no formulas to find it. Finding discounted payback period in Excel is made possible only when you use 3rd party function such as tadDPP as there no built-in financial functions in Excel to find it. tadDPP is one of the many financial functions that are part of tadXL add-in for Excel 2007, 2010, and 2013.
There are 10 financial functions in tadXL v0.5 including a number of functions to find discounted payback period. A list of these functions may be found here
|1||32-bit tadXL v0.5 download||$19||Download||Buy Now|
|1||64-bit tadXL v0.5 download||$19||Download||Buy Now|
Finance tutorials on a variety of topics ranging from finding ROI using IRR, NPV, Payback period, etc. TVM calculations i.e. present value & future value of loans and bank deposits. Valuation & yield on stocks and bonds i.e. cost of equity, & debt. Rates of return on investments i.e. ARR, GRR, holding period return & yield.
Excel 4 finance to perform DCF analysis NPV, xNPV, IRR, xIRR, MIRR, xMIRR etc. Time value of money calculations i.e GRADIENT, INTEREST RATE, NPER, PMT, etc, yields and prices of bonds and stocks. Rates of return i.e. HPR, HPY, AHPR, and AHPY, etc.
TI BA II plus guide to analyze investments using capital budgeting methods i.e IRR, NPV, MIRR etc. TVM calculations i.e. RATE, NPER, PMT, PV, FV. Interest rate factors i.e. PVIFA, PVIF, FVIFA, FVIF, etc .
Finance tables to find interest factors for present value and future value of $1 and of annuities with start of period and end of period payments in amount of $1. Interest rates for growing and shrinking annuities are available as well.