Ask Question, Ask an Expert


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

Project finance is difficult to define what are its

Project finance is difficult to define. What are its essential features? When deciding whether or not to back a project finance proposition, what essential features do potential lenders home in on?

Grind co is considering replacing an existing machine the

Grind Co. is considering replacing an existing machine. The new machine is expected to reduce labor costs by $153,000 per year for 5 years. Depreciation on the new machine is $124,000 compared with $86,000 on the old mac ...

1 what advantage does drp have over a fair share method of

1. What advantage does DRP have over a fair share method of inventory deployment? 2. Discuss the importance of collaboration in the developing of supply chain inventory strategies. Provide an example. 3. Customer-based i ...

As part of the financial planning process a common practice

As part of the financial planning process, a common practice in the corporate finance world is restructuring through the process of mergers and acquisitions (M&A). It seems that on a regular basis, investment bankers arr ...

Problems -1 triangular arbitragesuppose you observe the

Problems - 1. Triangular Arbitrage Suppose you observe the following posted exchange rates on the Japanese yen (¥) and South African ran (R) against the US dollar: JPY - ¥97.3702/$ ZAR - R10.1453/$ The posted cross rate ...

Discussion questionliabilities please respond to the

Discussion Question "Liabilities" Please respond to the following: • Let's use this discussion to study bonds together. Assume the following information for a bond issue: ABC Company issues the bonds at a face value of $ ...

Craigs manufacturing company is considering the purchase of

Craig's Manufacturing Company is considering the purchase of a new machine for a cost of$250,000. The new machine will have a 5-year useful life and will be depreciated to anexpected salvage value of zero using the strai ...

Explain the difference between path-dependent options and

Explain the difference between path-dependent options and path-independent options and give examples of each ? Give an example of a situation in which someone might wish to use a barrier option ? Explain the advantages a ...

Assignment - financial research report amanda todds

Assignment - Financial Research Report Amanda Todd's Story Watch the video titled "Amanda Todd's Story: Struggling, Bullying, Suicidal, Self-harm" (8 min 55 s). Video Source: ChisVideos. (2012, October 11). Amanda Todd's ...

1 how are the results of factorial experimental designs

1. How are the results of factorial experimental designs reported in the research report? 2. What is the purpose of means comparisons, and what different types of means comparisons are there? What do they tell the resear ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen