Problem 18-7 Completing a Ten-Column Work Sheet The Trial Balance for Cycle Tech Bicycles, as of August 31, is listed below. Also listed is the data needed for the adjustments Ending merchandise inventory Ending supplies inventory Insurance premium expired Federal income tax expense for the month $ 24,188 1,049 675 3,827 1. Prepare a ten-column work sheet for Cycle Tech Bicycles for the month ended August 31. The totals will be automatically calculated. Cycle Tech Bicycles Work Sheet For the Month Ended August 31, 20- Adjustments Adjusted Trial Balance Debit Credit Debit Credit Income Statement Balance Sheet Trial Balance Credit Debit Debit Credit Credit Debit Account Name Cash in Bank Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Store Equipment Office Equipment Accounts Payable Fed. Corporate Income Tax Pay. Employees' Fed. Ind. Tax Pay. Employees' State Inc. Tax Social Security Tax Payable 22 323 1.737 23,654 3,971 1,800 25,395 15,239 11,051 519 142 408 142 408 137 1,871 51 263 40,000 14,908 128,231 214 Employees' State Inc. Tax Social Security Tax Payable Medicare Tax Payable Sales Tax Payable Fed. Unemployment Tax Pay State Unemployment Tax Pay Capital Stock Retained Earnings Income Summary Sales Sales Discounts Sales Returns and Allowances Purchases Transportation in Purchases Discounts Purchases Returns and Allow. Advertising Expense Bankcard Fees Expense Fed. Corporate Income Tax Exp Insurance Expense Maintenance Expense Miscellaneous Expense Payroll Tax Expense Rent Expense Salaries Expense Supplies Expense Utilities Expense 1.289 67.118 1,172 810 322 2.938 185 3,650 2.450 3,929 834 10.750 4,670 5,395 0 0 0 198,713 198,713