Jenny is going to establish a University Fund for her son, James, who is four year's old.She plans to make the first deposit of $5,000 today and make another 9 annual deposits of this amount. After this, annual deposits of $10,000 will be made until James' 18th birthday. Given the long term nature of the investment, Jenny anticipates a 3% pa return. The money is then to be transferred to an account for James on his 18th birthday and he will then withdraw the money in equal annual amounts for 5 years starting on his 18th birthday. James will only be able to earn 1.5% pa on his money.

(i) How much money will be available on James' 18th birthday?

(ii) Make a schedule showing the cash inflows and outflows of this fund.How much will James be able to spend each year?

Can you show me the formula you have used and its excel equation (function) if possible?