solve all parts and show work with cell references. problem 3

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. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. - Cell Reference: Allows you to refer to data from another cell in the worksheet. In the Excel Simulation below, if "=B7" is entered in a blank cell, the formula outputs the result from cell B7, which is 5,000 in this example. - Basic Math functions: Allows 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). In the Excel Simulation below, if "=B11+B12" is entered in a blank cell, the formula adds the values from those cells and outputs the result, which is $1,730,000 in this example, If using the other math symbols, the result is an appropriate answer for its function. At December 31. Artists Unlimited Company had the following Required: The company is considering 3 alternative distributions to stockholders. Consider each alternative independently of the others. Complete the table above and show the resulting balances on the stockholders' equity section as a result of these distributions. Use only cell references in formulas. Use cells C3, D3, and E3 as appropriate. Do not reference cells from one alternative in another alternative. 1) Issue a 100% stock dividend. OR 2) Execute a 2 -for-1 stock split. OR 3) Distribute a $5,000 cash dividend