Statement of Shareholders' Equity On January 1, 2019, Osgood Film Studios reported the following alphabetical list of shareholders' equity items: Additional paid-in capital on common stock Additional paid-in capital on preferred stock Common stock, $2 par Preferred stock, $100 par Retained earnings $196,775 13,600 92,600 68,000 196,000 During 2019, the company sold 2,500 shares of common stock for $13 per share and 420 shares of preferred stock for $129 per share. It also earned income of $100,000 and paid dividends of $9 per share on the preferred stock and $2.20 per share on the common stock outstanding at the end of 2019. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Required: Prepare Osgood's statement of shareholders' equity (include retained earnings) for 2019. Check My Work OSGOOD FILM STUDIOS Previous Next> A29 B fx C D 5 DATA 6 Additional paid-in capital on common stock $196,775 7 Additional paid-in capital on preferred stock $13,600 8 Common stock, $2 par $92,600 9 Preferred stock, $100 par $68,000 $196,000 E G H 10 Retained earnings 11 12 Number of common shares sold during 2019 13 Price of a common share sold during 2019 14 Number of preferred shares sold during 2019 15 Price of a preferred share sold during 2019 16 Net income 17 Dividends paid on a preferred share 18 Dividends paid on a common share 19 20 REQUIRED: 2,500 $13 420 $129 $100,000 $9 $2.20 21 Prepare Osgood's statement of shareholders' equity (include retained earnings) for 2019. 22 3 4 5 6 7 $3 Type in the line item descriptions and use formulas and cell references from the problem data to enter amounts. Formulas entered in the gr cells. Transfer results to CNOWv2 for grading. OSGOOD FILM STUDIOS Statement of Shareholders' Equity For Year Ended December 31, Current Year Common Stock $ nar Additional Paid-in Capital on Preferred Stock Preferred Stock $100 nar Additional Paid-in Capital on Common Reta Stock Farm Balances, 1/1/19 Common stock issued Preferred stock issued Net income Cash dividend paid on preferred Cash dividend paid on common Balances, 12/31/19 OSGOOD FILM STUDIOS Statement of Shareholders' Equity For Year Ended December 31, 2019 Additional Preferred Stock Common Stock Additional Paid-in Capital on Preferred Paid-in Capital Retained $100 par $2 par on Common Stock Earnings Total Stock 68,000 $ 9.600 13,600 196,775 V 196,000 566,975 Accounting numeric field 636,395