You will use these scenarios and tables to complete the final project.
Ezra, age 26, is single. However, he is dating and preparing to get engaged. He will need roughly $5,000 for an engagement ring almost immediately, and expects he will need $10,000–$15,000 for the wedding in the next 12–24 months. He is currently employed and earns about $70,000 a year in salary. This salary is enough to cover all his taxes and normal living expenses of approximately $4,800. This leaves him with about $1,000 in savings each month ($350 to 401K, $650 to savings). He has been able to save roughly $15,000 to date in a 401K plan from work and about $20,000 in cash savings. His 401K plan has been invested 100% in the stock market, including some sector-specific funds. His other savings have been in interest-bearing savings and cash substitutes such as money market funds. He recently received a windfall of $60,000, and this prompted him to come to you for some advice. The following are few of Ezra’s comments to help guide your thoughts:
Jacob and Rachel, 53 and 52 respectively, are married with four children. Two of the children are currently in college, and two are in high school. They expect the other two children to attend college. The couple has done relatively well for themselves and earn roughly $275,000 before tax between the two of them, which equates to $190,000 after taxes. They live well below their means, and this should allow them to cover all of their children’s college expenses out of pocket, but it will not leave much for them to save over the next six to eight years. Through savings and portfolio growth, they have managed to accumulate $900,000. To this point, they have been moderately aggressive (70–75% equities) with their portfolio, but they feel that they need to begin preparing the portfolio for partial retirement in eight years, and full retirement in 13 years.
Market Return 9%
Risk-free Rate 0.75%
Stock Analysis Table:
|Symbol||Estimated Beta||Dividends||Earnings||Sales||Free Cash Flow||5-Year Dividend Growth||Average Industry P/E Ratio||Average Industry P/S Ratio||Free Cash Flow Growth|
|IBM||0.86||Use Last Year||Use Last Year||Use Last Year||Use Last Year||13.7||23.7||1.12||2.60%|
|KO||0.66||Use Last Year||Use Last Year||Use Last Year||Use Last Year||8.3||22.6||2.2||6.50%|
|BMY||0.78||Use Last Year||Use Last Year||Use Last Year||Use Last Year||2.9||24.4||3.37||N/A|
|ORCL||1.1||Use Last Year||Use Last Year||Use Last Year||Use Last Year||21.1||20.5||4.45||10%|
|MMM||0.98||Use Last Year||Use Last Year||Use Last Year||Use Last Year||15.1||23.8||2.59||7%|
|BAX||0.75||Use Last Year||Use Last Year||Use Last Year||Use Last Year||-16.9||36.09||3.68||N/A|
|BIG||1.04||None||Use Last Year||Use Last Year||Use Last Year||N/A||23||1.12||N/A|
|NFLX||1.57||None||Use Last Year||Use Last Year||Use Last Year||N/A||52.5||6||N/A|
|AKAM||1.34||None||Use Last Year||Use Last Year||Use Last Year||N/A||41.8||3.58||17%|
|GE||1.12||Use Last Year||Use Last Year||Use Last Year||Use Last Year||9.7||23.8||2.59||N/A|
Available Assets Table: Stocks listed in Analysis Table and these additional assets
|Symbol||Estimated Beta||Standard Deviation|
Ex-post Return Statistics:
|Symbol||Holding Period Return||Standard Deviation||Benchmarks||Holding PeriodReturn||Standard Deviation|
Hi there! Click one of our representatives below and we will get back to you as soon as possible.