Answer for google sheets, below are the formulas required

2. Jayne needs to make three payments to Jade requiring $2,000 each 5 months, 10 months, and 15 months from today. She proposes instead making a single payment eight months from today. If Jade agrees to a simple interest rate of 9.5%, what amount should Jayne pay? Format for Spreadsheet Functions on Excel Present worth: Contents of = PV(i%,n,A,F) for constant A series; single F value = NPV(i%,second_cell:last_cell) + first_cell for varying cash flow series Future worth: = FV(i%,n,A,P) for constant A series; single P value Annual worth: = PMT(i%,n,P,F) for single amounts with no A series = PMT(i%, n,NPV) to find AW from NPV; embed NPV function Number of periods (years): =NPER(i%,A,P,F) for constant A series; single P and F (Note: The PV, FV, and PMT functions change the sense of the sign. Place a minus in front of the function to retain the same sign.) Rate of return: = RATE(n,A,P,F) for constant A series; single P and F = IRR(first_cell:last_cell) for varying cash flow series Interest rate: = EFFECT(r%,m) = NOMINAL(i%,m) for nominal r, compounded m times per period for effective annual i, compounded m times per year Depreciation: = SLN(P,S,n) = DDB(P,S,n,t,d) straight line depreciation for each period double declining balance depreciation for period t at rated (optional) = DB(P,S,n,t) declining balance, rate determined by the function = VBD(P,0,n,MAX(0,t-1.5), MIN(n,t-0.5),d) MACRS depreciation for year t at rate d for DDB or DB method Logical IF function: = IF(logical_test,value_if_true,value_if_false) for logical two-branch operations