50.1K

Verified Solution

Link Copied!

'(3) Using formulas that link back to the "Trial Balance" tab, prepare a Classified Balance Sheet and Multi-Step Income Statement for 2017 and 2018.

B C 1 Walnut Grove Trial Balances 2 4 Cash 5 Accounts Receivable 6 Inventory 7 Prepaid Expenses 8 Building 9 Computers & Software 10 Furniture & Fixtures 11 Land 12 Machinery & Equipment 13 Accumulated Depreciation 14 Accounts Payable 15 Payroll Tax Payable 16 Sales Tax Payable 17 Interest Payable 18 Unearned Revenue 19 Line of Credit 20 Notes Payable 21 Peters, J., Capital 12/31/2017 - FINAL Debit Credit 326,356.20 26,676.00 18,630.00 963.00 119,250.00 2,007.00 5,184.00 45,000.00 78,120.00 837.00 11,191.50 4,487.40 2,292.30 3,656.25 K L To be calculated by student 12/31/2018 - Adjusted Debit Credit 410,753.54 41,901.43 24,061.10 740.31 119,250.00 7,047.00 16,299.00 45,000.00 78,120.00 18,329.51 11,471.29 4,599.59 2,349.61 5,187.24 20,475.00 258,750.00 315,000.00 900.00 900.00 900.00 129,343.95 258,688.80 8,085.60 1,008.00 404.10 900.00 282,921.75 264,706.02 8,287.74 1,483.20 414.20 22 Peters, M., Capital 23 Net Income/Retained Earnings 24 Material & Supplies Sales 25 Small Tool Sales 26 Tool Rentals 27 Vendor Compensation 28 COGS - Material & Supplies 29 COGS - Small Tools 30 COGS - Wages 31 Depreciation Expense 32 Insurance Expense 33 Interest Expense 34 Office Supplies Expense 35 Payroll Tax Expense 36 Postage Expense 80,040.60 12,701.70 16,225.20 4,237.20 82,191.62 13,819.24 16,630.83 17,492.51 4,589.90 1,439.58 118.08 1,273.05 47.97 115.20 1,242.00 46.80 736,794.90 736,794.90 880,775.15 880,775.15 Check Figure-should be zero (0) 882,421.92 1,646.77

Answer & Explanation Solved by verified expert

See Answer