Please input these numbers into excel using one of the formulas. Please show me how you got the answer and what formula was used. Thank you.

ment needed to fund each child's college education Step 3 Colculate the end of year payment needed to fun Tyler $52,162.89 6 Trace $49,318.28 PV IN N - 896 8% FV - 0 PMTA - $11,283.64 - FV PMTOA - $7,894.86 ines to fund Tyler's and Trace's education expense = $19,178.50. sal annual cost of savings to fund Tyler's and Trace's d. Review the proof of education funding schedule, CVEN CASH FLOW APPROACH TO CALCULATE THE NPV OF 4 YEARS OF EDUCATION USING THE UNEVEN CASH FLOW Appp EXPENSE of value calculation for cost of education for all three children: 10BII Keystrokes 15,000 (CF) 4 ORANGE IN O (CFj] 2 ORANGE (N) 15,000 (CFj] 3 ORANGE) (N) 30,000 (CFj] 15.000 (CF;] 3 ORANGE INj] 1.08 (+) 1.06 1 (x) 100 (-) (I/YR) ORANGE INPV) 12C Keystrokes 15,000 (g) (CF) 4 [g] [N] 0 [g] (CFj] 2 [g] [Nj] 15,000 (g) (CFj] 3 [g] [Nj] 30,000 [g] (CFj] 15,000 (g) (CFj] 3 [g] [Nj] 1.08 [ENTER) 1.06 [+] 1 [-] 100 (x) [i] [H (NPV) Answer: 159,835.05 Answer: 159,835.05 Recap The PV of Kylie's four years of education is $58,354. The PV of Tyler's four years of education is $52,163. The PV of Trace's four years of education is $49,318. The total present value of the inflated cost of education for the Windsor children is $159,835. See Education Savings and Withdrawal Schedule. The importance of financial aid for the Windsor children becomes clearer to William and Kate as they realize that tever financial aid they receive will help them close the small annual present value deficit of funds needed to meet their education funding goal and retire at age 64. ment needed to fund each child's college education Step 3 Colculate the end of year payment needed to fun Tyler $52,162.89 6 Trace $49,318.28 PV IN N - 896 8% FV - 0 PMTA - $11,283.64 - FV PMTOA - $7,894.86 ines to fund Tyler's and Trace's education expense = $19,178.50. sal annual cost of savings to fund Tyler's and Trace's d. Review the proof of education funding schedule, CVEN CASH FLOW APPROACH TO CALCULATE THE NPV OF 4 YEARS OF EDUCATION USING THE UNEVEN CASH FLOW Appp EXPENSE of value calculation for cost of education for all three children: 10BII Keystrokes 15,000 (CF) 4 ORANGE IN O (CFj] 2 ORANGE (N) 15,000 (CFj] 3 ORANGE) (N) 30,000 (CFj] 15.000 (CF;] 3 ORANGE INj] 1.08 (+) 1.06 1 (x) 100 (-) (I/YR) ORANGE INPV) 12C Keystrokes 15,000 (g) (CF) 4 [g] [N] 0 [g] (CFj] 2 [g] [Nj] 15,000 (g) (CFj] 3 [g] [Nj] 30,000 [g] (CFj] 15,000 (g) (CFj] 3 [g] [Nj] 1.08 [ENTER) 1.06 [+] 1 [-] 100 (x) [i] [H (NPV) Answer: 159,835.05 Answer: 159,835.05 Recap The PV of Kylie's four years of education is $58,354. The PV of Tyler's four years of education is $52,163. The PV of Trace's four years of education is $49,318. The total present value of the inflated cost of education for the Windsor children is $159,835. See Education Savings and Withdrawal Schedule. The importance of financial aid for the Windsor children becomes clearer to William and Kate as they realize that tever financial aid they receive will help them close the small annual present value deficit of funds needed to meet their education funding goal and retire at age 64