This assignment should be completed in the same groups as the ETF assignment. Although this is a collaborative group assignment, each group member must fully participate and be responsible for the solution to the entire assignment. Each group should submit only one solution to the assignment.
A hardcopy version of your assignment is due at the beginning of class on the due date. In your hardcopy submission, please be sure to provide clear answers to all questions and attach all relevant printouts from your excel worksheets and Bloomberg.
All supporting excel worksheets must be placed in one excel file and emailed to me before class on the due date. “BFIN 4227 _Team Last Names_EVA” should be used as the excel file name and the email subject.
No late assignment will be accepted.
Part I: 25 Points; Part II: 40 points, Part III: 35 points; à Total: 100 Points. Early submissions will be rewarded with additional 5 extra points.
This assignment accounts for 15% of the course grade.
Part I. Constant Growth Dividend Discount Model (25 points)
You expect Bright Path Corporation to have a ROE of 13%, a beta of 1.2, an expected earnings per share (E1) of $3.19, and a stable retention ratio (b) of 60%. The expected market return for future years is 11%, and long-term risk free assets (10-year Treasury notes) are yielding 2.8%.
Calculate your intrinsic value estimate of Bright Path stock (V0) according to the constant growth DDM.
Calculate the Present Value of Growth Opportunities (PVGO).
Calculate the justifiable forward P/E and trailing P/E according to the constant growth DDM.
If the expected ROE for Bright Path Corporation has been revised down to 11% from 13%, recalculate the V0, PVGO, and the justifiable forward P/E and trailing P/E. Discuss whether these changes in V0, PVGO, and the justifiable forward P/E and trailing P/E are consistent with the concepts that we learned from class.
Part II. Multiple-Stage FCFE Model (40 points)
Kevin Smith is preparing a valuation of Logistic Solutions, Inc. Kevin has decided to use a multiple-stage FCFE valuation model and the following estimates. The FCFE per share for the current year is $1.76. The FCFE is expected to grow at 16 percent for the next two years, then at 10 percent annually for the following five years, and finally at a constant growth rate of 6 percent starting year 8. Logistic Solutions’ estimated beta is 1.28, and Kevin believes that the current market conditions dictate a 2.8 percent risk free rate of return and a 7.0 percent market risk premium.
The following are five independent questions.
Given Kevin’s assumptions and approach, estimate the value of a share of Logistic Solutions.
If the terminal growth rate is projected to be 7%, rather than 6%, re-estimate the value of a share of Logistic Solutions. Does this new estimate make sense?
If the market risk premium is assumed to be 6%, rather than 7%, re-estimate the value of a share of Logistic Solutions. Does this new estimate make sense?
If the systematic risk (beta) of the stock increases substantially from 1.28 to 1.52, re-estimate the value of a share of Logistic Solutions. Does this new estimate make sense?
If Logistic Solutions’ estimated beta is statistically insignificant, suggest an alternative approach to arrive at the required rate of return (k) on the stock and use this new k to re-estimate the value of a share of Logistic Solutions. Assume Logistic Solutions’ bonds outstanding are traded at a yield of 5.7% and the risk premium required for Logistic Solutions’ equity shareholders over bond holders is 4.5%.
Part III. Equity Valuation Analysis using Bloomberg (35 points):
Provide a relative valuation analysis for Apple Inc. (Ticker: AAPL).
Use the RV (relative valuation) function in Bloomberg equity analysis to compile a peer group of 6 to 12 stocks in the same industry.
Compile a relative valuation table that includes the following statistics for AAPL and its peers:
Five price multiples: P/E, P/B, P/S, P/CF, EV/EBIDTA
Four Fundamental factors: Five-year EPS growth, Return on Equity (ROE), Beta, Net Profit Margin (PM)
Other Information: Closing Price, Market Cap, Sales Revenue, EPS, Debt to Equity Ratio, Dividend Payout Ratio
Compare the P/E, P/B and P/S of AAPL against the average P/E, P/B and P/S of the peer group. Discuss whether this is justified by the fundamental factors.
State your recommendation (Buy, Sell, Hold) on AAPL based on the relative valuation analysis above.
Identify two major limitations of the above analysis. Suggest what and how additional information could help you make a better decision on this relative valuation case.
Think about Discounted Cash Flow (DCF) analysis on AAPL.
Which DCF model (DDM, FCFE or FCFF) would you use? Justify your choice using historical data on the dividend payout ratio and debt to equity ratio of AAPL over the last five-year period.
Assuming the DCF model choice from f), determine the discount rate that you will use to discount AAPL’s future cash flows. Using resources from Bloomberg, explain in details how you have arrived at this discount rate estimate.
Solution: The Journal of Helene Berr and Rue Ordener, Rue Labat 2 evidences that prove the difficulty and destructiveness that the people had to face in those four years. As mentioned by Berr (2009, p.23), in h ...
Solution: Employee communication highlights the sharing of ideas and information. In this competitive business world, information exchange is essential among employees to develop team performance effectively.
Solution: As per Section 1 of the Thirteenth year plan describes about China’s two key objectives that will be accomplished if the National People’s Congress or the standing committee of this party passes t ...
Solution: (Feldman 2005) reference information extraction to be one of the weightiest pre-processing method that escalates the text mining potential significantly.
Pre-processing is an essential part in informa ...
Solution: The law relating to public interest as a concept first emerged in the US in early 20th century. Since then the concept has been expanded to different parts of the world. Thus, it can be safely said th ...
Solution: The pro forma income statement represents a trending statement that includes the probable net income value for the company considering the current growth and decline rates valid throughout the period ...
Solution: Mode is defined as the value which occurs more frequently in the data set. The mode for non-business is 82 while for business is only 59.
P value can be calculated from z table . As per z table p valu ...
Solution: ABC assumes that there are different activities involved in different processes that cause costs andthe product, services, and customers are reasons for those activities.
The UK customer segment is br ...
Solution: Residual earnings valuation method is used to calculate the intrinsic value of the stock based on the expected residual income of the company in the coming years. The residual income is discounted bac ...
Solution: The term “intangible asset” is related to the valuation of a business. Literarily the word “intangible” denotes that, which has no physical form. A business is formed of mixed assets, basicall ...