60.1K

Verified Solution

Link Copied!

I need help making sure I'm placing these correctly and doing the retained earnings correct

ed Web Payment Quiz: W8 Final Exam Me X + X BUS 603 Week 2 H https://canvas.olivet.edu/courses/20083/quizzes/65389/take . . . File Home Insert A In an excel worksheet, please prepare an Income Statement and Clipboard Font Alig Balance sheet for Stanley Inc., using the adjusted trial balance below. (Hint: before preparing the balance sheet you must complete a statement of retained earnings.) B13 X Stanley Incorporated A B Adjusted Trail Balance 1 2 December 31, 2017 3 Accounts payable 217,000 4 Accounts receivable 167,000 5 6 Accrued expenses 123,000 7 Current assets: Accumulated depreciation: 8 Cash Buildings 457,500 9 10 Accounts receiva Accumulated depreciation: 11 Merchandise inv Equipment 366,000 12 Pprepaid insruan Bonds payable 650,000 13 Supplies on hand 14 Total current as Building 1,220,000 15 Capital stock 500,000 16 Property, plant and 17 Land Cash 62,000 18 Building Cost of sales 430,500 19 Equipment (at cost 20 Accumulated depre Depreciation 67,100 21 Accumulated deprec Equipment 549,000 22 23 Net property, plant Income tax expense 20,130 24 Insurance expense 52,000 25 Other assets 329,000 26 Inventories 27 Land 315,000 28 Other noncurrent asse Marketable securities 284,000 4 ...Problem 2-5 case Ready Type here to search e X W X Home End FO F9 F10ived Web Payment Quiz: W8 Final Exam Ma X + v 0 X BUS 603 Week 2 Hom https://canvas.olivet.edu/courses/20083/quizzes/65389/take . . . File Home Insert Capital stock 500,000 A Cash 62,000 Clipboard Font Alignm Cost of sales 430,500 Depreciation 67,100 B13 X Equipment 549,000 A B Income tax expense 20,130 1 Insurance expense 52,000 2 3 Inventories 329,000 4 Land 315,000 5 Marketable securities 184,000 6 Notes payable 175,000 7 Current assets: 8 Cash Retained earnings 314,130 9 Sales Revenue 1,230,000 10 Accounts receivab 11 Supplies expense 75,400 12 Merchandise invent Pprepaid insruance Taxes payable 52,000 13 14 Supplies on hand Total current asset Utilities expense 188,700 15 Wages expense 324,800 16 Property, plant and 17 Land Totals $4,084,630 $4,084,630 18 Building 19 Equipment (at cost) 20 Accumulated depreci 21 Accumulated depreci Upload Choose a File 22 23 Net property, planta 24 25 Other assets 26 27 28 Other noncurrent asset D Question 27 15 pts ...|Problem 2-5 case 2- Ready Type here to search 0 e " OX W X Home End F5 F7 F8 F9 F10 F11 F12

Answer & Explanation Solved by verified expert

See Answer