File Home Insert Draw Formulas Data Review View Help A1 Calibri (Body) 11 B General A B C D E F H Artists Unlimited Company has provided the stockholders' equity section of the balance sheet as of December 31 . The Controller has asked you to calculate different distribution options to stockholders for management to consider. Required: The company is considering three alternative distributions to stockholders. Consider each alternative independently of the others. Complete the table and show the effect on stockholders' equity as a result of each of these distributions. Note: Use information in column B to complete columns C, D, and E. Here are some tips for using Excel: Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. 12 13 \begin{tabular}{|l|r|} \hline 1) Issue a 100% stock dividend. & 100% \\ \hline \end{tabular} 14 15 2) Execute a 2-for-1 stock split. 2 16 OR \begin{tabular}{l|r} \hline 3) Distribute a $5,000 cash dividend. & $5,000 \\ \hline \end{tabular} 18 19 \begin{tabular}{|l|c|c|c|c|} \hline Stockholders' Equity & At Dec 31 & \begin{tabular}{c} 100% Stock \\ Dividend \end{tabular} & \begin{tabular}{c} 2 for 1 Stock \\ Split \end{tabular} & \begin{tabular}{c} \$5,000 Cash \\ Dividend \end{tabular} \\ \hline Contributed Capital: & & \\ \hline Number of common shares outstanding & 5,000 & V & \\ \hline \end{tabular} File Home Insert Draw Formulas Data Review View Help A1 Calibri (Body) 11 B General A Here are some tips for using Excel: Cell Reference: Basic Math Functions: 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28 Earnings 29 Total Stockholders' Equity Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. \begin{tabular}{|l|r} \hline 1) Issue a 100% stock dividend. & 100% \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline 2) Execute a 2-for-1 stock split. & 2 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline 3) Distribute a $5,000 cash dividend. & $5,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Stockholders' Equity & At Dec 31 & \begin{tabular}{c} 100% Stock \\ Dividend \\ \end{tabular} & \begin{tabular}{c} 2 for 1 Stock \\ Split \end{tabular} & \begin{tabular}{c} $5,000 Cash \\ Dividend \end{tabular} \\ \hline \multicolumn{5}{|l|}{ Contributed Capital: } \\ \hline Number of common shares outstanding & 5,000 & & r & r \\ \hline Par value per common share & $1.00 & & r & r \\ \hline Common Stock, at par & $5,000 & & T & \\ \hline Additional Paid-in Capital & 745,000 & 7 & r & r \\ \hline Total Contributed Capital & 750,000 & & T & \\ \hline Retained Earnings & 980,000 & & r & r \\ \hline Total Stockholders' Equity & $1,730,000 & & 7 & \\ \hline \end{tabular} 30