IN EXCEL WITH FORMULAS

Karine and Arlo are trying to establish a University Fund for their daughter Amelia, who turns 2 today.They plan for Amelia to withdraw $12,000 on her 18th birthday and $13,000, $14,000 and $15,000 on her subsequent birthdays (19th, 20th and 21st).They wish to deposit money into an account so that, with interest it will build up enough to make the planned withdrawals.They wish to make ten equal annual deposits, and they intend to make their first deposit one year from today, and expect to earn an average return of 6.55%pa on the account.

i.How much will Karine and Arlo have to deposit each year to the account to achieve their goal?

ii.Createa schedule showing the cash inflows (including interest) and outflows of this fund.How much will be in the fund on Amelia's 16th birthday?

(Your answers should be accurate to the nearest dollar)