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 Ramirez Heyward Jones Beginning of the year: Assets $ $503,400 $441,600 265,000 $ 198,700 151,000 Uabilities 261,800 242,500 178,800 501,100 End of the year Assets Labilities During the year Additional common stock issued 547,600 238,500 704,800 221,500 159,000 274,800 100,700 19,900 80,800 Dividends 30,900 30,200 118,500 Revenue 145,700 228,400 226,300 Expenses 79,500 130,900 244,400 258,600 . Manomen who comment on One lumi omitted in each of the following umars of bone shot and income statement data for the folowing for proprietorship Using formulas and career perform the required analysis and input your answer to the Freeman, Heyward Jones, and Ramirez coluna Transfer the numero results for the entry cos (15.17,016and into the appropriate fe NOW2 for grading F Fi Martire Hayward degennya A End of the year 34416005503.400 205.000 21.00 56700 151,000 2320 Asset 517100 22 POUR 221.00 110 150 000 100 214.000 11 14 During the year Analomon Donde R 100 10000 30200 0.000 11600 22000 214.000 145.70 79.500 22:00 24400 130 000 AD