Discounted Payback Period: Definition, Formula & Calculation
Input the known values (year, cash flows, and discount rate) in their respective cells. Use Excel’s present value formula to calculate the present value of cash flows. To calculate the discounted payback period, we need to determine how long these discounted cash flows can cumulatively equal or exceed the initial investment of $4,000. Use this […]
Discounted Payback Period: Definition, Formula & Calculation Read More »