I have no idea how to use excel to create the financial statements :( Based on the adjusted trial balance prepare a adjusted trial balance, multi-step income statement, retained earnings statement and balance sheet using excel.

Page 15 Big Data Company Adjusted Trial Balance December 31, 2018 Cash 43,500 45,000 Accounts Receivable Allowance for Doubtful Accounts Merchandise Inventory $ 3,100 18,600 Supplies Prepaid Insurance 2,000 75,000 650,000 Land Building Accumulated Depreciation- Building 340,000 Equipment Accumulated Depreciation- Equipment 390,000 160,000 42,400 22,500 1,200 25,000 128,000 250,000 272,000 Accounts Payable Unearned Revenue Salaries Payable Notes Payable, due May. 31, 2019 Mortgage Payable due Dec. 31, 2025 Common Stock Retained Earnings Dividends 35,000 Sales 197,000 Sales Returns & Allowances 4,300 1,700 118,000 30,000 4,000 800 3,000 2,400 1,800 2,600 Sales Discounts Cost of Goods Sold Salaries Expense Depreciation Expense Freight Out Advertising Expense Utilities Expense Supplies Expense Bad Debt Expense Interest Revenue Gain on sale of Equipment 700 2,000 Loss on sale of Building Interest Expense 3,500 Total