What single sum, deposited today, into a college account earning
10% compounded semi-annually, would allow for the following: semi
annual college payments for four years (starting 10 years from
now), tuition and fee payments at the beginning of each half year
over that same four year timeframe (again, starting 10 years from
now), and tuition payments of $15,000 per half year over the same
four years (starting 10 years from now) . (show using
Excel)