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 Insert v 11 I V = = V V > ab Wrap Text General ZE WE > > > 48- 0 9X Delete 3 Paste U V A Find & & LE %) Merge & Center v V .00 0 48 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Select Analyze Data J18 4 X fx A B D E F G H 1 J L M 37 38 39 40 41 Dr/Cr Account name Account balance I/S or B/S 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Part 1 Part 2 Part 3 Part 4 + Ready @ B 11 i + 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 Insert v 11 AA = = V V ab Wrap Text > General ZE WEO > > > Ayu Oy X Delete 3 Paste B B I U Av = = Merge & Center & LE % V 28 .00 0 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analyze Data V10 4 X fx N o P Q Q R S S T U V w Y z AA 1 J K L M 14 15 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 32 33 34 35 36 37 38 39 40 41 42 43 44 Part 1 Part 2 Part 3 Part 4 + Ready @ B 11 - + 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 Insert v 11 AA V = = V V > ab Wrap Text General ZE WE Ayu -0 3 9X Delete v Paste B B I U : & Merge & Center & LE %> V .00 0 8 Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find & Select Analyze Data J6 fx A B D E F G H J K L M M N 0 P P 1 2 III) Make the necessary adjusting entries for September month-end for Sharon's Stones. Also, make a list of updated income statement and balance sheet accounts (and their dr/cr balances) after these adjustments are done. 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 28 29 30 31 32 33 34 Part 1 Part 2 Part 3 Part 4 + Ready B 11 + 125% 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 AA = = V V > Wrap Text General # Insert 9X Delete WE Ayu Oy 3 Paste I U V A & Merge & Center LE %> V > 0 Conditional Format Cell Formatting as Table Styles A Format v Sort & Filter Find & Select Analyze Data J6 4 X fx B C D E F G H 1 J K L Dr/Cr Account name Account balance I/S or B/S 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Part 1 Part 2 Part 3 Part 4 + Ready B + 150% 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) Insert v V 11 AA = = V V > ab Wrap Text General ZE 48- 0 OEM X Delete v 5 Paste B I U Av & E Merge & Center LE %> V > 0 Conditional Format Cell Formatting as Table Styles F Format Sort & Filter Find & Select Analyze Data A J6 Q R S T U V V V X fx G G H 1 J K L M M N o 1 2 ted income statement and balance sheet accounts (and their dr/cr balances) after these adjustments are done. 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 28 Part 1 Part 2 Part 3 Part 4 + Ready B A + 150% 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% 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 Insert v 11 I V = = V V > ab Wrap Text General ZE WE > > > 48- 0 9X Delete 3 Paste U V A Find & & LE %) Merge & Center v V .00 0 48 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Select Analyze Data J18 4 X fx A B D E F G H 1 J L M 37 38 39 40 41 Dr/Cr Account name Account balance I/S or B/S 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Part 1 Part 2 Part 3 Part 4 + Ready @ B 11 i + 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 Insert v 11 AA = = V V ab Wrap Text > General ZE WEO > > > Ayu Oy X Delete 3 Paste B B I U Av = = Merge & Center & LE % V 28 .00 0 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analyze Data V10 4 X fx N o P Q Q R S S T U V w Y z AA 1 J K L M 14 15 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 32 33 34 35 36 37 38 39 40 41 42 43 44 Part 1 Part 2 Part 3 Part 4 + Ready @ B 11 - + 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 Insert v 11 AA V = = V V > ab Wrap Text General ZE WE Ayu -0 3 9X Delete v Paste B B I U : & Merge & Center & LE %> V .00 0 8 Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find & Select Analyze Data J6 fx A B D E F G H J K L M M N 0 P P 1 2 III) Make the necessary adjusting entries for September month-end for Sharon's Stones. Also, make a list of updated income statement and balance sheet accounts (and their dr/cr balances) after these adjustments are done. 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 28 29 30 31 32 33 34 Part 1 Part 2 Part 3 Part 4 + Ready B 11 + 125% 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 AA = = V V > Wrap Text General # Insert 9X Delete WE Ayu Oy 3 Paste I U V A & Merge & Center LE %> V > 0 Conditional Format Cell Formatting as Table Styles A Format v Sort & Filter Find & Select Analyze Data J6 4 X fx B C D E F G H 1 J K L Dr/Cr Account name Account balance I/S or B/S 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Part 1 Part 2 Part 3 Part 4 + Ready B + 150% 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) Insert v V 11 AA = = V V > ab Wrap Text General ZE 48- 0 OEM X Delete v 5 Paste B I U Av & E Merge & Center LE %> V > 0 Conditional Format Cell Formatting as Table Styles F Format Sort & Filter Find & Select Analyze Data A J6 Q R S T U V V V X fx G G H 1 J K L M M N o 1 2 ted income statement and balance sheet accounts (and their dr/cr balances) after these adjustments are done. 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 28 Part 1 Part 2 Part 3 Part 4 + Ready B A + 150% 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%