Reviewed by Margaret James Fact checked by Suzanne Kvilhaug What Is a Payback Period? The payback period is the amount of ...

The sum of all these discounted cash flows, representing the total ... cost of capital equals the return of capital. The Excel formula for calculating the discount rate is =RATE (nper, pmt ...

How Do I Calculate a Discounted Payback Period in Excel? The discounted payback period is the number of years it takes to pay back the initial investment after discounting cash flows. In Excel ...