Craig (44) and Liz (35) aren't sure about how they are saving for their two daughters, Lily (5) and Ellie(2).

Craig is a professor at UIUC and Liz a dental hygienist.They both work full time and have some funds already set aside for college. They have different higher education goals for their children and would like you to run an analysis of what type of funding, asset allocation and initial resources should be allocated to meet each goal.

Craig would like to provide for four years of undergraduate education for each child. The first two years including 100% room and board costs, the second two years only covering 50% of room and board costs. Craig would like to save enough for Lily and Ellie to attend an in-state public university. Craig is conservative and does not want to assume any tuition or fee waiver from being a professor.

Liz would like to provide for four years of private education for each child, including all room and board costs as well as budgeting enough for holiday plane tickets home.

Lily currently has $60,000 in the Illinois Bright Start 529 plan in the "indexed moderate age-based" portfolio. Ellie currently has $60,000 in the Illinois Bright Start 529 plan in the "indexed moderate-age based" portfolio. For 2020, both accounts are being funded with $50 weekly contributions. Craig and Liz previously invested the proceeds of a business sale into these accounts. Liz and Craig have $20,000 cash they can allocate towards this goal, but would rather spend on upgrading the home. They are able to save more monthly if your analysis requires it.

Please finish education funding plan providing:

1) A list of all assumptions you are making in this plan. Please include college inflation rates, market return expectations, estimated broken down higher education costs and any other assumptions needed to help Liz and Craig plan for college. Please provide references for your assumptions.

2) Using the methodology outlined in this section - and your time value of money skills - please provide a saving recommendation for both Craig and Liz's goals. In this recommendation include

• How much a year of college will cost when Lily turns 18 and Ellie turns 18(2 points)
• What is the present value needed to fund college when Lily and Ellie turn 18 (3 points)
• Considering existing 529 account balances, how much should Craig and Liz save weekly into each account to meet their respective goals? (5 points)
• If a new kiddo came along with $0 529 balance, how much monthly do Craig and Liz need to save to hit their respective goals? (5 points)
• How can Craig and Liz accumulate funds with an eye on financial aid? (5 points)