Question

In: Accounting

Required: Complete the following worksheet for Appliance Repair for the year ended 30 June 2020. (15...

Required: Complete the following worksheet for Appliance Repair for the year ended 30 June 2020.

Additional information to complete the worksheet:

  1. The equipment of $67,500 was purchased on 1 March 2020. The straight-line depreciation method is used with a useful life of 3 years and a scrap value of $2,700. No depreciation is ever recorded.
  2. The $75,000 bank loan was borrowed on 1 May 2020. It is an interest only loan. The interest rate is 0.8% per month. No interest is ever paid or recorded.
  3. The supplies on hand at 30 June 2020 were $650.
  4. The prepaid insurance balance represents the annual premium paid on 1 April 2020.
  5. $2,500 of unearned revenue has been earned by 30 June 2020.
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

Solutions

Expert Solution

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

Related Solutions

Complete the following worksheet for Appliance Repair for the year ended 30 June 2020. (15 marks)...
Complete the following worksheet for Appliance Repair for the year ended 30 June 2020. Additional information to complete the worksheet: The equipment of $67,500 was purchased on 1 March 2020. The straight-line depreciation method is used with a useful life of 3 years and a scrap value of $2,700. No depreciation is ever recorded. The $75,000 bank loan was borrowed on 1 May 2020. It is an interest only loan. The interest rate is 0.8% per month. No interest is...
Problem 15-2: Prepare a complete Worksheet. Edward Mantis is the owner of his own appliance repair...
Problem 15-2: Prepare a complete Worksheet. Edward Mantis is the owner of his own appliance repair service. On October 31, XXX1, the balances of Mr. Mantis' ledger accounts are: ACCOUNT TITLES DEBIT CREDIT Cash 5,320 Accounts Receivable—Marilyn Anker 700 Supplies 345 Prepaid Insurance 600 Equipment 4,200 Accumulated Depreciation--Equipment 630 Account Payable—Francis Lloyd 1,000 Note Payable—John Miller 1,500 Edward Mantis, Capital 6,200 Edward Mantis, Drawing 550 Income from Services 3,750 Salary Expense 800 Rent Expense 350 Miscellaneous Expense 215 Supplies used...
The following information relates to a company ABC Ltd for the year ended 30 June 2020:...
The following information relates to a company ABC Ltd for the year ended 30 June 2020: Transaction totals for the year ended 30 June 2020 R Credit purchases of raw materials 503750 Freight on raw materiasl purchased (on credit) 99833 Sales of finished producgts 11440000 Direct Labour: Factory wages 828600 Pension fund contributions paid by employer 172500 Medical aid paid by employer 227200 UIF Contributions paid by employer 8144 Indirect Labour 500250 Electricity Factory 211450 Administration offices 127900 Rent Expenses...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500 Accounts payable 52,700 Electricity expense 7,500 Unearned revenue 11,600 Wages payable 12,500 Accumulated depreciation- Equipment 8,600 Capital ? Rent expense 32,000 Cash at bank 75,800 Wages expense 135,400 Supplies 3,900 Service revenue 282,600 Bank Loan (due in 2025) 38,000 Accounts receivable 7,500 Drawings 4,000 Equipment 235,200 Depreciation expense-Equipment 8,600 Required: Prepare an Income Statement , a fully classified Balance Sheet in narrative format and...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500 Accounts payable 52,700 Electricity expense 7,500 Unearned revenue 11,600 Wages payable 12,500 Accumulated depreciation- Equipment 8,600 Capital ? Rent expense 32,000 Cash at bank 75,800 Wages expense 135,400 Supplies 3,900 Service revenue 282,600 Bank Loan (due in 2025) 38,000 Accounts receivable 7,500 Drawings 4,000 Equipment 235,200 Depreciation expense-Equipment 8,600 Required: Prepare an Income Statement , a fully classified Balance Sheet in narrative format and...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500 Accounts payable 52,700 Electricity expense 7,500 Unearned revenue 11,600 Wages payable 12,500 Accumulated depreciation- Equipment 8,600 Capital ? Rent expense 32,000 Cash at bank 75,800 Wages expense 135,400 Supplies 3,900 Service revenue 282,600 Bank Loan (due in 2025) 38,000 Accounts receivable 7,500 Drawings 4,000 Equipment 235,200 Depreciation expense-Equipment 8,600 Required: Prepare an Income Statement , a fully classified Balance Sheet in narrative format and...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500...
The following information relates to YogaGuru for the year ended 30 June 2020. Prepaid rent 14,500 Accounts payable 52,700 Electricity expense 7,500 Unearned revenue 11,600 Wages payable 12,500 Accumulated depreciation- Equipment 8,600 Capital ? Rent expense 32,000 Cash at bank 75,800 Wages expense 135,400 Supplies 3,900 Service revenue 282,600 Bank Loan (due in 2025) 38,000 Accounts receivable 7,500 Drawings 4,000 Equipment 235,200 Depreciation expense-Equipment 8,600 Required: Prepare an Income Statement , a fully classified Balance Sheet in narrative format and...
(a) Prepare a Statement of Cash Flows for the year ended 30 June 2020 using the...
(a) Prepare a Statement of Cash Flows for the year ended 30 June 2020 using the direct method, ignoring GST. Show all workings on the Workings page. (b) Using the relevant information from the question above, identify two (2) specific items (including their values) which causes a difference between Net Profit and Net Cash from Operating Activities and analyse why it causes a difference. The following financial statements relate to Clarke Ltd for the financial year ended 30 June 2020....
During the year ended 30 June 2020, Starhub Ltd acquired the following investments in shares issued...
During the year ended 30 June 2020, Starhub Ltd acquired the following investments in shares issued by other companies: M3 Ltd $480 000 (42% of issued capital) Republic Ltd $680 000 (35% of issued capital) Starhub Ltd is unsure how to account for these investments and asked you for some professional advice. Specifically, Starhub Ltd is concerned that it may need to prepare consolidated financial statements under AASB 10. The company provided the following information about the two investee companies:...
Days Ltd's financial year ended on 30 June 2020. The following events occurred between the end...
Days Ltd's financial year ended on 30 June 2020. The following events occurred between the end of the reporting period and the date the directors of Edwards Ltd expect to authorise the financial statements for issue: On 3 July 2020, directors proposed a final dividend of $120,000. On 15 July 2020, Days Ltd took delivery of building materials (inventory). Building materials were purchased from a Chinese manufacturer. Building materials were in transit at the end of the reporting period. An...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT