2. Insert a formula in cell E4 using the PMT function that calculates monthly payments. (Type a minus symbol [-] before the cell designation in the Pv text box at the Function Arguments dialog box.) Copy the formula in cell E4 into the range E5:E7 without formatting. 3. Insert a formula in cell F4 that calculates the total amount paid during the duration of the loan, including interest, by multiplying the contents of cells D4 and E4. Copy the formula in cell F4 into the range F5:F7 without formatting.