Hello,

Can you please show me how to set this up to solve in excel with formulas? Thank you.

P149 Stock dividend: Firm Columbia Paper has the following stockholders' equity account. The firm's conunon stock has a current market price of $30 per share. Preferred stock $100,000 Common stock {10,000 shares at $2 par) $20,000 Paidin capital in excess of par $230,000 Retained earnings $100,000 Total stockholders1 equity $500,000 Show the effects on Cofumbia of a 5 % stock dividend. b. Show the effects of (1) a 10% and {2} a 20% stock dividend. c. In light of your answers to parts a and I}, discuss the effects of stock dividends on stockholders' equity. P