What's new

Help PHC Bot

Sej

Honorary Poster
The trial balance of Xyz Corporation prior to the closing of its accounts for the fiscal year ended September 30, 2021 is as follows:


DebitCredit
Cash225,000
Accounts receivable936,000
Allowance for doubtful accounts31,900
Notes receivable155,000
Merchandise Inventory568,900
Furniture and equipment618,000
Accumulated depreciation187,500
Goodwill300,000
Accounts payable536,000
Notes payable100,000
Ordinary Share Capital1,000,000
Retained earnings552,500
Sales3,728,200
Sales returns and allowances47.600
Purchases2,159,300
Purchase returns and allowances36,500
Advertising expense96,100
Sales salaries288,500
Commission expense152.000
Miscellaneous selling expense29,900
Rent expense130,000
Office salaries197,200
Light and water15,000
Insurance expense10,800
Taxes and licenses47,800
General expenses163,400
Interest expense41.200
Interest income9,100
6,181,7006,181,700


Your examination of the company's accounts has indicated the need for adjustments based on the following information:


1. The Cash account includes a customers check for P15,000 deposited on September 25, 2021 but returned by the bank on September 29, 2021 for lack of countersignature.
No entry was made by the company for the
return of the check or its redeposit on October 5, 2021.
2. Based on assessment of expected credit losses and grouping receivables with similar characteristics, the allowance for doubtful accounts should be adjusted to 5% of the customers' outstanding balance as of September 30, 2021.
3. A physical inventory taken of the merchandise stock as of the close of the fiscal year amounted to P601,200.
4. A purchase of merchandise, FOB shipping point, for which goods costing P50,000 were in transit on September 30, 2021, was neither taken as a liability nor included in the inventory on that date.
5. Goods received on consignment, still unsold, were included in the inventory at the agreed selling price of P30,000,
6. The merchandise inventory at September 30, 2020 was correctly stated.
7. On July 1, 2021, equipment acquired on October 1, 2018 with a carrying value of P32,000 on September 30, 2020, was sold for P35,000 cash. The sales proceeds were credited to the furniture and equipment account.
8. Depreciation for the fiscal year 2020-2021 has not yet been recorded.
Depreciation rate is 10%, except for right-of-use assets.
9. An Insurance policy was renewed on the inventory and equipment on April
1, 2021 with the annual ρrémíùm of P8,400 pald on that date.
10. The rent expense account represents annual rent ρáíd for store and office space covering the period November 1, 2020 through October 31, 2021.
The lease term of five years commences on November 1, 2020.
The
lessor's implicit rate is unknown, but XYZ's incremental borrowing rate at the lease commencement was 10%. Straight-line depreciation is used for right-of-use assets.
11. The one-year Note Payable of P100,000 was discounted at the bank at
12% on August 31, 2021.
12. The Goodwill account was set up by a credit to Retained Earnings under a resolution of the board of directors.
 
Solution
Based on the information provided, let's go through each adjustment that needs to be made to the trial balance of XYZ Corporation.

1. The Cash account includes a customer's check for P15,000 deposited on September 25, 2021, but returned by the bank on September 29, 2021, for lack of countersignature. No entry was made by the company for the return of the check or its redeposit on October 5, 2021.
- To adjust for this, we need to deduct the P15,000 from the Cash account.

Adjusted Cash: P210,000 (P225,000 - P15,000)

2. Based on the assessment of expected credit losses and grouping receivables with similar characteristics, the allowance for doubtful accounts should be adjusted to 5% of the customers' outstanding balance as of September...
Based on the information provided, let's go through each adjustment that needs to be made to the trial balance of XYZ Corporation.

1. The Cash account includes a customer's check for P15,000 deposited on September 25, 2021, but returned by the bank on September 29, 2021, for lack of countersignature. No entry was made by the company for the return of the check or its redeposit on October 5, 2021.
- To adjust for this, we need to deduct the P15,000 from the Cash account.

Adjusted Cash: P210,000 (P225,000 - P15,000)

2. Based on the assessment of expected credit losses and grouping receivables with similar characteristics, the allowance for doubtful accounts should be adjusted to 5% of the customers' outstanding balance as of September 30, 2021.
- To adjust for this, we need to calculate the new allowance for doubtful accounts and subtract it from the Accounts Receivable.

Customers' outstanding balance as of September 30, 2021: P936,000
Allowance for doubtful accounts (5% of outstanding balance): P46,800

