i need help with what function to use and what to type in

i know i need to use the pmt function to find the first monthly payment. all the information is there

Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number Copy the formula from cell G5 to the ranna 2011 Open recovered workbooks? Your recent changes were VOOKUP fx =PMT C PMT(rate, nper, pv, [fv], [type]) G H Inland Jewelers 1 8/25/21 2 Date 3 Total Name Ring Cost Personalized Type Silver $ 400.00 Yes Gold $ 550.00 Yes Titanium $ 700.00 No Platinum $ 750.00 No Platinum $ 750.00 Yes Gold $ 550,00 No Titanium $ 700.00 Yes $ 420-22 $577.50 $ 700.00 $ 750.00 $ 787.50 $ 550.00 $ 735.00 Monthly Years Payment 1 EPMTC 1 (8577.50) E5 2 ($350.00) 3 (S250.00) 3 ($262.50) 2 ($275.00) 3 (5245.00) 5 Dodson 6 Jones 7. Clarke 8 Ranger 9. McKinley 10 Broadnax 11 Burch 12 Totals 23 14 15 Ring Type 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Cost Personalising Surcharge SX 21 Interest Rate 3% 23 25 26 27 20 20 ClassRing + Edit HH