Question: Please show calculations on Excel. Year Dividend per share Total dividends Number of share repurchases Payments from share repurchases Total payments to shareholders 2010 0.25
Please show calculations on Excel.
| Year | Dividend per share | Total dividends | Number of share repurchases | Payments from share repurchases | Total payments to shareholders |
| 2010 | 0.25 | $1,000,000.00 | 0 | $0.00 | $1,000,000.00 |
| 2011 | 0.3 | $1,155,000.00 | 150,000 | $180,000.00 | $1,335,000.00 |
| 2012 | 0.31 | $1,193,500.00 | 0 | $0.00 | $1,193,500.00 |
| 2013 | 0.35 | $1,295,000.00 | 150,000 | $210,000.00 | $1,505,000.00 |
| 2014 | 0.38 | $1,406,000.00 | 0 | $0.00 | $1,406,000.00 |
| 2015 | 0.4 | $1,400,000.00 | 200,000 | $360,000.00 | $1,760,000.00 |
| Share price, end of 2015 | 1.80 |
|
|
|
|
| Number of shares | 3,500,000 |
|
|
|
|
| Company's Market Value | $6,300,000 |
|
|
|
|
| Dividend compound growth rate |
|
|
|
|
|
| Cost of equity, rE |
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
