To do this in Excel Table
Foremost anterial Service Trial Balance September 30, 2x 3.28 Cash Accounts Receivable Prepaid Insurance Prepaid Cleaning Supplies Gearing met Track Accounts Payable themed Jutorial Fees Share Capital Divide Janitoriales Wapes Zapese Gas Oil and Other Trucken 2,792 3480 7.200 14.1% 1,000 14,974 4,800 680 30,464 30,464 The balance of the Share Capital account reflects investments made by Ron Hudson. The following information is also available 1. Cleaning supplies of 29 are available Prepaid insurance represents the cost of a one-year policy purchased on April 1. Prepaid Rent represents a 200 payment made on April towards the last month's rent of a three- year lease plus 200 rent per month for each of the past six months d. The dening equipment and trade ane depreciated at the rate of 20 per cent per year (10 per cent for each se month period). The namedrevene represents a month payment in advance made by customer on August f. During the last week of September, Ron completed the first stage of work on a project that will not be billed until the contract is completed. The price of this stage in 800 On Saturday, October 3, Ron will owe his employees 1,680 for ce si-day wolweck facometes for the six months recitimited to be 1.500. REQUIRED 1. Open Taccounts for the accounts in the trial balance plus Vees Receivable, Accumulated Depreciation. Cleaning Equipment Accumulated Depreciation, Truck Wages Payable income Tees Payable; Rent Expense, Insurance Expense Cleaning Supplies Ewers, Depreciation Expens, Cleaning Equipment, Depreciation Truckand lucome Tuspenst. 2. Determine the adjusting entries and post the directly to the accounts 3. Prepare an adjusted trial balance, an income statement, and a balance sheet. Foremost anterial Service Trial Balance September 30, 2x 3.28 Cash Accounts Receivable Prepaid Insurance Prepaid Cleaning Supplies Gearing met Track Accounts Payable themed Jutorial Fees Share Capital Divide Janitoriales Wapes Zapese Gas Oil and Other Trucken 2,792 3480 7.200 14.1% 1,000 14,974 4,800 680 30,464 30,464 The balance of the Share Capital account reflects investments made by Ron Hudson. The following information is also available 1. Cleaning supplies of 29 are available Prepaid insurance represents the cost of a one-year policy purchased on April 1. Prepaid Rent represents a 200 payment made on April towards the last month's rent of a three- year lease plus 200 rent per month for each of the past six months d. The dening equipment and trade ane depreciated at the rate of 20 per cent per year (10 per cent for each se month period). The namedrevene represents a month payment in advance made by customer on August f. During the last week of September, Ron completed the first stage of work on a project that will not be billed until the contract is completed. The price of this stage in 800 On Saturday, October 3, Ron will owe his employees 1,680 for ce si-day wolweck facometes for the six months recitimited to be 1.500. REQUIRED 1. Open Taccounts for the accounts in the trial balance plus Vees Receivable, Accumulated Depreciation. Cleaning Equipment Accumulated Depreciation, Truck Wages Payable income Tees Payable; Rent Expense, Insurance Expense Cleaning Supplies Ewers, Depreciation Expens, Cleaning Equipment, Depreciation Truckand lucome Tuspenst. 2. Determine the adjusting entries and post the directly to the accounts 3. Prepare an adjusted trial balance, an income statement, and a balance sheet
