Question: Please provide feedback with an excel attachment. The companys payout ratio has been 56% over the last nine years and the last quoted price of
Please provide feedback with an excel attachment.
The companys payout ratio has been 56% over the last nine years and the last quoted price of the firms share of stock was $17. Flotation costs for new equity will be 8%. The company has 34,000,000 of common shares of stock outstanding and a debt-equity ratio of 0.4.
If dividends are expected to grow at the same arithmetic average growth rate of the last nine years, what is the dividend payment per share in 2016?
_________________________________________________________________________-
Use the following data for the next 3 questions
The following are the company sales from 2000-2015
| Year | Xylophone |
| 2000 | $230 |
| 2001 | $573 |
| 2002 | $994 |
| 2003 | $1,683 |
| 2004 | $3,192 |
| 2005 | $6,140 |
| 2006 | $8,892 |
| 2007 | $13,586 |
| 2008 | $18,376 |
| 2009 | $29,476 |
| 2010 | $33,598 |
| 2011 | $44,208 |
| 2012 | $58,473 |
| 2013 | $96,368 |
| 2014 | $149,306 |
| 2015 | $204,397 |
- Fit an exponential trend curve to the data- show the equation
- Calculate the projected sales in 2016
- What is the CAGR over the 2000-2015 period?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts