Question: Hello, Please include Excel functions so that I can better understand. The owners' equity accounts for Vulcano International are shown below. a. If the company's
Hello, Please include Excel functions so that I can better understand.

The owners' equity accounts for Vulcano International are shown below. a. If the company's stock currently sells for $42 per share and a 10 percent stock dividend is declared, how many new shares will be distributed? Show how the equity accounts would change. b. If the company declared a 25 percent stock dividend, how would the accounts change? Input Area: \begin{tabular}{|lr|} \hline Common stock & $20,000 \\ Par value & 50.50 \\ Capital surplus & $210,000 \\ Retained earnings & $587,300 \\ Total owners' equity & $817,300 \\ Stock price & $42 \\ Stock dividend & 10% \\ Stock dividend & 25% \\ \hline \end{tabular} (Use cells A6 to B13 from the given information to complete this question.) Output Area: New shares outstanding New shares issued Capital surplus on new shares Common stock Capital surplus Retained earnings Total owners' equity New shares outstanding New shares issued Capital surplus on new shares Common stock Capital surplus Retained earnings total owners' equity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
