Your friends are setting up a college fund for their young daughter and are asking your advice. They plan to deposit $$4000$ annually $($on January $1$st$)$ for the next $14$ years. Their investment program will pay $6\%$ annually on their deposits. They will then need to make college payments in the amount of $$28,000$ annually on January $1$st for the next four years. Determine if their plan is reasonable. Use PV and PMT to determine what amount your friends need to deposit annually to fund this college plan.

Please show in excel spreadsheet.