In: Accounting
Required: Complete the following worksheet for Appliance Repair for the year ended 30 June 2020.
Additional information to complete the worksheet:
Appliance Repair Worksheet For the year ended 30 June 2020 |
||||||||||
Trial Balance (Unadjusted) |
Adjustments |
Trial Balance (Adjusted) |
Income Statement |
Balance Sheet |
||||||
Account title |
Debit |
Credit |
Debit |
Credit |
Debit |
Credit |
Debit |
Credit |
Debit |
Credit |
Cash at bank |
37,500 |
|||||||||
Accounts receivable |
127,500 |
|||||||||
Prepaid insurance |
1,800 |
|||||||||
Supplies |
900 |
|||||||||
Equipment |
67,500 |
|||||||||
Accumulated depreciation-Equipment |
||||||||||
Accounts payable |
2,700 |
|||||||||
Unearned revenue |
3,150 |
Interest payable |
||||||||||
Bank loan (due in 2028) |
75,000 |
|||||||||
Capital |
49,950 |
|||||||||
Service revenue |
157,500 |
|||||||||
Wages expense |
52,500 |
|||||||||
Supplies expense |
600 |
|||||||||
Depreciation expense – Equipment |
||||||||||
Insurance expense |
||||||||||
Interest expense |
||||||||||
288,300 |
288,300 |
|||||||||
Trial balance (Unadjusted) | Adjustment | Trial balance (adjusted) | Income statement | Balance Sheet | ||||||
Account Title | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit |
Cash at bank | 37500 | 37500 | 0 | 37500 | 0 | |||||
Accounts receivable | 127500 | 127500 | 0 | 127500 | 0 | |||||
Prepaid insurance | 1800 | 450 | 1800 | 450 | 1800 | 450 | ||||
Supplies | 900 | 250 | 900 | 250 | 900 | 250 | ||||
Equipment | 67500 | 67500 | 0 | 67500 | 0 | |||||
Accumulated depreciation | 21600 | 0 | 21600 | 0 | 21600 | |||||
Accounts payable | 2700 | 0 | 2700 | 0 | 2700 | |||||
Unearned revenue | 3150 | 2750 | 2750 | 3150 | 2750 | 3150 | ||||
Interest payable | 1200 | 0 | 1200 | 0 | 1200 | |||||
Bank loan (due in 2028) | 75000 | 0 | 75000 | 0 | 75000 | |||||
Capital | 49950 | 0 | 49950 | 0 | 49950 | |||||
Service revenue | 157500 | 2500 | 0 | 160000 | 0 | 160000 | ||||
Wages expense | 52500 | 52500 | 0 | 52500 | 0 | |||||
Supplies Expense | 600 | 600 | 0 | 600 | 0 | |||||
Depreciation expense - Equipment | 21600 | 21600 | 0 | 21600 | 0 | |||||
Insurance expense | 450 | 450 | 0 | 450 | 0 | |||||
Interest expense | 1200 | 1200 | 0 | 1200 | 0 | |||||
Profit | 83650 | |||||||||
Profit added to capital | 83650 | |||||||||
288300 | 288300 | 26000 | 26000 | 314300 | 314300 | 160000 | 160000 | 237950 | 237950 |
Notes | |
Depreciation | |
Cost | 67500 |
Scrap value | 2700 |
Depreciable value | 64800 |
No of years | 3 |
Depreciation per year | 21600 |
Interest on bank loan | |
Loan amount | 75000 |
Interest % | 0.80% |
Interest per month | 600 |
Interest for 2020 (2 months) | 1200 |
Supplies unadjusted | 900 |
Supplies in hand | 650 |
Used for services but no information on billing, hence debited unearned revenue | 250 |
Insurance paid | 1800 |
Apr to Jun 2020 (3 months) | 450 |
Adjusted prepaid insurance | 1350 |