Answered step by step
Verified Expert Solution
Link Copied!

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%

a) 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)

b) 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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Solution a To calculate the amount of money you need to have accumulated one year before each childs ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Business Mathematics with Canadian Applications

Authors: S. A. Hummelbrunner, Kelly Halliday, K. Suzanne Coombs

10th edition

133052311, 978-0133052312

More Books

Students also viewed these Economics questions

Question

Describe how money and politics have a similar use.

Answered: 1 week ago

Question

Would giving rewards or administering punishments be

Answered: 1 week ago

Question

-4 1 9. Let A = Find A-1, (A") and verify that (A")= (A-1)".

Answered: 1 week ago