1. Kelly wants to plan for her daughters education. Her daughter, Rachel is 5 years old today will go to college at age 18 for 4 years. Current tuition cost is $20,000 per year. She has saved $7,000 for this goal. Kelly anticipates inflation rate for tuition is 8% and believes she can earn an 11% return on her investments. Show your work.

1. What is the estimated total future costs (tuitions for 4 years) at the time the child enters college?
2. What is the current funding shortfall?
3. How much must Kelly save at the end of each month if she starts to save today?