Ask Basic Finance Expert

Need help with the following. Can you please show me how to answer the problems at the end of this reading for future value and present value. Problem: Critical Thinking Problem - College Cost Case Study

'Greg and Debra Quilici own a four bedroom home in an affluent neighborhood just north of San Francisco, California. Greg is a partner in the family owned commercial painting business. Debra now stays home with their child, Brady, who is age 5. Until recently, the Quilicis have felt very comfortable with their financial position. After visiting Lawrence Krause, a family financial planner, the couple became concerned that they were spending too much and not putting enough funds aside for both their child's future education needs and their own retirement. Greg earns $85,000 per year, but with the rising costs of education, their past contribution efforts have left them short of their financial goals. To estimate the amount of money the Quilicis need to begin putting away for future security some general information was obtained by their financial planner. The couple felt that the amount of money they currently contribute to their Koegh plan would be sufficient for their retirement needs. What they had not accounted for was Brady's education. Greg is an alumni of Stanford University, a private school with an extremely high tuition of approximately $20,000 per year. Debra graduated from the University of North Carolina at Chapel Hill. The tuition expense there is only $2,500 per year. When Brady turns 18, the couple wishes to send him to either of these exceptional universities. They have a slight preference for the much more local Stanford University. The problem, however, is that with the rate at which tuition is increasing the Quilicis are not sure they can raise enough money. To assist in the calculations, assume the tuition at both universities will increase at an annual rate of 5%. Living expenses are currently estimated at $6,000 per year at both schools. This expense is expected to grow at only 3% per year. Further assume the Quilicis can deposit their money into a growth oriented mutual fund at Neuberger & Berman Management, Inc., which has historically earned a 12% return per annum (1% per month). The couple wishes to have a pre-determined monthly amount automatically drafted from their checking account. When Brady starts college they will slowly liquidate the account by making an annual payment to Brady to cover tuition and living expenses at the beginning of each year for the four years he will be in college.'

I need help answering problems:
1. How much will tuition and living expenses be per year when Brady is ready to attend? Give an answer for each university.
2. Once Brady starts college what will his total expenses be in each of his four years? Again, give an answer for each university.
3. How much money will Greg and Debra have to deposit per month to allow Brady to attend Stanford University? How much money will have to be deposited per month to allow Brady to attend the University of North Carolina? (HINT: To answer this problem you need to consider the costs of ALL four years.)
4. What if the Quilicis feel the Neuberger & Berman mutual fund will only yield 10%. How much will have to be deposited per month in order for Brady to attend each college?
5. What is the relationship between the amount that must be deposited monthly by the parents and and the future increases in both tuition and living expenses?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M924329

Have any Question?


Related Questions in Basic Finance

Question utilizing the concepts learned throughout the

Question: Utilizing the concepts learned throughout the course, write a Final Paper on one of the following scenarios: • Option One: You are a consultant with 10 years experience in the health care insurance industry. A ...

Discussion your initial discussion thread is due on day 3

Discussion: Your initial discussion thread is due on Day 3 (Thursday) and you have until Day 7 (Monday) to respond to your classmates. Your grade will reflect both the quality of your initial post and the depth of your r ...

Question financial ratios analysis and comparison

Question: Financial Ratios Analysis and Comparison Paper Prior to completing this assignment, review Chapter 10 and 12 in your course text. You are a mid-level manager in a health care organization and you have been aske ...

Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs $300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

You are planning to make annual deposits of 4440 into a

You are planning to make annual deposits of $4,440 into a retirement account that pays 9 percent interest compounded monthly. How large will your account balance be in 32 years?  (Do not round intermediate calculations a ...

One year ago you bought a put option on 125000 euros with

One year ago, you bought a put option on 125,000 euros with an expiration date of one year. You paid a premium on the put option of $.05 per unit. The exercise price was $1.36. Assume that one year ago, the spot rate of ...

Common stock versus warrant investment tom baldwin can

Common stock versus warrant investment Tom Baldwin can invest $6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for $30 per share. Its warrants, which provide f ...

Call optionnbspcarol krebs is considering buying 100 shares

Call option  Carol Krebs is considering buying 100 shares of Sooner Products, Inc., at $62 per share. Because she has read that the firm will probably soon receive certain large orders from abroad, she expects the price ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As