AutoSave OFF BESU- Week 4 Assignment (7) AC DR Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments V V V V ZE WA 0 WE > > 48- 0 3 V 97 .00 > 0 V X Calibri (Body) Insert v 11 = = "Ai > ab Wrap Text General 9X Delete Paste I U B Cell A LE %> Sort & Conditional Format Find & & Merge & Center Analyze Formatting as Table Styles Format Filter Select Data J18 4 x fx A A B D E F F G H 1 J L M 1 Here are the current account balances (Part 1 transactions not included) for Sharon's Stones: 2 3 Income Statement account Amount (dr/cr) Balance Sheet account Amount (dr/cr) 4 Sales Revenue 1900 cr Cash 4,330 dr 5 Service Revenue 150 cr Accounts Receivable 450 dr 6 Cost of Goods Sold Expense 400 dr Inventory 800 dr 7 Utilities Expense 220 dr Equipment 3,000 dr 8 Accounts Payable 1,200 cr 9 Bank Loan 2,250 cr 10 Sharon, Capital 5,000 cr 11 Sharon, Withdrawals 300 dr 12 13 14 15 II) Make the necessary adjusting entries for the August month-end. Also, make a list of updated income statement and balance sheet accounts and their dr/cr balances) after these adjustments are done. 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Part 1 Part 2 Part 3 Part 4 + Ready @ B + 142% AutoSave OFF HESU- Week 4 Assignment (7) AC DR Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V 11 I Insert v = = V V > General ab Wrap Text WE 17.0. 5 9X Delete Paste B B I U A === 3 Merge & Center v LE %> IN V Conditional Format Cell Formatting as Table Styles > 0 Format V Sort & Filter Find & Select Analyze Data B36 4 x fx A A B D E F G H 1 J K 1 IV) Make the necessary closing entries at the end of September (quarter-end) for Sharon's Stones. 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Part 1 Part 2 Part 3 Part 4 + Ready B a + 157%