The unadjusted trial balance of Cisco Brothers as at 30 June 2020 is shown in Table 3 below. The following adjustments are yet to be included in Cisco Brothers' Worksheet.(a) Supplies on hand at the end 30 June amount to $300.(b) Cisco paid $12,000 for rent on 1 May. This represented 10 months of rent paid in advance.At 30 June, Prepaid rent needs to be adjusted for the amount of the asset that has been used up.(c) Cisco depreciates motor vehicles at a rate of 10%% per year on cost.(d) Employees at Cisco work Monday to Friday and they are paid fortnightly every Friday. Ciscolast paid wages of $3,000 on Friday 26 June for the previous 10 days work. The next payment of wages will not occur until the 10 July. Assume the 30 June 2020 is a Tuesday.Accrued wages are yet to be recorded in the accounts.(e) Cisco has now performed $1,000 worth of work related to the unearned revenue. Compete a 10 column worksheet using Excel for Cisco Brothers showing the trial balance before balance day adjustments (using the input data function), the balance day adjustments for June (using the input data function), the adjusted trial balance (after balance day adjustments), the Income Statement, and the Balance Sheet, in ONE Sheet after inputting the opening balances from Table 3 below.

Table 3. Opening Balances - Part B: Cisco Brothers Trial Balance of Cisco Brothers (Prior to BDA) as at 30 June 2020 Acc. No. Account Name Debit Credit Banks 2,000 Accounts Receivables 3,000 Allowance for Doubtful Debts 100 Office Supplies 800 Prepaid Rent 12,000 GST Receivable 400 Motor Vehicle 15,000 Accumulated Depreciation - MV 5,000 Accounts Payable 4,000 Accrued Wages Unearned Service Revenue 4,000 GST Payable 800 Capital 10,300 Drawings 7,000 Service Revenue 45,000 Supplies Expense Rent Expense Wages Expense 29,000 Depreciation - Motor Vehicle 69,200 69,200