Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 4-2 Extending accounts in the work sheet L01 excel CHECK FIGURE: Loss = $8,150 The Adjusted Trial Balance columns of a 10-column work
Exercise 4-2 Extending accounts in the work sheet L01 excel CHECK FIGURE: Loss = $8,150 The Adjusted Trial Balance columns of a 10-column work sheet for Webber Co. follow. Complete the work sheet by extending the account balances into the appropriate financial statement columns and by entering the amount of profit or loss for the reporting period. Webber Co. Work Sheet.xls Home Insert Page Layout Formulas P18 Data Review View B C 123456 Webber Co. Work Sheet December 31, 2017 Adjusted Trial Balance Account 7 101 Cash 8 106 Accounts receivable 9 153 Trucks Debit Credit $ 21,000 8,200 48,000 10 154 Accumulated depreciation, trucks $ 31,250 11 193 Franchise 6,500 12 201 Accounts payable 13,000 13 209 Salaries payable 14,600 14 233 Unearned revenue 2,450 15 301 Bo Webber, capital 37.750 16 302 Bo Webber, withdrawals 7,200 31.600 17 401 Plumbing revenue 18 611 Depreciation expense, trucks 12,100 19 622 Salaries expense 17,800 20 640 Rent expense 6,000 21 677 Miscellaneous expense 3,850 22 Totals $ 130,650 $ 130,650
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