Calculating the payback period in Excel is the simplest when the annual cash flows are the same for each year. Here is a brief outline of the steps to calculate the payback period in Excel.