Online Activity: Alternative Dividen 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 comings $ 2. It continues the 2015 dividend payout ratio $ 3. It was a pure residual policy with all distributions in the form of dividends (35% of the $7.4 millon 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? $ . Which of the preceding policies would you recommend? Restrict your choices to the ones listed. Online Activity: Alternative Dividen 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 comings $ 2. It continues the 2015 dividend payout ratio $ 3. It was a pure residual policy with all distributions in the form of dividends (35% of the $7.4 millon 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? $ . Which of the preceding policies would you recommend? Restrict your choices to the ones listed