In: Finance
ART I: STOCK VALUATION |
||||||||
Dividend from Financial Statements: |
||||||||
Read the Explanations to the right of the calculation cells for specific information on the data. |
||||||||
Year | Cash Div/share ($) | Dividend Yield | Stockholder's Equity (in millions) | Stock Price | ||||
2015 | 2.92 | 3.00% | 2,491 | 97.33333333 | ||||
2016 | 3.12 | 2.70% | 429 | 115.5555556 | ||||
2017 | 3.32 | 2.60% | 1,030 | 127.6923077 | ||||
1. Stock Valuation - The new dividend yield if the company increased its dividend per share by 1.75 |
||||||||
Year | Cash Div/Share ($) +1.75 | Dividend Yield | Stockholder's Equity (in millions) | Stock Price | ||||
2015 | 4.67 | 4.80% | 2,491 | 97.33333333 | ||||
2016 | 4.87 | 4.21% | 429 | 115.5555556 | ||||
2017 | 5.07 | 3.97% | 1,030 | 127.6923077 | ||||
2. The dividend yield if the firm doubled it's outstanding shares |
||||||||
Year | Cash Div/Share ($) | Dividend Yield | Stockholder's Equity (in millions) -doubled | Stock Price | ||||
2015 | 1.46 | 1.50% | 4,982 | 97.33333333 | ||||
2016 | 1.56 | 1.35% | 858 | 115.5555556 | ||||
2017 | 1.66 | 1.30% | 2,060 | 127.6923077 | ||||
3. The rate of return on equity (i.e., the cost of stock) based on the new dividend yield you calculated above |
||||||||
Year | Cash Div/Share ($) +1.75 | Stock Price | Return on Investment | |||||
2015 | 4.67 | 97.33333333 | CALCULATE ROI | |||||
2016 | 4.87 | 115.5555556 |
(Dividends + Capital gain)/ Divided by the original Price |
|||||
2017 | 5.07 | 127.6923077 | (D1 + (P1-P0)) / PO |
Return on equity
2015 | 4.80% | 4.67*100/97.33333333 |
2016 | 23.72% | 4.87+(115.5555556-97.33333333)/97.33333333 |
2017 | 36.40% | 5.07+(127.6923077-97.33333333)/97.33333333 |
The Return on equity for the three consecutive years is as 2015- 4.8% , 2016 -23.72% & 2017 -36.40%
ROE 0 Net Income / Shareholders equity