Finance Stock Analysis- 688695

Finance

Stock Analysis
Overview of the stock analysis section.  2 – 3 paragraphs.  Each of the sections Pricing, Performance, and Value Forecast may include charts created by you (not image copied from website).  Use the references – Figure label and include a Table of Figures.  Each section should include discussion on (a) company results, (b) Industry or competitor results (may choose one main competitor), and (c) Market results (gurufocus has market results).  This section uses Case Data Collection Worksheet – 3.
Pricing
1 – 2 paragraphs for each of the following:
Price – describe method of growth
1.         Max / Min closing for each year
2.         Average closing for each year

Describe – No charts or graphs***

You may include a bar graph of average price if it assists in the exp.
Earnings Per Share – discussion of row 14 including average, growth, competitor and market (market growth over 5 years -0.7% – gurufocus.com) Discuss row 15 (excel)
***Dividends Per Share – no dividends (growth in EPS indicates no dividends because of reinvesting) (decline in EPS indicates no dividends because no profit)
Book Value Per Share – row 17
**Rows from Valuation Worksheet completed in class

Stock Performance
1 – 2 paragraphs for each of the following:
Price Earnings Ratio – row 18
***Dividend Yield – row 21
Payout Ratio
Return on Equity – row 25
Financial Leverage ratios can be obtained at: Morningstar.com
The stock performance trend for XYZ illustrated in a 5-Year pattern in Figure 1.

The stock performance trend

Figure 1 – XYZ 5-Year Stock Performance (gurufocus.com,2017)
Compare and contrast with the NASDAQ performance.  “When compared with the NASDAQ performance over the same period of time a (similar/different/contrasting,etc) trend can be seen in Figure 2 – NASDAQ 5-Year Performance.  You can have up tp 3 charts but no fewer than one chart.

Must Include:

Company

Company and Competitor

Company and Market (Nasdaq)

Each chart must be accompanied by a description of 1-2 paragraphs which includes the key highlights from columns JK&L (EXCEL)

highlights from columns JK&L

Figure 2-NASDAQ 5 Year Performance (marketwatch.com, 2017)
Valuation Forecast
Complete and discuss a value forecast based on earnings and based on dividends. (3 paragraphs – covering each of the following bullets)
•           Price forecast for next year (Market Value).  High and low forecast.  % Change from 2016 (or last year / quarter)
(Forecast – 2016) / 2016 = % change next year
•           Book value forecast for next year – calculate using row 16
Shareholder equity / number shares outstanding
5 year average growth rate * 2016 Book Value Per Share
Last year growth rate = (2016-2015)/2015 * 2016 Book Value Per Share
•           Likelihood of consistency in forecasts based on trends (likely consistent or likely overvalued/undervalued)
Stock Analysis Summary
2 – 3 paragraphs summarizing the above findings and transitioning paper to next section.