Q.16 Please answer using the formula sheet

16. Stan and Kendra's children are currently four and two years old. When their older child turns 18, they want to have saved up enough money so that at the beginning of each year they can withdraw $20,000 for the first two years, $40,000 for the next two years, and $20,000 for a final two years to subsidize their children's cost of postsecondary education. The annuity earns 4.75% compounded semi-annually when paying out and 6.5% compounded monthly when they are contributing toward it. Starting today, what beginning-of-quarter payments must they deposit until their oldest reaches 18 years of age in order to accumulate the needed funds? Format for Spreadsheet Functions on Excel Present worth: Contents of = PV(%,n,A,F) for constant A series; single F value = NPV (%.second_cell:last_cell) + first_cell for varying cash flow series Future worth: = FV(%,1,A,P) for constant A series; single P value Annual worth: = PMT(%,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(%,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) for nominal r, compounded m times per period = NOMINAL(i%,m) for effective annual i, compounded m times per year Depreciation: = SLN(P,S,11) straight line depreciation for each period = DDB(P,5,n,1,d) double declining balance depreciation for period t at rated (optional) = DB(P,S,n,1) declining balance, rate determined by the function = VBD(P,0,1,MAX(0,t-1.5), MACRS depreciation for year t at rated for MIN(n,t-0.5),d) DDB or DB method Logical IF function: = IF(logical_test,value_if_true,value_if_false) for logical two-branch operations