A B C G H K M N P Q The next step is to calulate the periodic payment for each student's account. The payments are based on the years financed in column F and the annual intereste rate in cell B22. All accounts are paid on a monthly basis. 8. Insert a PMT function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell reference. Ensure that all information is provided monthly under "Monthly Payment" as the interest rate and the years financed are provided in a yearly format. 9. Copy the formula down the column. 10. Calculate the total in cell C12, E12, and G12. 11. Apply the accounting number format to decimal places for column C, E, and G. 12. In cells C12, E12, and G12 apply a "Top and Double Bottom Border" for the totals. 13. In cell G16 apply a statistical function calculating the average monthly payment Per Customer for Inland Jewlers. 14, In cell G17 apply a statistical function calculating the minimum monthly payment Per Customer for Inland Jewlers. 15. In cell G18 apply a statistical function calculating the maximum monthly payment Per Customer for Inland Jewlers. 16 In rell 619 annly a statistical function calculatine the median monthly naumant Par Customer for inland lesulnes Instructions class ring completed A I B C D E F H 11. Apply the accounting number format to decimal places for column C, E, and G. 12. In cells C12, E12, and G12 apply a "Top and Double Bottom Border" for the totals. J K M N Q 13. In cell G16 apply a statistical function calculating the average monthly payment Per Customer for Inland Jewlers. 14. In cell G17 apply a statistical function calculating the minimum monthly payment Per Customer for Inland Jewlers. 15. In cell G18 apply a statistical function calculating the maximum monthly payment Per Customer for Inland Jewlers, 16. In cell G19 apply a statistical function calculating the median monthly payment Per Customer for Inland Jewlers. 17. Save your file and insert your last and first name at the end of the file name. Submit your completed file to your instructor... AutuSave File Paste Exercise2 FormulasandFunctions Student Copy-2 - Excel (Unlicensed Product) Wendy Home Insert Page Layout Formulas Data Review View Help X 22 Ins Calibri 11 AA== Wrap Text Accounting Del BIU A Merge & Center- $ % 28 28 Conditional Format as Cell Formatting Table Styles - For Font Alignment 19 Number Styles Ce Clipboard E12 123 2 Date A B C D E F G H Custom Jewelers =CONCATENATE"(Today is March 10,2022)" 4 Name 5 Taylor Ring Type Silver 6 O'Neil Gold 7 Hernandez Titanium. 18 Trevor 9 McCannon 10 Martinez Platinum Platinum Gold Titanium Monthly Cost Personalized Total Years Payment $400.00 Yes $424.00 1 $ 35.33 $550.00 Yes $583.00 1 $ 48.58 $700.00 No $700.00 2 $ 29.17 $750.00 No $750.00 3 $ 20.83) $750.00 Yes $795.00 3 $ 22.08 $550.00 No $550.00 2 $ 22.92 $700.00 Yes $742.00 3 $ 20.61 11 Smith 12 Totals 13 14 15 Ring Type Cost 16 Silver $ 400.00 550.00 17 Gold $ Instructions class ring completed Ready Accessibility: Good to go Statistics Average Min Lr AutoSave File 47: Paste Clipboard E12 Home Calibri BIU Exercise2 Formulasand Functions Student Copy-2- Excel (Unlicensed Product) A Wendy Insert Page Layout Formulas Data Review View Help 11 A A = Insert Wrap Text Accounting Delete a A Merge & Center - $ % 808 Conditional Format as Cell Formatting Table Styles Format 10 Font 19 Alignment Number Styles Cel F x fx B 7 Hernandez Titanium 8 Trevor 9 McCannon 10 Martinez Platinum Platinum Gold Titanium 11 Smith 12 Totals 13 14 15 Ring Type Cost 16 Silver $ 400.00 17 Gold $ 550.00 18 Titanium $ 700.00 19 Platinum $ 750.00 20 21 21 22 Personalizing Surcharge Yearly Interest Rate 6% 4% Instructions class ring completed Ready Accessibility: Good to go C $700.00 No D F G H $700.00 2 $ 29.17 $750.00 No $750.00 3 $ 20.83 $750.00 Yes $795.00 3 $22.08 $550.00 No $550.00 2 $ 22.92 $700.00 Yes $742.00 3 $ 20.61 Statistics Average Min Maxi Median 75 Lr