Need to complete the worksheet provided. And i'll be sure to give a thumbs up!

Background: The Mason family operates a building supply store and counts the physical inventory once a year. The value assigned to the year-end inventory was $35 000. They failed to count the inventory on four shelves in the warehouse. As a result, the year-end financial statements were prepared with an incorrect valuation for ending inventory. A couple of weeks after the statements were prepared, the omission was discovered and reported to the company's accountant. The value of the inventory missed was $7 500. Required: 1. Create a mini-income statement including the incorrect ending inventory on the spreadsheet provided. Net sales for the period were $325 000; beginning inventory was $65 000; purchases were $24 000; and operating expenses were $161 000. 2. Create a revised income statement with the correct ending inventory figure. 3. Evaluate the effect of the omission on each of the following: a. Income statement accounts o cost of goods sold o gross profit o net income b. the balance sheet o Total Assets o Owner's Equity 4. Assume the accountant did NOT correct the error this year, and she permitted this error to be carried forward to the next accounting year. What would be the effect of this error on next year's: a. income statement accounts? b. balance sheet accounts? D E F H J State effect as: overstated, understated, OR no effect Part 3 Effect of the omission on: Effect Amount a. income statement accounts the cost of goods sold gross profit net income b the balance sheet accounts total assets owner's equity Effect Amount A B B 1 Unit 3 Activity 2 Assignment 1 2 Part 1: With inventory error 3 Mason Building Supplies 4 Income Statement 5 For the Year ended December 31, 2015 6 7 Net Sales 8 9 Cost of Goods Sold 10 Inventory, January 1 11 Purchases 12 Cost of Goods Available for Sale 13 Inventory, December 31 14 Cost of Goods Sold 15 Gross Profit 16 17 Operating Expenses 18 Net Income 19 20 21 Part 2: With correction 22 Mason Building Supplies 23 Income Statement 24 For the Year ended December 31, 2015 25 26 Net Sales 27 28 Cost of Goods Sold 29 Inventory, January 1 30 Purchases 31 Cost of Goods Available for Sale 32 Inventory, December 31 33 Cost of Goods Sold 34 Gross Profit 35 36 Operating Expenses 37 Net Income 38 39 40 41 42 Part 4 a. income statement accounts beginning inventory the cost of goods sold gross profit net income b. balance sheet accounts total assets owner's equity Sheet1 +