Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help with my practice set part 5, my balance sheet is off by $100 and can figure out what im missing and not
i need help with my practice set part 5, my balance sheet is off by $100 and can figure out what im missing and not seeing, attached is all the adjusted trial balances with all correct information.
PS M N O $17.066.67 $320.00 $7,395.00 $595.00 $43.00 $150.00 $2,400.00 $1,500.00 $0.00 $10,000.00 $155.67 $13,000.00 $200.00 $900.00 $0.00 3 Cash $17,416.67 4 Accounts Receivable $0.00 5 Inventory Orange Headbands $7,395.00 6 Inventory Blue Headband $595.00 7 Office Supplies $43.00 3 Store Supplies $150.00 9 Prepaid Rent $2,400.00 LO Prepaid insurance $1,500.00 1 Prepaid Advertising $0.00 2 Store & Office Equipment $10,000.00 13 Accu. Depr. Store & Office Equip. $166 67 4 Furniture & Fixtures $13,000.00 15 Accu. Depr. Furniture & Fixtures $200.00 16 Computer Equipment S900.00 17 Accu. Depr. Computer Equip $25.00 18 Accounts Payable 19 Note Payable - Wells Fargo $7.000.00 20 Note Payable - Store & Office Supply $9,166.67 1 Wages Payable $1,550.00 22 Interest Payable $35.00 23 Sales Tax Payable $0.00 24 Utility Payable $277.23 25 Common Stock $25,000.00 26 Retained Earnings 27 Dividends $100.00 28 Sales $0.990,00 29 Cost of Goods Sold $15.560.00 30 Legal Expense $350.00 31 Store Supplies Expense $50.00 32 office Supplies Expense $322.00 33 Insurance Expense $300.00 34 Wages Expense $1.550.00 35 Delivery Expense 5375.00 36 Advertising and Promotion Expense $850.00 37 Utility Expense $277.23 38 Rent Expense $800.00 39 Depreciation Expense $391.67 40 Interest Expense $85.00 41 Bank Service Fee $0.00 42 Totals 574.410.57 $74.410.57 Adjusted Trial Balance Income Statement Cash Accounts Receivable Inventory Orange Headbands Inventory Blue Headband Office Supplies Store Supplies Prepaid Rent Prepaid insurance Prepaid Advertising Store & Office Equipment Accu. Depr. Store & Office Equip Furniture & Fixtures Accu. Depr. Furniture & Fix Computer Equipment Accu. Depe. Computer Equip Accounts Payable Note Payable. Wells Fargo 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 Delivery Expense Advertising and Promotion Expense Utility Expense Rent Expense Depreciation Expense Interest Expense $30.00 Bank Service Fee Totals STATEMENT OF STOCKHOLERS EQUITY Balance Sheet $25.00 $0.00 $7,000.00 $9166.67 $1.550.00 $35.00 $0.00 $277.23 $25.000.00 $0.00 $0.00 $100.00 $30.990.00 $15.560.00 $350.00 $50.00 5300.00 $1,550.00 $375.00 $850.00 $800.00 $85.00 $74.410.57 $74.410.57 Ready A Selection Remove Arrows Show Formulas 1 Income Statement 2 Sales $30,990.00 3 Operating Expense: 4 Cost of Goods Sold $15,560.00 5 Legal Expense $350.00 6 Store Supply Exp $50.00 7 Office Supply Expense $322.00 8 Insurance Expense $300.00 9 Wages Expense $1,550.00 10 Delivery Expense $375.00 11 Advert/Promo Expense $850.00 12 Utility Expense $277.23 13 Rent Expense $800.00 14 Depreciation Expense $391.67 15 Interest Expense $85.00 16 Bank Service Fee's $30.00 17 Total Operating Expense $20.940.90 18 Net Income: $10,049.10 Income Stament STATEMENT OF STOCKHOLERLE EOLITY H Common Stock $25,000.00 Beginning Balance, January 2, 2020 Net Income Dividend Paid Ending Balance, January 31, 202 G Retained Earnings $0.00 $14,708.00 ($100.00) $14,608.00 Total $25,000.00 $14,708.00 ($100.00) $39,608.00 $25,000.00 SETEMTOTOCOLERSEY Function Used' Date & Time Lookup & Math & Reference Trig x A More Functions Create from Selection race Dependents Remove Arrows Show Error Formulas Checking HI L M N O Total Assets Total Liabilities + Equity $52.978.00 $53,078.00 Current Assets e Cash $17,066.67 3 Accounts Receivable $320.00 4 Inventory Orange Headbands $7,395.00 5 Inventory Blue Headbands $595.00 6 Office Supplies $43.00 7 Store Supplies $150.00 8 Prepaid Rent $2.400.00 9 Prepaid Insurance $1,500.00 10 Total Current Assets: $29,469.67 11 Long-Term Assets 12 Store & Office Equipment $10,000.00 13 Less: Accumulated Depreciation $166 67) 14 Furniture & Fixtures $13,000.00 15 Less: Accumulated Depreciation $200.00) 16 Computer Equipment $900.00 17 Less: Accumulated Depreciation 1525.00) 18 Total Long Term Assets: $23,508.33 19 Total Assets $52.97.00 20 Current Liabilities 21 Accounts Payable $0.00 22 Note Payable-Wells Fargo $7,000.00 23 Note Payable-Store & Office Supplies 59,166 67 24 Wages Payable $1,550.00 25 Interest Payable $35.00 26 Sales Tax Payable 27 Utility Payable $277.23 28 Total Latilities: $18.028.90 29 Stockholders' Equity 30 Common Stock 525.000.00 31 Retained Earnings $10.049.10 32 Total Stockholders' Equity $35.049.10 50.00 Adjusted that STATEMENT TOOLBOTY Balance Sheet Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started