FCILICICLJ TimmyJIVICU VICTICIDJYLUJUUL JUICII 1. Post the opening balances from Table 1 plus all the transaction from Table 2 for the month of June 2020 into the general ledger. 2. Record the balance day adjustments from Table 2 in the general journal 3. Post the balance day adjustments in the general ledger. 4. Prepare an Adjusted Trial Balance as at 30 June 2020 5. Prepare a Statement of Financial Performance and a Statement of Changes in Equity (correct format) for the year ended 30 June 2020. 6. Prepare a Statement of Financial Position (correct format and classification) as at 30 June 2020. Note: Even though you are required to prepare a Statement of Changes in Equity you are NOT required to close off revenue and expense accounts. Table 1: Opening Balances - Part A Nelson Enterprises - Trial Balance (Before Transactions and BDA) Debit Credit 900 Nelson Enterprises as at 31 May 2020 Acc. No. Account Name Banks 2,000 Accounts Receivables 51,010 Allowance for Doubtful Debts Office Supplies 1,500 Prepaid Insurance Prepaid Rent GST Receivable Motor Vehicle 79,000 Accumulated Depreciation - MV Accounts Payable Accrued Wages Accrued Interest Unearned Service Revenue GST Payable 15,984 19,056 28,000 40,000 10,000 17,500 GST Payable Fixed Interest Loan -9% Mortgage Loan Capital Retained Earnings Drawings Service Revenue Insurance Expense Rent Expense Supplies Expense Wages Expense Interest Expense Depreciation - Motor Vehicle 250,070 213,000 364.010 364.010 Amount Date Business transactions June 1 The owner of the business (Paul Nelson) invested an additional $10,000 of his own money into Nelson Enterprises. 1 Paid the yearly insurance premium. (treat as a prepayment in the first instance) The amount includes GST. $10,000 $3,630 Amount $10,000 $3,630 $22,000 Date Business transactions June The owner of the business (Paul Nelson) invested an additional $10,000 of his own money into Nelson Enterprises. Paid the yearly insurance premium. (treat as a prepayment in the first instance). The amount includes GST. In addition to the above transaction you will also be required to determine the appropriate BDA at the end of June. Purchased another Motor Vehicle for the business by borrowing the full amount with a 5-year fixed interest rate loan of 9%. Interest is paid quarterly and the first interest payment occurs on 1 September 2020. Base the accrued interest on the quarterly amount. The Motor Vehicle is to be depreciated at a rate of 40% p.a. over the next 5 years using the reduced balance method and has a residual value of $2,000. The amount includes GST. Note 1: Use the reduced balance approach illustrated in Slide 31 of the week 9 lecture. Note 2: Assume the opening balance of $79,000 in the motor vehicle account has already been depreciated at a rate of 40% p.a. for three of its five years useful life. Thus, you are required to depreciate the opening balance for the month of June 2020. These motor vehicles have a scrap value of $5000. Note 3: Show the above two depreciation calculations related to motor vehicles separately in the general journal and the general ledger. Note 4: Interest of the mortgage was last paid on 31 March 2020. Interest on the Mortgage Loan is calculated on a fixed rate of 6%. p.a. Note 5: Show the two interest calculations separately in the general journal and the general ledger. Note 6: In addition to the above purchase of the motor vehicle you will also be required to determine the appropriate BDA at the end of June for depreciation and interest. 4 Received cash for services yet to be performed. The amount includes GST. 5 Purchased office supplies paying cash. The amount includes GST. Treat the purchase of office supplies as an asset in the first instance. Office supplies on $11,220 $1,100 on the quarterly amount. The Motor Vehicle is to be depreciated at a rate of 40% p.a. over the next 5 years using the reduced balance method and has a residual value of $2,000. The amount includes GST. Note 1: Use the reduced balance approach illustrated in Slide 31 of the week 9 lecture. Note 2: Assume the opening balance of $79,000 in the motor vehicle account has already been depreciated at a rate of 40% p.a. for three of its five years useful life. Thus, you are required to depreciate the opening balance for the month of June 2020. These motor vehicles have a scrap value of $5000. Note 3: Show the above two depreciation calculations related to motor vehicles separately in the general journal and the general ledger. Note 4: Interest of the mortgage was last paid on 31 March 2020. Interest on the Mortgage Loan is calculated on a fixed rate of 6%. p.a. Note 5: Show the two interest calculations separately in the general journal and the general ledger. Note 6: In addition to the above purchase of the motor vehicle you will also be required to determine the appropriate BDA at the end of June for depreciation and interest. 4 Received cash for services yet to be performed. The amount includes GST. Purchased office supplies paying cash. The amount includes GST. Treat the purchase of office supplies as an asset in the first instance. Office supplies on hand at the end of the month were valued at $1,200. In addition to the above transaction you will also be required to determine the appropriate BDA at the end of June. Received cash for services provided. The amount includes GST. 9 Paid wages for the previous three weeks work. Note a working week consists of 5 days and wages are always paid on Friday. Do not account for PAYE tax. In addition to the above transaction you will also be required to determine the appropriate BDA at the end of June. 21 Received cash from customer for an invoice dated the previous month. 21 Nelson withdrew cash from the business accounts 26 Provided services on credit terms. The amount includes GST. $11,220 $1,100 $4,433 25,000 2,500 22,990 FCILICICLJ TimmyJIVICU VICTICIDJYLUJUUL JUICII 1. Post the opening balances from Table 1 plus all the transaction from Table 2 for the month of June 2020 into the general ledger. 2. Record the balance day adjustments from Table 2 in the general journal 3. Post the balance day adjustments in the general ledger. 4. Prepare an Adjusted Trial Balance as at 30 June 2020 5. Prepare a Statement of Financial Performance and a Statement of Changes in Equity (correct format) for the year ended 30 June 2020. 6. Prepare a Statement of Financial Position (correct format and classification) as at 30 June 2020. Note: Even though you are required to prepare a Statement of Changes in Equity you are NOT required to close off revenue and expense accounts. Table 1: Opening Balances - Part A Nelson Enterprises - Trial Balance (Before Transactions and BDA) Debit Credit 900 Nelson Enterprises as at 31 May 2020 Acc. No. Account Name Banks 2,000 Accounts Receivables 51,010 Allowance for Doubtful Debts Office Supplies 1,500 Prepaid Insurance Prepaid Rent GST Receivable Motor Vehicle 79,000 Accumulated Depreciation - MV Accounts Payable Accrued Wages Accrued Interest Unearned Service Revenue GST Payable 15,984 19,056 28,000 40,000 10,000 17,500 GST Payable Fixed Interest Loan -9% Mortgage Loan Capital Retained Earnings Drawings Service Revenue Insurance Expense Rent Expense Supplies Expense Wages Expense Interest Expense Depreciation - Motor Vehicle 250,070 213,000 364.010 364.010 Amount Date Business transactions June 1 The owner of the business (Paul Nelson) invested an additional $10,000 of his own money into Nelson Enterprises. 1 Paid the yearly insurance premium. (treat as a prepayment in the first instance) The amount includes GST. $10,000 $3,630 Amount $10,000 $3,630 $22,000 Date Business transactions June The owner of the business (Paul Nelson) invested an additional $10,000 of his own money into Nelson Enterprises. Paid the yearly insurance premium. (treat as a prepayment in the first instance). The amount includes GST. In addition to the above transaction you will also be required to determine the appropriate BDA at the end of June. Purchased another Motor Vehicle for the business by borrowing the full amount with a 5-year fixed interest rate loan of 9%. Interest is paid quarterly and the first interest payment occurs on 1 September 2020. Base the accrued interest on the quarterly amount. The Motor Vehicle is to be depreciated at a rate of 40% p.a. over the next 5 years using the reduced balance method and has a residual value of $2,000. The amount includes GST. Note 1: Use the reduced balance approach illustrated in Slide 31 of the week 9 lecture. Note 2: Assume the opening balance of $79,000 in the motor vehicle account has already been depreciated at a rate of 40% p.a. for three of its five years useful life. Thus, you are required to depreciate the opening balance for the month of June 2020. These motor vehicles have a scrap value of $5000. Note 3: Show the above two depreciation calculations related to motor vehicles separately in the general journal and the general ledger. Note 4: Interest of the mortgage was last paid on 31 March 2020. Interest on the Mortgage Loan is calculated on a fixed rate of 6%. p.a. Note 5: Show the two interest calculations separately in the general journal and the general ledger. Note 6: In addition to the above purchase of the motor vehicle you will also be required to determine the appropriate BDA at the end of June for depreciation and interest. 4 Received cash for services yet to be performed. The amount includes GST. 5 Purchased office supplies paying cash. The amount includes GST. Treat the purchase of office supplies as an asset in the first instance. Office supplies on $11,220 $1,100 on the quarterly amount. The Motor Vehicle is to be depreciated at a rate of 40% p.a. over the next 5 years using the reduced balance method and has a residual value of $2,000. The amount includes GST. Note 1: Use the reduced balance approach illustrated in Slide 31 of the week 9 lecture. Note 2: Assume the opening balance of $79,000 in the motor vehicle account has already been depreciated at a rate of 40% p.a. for three of its five years useful life. Thus, you are required to depreciate the opening balance for the month of June 2020. These motor vehicles have a scrap value of $5000. Note 3: Show the above two depreciation calculations related to motor vehicles separately in the general journal and the general ledger. Note 4: Interest of the mortgage was last paid on 31 March 2020. Interest on the Mortgage Loan is calculated on a fixed rate of 6%. p.a. Note 5: Show the two interest calculations separately in the general journal and the general ledger. Note 6: In addition to the above purchase of the motor vehicle you will also be required to determine the appropriate BDA at the end of June for depreciation and interest. 4 Received cash for services yet to be performed. The amount includes GST. Purchased office supplies paying cash. The amount includes GST. Treat the purchase of office supplies as an asset in the first instance. Office supplies on hand at the end of the month were valued at $1,200. In addition to the above transaction you will also be required to determine the appropriate BDA at the end of June. Received cash for services provided. The amount includes GST. 9 Paid wages for the previous three weeks work. Note a working week consists of 5 days and wages are always paid on Friday. Do not account for PAYE tax. In addition to the above transaction you will also be required to determine the appropriate BDA at the end of June. 21 Received cash from customer for an invoice dated the previous month. 21 Nelson withdrew cash from the business accounts 26 Provided services on credit terms. The amount includes GST. $11,220 $1,100 $4,433 25,000 2,500 22,990