Lynda Jones College Plan On her 10th birthday Linda Jone's parents decide to deposit $4,000 in a 529 account for their daughter to go to college. They intend to put an additional $4,000 in the account each year on her 11th, 12th, ..., 17yh birthdays. Assume all account balances will earn 8% per year. On Lynda's 18th, 19th, 20th, and 21st birthdays, her parents will withdraw $20,000 to pay for Linda's college education. Questions: Is the $4,000 savings per year sufficient to cover the anticipated college expenses? Is Linda's 529 account underfunded? What should be the annual deposit in Lynda's 529 account to cover entirely her tuition and fees? What will be the PV of Lynda's college tuition on her 18th birthday? Summarize the results of your analysis and provide your recommendation in this quizz. Create a spreadsheet and submit it in you Drop Box.