Excel Online Structured Activity: Dividend Policy Boehm Corporation has had stable earnings growth of 6% a year for the past 10 years, and in 2015 Boehm paid dividends of $2.8 million on net income of $12.0 million. Hower, in 2016 earnings are expected to jump to $15.6 million, and Boehm plans to invest $9 million in a plant expansion. This one-time unusual earnings growth won't be maintained, though, and after 2016 Boehm will return to its previous 6% earnings growth rate. Its target debt ratio is 35%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Calculate Boehm's total dividends for 2016 under each of the following policies. Enter your answers in dollars. For example: $2.9 million should be entered as $2,900,000. Do not round intermediate calculations. Round your answers to the nearest dollar. 1. Its 2016 dividend payment is set to force dividends to grow at the long-run growth rate in earnings. 2. It continues the 2015 dividend payout ratio. 3. It uses a pure residual policy with all distributions in the form of dividends ( 35% of the $9 million investment is financed with debt). $ 4. It employs a regular-dividend-plus-extras policy, with the regular dividend being based on the long-run growth rate and the extra dividend being set according to the residual policy. How much will the extra dividend be? b. Which of the preceding policies would you recommend? Restrict your choices to the ones listed. fx Alternative Dividend Policies Alternative Dividend Policies \begin{tabular}{|l|r|} \hline 10-year earnings growth & 6.00% \\ \hline 2015 Dividends & $2,800,000 \\ \hline 2015 Net income & $12,000,000 \\ \hline Expected 2016 Net income & $15,600,000 \\ \hline Plant Expansion & $9,000,000 \\ \hline Future earnings growth, after 2016 & 6.00% \\ \hline Debt ratio & 35.00% \\ \hline \end{tabular} Calculation of 2016 total dividends under different policies: Formulas 2016 dividends if dividends grow at long-run earnings growth rate 2016 dividends if continue 2015 dividend payout ratio 2016 dividends if it uses pure residual policy 2016 dividends under regular-dividend-plus-extras policy: Regular dividends (based on long-run earnings growth rate) \#N/A Extra dividend (based on residual policy) \#N/A