Solve it on Google Sheets, Below are the formulas

3. Marrina is searching for the best way to invest her $10,000. One financial institution offers 4.25% on three-month term deposits and 4.5% on six-month term deposits. Marrina is considering either doing two back-to-back three-month term deposits or just taking the six-month deposit. It is almost certain that interest rates will rise by 0.5% before her first three-month term is up. She will place the simple interest and principal from the first three-month term deposit into the second three-month deposit. Which option should Marrina pursue? How much better is your recommended option? 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