Excel Practice Problem... I went off I believe around step 9... The monthly payments in my chart I believe are incorrect. Thank you so much. urgent in time

its urgent!

9 8 10 10 11 8 12 6 Copy the function from cell F5 down through F13 to complete column F and apply Currency Number Format with two decimal places to column F. Insert the function in cell H5 to calculate the first customer's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number. Copy the formula down to complete column H. Insert a function in cell H14 to calculate the total of all monthly payments in column H and apply Currency Number Format with two decimal places to column H. Insert a function in cell H18 to calculate the total number of orders based on entries in column A. Insert a function in cell H19 to calculate the lowest monthly payment in column H. Insert a function in cell H20 to calculate the average monthly payment in column H. Insert a function in cell H21 to calculate the highest monthly payment in column H. Insert a function in cell H22 to calculate the median monthly payment in column H. Apply Currency Number Format with two decimal places to the range H19:H22. Insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side. 13 6 14 6 15 6 16 6 17 2 18 6 Feated On: 10/21/2020 1 Exp19_Excel_Cho2_Cap - Appliances 1.8 -ader - Instructions Excel 2019 Project Step Instructions Points Possible 19 0 Save and close Exp19_Excel_Ch02_Cap_Appliances.xlsx. Exit Excel. Submit the file as directed Date Prepared: Tuesday, January 19, 2021 Total Due Years 3 5 3 5 Client Name Garten Leggett Vong Ranger Williams Davis Jackson Garcia Broadnax Totals SKUSKUSKUSKUSKUSKU 294211294211294211 327064327064327064 446741446741446741 643081643081643081 294211294211294211 446741446741446741 306862306862306862 643081643081643081 446741446741446741 Item Name Delivery Refrigerator Yes Microwave Yes Washer No Dryer No Refrigerator No Washer No Dishwasher Yes Dryer No Washer Yes Price $1,399.00 $379.99 $467.99 $599.99 $1,399.00 $467.99 $809.99 $599.99 $467.99 1,474.00 454.99 467.99 599.99 1,399.00 467.99 884.99 599.99 542.99 Monthly Payment 40.94444444 7.583166667 12.99972222 9.999833333 38.86111111 12.99972222 18.43729167 12.49979167 9.049833333 163.3749167 4 9 Inventory Information SKU DescriptionDescription 294211 Refrigerator Refrigerator 306862 Dishwasher Dishwasher 327064 Microwave Microwave 446229 Oven Oven Oven Oven 446741 Washer Washer Washer 643081 Dryer Dryer Dryer Dryer Price $1,399.00 $809.99 $379.99 $1,099.99 $467.99 $599.99 Summary Statistics Number of Orders Lowest Monthly Payment Average Monthly Payment Maximum Monthly Payment Median Monthly Payment 7.583166667 18.15276852 Delivery Fee $75.00$75.00$75.00 Interest Rate 3.25%3.25%3.25%3.25% Months Per Year 12121212121212121212