(use excel time value functions and show work please)

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.