Taser Consulting End-of-Period Spreadsheet For the Year Ended October 31, 2018 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 57,800 57,800 Accounts Receivable 108,800 108,800 Supplies 12,200 6,300 5,900 Office Equipment 518,000 518,000 Accumulated Depreciation 28,500 6,900 35,400 Accounts Payable 20,000 20,000 Salaries Payable 2,300 2,300 Common Stock 150,000 150,000 Retained Earnings 367,000 367,000 Dividonde 26.00 25 Instructions Chart of Accounts Labels and Amount Descriptions Income Sta nstructions Accumulated Depreciation 28,500 6,900 35,400 Accounts Payable 20,000 20,000 Salaries Payable 2,300 2,300 Common Stock 150,000 150,000 Retained Earnings 367,000 367,000 Dividends 25,000 25,000 Fees Earned 352,000 352,000 Salary Expense 184,000 2,300 186,300 Supplies Expense 6,300 6,300 Depreciation Expense 6,900 6,900 Miscellaneous Expense 11,700 11,700 Total 917,500 917,500 15,500 15,500 926,700 926,700 Based on the preceding spreadsheet, prepare an income statement, retained earnings statement, and sure to read the instructions for each financial statement carefully Instructions Retained Earnings Statement Taser Consulting Score: 16/53 Retained Earnings Statement For the Year Ended October 31, 2018 1 Retained earnings $367,000.00 2 Dividends $(25,000.00) 140,800.00 3 Net income 4 Change in retained earnings 115,800.00 5 October 31, 2018 $251,200.00 Taser Consulting Score: 97/139 Balance Sheet October 31, 2018 1 Assets 2 Current assets: 3 Cash $45,000.00 4 Accounts receivable 119,200.00 5 Supplies 4,400.00 6 Total current assets $168,600.00 7 Property, plant, and equipment: Office equipment Accumulated depreciation 8 $400,000.00 9 (62,000.00) 10 Total property, plant, and equipment 338,000.00 11 Total assets $506,600.00 12 Liabilities 13 Current liabilities: Balance Sheet 8 Office equipment Shaded cells have feedback. $400,000.00 9 Accumulated depreciation (62,000.00) 10 Total property, plant, and equipment 338,000.00 > 11 Total assets $506,600.00 12 Liabilities 13 Current liabilities: 14 $20,500.00 Accounts payable 15 Salaries payable 9,000.00 16 Total Liabilities $29,500.00 17 Stockholders' Equity 18 Common stock $75,000.00 19 Retained earnings 402,100.00 20 Total stockholders' equity 477,100.00 21 Total liabilities and stockholders' equity $506,600.00