Question

Missing amounts from balance sheet and income statement data One item is omitted in each of the following summaries of balance sheet and income statement data for the following four different corporations. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. x Open spreadsheet Determine the missing amounts. (Hint: First determine the amount of increase or decrease in stockholders' equity during the year.) Round your answers to the nearest dollar. Enter your answers as positive values. Freeman Heyward Jones Ramirez Beginning of the year: Assets $ 427,300 $ 491,400 $ 183,700 $ Liabilities 256,400 255,500 139,600 232,700 End of the year: Assets 529,900 688,000 165,300 480,800 Liabilities 230,700 216,200 147,000 263,700 During the year: Additional common stock issued 98,300 18,400 77,600 Dividends 29,900 29,500 113,700 141,100 211,200 Revenue 217,100 76,900 127,800 226,000 Expenses 248,200

Answer 1

Req a.
FREEMAN
Stockholder's equity
			Beginning	Ending
Total assets		4,27,300	5,29,900
Less: Liabilities		2,56,400	2,30,700
Stockholder's equity		1,70,900	2,99,200
Computation of Additional stock issued:
Stockholder's equity at the end		2,99,200
Add: Dividend			29,900
Less: Net Income	(141,100-76,900)	-64200
				2,64,900
Less: Stockholder's equity in the beginning	1,70,900
Additional stock issued		94,000
Answer is $ 94,000
Req b.
Heyward
Stockholder's equity
			Beginning	Ending
Total assets		4,91,400	6,88,000
Less: Liabilities		2,55,500	2,16,200
Stockholder's equity		2,35,900	4,71,800
Computation of Net Income issued:
Stockholder's equity at the end		4,71,800
Add: Dividend			29,500
Less: Additional stock issued		-98300
				4,03,000
Less: Stockholder's equity in the beginning	2,35,900
Net Income for the year		1,67,100
Net Income for the year		1,67,100
Add: Expenses for the year		1,27,800
Revenues for the year		2,94,900
Answer is $ 294,900
Req c.
JONES
Stockholder's equity
			Beginning	Ending
Total assets		1,83,700	1,65,300
Less: Liabilities		1,39,600	1,47,000
Stockholder's equity		44,100	18,300
Computation of Net Income issued:
Stockholder's equity in the beginning	44,100
Less: Net loss	(211200-226000)	-14,800
Add: Additional stock issued		18400
				47,700
Less: Stockholder's equity at the end	18,300
Dividend paid			29,400
Answer is $ 29,400.
Req d.
RAMIREZ
Stockholder's equity
			Ending
Total assets		4,80,800
Less: Liabilities		2,63,700
Stockholder's equity		2,17,100
Computation of Stockholder's equity in the beginning
Stockholder's equity at the end		2,17,100
Add: Dividend			1,13,700
Add: Net Loss (217100-248200)		-31100
Less: Additional stock issued		-77600
Stockholder's equity in the beginning	2,22,100
Stockholder equity in the beginning	2,22,100
Add: Liability in the beginning		2,32,700
Total assets in the beginning		4,54,800
Answer is $ 454,800