Please breakdown in Excel format and Formulas

Alternative dividend policies Over the last 10 years, a firm has had the earnings per share shown in the following table P14-7 4 Earnings per share Year Earnings per share 2010 2009 2008 2007 2006 Year 2015 2014 2013 2012 2011 $4.00 3.80 3.20 2.80 3.20 $2.40 1.20 1.80 0.50 0.25 a. If the firm's dividend policy were based on a constant payout ratio of 40% for b. If the firm had a dividend payout of $1.00 per share, increasing by S0.10 per c. If the firm's policy were to pay $0.50 per share each period except when earnings d. Discuss the pros and cons of each dividend policy described in parts a through c. all years with positive earnings and 0% otherwise, what would be the annual dividend for each year? share whenever the dividend payout fell below 50% for two consecutive years, what annual dividend would the firm pay each year? per share exceed $3.00, when an extra dividend equal to 80% of earnings be- yond $3.00 would be paid, what annual dividend would the firm pay each year