Question

UNION MONOW Unice 365 Calculator 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 informa been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. 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 t 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 Revenue 141,100 211,200 217,100 Expenses 76,900 127,800 226,000 248,200 Previous Check My Work

Answer 1

Particular	freeman	Heyward	Jones	Ramirez
Beginning of the year
Asset	427300	491400	183700	517000 (work note 4)
Liabilities	256400	255500	139600	232700
End of the year
Asset	529900	688000	165300	480800
Liabilities	230700	216200	147000	263700
During the year
Additional common stock issued	94000 (Work note 1)	98300	18400	77600
Dividends	29900	29500	11000 (work note 3)	113700
Revenue	141100	294900 (work note)	212200	217100
Expense	76900	127800	226000	258200

Work note 1: addition in common stock of freeman

Opening capital=427300-256400=170900

Closing capital=529900- 230700=299200

Net profit transferred to capital account=141100-76900-29900=34300

Additional common stock issued= closing capital -net profit transferred to capital account- opening capital

=299200-170900-34300 = 94000

Work note 2. Computation of revenue of Heyword

Opening capital=491400-255500=235900

Closing capital=688000-216200=471800

Profit transferred to capital account during the year = closing capital - opening capital- addition in common stock=471800-235900-98300=137600

Revenue= net profit transferred to capital account +dividend apportioned+expence

=137600+29500+127800=294900

Work note 3.computation of dividend

Opening capital= 183700-139600=44100

Closing capital=165300-147000=-18300

Net profit= 211200-226000= -14800

Net profit transferred to capital account=18300- 44100= -25800

Dividend= -25800+14800 =11000

Work note 4

Net profit transferred to capital account=revene-expense- dividend=217100-248200- 113700 =-144800

Closing capital=480800- 263700=217100

Assets for beginning of the year= 217100+144800-77600+232700=517000