plz answer by taking pictures of excel sheet and writing clear steps of the formula. the data is attached below.

8 15 9 10 Insert the PMT function in cell J5 to calculate the first client's monthly payment, using appropriate relative and absolute cell references. Copy the formula down the column. Calculate totals for Annual Total, Total Due Down Payment Balance, and Monthly Payment on row 14 Insert the appropriate functions in the Summary Statistics section of the worksheet cells H18:H22. Format the payments with Accounting number format Format the other column headings on rows 4 and 17 to match the fill color in the range E17 H17 Wrap text for the column headings 10 10 11 10 12 5 13 5 Set 0.3" left and right margins and ensure that the page prints on only one page Insert a footer with your name on the left side the date code in the center and the file name on the right side Save and close the workbook Submit the file as directed 14 0 Total Points 100 AutoSave OF Copy of exploring_03_graderat. File Home Insert Page Layout Formulas Data Review View Help Ana 10 VA A X Cut In Copy Patie Format Painter Clipboard 15 BIU a-A. 2 Wrap Text EEZE Merge & Center - General $ % 9-1 Condit Format Front Number D Health & Fitness Gym 1/25/2021 1 2 Date Prepared 3 4 Client 5 Andrews 6 Baker 7 Carter 8 Dudley 9 Evans 10 Foust 11 Gardner 2 Hart 3 Ivans 4 Totals Membership Deluxe Individual Family Deluxe Dolu Individual Individual Individual Individual Cost Locker Annual Total Years Total Due Down Paymen Balance Monthly Payment 575 Yes 650 1 650 250 4001 300 Yes 375 2 750 1500 NO 150 600 1500 3 4500 700 3800 575 No 575 2 1150 250 900 575 Yes 650 3 1950 1700 300 No 300 1 300 150 150 300 NO 300 2 600 150 450 300 No 300 3 150 750 300 Yes 375 3 1125 150 975 250 900 9 Family 6 7 Membership 8 Deluxe $ Individual 5 1 2 Locker Fee $ 3 Interest Rate Months Par Year Cost wn Payment 5755 250 1,500 $ 700 300 $ 150 Summary Statistics Number of New Members Lowest Monthly Payment Average Monthly Payment Maxum Monthly Payment Median Monthly Payment 75 5.75% 12 New Clients # Type here to search o HD