Part 5 instructions

Part Five Instructions Prepare an Adjusted Trial Balance, then an Income Statement, Statement of Stockholders' Equity and a Balance Sheet and staple them to the front cover of the practice set in the correct order as listed here. These statements should be done in Word or Excel. Bank Statement Wells Fargo Bank Page 1 PO Box 12345 El Paso, Texas 79902 on ME Sweaty Bands, Inc. 123 Main Avenue El Paso, Texas 79945 WELLS FARGO BANK STATEMENT 070 and suc Sweaty Bands, Inc. $0 Balance, beginning Deposits and other credits Checks and other debits Balance on statement date 01/01/2020 January January 01/31/2020 $57,449.90 $37,163.33 $20,286.57 Deposits Added 1/2/2020 Deposit 1 $25,000.00 1/5/2020 Deposit 2 $7,000.00 1/19/2020 Deposit 3 $5,953.75 1/23/2020 Deposit 4 $8,000.00 1/23/2020 Deposit 5 $11,496.15 Wells Fargo Bank Statement-Checks Paid and other Debits 1002 $1,800.00 1008 $16,000.00 1003 $13,000.00 1012 $883.33 1004 $900.00 NSF $300.00 1005 $300.00 DM $30.00 Check Printing Fee 1006 $530.00 SC $20.00 Charge for NSF Check *Assume any errors are made by the bank Balance as per bank Add: Deposit in transit Add: Bank Error Less: Outstanding check Reconciled bank balance $ 20,286.57 $ 7,362.53 $ 180.00 $ -10,762.43 $ 17,066.67 Balance as per books Less: NSF Check Less: Bank Charges $ 17,416.67 $ 300.00 $ -50.00 Reconciled Book Balance $ 17,066.67 $ 300.00 Accounts Receivable Cash $ 300.00 $ 50.00 Bank Charges Cash $ 50.00 Unadjusted TB Debit Credit 17,416.67 Adjusted TB Debit Credit 17,416.67 Post-Closing TB Debit Credit 17,416.67 7,395.00 595.00 365.00 200.00 3,200.00 1,800.00 10,000.00 7,395.00 595.00 43.00 150.00 2,400.00 1,500.00 10,000.00 7,395.00 595.00 43.00 150.00 2,400.00 1,500.00 10,000.00 166.67 166.67 13,000.00 13,000.00 200.00 200.00 900.00 900.00 900.00 25.00 25.00 Sweaty Bands, Inc. Account Names Cash Account Receivable Inventory - Orange Headbands Inventory - Blue Headbands Office Supplies Store Supplies Prepaid Rent Prepaid Insurance Store & Office Equipment Accumulated Depreciation - Store & Office Equipment Furniture & Fixtures Accumulated Depreciation - Furniture & Fixtures Computer Equipment Accumulated Depreciation - Computer equipment Account Payable Note Payable - Wells Fargo Bank Note Payable - Store & Office Supply Wages Payable Interest Payable Sales Tax Payable Utility Payable Common Stock Retained Earnings Dividends Sales Cost of goods sold Legal expense Store Supplies expense Office Supplies expense Insurance expense Wages expense 7,000.00 9,166.67 7,000.00 9,166.67 1,550.00 35.00 7,000.00 9,166.67 1,550.00 35.00 277.23 25,000.00 277.23 25,000.00 277.23 25,000.00 9,979.10 100.00 100.00 30,990.00 30,990.00 15,560.00 350.00 15,560.00 350.00 50.00 322.00 300.00 1,550.00 375.00 850.00 277.23 800.00 391.67 85.00 375.00 850.00 277.23 Advertising and Promotion expense Utility expense Rent expense Depreciation expense Interest expense Bank Service fee Totals 50.00 Dute D D Date Credit Dute De Date Cre a te Cash S . $ 1.200 SLO S $13.000 2000 Debit Dale Credit Accrate SLO S . SS 23 .000 u te et orygd $11.00 $ 2.500 $ . 15. $ SOO 2- 10000 36 22 $ 2.500 2.000.00 25 $ - 1.000.00 $ $ 350 200 $ 65 - 12 100 $ Bal S17417 Office Supplies $ 300 Prepaid Rent 1.200 $ 35 Prepaidwance $ 100 Store Supplies 200 3 3 S - - 50.00 Store Office Equipment $10.000 Bal $ 150 lated Depreciation Store & Office Equi 31.jan 367 $ 2.400 Furniture & Fixtures San $11,000 $ 1.500 umulated Depreciation Furniture & Fit $ 200 $10.000 Computer Equipment 100 $ 357 Bal $13,000 ulated Depreciation Computer equipe Account Payable 11. 25 20 $ 200 la 11000 22-Jan $ 15,000 8-lan $ 5.000 23-Jan S 8.400 Note Payable Wells Fargo Bank San 7.000 - 22-lan $ 2.500 Note Payable. More Office Supply Sales Tax Payable Wapes Payable 31.jan $ 1.550 Interest Payable 31. 35 5 28-Jan $ 25 ans 212 Retained wings Divides Legal expe 13-Jan $ 350 3.000 $ 5.500 $10.620 15- 2 5. 5 13- 15 25 25 30 a Cost of goods sold $ 4.000 $ 270 $30 $ 2150 $ 350 $ 2.50 Opise 31 $ 300 3- $ 1.550 $ 1550 n expense Avertising o 2 50