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 $ 588,700 $ 682,900 $ 253,100 Liabilities 353,200 355,100 192,400 331,200 End of the year: Assets 730,000 956,100 227,800 684,400 Liabilities 317,900 300,500 202,500 375,300 During the year: Additional common stock issued 136,600 25,300 110,400 Dividends 41,200 41,000 161,900 Revenue 194,300 291,100 309,100 Expenses 106,000 177,600 311,300 353,200