To complete this assignment, you will set up a spreadsheet according to the Principles of Spreadsheet Design, and then enter the necessary information along with your answers Tab 1 of the M8 Submission Template. Once you have completed Tab 1, you will copy it to Tab 2 then you will click on Formulas, then on Show Formulas. Remember that you are graded on the assignment as well as your accuracy in using the Principles of Spreadsheet Design. 1. A company has $10 million in profit. If it pays $6 million of that in dividends, what is the dividend payout ratio? 2. What is the retention ratio? 3. A company is doing a 2-1 stock split. You own 1,575 shares. How many shares will you own after the split? 4. A company is doing a 10% stock dividend. You own 1,575 shares. How many shares will you own after youve received the stock dividend? 5. Coca-Cola has increased its dividends for 25 years. What would we call this type of stock? 6. A company has a steady dividend rate of 9%. If its net income is $30,000,000, what is the dollar amount of its dividends?

Please build your own Templet in excel and show the formula and calculation for each question