Excel Online Structured ACIVILY! Boehm Corporation has had stable earnings growth of 8% a year for the past 10 years, and in 2015 Boehm paid dividends of $2.3 million on net income of $12.5 million. However, in 2016 earnings are expected to jump to $17.5 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 8% 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 Its 2016 dividend payment is set to force dividends to grow at the long-run growth rate in earnings. 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? $ VIDU Excel Online Structured Activity: Dividend Policy Boehm Corporation has had stable earnings growth of 8% a year for the past 10 years, and in 2015 Boehm paid dividends of $2.3 million on net income of $12.5 million. However, in 2016 earnings are expected to jump to $17.5 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 8% earnings growth rate. Its target debt ratio is 35%. The data has been collected in the Microsoft Excel caline file below. Open the spreadsheet and perform the required analysis to answer the questions below. X HHH Open spreadsheer 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, 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 4 A 9 2 3 10-year earnings growth 8.00% 4 2015 Dividends $2,300,000 5 2015 Net income $12,500,000 6 Expected 2016 Net income $17,500,000 Plant Expansion $9.000.000 8 Future earnings growth, after 2016 8.00% Debt ratio 35.00% 10 11 Calculation of 2016 total dividends under different policies: 12 2016 dividends if dividends grow at long-run earnings growth rate 13 2016 dividends if continue 2015 dividend payout ratio 14 2016 dividends if it uses pure residual policy 15 2016 dividends under regular dividend-plus-extras policy: 16 Regular dividends (based on long-run earnings growth rate) 17 Extra dividend (based on residual policy) Formulas #N/A #N/A #N/A #NIA #N/A