Question

In: Finance

A professor has two daughters that he hopes will one day go to college. Currently, in-state...

A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $22,119.00 per year (all expenses included). Tuition will increase by 3.00% per year going forward. The professor's oldest daughter, Sam, will start college in 16 years, while his youngest daughter, Ellie, will begin in 18 years. The professor is saving for their college by putting money in a mutual fund that pays about 7.00% per year. Tuition payments are at the beginning of the year and college will take 4 years for each girl. (Sam's first tuition payment will be in exactly 16 years)

The professor has no illusion that the state lottery funded scholarship will still be around for his girls, so how much does he need to deposit each year in this mutual fund to successfully put each daughter through college. (ASSUME that the money stays invested during college and the professor will make his last deposit in the account when Sam, the OLDEST daughter, starts college.)

Solutions

Expert Solution

Step1: Calculate money required for each of the daughters for collage, considering inflation rate:

(Formula used: Future value = Present value *(1+rate of inflation)^number of years)

Step 1
Year Tution Fees (Daughter 1) Tution Fees (Daughter 2) Total
16                                    35,494.50                                    35,494.50
17                                    36,559.34                                    36,559.34
18                                    37,656.12                                    37,656.12                                    75,312.23
19                                    38,785.80                                    38,785.80                                    77,571.60
20                                    39,949.37                                    39,949.37
21                                    41,147.86                                    41,147.86

Step 2: Calculate the present value of total tution fees required at the end of year 16, when the professor will stop making investments.

(Formula used: Present value = Future value *(1/((1+investment returns)^number of years))

Step 2
Total Present Value factor @ 7% Present Value
                                   35,494.50      1.0000       35,494.50
                                   36,559.34      0.9346       34,167.60
                                   75,312.23      0.8734       65,780.62
                                   77,571.60      0.8163       63,321.53
                                   39,949.37      0.7629       30,477.19
                                   41,147.86      0.7130       29,337.85
Total investment value required at the beginning of year 16     258,579.30

Step 3: Calculate the annual investments professor needs to make:

Using financial calculator FVM function in end mode:

N=16, I/Y=7%, PV=0, FV=258,579.30 ----> PV=-9272.045449. That is the annual investment in mutual funds required to be made at each year end till year 16.


Related Solutions

A professor has two daughters that he hopes will one day go to college. Currently, in-state...
A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $21,435.00 per year (all expenses included). Tuition will increase by 5.00% per year going forward. The professor's oldest daughter, Sam, will start college in 16 years, while his youngest daughter, Ellie, will begin in 18 years. The professor is saving for their college by putting money in a mutual fund that pays about 9.00% per year. Tuition...
A professor has two daughters that he hopes will one day go to college. Currently, in-state...
A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $21,801.00 per year (all expenses included). Tuition will increase by 4.00% per year going forward. The professor's oldest daughter, Sam, will start college in 16 years, while his youngest daughter, Ellie, will begin in 18 years. The professor is saving for their college by putting money in a mutual fund that pays about 7.00% per year. Tuition...
A professor has two daughters that he hopes will one day go to college. Currently, in-state...
A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $20,432.00 per year (all expenses included). Tuition will increase by 3.00% per year going forward. The professor's oldest daughter, Sam, will start college in 16 years, while his youngest daughter, Ellie, will begin in 18 years. The professor is saving for their college by putting money in a mutual fund that pays about 9.00% per year. Tuition...
A professor has two daughters that he hopes will one day go to college. Currently, in-state...
A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $22,478.00 per year (all expenses included). Tuition will increase by 3.00% per year going forward. The professor's oldest daughter, Sam, will start college in 16 years, while his youngest daughter, Ellie, will begin in 18 years. The professor is saving for their college by putting money in a mutual fund that pays about 7.00% per year. Tuition...
Bodie Bonds is making his retirement plans. He currently has savings of $125,000. He hopes to...
Bodie Bonds is making his retirement plans. He currently has savings of $125,000. He hopes to retire in 15 years. His retirement expenses are expected to be $60,000 during the first year of retirement; Bodie expects these expenses to grow by 2% a year to keep up with inflation. Bodie wishes to provide for 30 years of retirement. Assume that all cash flows arise at year end (not year beginning) and that the rate of return (interest rate or discount...
Oliver likes to go fishing in the river by his house. One day he noticed that...
Oliver likes to go fishing in the river by his house. One day he noticed that there was a white substance on some rocks at the bottom of the river. When he looked closely, it appeared as though someone had sprinkled a powder or crystals in the water. Moreover, the substance was found mainly where a small creek joined the larger river. Curious, Oliver followed the creek through the forest toward an industrial area. Eventually, he reached a fence and...
Jackson Daniels graduated from Lynchberg State College two years ago. Since graduating from college, he has...
Jackson Daniels graduated from Lynchberg State College two years ago. Since graduating from college, he has worked in the accounting department of Lynchberg Manufacturing. Daniels was recently asked to prepare a sales budget for the year 2016. He conducted a thorough analysis and came out with projected sales of 250,000 units of product. That represents a 25 percent increase over 2015. Daniels went to lunch with his best friend, Jonathan Walker, to celebrate the completion of his first solo job....
Rick is currently 35 years old. He plans to retire at age 65 and hopes to...
Rick is currently 35 years old. He plans to retire at age 65 and hopes to live to age 85. His labour income is $50,000 per year, and he intends to maintain a constant level of real consumption spending over the next 50 years. Assuming a real interest rate of 3% per year, no taxes, and no growth in real labour income, what is the value of Rick’s human capital? ****I would like this broken down step by step, and...
A college professor at LeTall University, Professor Lai, makes mountains out of molehills. He can do...
A college professor at LeTall University, Professor Lai, makes mountains out of molehills. He can do this with almost no effort; so molehills are the only input used for producing mountains. Suppose it takes 100 molehills to make 1 mountain. The current market price of molehills is $20 each. A few years ago, Lai bought an option contract that allows him to buy up to 2, 000 molehills at $10 each. His option contract stipulates that he can buy fewer...
Task #1 It is orientation day at the college. Students need to go to a specific...
Task #1 It is orientation day at the college. Students need to go to a specific room based on their status. Their status can be either international full-time, domestic full-time, or domestic parttime. Your task is to complete a program that will do the following: • Ask a student for their name • Ask them for their status – keep the status simple in order to ensure that you do not have to handle a wide variety of inputs. For...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT