Payback and Discounted Payback Period in Excel

[@ravinavijayan639]

Incase there is a payment in one or two years, then how do we calculate the discounted payback period?

[@NguyenTuanMinhK18HL]

Thank you for this helpful formula