Piste B IU A E Merge & Center % Conditional Format Formatting Tale Style Coboard is Fone Alignment Number F7 $ A C D 3 5 $ $ 6 Buying a Car Cost of the Car MFG Rebate Down Payment Amount of your loan Interest Rate (per Year Term Years) Quarterly Payment 764581 28,765.43 5,481.00 2.500.00 Loan Amount RATE: per quarter NPER: total number of payments PMT: quarterly payment 4.16% 5 9 TO 11 Points 12 13 1 1 14 15 16 17 T8 4 4 3 Student Grade INSTRUCTIONS 1. Enter your Student Number in cell F3 12. In cell F5 (MFG Rebate) enter the last 4 digits of your student number as the amount. Example: for student number 0123456, enter 3456 3. In cell F7 - create a formula to calculate the Amount of your Loan 4. In cel FB - Calculate the Rate per quarter 5. In cell F9 - Calculate the Number of payments over the term of the Loan In cell FIO - using the PMT Function - Calculate your Quarterly Payment, using the information 6. above in the shaded cells. 17. Display the payment as a negative number. Save the workbook as First Initial Last Name Student Number GPA, and submit in the Assignment Area by selecting Browse Computer and Attaching your Excel tie. Then Save and Submit Example: KDi Paolo0123456GPA 8 19 20 2 21 + 23 0 TOTAL 23 24 25 26 2 Instructions Documentation Budget GPA Buying a Car o Reacy