Paste BIU E EEEE E E Merge & Center $ - % 9 58 88 0 00 Clipboard Font Alignment Number AutoSave 品2- 2. - On C8 H. Loan Payment Example 2 Annual Interest Rate (APR) 1 4% 3 Term in Years 4 Amount...

In cell C7 type a PMT function to calculate the monthly payment for the Lon amount in B7 and the rate and number of payments determined by B2 and B3. Notice you are to calculate a monthly payment but B3 are annual values. Place a minus sign between = and PTM to convert the payment to a positive number. Copy the formula in C7 to C8. Did you property use absolute and relative references so the formula would copy correctly?

Extracted text: Paste BIU E EEEE E E Merge & Center $ - % 9 58 88 0 00 Clipboard Font Alignment Number AutoSave 品2- 2. - On C8 H. Loan Payment Example 2 Annual Interest Rate (APR) 1 4% 3 Term in Years 4 Amount Monthly Total Total Paid Car Financed Payment Interest $ 25,000.00 $ 17,000.00 7 Choice One 8 Choice Two 6. 10 11 12