Question

a) Let's say a year of college currently costs $20,000 in today's dollars. If your clients' child is currently 9 years old and will start college at 18 years of age, how much will the first year of college cost?

Assume college expenses inflate at 3.4% per year, and you can earn an annual rate of return of 6.9% on your investments.

b) Let's say that when your clients' child starts college, you estimate that annual tuition will be about $27,000 in future dollars. How much in total will your clients need to have saved when their child starts college?

Assume the following:

• College expenses inflate at 4.3% per year
• Your clients can earn an annual rate of return of 5.6% on their investments while their child is in college
• Your clients want to help their child with 5 years of college
• Tuition is due in full at the beginning of each year of college

c) In order for your clients to reach their goal, let's say you've estimated that they need to have $94,000 accumulated by the time their child starts college at age 18. To reach that goal, how much do they need to save at the end of each month if their child is currently 13 years old?

Assume college expenses inflate at 4.2% per year, and you can earn an annual rate of return of 6.2% on your investments.

d) Your clients want help figuring out how much they need to save for their child's education. If your clients' child is currently 5 years old and will start college at 18 years of age, how much do they need to save at the end of each month to reach their goal?

Assume the following:

• You estimate that a year of tuition in line with your clients' goal is $10,000 in today's dollars
• College expenses inflate at 3.2% per year
• Your clients can earn an annual rate of return of 6.8% on their investments while their child is in college
• Your clients want to help their child with 5 years of college
• Tuition is due in full at the beginning of each year of college

e) Your clients want help figuring out how much they need to save for their child's education. If your clients' child is currently 1 years old and will start college at 18 years of age, how much do they need to save at the end of each month to reach their goal?

Assume the following:

• You estimate that a year of tuition in line with your clients' goal is $16,000 in today's dollars
• College expenses inflate at 3.3% per year
• Your clients can earn an annual rate of return of 6.5% on their investments while their child is in college
• Your clients want to help their child with 6 years of college
• Tuition is due in full at the beginning of each year of college

Answer 1

The following are the data inputs in spreadsheet:

$8XWqJ2pYF44AAAAASUVORK5CYII=$

$RVzqHKgPO44AAAAASUVORK5CYII=$

The following are the obtained results in spreadsheet:

$wFz01FkGM4ucAAAAABJRU5ErkJggg==$