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 proprietorships. 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. Open spreadsheet $ Determine the missing amounts. (Hint: First, determine the amount of increase or decrease in owner's 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 $ 506,100 $ 577,000 $ 212,600 Labilities 303,700 300,000 161,600 282,400 End of the year: Assets 627,600 807,800 191,300 583,700 Liabilities 273,300 253,900 170,100 320,100 During the year: Additional common stock issued 115,400 21,300 94,100 Dividends 35,400 34,600 138,100 167,100 244,400 263,600 Expenses 91,100 150,000 261,500 301,200 Revenue