need help with #10 the monthly payment formula

KI Paragraph relative and absolute cell references. Styles 9 8 10 10 Copy the function from cell F5 down through F13 to complete column F and apply Currency Number Format 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 to column H. Insert a function in cell H18 to calculate the total number of orders based on entries in column A. 11 8 12 6 13 Insert a function in cell H19 to calculate the lowest monthly payment in column H. 6 14 Insert a function in cell H20 to calculate the average monthly payment in column H. 6 15 Insert a function in cell H21 to calculate the highest monthly payment in column H. 6 6 16 2 17 Insert a function in cell H22 to calculate the median monthly payment in column H. Apply Currency Number Format 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. 6 18 Created On: 10/01/2019 Exp19_Excel_Cho2_Cap - Appliances Clipboard Font Alignment 2 Number J7 fx D E G H A B 2 Date Prepared: Friday, September 11, 2020 3 Price Total Due Years Monthly Payment $1,399.00 $379.99 $467.99 $599.99 $1,399.00 $467.99 $809.99 $599.99 $467.99 No $1,474.00 $454.99 $467.99 $599.99 $1,399.00 $467.99 $884.99 $599.99 $542.99 3 5 3 5 3 3 4 4 5 Client Name SKU Item Name Delivery 4 5 Garten 294211 Refrigerator Yes 6 Leggett 327064 Microwave Yes | Vong 446741 Washer No 8 Ranger 643081 Dryer No 9 Williams 294211 Refrigerator 10 Davis 446741 Washer No 11 Jackson 306862 Dishwasher Yes 12 Garcia 643081 Dryer No 13 Broadnax 446741 Washer Yes 14 Totals 15 16 Inventory Information 17 SKU Description Price 18 294211 Refrigerator $1,399.00 19 306862 Dishwasher $809.99 20 327064 Microwave $379.99 21 446229 Oven $1,099.99 22 446741 Washer $467.99 23 643081 Dryer $599.99 24 25 Delivery Fee $75.00 26 Interest Rate 3.25% 27 Months Per Year 12 Summary Statistics Number of Orders 9 Lowest Monthly Payment $0.00 Average Monthly Payment #DIV/0! Maximum Monthly Paymer $0.00 Median Monthly Payment Sales Ready