In cell C8, enter a PMT function to calculate the monthly flex payment for the first option. Be sure to use the appropriate absolute, relative, or mixed cell references. Use the fill handle to copy the function down through cell C10. Make sure each of the monthly flex payments is a positive value.