How to Calculate the Payback Period in Excel
The payback period is the time it takes for a project to recover the investment cost. For example, if you invest $100 and the returns are $50 per year, you will recover your initial investment in two years.