(use excel time value money functions and show work please)

1. Mr. J. J. Parker is creating a college fund for his daughter. He plans to make 15 yearly payments of $1500 each with the first payment deposited today on his daughters first birthday. Assuming his daughter will need four equal withdrawals from this account to pay for her education beginning when she is 18 (i.e. 18, 19, 20, 21), how much will she have on a yearly basis for her college career? J. J. expects to earn a hefty 12% annual return on his investment.

Solves for the present value of the cashflows PV (rate, nper, pmt, fv, type), Computes the payment PMT (rate, nper, pv, fv, type), Calculates the implied interest rate RATE(nper, pmt, pv, fv, type, guess), Calculates the number of periods NPER(rate, pmt, pv, fv, type), Computes the future value of a series of even cashflows FV(rate, nper, pmt, pv, type), Returns the interest portion of the payment IPMT(rate, per, nper, pv, fv, type), Returns the cumulative interest paid between two periods of time CUMIPMT(rate, nper, pv, start_period, end_period, type)