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 $ 653,600 $ 751,600 $ 274,500 $ Liabilities 392,200 390,800 208,600 355,900 End of the year: Assets 810,500 1,052,200 247,100 735,500 Liabilities 352,900 330,700 219,600 403,400 During the year: Additional common 150,300 27,500 118,600 stock issued Dividends 45,800 45,100 174,000 Revenue 215,800 315,600 332,100 Expenses 117,600 195,400 337,600 379,600 H I Jones Ramirez A B D E F G 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. 4 Transfer the numeric results for the green entry cells (B15, C17, D16, and E9) into the appropriate fields in CNOWv2 for grading. 5 6 Formulas 7 Freeman Heyward Jones Ramirez Freeman Heyward 8 Beginning of the year: 9 Assets $653,600 $751,600 $274,500 10 Liabilities 392,200 390,800 208,600 355,900 11 End of the year: 12 Assets 810,500 1,052,200 247,100 735,500 13 Liabilities 352,900 330,700 219,600 403,400 14 During the year: 15 Additional common stock issued 150,300 27,500 118,600 16 Dividends 45,800 45,100 174,000 17 Revenue 215,800 315,600 332,100 18 Expenses 117,600 195,400 337,600 379,600 19 20 21