Adjusted Accounts Receivable: P889,200 (P936,000 - P46,800)
Adjusted Allowance for Doubtful Accounts: P46,800

3. A physical inventory taken of the merchandise stock as of the close of the fiscal year amounted to P601,200.
- To adjust for this, we need to update the Merchandise Inventory account to reflect the correct value.

Adjusted Merchandise Inventory: P601,200

4. A purchase of merchandise, FOB shipping point, for which goods costing P50,000 were in transit on September 30, 2021, was neither taken as a liability nor included in the inventory on that date.
- To adjust for this, we need to include the cost of the goods in transit as both a liability and an addition to the Merchandise Inventory.

Liability for Goods in Transit: P50,000
Adjusted Merchandise Inventory: P651,200 (P601,200 + P50,000)

5. Goods received on consignment, still unsold, were included in the inventory at the agreed selling price of P30,000.
- To adjust for this, we need to remove the consignment goods from the inventory, as they are not owned by the company.

Adjusted Merchandise Inventory: P621,200 (P651,200 - P30,000)

6. The merchandise inventory at September 30, 2020, was correctly stated.
- No adjustment is needed for this item.

7. On July 1, 2021, equipment acquired on October 1, 2018, with a carrying value of P32,000 on September 30, 2020, was sold for P35,000 cash. The sales proceeds were credited to the furniture and equipment account.
- To adjust for this, we need to transfer the gain or loss from the sale of equipment to the Retained Earnings account.

Gain on Sale of Equipment: P3,000 (P35,000 - P32,000)

Adjusted Retained Earnings: P555,500 (P552,500 + P3,000)

8. Depreciation for the fiscal year 2020-2021 has not yet been recorded. Depreciation rate is 10%, except for right-of-use assets.
- To adjust for this, we need to calculate the depreciation expense for the year and subtract it from the Furniture and Equipment account.

Depreciation Expense: P61,800 (10% of P618,000)

Adjusted Furniture and Equipment: P556,200 (P618,000 - P61,800)

9. An Insurance policy was renewed on the inventory and equipment on April 1, 2021, with the annual ρrémíùm of P8,400 ρáíd on that date.
- To adjust for this, we need to allocate the insurance expense over the fiscal year.

Insurance Expense: P2,800 (P8,400 / 3 months)

Adjusted Insurance Expense: P13,600 (P10,800 + P2,800)

10. The rent expense account represents annual rent ρáíd for store and office space covering the period November 1, 2020, through October 31, 2021. The lease term of five years commences on November 1, 2020. The lessor's implicit rate is unknown, but XYZ's incremental borrowing rate at the lease commencement was 10%. Straight-line depreciation is used for right-of-use assets.
- To adjust for this, we need to calculate the amount of rent expense for the current fiscal year and allocate it accordingly.

Rent Expense for fiscal year 2020-2021: P26,000 (P130,000 / 5 years)

Adjusted Rent Expense: P156,000 (P130,000 + P26,000)

11. The one-year Note Payable of P100,000 was discounted at the bank at 12% on August 31, 2021.
- To adjust for this, we need to record the discount on the Note Payable as interest expense.

Interest Expense: P12,000 (P100,000 * 12%)

Adjusted Interest Expense: P53,200 (P41,200 + P12,000)

12. The Goodwill account was set up by a credit to Retained Earnings under a resolution of the board of directors.
- No adjustment is needed for this item.

After making all the required adjustments, the adjusted trial balance for XYZ Corporation would be as follows:

AccountDebitCredit
Cash210,000
Accounts receivable889,200
Allowance for doubtful accounts46,800
Notes receivable155,000
Merchandise Inventory621,200
Furniture and equipment556,200
Accumulated depreciation187,500
Goodwill300,000
Accounts payable536,000
Notes payable100,000
Ordinary Share Capital1,000,000
Retained earnings555,500
Sales3,728,200
Sales returns and allowances47,600
Purchases2,159,300
Purchase returns and allowances36,500
Advertising expense96,100
Sales salaries288,500
Commission expense152,000
Miscellaneous selling expense29,900
Rent expense156,000
Office salaries197,200
Light and water15,000
Insurance expense13,600
Taxes and licenses47,800
General expenses163,400
Interest expense53,200
Interest income9,100
6,181,7006,181,700

Please note that the adjustments made above are based on the information provided, and it's always recommended to consult with an accounting professional for a comprehensive review of the financial statements.
 
Solution

Similar threads

Back
Top