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 the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X 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 $ 572,100 $ 646,500 $ 246,000 343,300 336,200 187,000 319,200 709,400 308,900 905,100 284,500 221,400 196,800 659,700 361,00 Libilities End of the year Assets Liabilities During the year Additional common stock issued Dividends Revenue Expenses 24,600 106,400 129,300 38,800 40,000 188,800 103,000 283,000 302,600 156,100 297,900 340,500 168,100 A Missing amounts from balance sheet and income statement Gata One item is omitted in each of the following summaries of balance sheet and income statement data for the following four proprietorships Using formulas and cel references, perform the required analysis, and input your answers into the Freeman, Heyward, Jones, and Ramirez columns Transfer the numeric results for the green entry cels (815. C17. D16, and more appropriate fields in CNOW2 for grasing Form Freeman Heyward Ramirez Freeman Hayward Jones Ramire $572.100 5546 500 336200 $245,000 187.000 319 700 709,400 Jono 905 100 284 500 221.400 TOO 361 BOO 14 Dugo 24600 12,300 TANGO Dividends Revenue 18500 100.000 283.000 30 000 100.400 156, 100 27.000 H000 168100