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

I cant seem to get the right formula for this question I have included a picture from the assignment. The formula has to be able to be copied down the remaind cells which vary in both price and duration of the loan.

AutoSave DominicFrasca exploring e02 grader_h1.xlsx - Excel File Insert Draw Page Layout Formulas Data Review View w Tell me what you want to do AutoSum . A Fill Calibri Wrap Text Conditional Format as Cell Formatting Table Styles Sort & Find& Filter Select Merge Insert Delete Format Clear Clipboard Font Alignment Cells H13 Inland Jewelers Name Tpe Cast PersonalizedTtYear 5 Codur 6 lones T Clarke 8 Ranger 9 McKirley Platinum 10 Breacnax 11 Burch 2 Totals il5 400.00 Ye Gold$ 550.C0 Yes 700.00 No Platinum 750.CO No 5.c0 Yes S50.C0 No litanium S OU.CO Yes $ 42000 577.50 s 700on 75D.o0 TR7 1 535,57) 1548.91 2 530.0 3 $21.8 2 1$23.641 :S21.3 Gold 6 Siver 17 Gold 400.00 S 550.00 5 700.00 5 750.00 Titanium Painm Personalizirc 3% ClassRing Reacy 1]- + 70% Type here to search 3:26 PM 10/6/2017