Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references.

- In the Cell 'G5' of Sheet 'ClassRing', the 'Formula Result Value' was set to be 35.571

i need to know which function to use for this question in order to get 35.571 (should be exactly 35.571) and the formula for (using PMT function or if function)

7 Inland Jewelers Date 10/23/16 Monthly Payment Name Ring Type Cost Personalized Total Years Dodson Jones Clarke Ranger McKinley Broadnax Burch Totals Silver$ 400.00 Yes Gold Titanium 700.00 No Platinum 750.00 No Platinum$ 750.00 Yes Gold Titanium$ 700.00 Yes S 420.00 $ 577.50 $ 700.00 $ 750.00 $ 787.50 $ 550.00 $ 735.00 4,520.00 $ 550.00 Yes 10 $ 550.00 No 3 12 $ 4,400.00 14 Ring Type 16 17 18 19 20 Cost 400.00 550.00 700.00 750.00 Gold Titanium Platinum Personalizing Surcharge Interest Rate 21 3%