To complete this assignment, you will use the M$8$ Submission Template to set up a spreadsheet according to the Principles of Spreadsheet Design, and then enter the necessary information along with your answers in Tab $1.$ 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.$ Ralph Lauren$$s net income last year was $$522\mathrm{.}7$ million. It has $40\mathrm{.}7$ million shares outstanding, and recently paid a $$3\mathrm{.}00$ per share dividend. What is RL$$s dividend payout ratio?

$2.$ What is RL$$s retention ratio?

$3.$ Walmart did a $3-1$ stock split on January $30,2024.$ If you owned $1,459$ shares before the stock split, how many did 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 you$$ve 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 payout ratio of $9\%.$ If its net income is $$30,000,000,$ what is the dollar amount of its dividends?