comprehensive stock valuation project
Question Description
The finance internship course is composed of a stock valuation project for international students that do nothave permission to work in the U.S. The main outcome of the project is an Internship Report. The grade forthe course depends on the quality of the report in terms of accuracy, analyses, completeness, organization,writing, and relevance. Based on your analyses, you are expected to answer each of the project relatedquestions and address each of the issues mentioned in the following.Pick a publicly-owned, dividend-paying firm from the Dow Jones Industrial Average (DJIA) stock market index.The chosen firm must be both publicly-traded dividend-paying. Use the financial data for the firm andindustry using Bloomberg terminals in the Capital Market Lab. Use appropriate dividend discount/growth modelto find the intrinsic value of the stock. Review the assumptions of the model. In calculating the growth rate forthe firm, use sustainable growth rate method. For estimating the required return, use the capital asset pricingmodel (CAPM). As an estimate of the risk free rate, use the current yield to maturity of a 10 year T-bill.Estimate firm beta using the simple market model in excel. You may use one of the two ways to calculate Betausing Excel. The first is to use the “=slope” formula: the X variable series is the return on the market and the Yvariable series is the return on your chosen stock. A second alternative is to calculate the Beta directly as thecovariance between the two return series, divided by the variance of market returns. Find the actual stock priceon December 31, 2018 using Bloomberg terminals. Compare your estimated intrinsic stock value to the actualDecember 31, 2018 stock price. Does the market undervalue or overvalue the stock? Based on the aboveanalysis, do you plan to undertake any transaction (buy/sell) in the stock? Why or why not?
Instructions:
Consistent with the university academic integrity policy, your submission MUST be your original work.
There is no page limit for the Internship Report. The length of the report depends on the work needed incompleting each of the components of the project.
In the report, besides valuing the firm’s stock, include an overview of the firm and its financial position incomparing with the major competitors in the industry.
Show your work/calculations when possible.
The financial statements along with other required financial data are available on Bloomberg.Sample Internship Project Report Contents:Cover PageReport ObjectiveFirm OverviewIndustry AnalysisDividend Discount Method Dividend Growth Model Security Market Line Beta Selection Stock Valuation based on Dividend Growth/Discount ModelTrading RecommendationsConclusionReferencesAppendix
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."