Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the Income Statement and Balance Sheet columns in the worksheet. Using your worksheet as a guide, prepare the Income Statement for the month ending
Complete the Income Statement and Balance Sheet columns in the worksheet. Using your worksheet as a guide, prepare the Income Statement for the month ending 30 June 20XX and the Balance Sheet as at 30 June 20XX (Note: Enter accounts in ascending order according to their chart of account number. If an account results in a zero balance, leave the debit and credit fields for the account blank. Do not enter 0.00 in the debit or credit field.) WORKSHEET Worksheet for period ended 30 June 20xx Trial Balance Dr Cr Dr 100 105 110 120 130 140 Bank Account Petty Cash Accounts Receivable Prepaid Insurance Prepaid Rates and Taxes 7,231.07 200.00 7,493.00 381.25 164.75 2,498.60 350,000.00 7,231.07 200.00 7,493.00 381.25 164.75 GST Paid (Outlays) Buildings and Improvements (Cost) Accumulated Depreciation 2,498.60 350,000.00 161 - Bldgs and 170 Hire Equipment (Cost) 110,948.09 171 Accumulated Depreciation 180 Motor Vehicles (Cost) 729.00 43,750.00 44,479.00 110,948.09 67,003.00 1,924.00 68,927.00 - Hire Equipment 29,900.00 29,900.00 Accumulated Depreciation - Motor Vehicles 498.00 8,970.00 9,468.00 190 Store Equipment (Cost) 14,700.00 191Store Equipment 200 Accounts Payable 14,700.0 Accumulated Depreciation 184.00 6,799.00 6,615.00 5,371.00 5,371.00 6,732.81 220 PAYG Withholding Payable 1,660.00 230 Superannuation Payable 414.00 80.00 1,191.67 219,191.67 218,000.00 151,156.00 151,156.00 39,024.00 39,024.00 400 Hire Service Income 127,180.45 30,810.00 517.46 127,180.45 30,810.00 420 Discounts Recerved Profit on Sale of PPE 440 3,335.00 Given 630 Freight Expense 381.25 1,191.67 2,610.00 118.80 163.65 1,812.25 995.00 14,952.73 260.83 1,404.00 1,479.60 20,200.00 668,134.90 645 Motor Vehicle Expenses 650 Office Supplies 655 Printing and Postage 660 Rates and Taxes 665 Repairs and Maintenance 670 Diving Instruction 675 Staff Amenities 2,610.00 118.80 163.65 1,977.00 995.00 14,952.73 260.83 1,818.00 1,479.60 20,280.00 668,134.90 5,566.67 5,566.67 673,155.57 164.75 Charges 414.00 685 Telephone 690 Wages and Salaries 80.00 673,155.57 Pro Diver INCOME STATEMENT for the period 1 July 20XX to 30 June 20xX INCOME Service Revenue: Total Service Revenue Other Income: Total Other Income TOTAL INCOME EXPENSES TOTAL EXPENSES Pro Diver BALANCE SHEET as at 30 June 20XX CURRENT ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS TOTAL NON-CURRENT ASSETS TOTAL ASSETS CURRENT LIABILITIES TOTAL CURRENT LIABILITIES NON-CURRENT LIABILITIES TOTAL NON-CURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS EQUITY Opening Balance for the year : Drawings TOTAL EQUITY Complete the Income Statement and Balance Sheet columns in the worksheet. Using your worksheet as a guide, prepare the Income Statement for the month ending 30 June 20XX and the Balance Sheet as at 30 June 20XX (Note: Enter accounts in ascending order according to their chart of account number. If an account results in a zero balance, leave the debit and credit fields for the account blank. Do not enter 0.00 in the debit or credit field.) WORKSHEET Worksheet for period ended 30 June 20xx Trial Balance Dr Cr Dr 100 105 110 120 130 140 Bank Account Petty Cash Accounts Receivable Prepaid Insurance Prepaid Rates and Taxes 7,231.07 200.00 7,493.00 381.25 164.75 2,498.60 350,000.00 7,231.07 200.00 7,493.00 381.25 164.75 GST Paid (Outlays) Buildings and Improvements (Cost) Accumulated Depreciation 2,498.60 350,000.00 161 - Bldgs and 170 Hire Equipment (Cost) 110,948.09 171 Accumulated Depreciation 180 Motor Vehicles (Cost) 729.00 43,750.00 44,479.00 110,948.09 67,003.00 1,924.00 68,927.00 - Hire Equipment 29,900.00 29,900.00 Accumulated Depreciation - Motor Vehicles 498.00 8,970.00 9,468.00 190 Store Equipment (Cost) 14,700.00 191Store Equipment 200 Accounts Payable 14,700.0 Accumulated Depreciation 184.00 6,799.00 6,615.00 5,371.00 5,371.00 6,732.81 220 PAYG Withholding Payable 1,660.00 230 Superannuation Payable 414.00 80.00 1,191.67 219,191.67 218,000.00 151,156.00 151,156.00 39,024.00 39,024.00 400 Hire Service Income 127,180.45 30,810.00 517.46 127,180.45 30,810.00 420 Discounts Recerved Profit on Sale of PPE 440 3,335.00 Given 630 Freight Expense 381.25 1,191.67 2,610.00 118.80 163.65 1,812.25 995.00 14,952.73 260.83 1,404.00 1,479.60 20,200.00 668,134.90 645 Motor Vehicle Expenses 650 Office Supplies 655 Printing and Postage 660 Rates and Taxes 665 Repairs and Maintenance 670 Diving Instruction 675 Staff Amenities 2,610.00 118.80 163.65 1,977.00 995.00 14,952.73 260.83 1,818.00 1,479.60 20,280.00 668,134.90 5,566.67 5,566.67 673,155.57 164.75 Charges 414.00 685 Telephone 690 Wages and Salaries 80.00 673,155.57 Pro Diver INCOME STATEMENT for the period 1 July 20XX to 30 June 20xX INCOME Service Revenue: Total Service Revenue Other Income: Total Other Income TOTAL INCOME EXPENSES TOTAL EXPENSES Pro Diver BALANCE SHEET as at 30 June 20XX CURRENT ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS TOTAL NON-CURRENT ASSETS TOTAL ASSETS CURRENT LIABILITIES TOTAL CURRENT LIABILITIES NON-CURRENT LIABILITIES TOTAL NON-CURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS EQUITY Opening Balance for the year : Drawings TOTAL EQUITY
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started