To calculate the payback period, enter the following formula in an empty cell: "=A3/A4." The payback period is calculated by dividing the initial investment by the annual cash inflow. How Do I ...