Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose you are planning tuition funds for two children. The first child will need to make their first tuition payment in 10 years from today,
- Suppose you are planning tuition funds for two children. The first child will need to make their first tuition payment in 10 years from today, and the second child will need to make their first tuition payment in 14 years from today. Each child will need four annual tuition payments. Assume average tuition now is $22,000 per year and will increase at a rate of 3% each year. You will invest the fund in equities with a 10.5% expected annual return until one year before the first tuition payment for the child. One year before the first tuition payment, you will switch the fund into a money market account with an expected annual return of 2%.
Average tuition today | 22,000.00 |
Annual increase in tuition | 3.00% |
Rate of Return before college starts | 10.50% |
Rate of Return after college starts | 2.00% |
Tuition Planning Worksheet | Child 1 | Child 2 | ||||||||
Average tuition cost today | 22,000.00 | Years from now | Year in college | Tuition needed | Years from now | Year in college | Tuition needed | |||
Annual increase in tuition | 3.00% | 10 | 1 | 14 | 1 | |||||
Rate of return before college starts | 10.50% | 11 | 2 | 15 | 2 | |||||
Rate of return after college starts | 2.00% | 12 | 3 | 16 | 3 | |||||
13 | 4 | 17 | 4 | |||||||
a) | $Amount needed for child 1 in 9 years | |||||||||
$Amount needed for child 2 in 13 years | ||||||||||
b) | Lump sum investment required today for child 1 | |||||||||
Lump sum investment required today for child 2 | ||||||||||
c) | Annual Investment required (end year) child 1 | |||||||||
Annual Investment required (end year) child 2 | ||||||||||
d) | Annual Investment required (beginning year) child 1 | |||||||||
Annual Investment required (beginning year) child 2 | ||||||||||
e) | Annual saving at end of year child 1 | 7,000.00 | ||||||||
Annual saving at end of year child 2 | 5,000.00 | |||||||||
Pre-retirement rate required child 1 | ||||||||||
Pre-retirement rate required child 1 |
- How much money will you need to have accumulated one year before each child's first tuition payment to be able to meet the total tuition requirements? (Use Excel's NPV function)
- If you were to make a single lump sum investment today, how much would you need to invest today to meet each child's total tuition requirements?
- If you were to invest an equal dollar amount at the end of each year, how much would you need to invest annually to meet each child's total tuition requirements?
- If you were to invest an equal dollar amount annually and your first investment is today, how much would you need to invest annually to meet each child's total tuition requirements?
- Assume you can save $7,000 for child 1 and $5,000 for child 2 at the end of each year to invest towards their tuition requirements. What rate of return do you need to earn in pre-college years to meet each child's total tuition requirements?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started