In: Accounting
Your clients, Jerry and Jenny, are 25 years old. They have come to you for assistance with planning for the cost their child’s education and their retirement. They would like to know if they are on track to reach these two goals. Below are the facts about the family. • Jenny currently earns $150,000 and they expect to need $150,000 per year in today’s dollars in retirement. Jerry is a stay-at-home dad. • Jenny plans to retire at age 67, and they expect to live until age 100. • They also expect that Social Security will provide $40,000 of benefits in today’s dollars at age 67. • Jenny has been saving $5,000 annually in her 401(k) plan. • Their son, Jazz, was just born and is expected to go to college in 18 years. • They want to save for Jazz’s college education, which they expect will cost $20,000 in today’s dollars per year and they are willing to fund 5 years of college. They want all funds needed for Jazz’s college education available the first year Jazz starts college. • They were told that college costs are increasing at 7% per year, while general inflation is 3%. • They currently have $100,000 saved in total and they are averaging a 10% rate of return and expect to continue to earn the same return over time. 1. Calculate the current cost of Jazz’s college education. 2. Calculate the capital needs of the couple at retirement and the current value (today’s value) of their retirement needs. 3. Provide the couple with a summary of their goals with the current total amount needed to reach their goals, showing how you arrived at the total. 4. Given their current resources, does the couple have sufficient resources to achieve their goals? Using calculations, show and explain your answer to the couple. 5. Using calculations and explanations provide the couple with three alternatives for meeting their goals. 6. In your own words, provide the couple with the advantages and disadvantages of two accounts and/or investment instruments that are used specifically to save for college education expenses. Which would you recommend and why? Your completed Case Study must contain a minimum of 500 words and 2 citations in current APA format. Acceptable sources are personal finance journals, magazines, or newspapers.
i)
college fees per year-$20,000( given)
fees increseing rate per year -7%(given)
college fees per year (amt in$)
year 1-20,000
year 2-20,000*107%=21,400
year 3-21400*107%=22898
year4-22898*107%=24500
year 5-24500*107%=$262152
current cost of jazz education (5 years)=$20,000+$21400+$22898+$24500+$26215=$115013
inflation rate=3% given
so per year current cost of jazz(annualy now)=$115013/(1.03)^5
=$115013/4.579
=$25117 per year (today)
ii)jenny )age now=25 years (given)
retirement age-=67 years(given)
life expectancy=100 years(given)
amt needed at retirement=$150,00 annualy
social security benifet=$40,000 annualy
return on investment=$100000*10%=10,000 annualy
so amt required would be= $1,50,000-$40,000-$10,000=$1,00,000 annualy
so,$1,00,000*(100-67)=$33,00,000(total) however,jenny is saving$ 5000 annualy.
so amt saved at the time of retirement would be=$5000*(67-25)
=$2,10,000
so amt(total in $)=33,00,000-2,10,000=$30,90,000
amt req. (annualy)=30,90,000/33=$93,636
iii)
couple wants $1,50,00(today's value) annualy after retirement,
however considerng the social srcurity benefit and their ROI on investment they additiponaly need to save some money to arrive at their goal of fetching $1,50,00 after retirement. as per solutin ii) they are short of money $93,636 if they want to reach their goal they need to save additionaly or look for some other sources of avenue.
iv)no, as per part ii),we can very well make out that the couple does not have sufficent funds for meeting their goals.