Part A.

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.

1. Supplies on hand at the end 30 June amount to $300.
2. 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. Cisco last 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.

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