Reference no: EM133116957
Guidelines for the Security Analysis Project
Your report, graphs, tables, and calculations must be processed on MS Excel. You should have a cover page including your group name, names of group members, stock symbol, and firm name, etc. Your report should start with an executive summary. Please only submit one file each group.
I. Fundamental ratio analysis and industry analysis
1. Each group will be assigned a stock.
2. Study the industry of the stock you are assigned. Which industry is your firm engaged (provide the different business lines of your firm)?
3. Summarize and compare the key statistics for the stock and the industry (choose at least 5 items you believe informative, such as P/E ratio, market cap, dividend yield, ROE, sales etc.)
II. Valuation analysis
Valuate the stock using dividend discount model and multi period dividend discount model
4. Collect data for stock price, market price (S&P 500 Index), risk free rate (using 3-month T-bill rate or 10-year T-note rate). Hint: Collect adjusted stock price (Pi) and the S&P 500 Composite Index Price (Pm) from Yahoo Finance (use data more than 10 years), collect three-month T-bill rate (Rf=TB3MS) from Economic data-FRED ® @ https://research.stlouisfed.org/fred2/categories/116 (TB3MS is an annualized time series) or 10 year T-note rate. Construct stock returns and market returns using stock price and market price.
5. Run the regression of stock return on market return in Excel (Hint: click on Tools in the menu bar, choose Data Analysis and then double lick regression. If it does not show Data Analysis in the drop-down list, click Add-ins on the drop-down list. When the Add-Ins dialog box pops up, click the box in front of Analysis ToolPak, and then click the OK button. The Data Analysis add-in will be installed. Report your results: interpret the coefficients, t-statistics and R2.
6. Estimate the expected return if the stock using CAPM (Please provide details on your estimation. You need to estimate risk free rate and market risk premium. A reasonable risk free rate should be between 2%-4% and reasonable risk premium should be between 4%-10%). Provide analysis showing how to understand the expected return.
7. Estimate the growth rate for the firm using historical dividend information or roe and dividend payout ratio (Provide details on your calculation. Common practice is to estimate industry growth; for multi period DDM, you have to estimate the short run growth for the future five years and the long run growth from year 6 to infinity).
8. Valuate your stock using constant dividend growth model (provide details on your calculation) and multi period dividend discount model.
9. Provide sensitivity analysis showing how stock value varying with different discount rates and growth rates.
10. Comparing your estimation with the stock price in March 31, 2019, show whether the stock is undervalued or overvalued. Determine your trading strategy based on your estimation. Stock is NG ENERGY
|
Compute the equivalent units for materials costs
: Started in August 119,400. Compute the equivalent units for materials costs and for conversion costs using the weighted-average method
|
|
Find the value of the stock of whizz corp
: Whizz Corp. has recently paid a dividend of $3 per share. You expect that the dividend will be $4 next year (t=1), increase 20% the following year (t=2), then g
|
|
Yearly perpetual constant cash flow from the account
: Starting from today you will deposit $5000 every year in an account for a total of 5 deposits. At the same time that you make the last deposit, you will begin r
|
|
Closing balances of cash for month
: A cash budget for the period 1St January to 31St December 20x5 on a month- by-month basis. This should show the total cash in and/out for the year as a whole fo
|
|
Guidelines for the security analysis project
: Your report, graphs, tables, and calculations must be processed on MS Excel. You should have a cover page including your group name, names of group members, sto
|
|
Prepare the table below showing the yearly depreciation
: Jefferson Consulting has a December 31 year end. Prepare the table below showing the yearly depreciation, accumulated depreciation
|
|
How much is left for you after all taxes are? paid
: You are a shareholder in a C corporation. The corporation earns $2.43 per share before taxes. Once it has paid? taxes, it will distribute the rest of its earnin
|
|
Mathematical formulation of the non-arbitrage theorem
: Provide the mathematical formulation of the non-arbitrage theorem in the case of 3 assets and 2 states of nature.
|
|
Explain the key principles of stock valuation
: Critically evaluate and discuss this statement. Explain the key principles of stock valuation. In your answer, refer to theory and provide evidence where suitab
|