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 groups This information has been collected in the Microsoft Excel Online Open the spreadshest perform the required analysis, and input your awers in the questions Open sonradsheet Determine the missing amounts (Hint: fint determine the amount of increase or decrease in owney during the year) Mound your answers to the rest dollater answers as positive values Freeman Heyward Jone Ramirez Beginning of the year $530,300 597,000 $24.300 Liabilities 317,000 310,400 103,700 207,200 End of the year Assets 655,100 35,000 223,500 6142200 Liabilities 285,100 262,700 190,600 336,800 During the year Additional common stock issued 119,400 24,000 99 100 Dividends 37,000 35,800 145,300 Revenue 174.400 285,600 277,400 Expenses 95.100 55,200 305,400 317,000 Formulas 1 Missing amounts from balance sheet and income statement data 2 One item is omitted in each of the following summaries of balance sheet and income statement data for the following four proprietorships, 3 Using formulas and cell 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 cells (B16, C17. D16, and E9) into the appropriate fields in CNOWV2 for grading 5 16 7 Freeman Heyward Jones Ramirez Freeman Hayward 8 Beginning of the year 9 Assets 5528,300 $597 000 5248,300 10 Liabilities 317.000 310,400 188.700 297,200 11 End of the year 12 Assets 855.100 835,800 223,500 614,200 13 Liabilities 285,300 262.700 198,600 336.800 14 During the year 15 Additional common stock issued 119,400 24.800 99.100 16 Dividends 37.000 35.800 145 300 17 Revenue 174 400 285,600 277.400 18 Expenses 95.100 155200 305,400 317 000 19