The next step is to create the base formulas needed to determine the payback period. The formula in cell C7 transfers the initial investment in B4 to the work area. Cell D7 contains the first intermediate calculation, which determines the net cash flow for each period.