Question

In: Accounting

Weez Ltd is a GST registered retailer of widgets with monthly accounting periods. The following is...

Weez Ltd is a GST registered retailer of widgets with monthly accounting periods. The following is the unadjusted trial balance at 28 February 2018, the end of the financial year. Important: the balances in the temporary accounts reflect February events only. No other account names are available in the General Ledger. Additional information follows the trial balance.

Weez Ltd

Unadjusted Trial Balance

28 February 2018

Account Name

DR Balance

Account Name

CR Balance

Cash

$37,000

Acc. Depreciation, Equipment

$1,200

Accounts Receivable

20,000

Accounts Payable

12,400

Allowance for Doubtful Accts

500

Warranty Payable

28,000

Interest Receivable

1,000

GST Clearing

2,000

Prepaid Rent

20,250

Salaries Payable

0

Inventory

50,000

PAYE Payable

0

Investment in Debentures

100,000

Income Tax Payable

0

Computer Equipment

12,000

Retained Earnings

8,650

Dividends Declared

5,000

Foreign Currency Reserve

12,000

Salaries Expense

28,800

Share Capital

90,000

Cost of Goods Sold

0

Gain on Sale of Building

16,000

Sales Returns & Allowances

200

Sales Revenue

120,000

Sales Discounts

800

Interest Revenue

0

Bad Debt Expense

0

Other Operating Expenses

4,200

Interest Expense

500

Warranty Expense

0

Rent Expense

0

Depreciation Expense, Equipment

0

Income Tax Expense

0

OCI Loss on Foreign Currency

____10,000

_________

     Total

$290,250

     Total

$290,250

Additional Information:

  1. The recoverable amount of the $20,000 of accounts receivable shown on the unadjusted trial balance is $18,000.
  2. The investment in debentures pay interest quarterly at a 6% annual rate. The next interest payment date is 1 March 2018.
  3. In October 2017, Weez Ltd prepaid its store rent for the entire year, effective the beginning of November 2017. The yearly rent is $31,050, including GST.
  4. The computer equipment has a useful life of five years, a residual value of $1,000, and is being depreciated using the declining balance method at 2X the straight-line rate. The balance in Accumulated Depreciation represents three months of depreciation. (Weez Ltd calculates a 12 month block of depreciation and then apportions the expense monthly.)
  5. Dividends of $5,000 were declared and paid to Weez Ltd shareholders in February.
  6. The February payroll totals $32,000 for 20 days of work for that month. The 20 days include two days worked the end of February that will be paid in March. Included in the $32,000 is $8,000 of PAYE and other withholdings.
  7. Weez Ltd uses the periodic inventory system and debits Inventory for all of its merchandise purchases. It then counts the inventory remaining at the end of each month and applies FIFO in order to calculate Cost of Goods Sold for the month. The $50,000 balance of Inventory on the trial balance (shown net of GST) consists of the following:
  • Beginning inventory (as at 1 February 2018) of 2,000 widgets at $2 each;
  • 6,000 units purchased at $3 each on 10 February;
  • 10,000 units purchased at $2.50 each on 16 February;
  • 1,000 units purchased at $3 each on 25 February.

An inventory count on 28 February showed that 1,500 widgets remained on hand.

  1. The inventory count did not include the items shipped as the result of a 27 February sale of 500 widgets at $11.50 each, including GST, terms 2/10 net 30. Weez Ltd shipped the widgets on 28 February, FOB shipping point, to arrive at the buyer’s place of business in early March. Weez Ltd has not yet recorded the sale.
  2. Weez Ltd offers a one year warranty and estimates that as at 28 February, the amount owing for the next 12 months is $30,000. GST does not apply to warranty work.
  3. Income tax payable is estimated at 30% of pre-tax profit.

Required:

Prepare a Statement of Comprehensive Income for Weez Ltd for the month ending 28 February 2018

Solutions

Expert Solution

Weez Ltd.
Adjusting Journal Entries
28-Feb-18
Account Title Debit Credit
i.Bad debt expense 2500
Allowance for Doubtful Accts 2500
(Additional allowance created to reflect actual receivables)
ii.Interest Receivable 500
Interest Revenue 500
(Feb.2018 Interest on debentures---100000*6%*1/12)
iii.Rent Expense 2588
Prepaid Rent 2250
GST clearing 338
(31050/12)-(20250/9)=338--GST on rent
iv.Depreciation Expense, Equipment 400
Acc. Depreciation, Equipment 400
(12000*40%/12)
v.Retained Earnings 5000
Dividends Declared 5000
(Dividends declared & paid)
vi.Salaries Expense 32000
Salaries Payable 24000
PAYE Payable 8000
(accrual of Feb 2018 payroll)
vii.Cost of Goods Sold 45750
Inventory 45750
(50000-(1000*3)-(500*2.50)--FIFO
viii.Accounts Receivable(500*11.50) 5750
Sales Revenue 5000
GST clearing(5750/115*15) 750
Cost of Goods Sold 1250
Inventory 1250
(500*2.50)
ix. Warranty expense 2000
Warranty Payable 2000
(30000-28000)
Income Tax Expense 6154
Income Tax Payable 6154
(as per income statement)
Trial Balance
28-Feb-18 Unadj. Unadj.
Account Name Debit Adj. Adj. Bal. Account Name Credit Adj. Adj. Bal.
Cash 37000 37000 Acc. Depreciation, Equipment 1200 400 1600
Accounts Receivable 20,000 5,750 25750 Accounts Payable 12,400 12400
Allowance for Doubtful Accts 500 500 Allowance for Doubtful Accts 2500 2500
Interest Receivable 1,000 500 1500 Warranty Payable 28,000 2,000 30000
Prepaid Rent 20,250 -2,250 18000 GST Clearing 2,000 1,088 3088
Inventory 50,000 -47,000 3000 Salaries Payable 0 24000 24000
Investment in Debentures 100,000 100000 PAYE Payable 0 8000 8000
Computer Equipment 12,000 12000 Income Tax Payable 0 6154 6154
Dividends Declared 5,000 -5,000 0 Retained Earnings 8,650 -5000 3650
Salaries Expense 28,800 32,000 60800 Foreign Currency Reserve 12,000 12000
Cost of Goods Sold 0 47000 47000 Share Capital 90,000 90000
Sales Returns & Allowances 200 200 Gain on Sale of Building 16,000 16000
Sales Discounts 800 800 Sales Revenue 120,000 5000 125000
Bad Debt Expense 0 2500 2500 Interest Revenue 0 500 500
Other Operating Expenses 4,200 4200
Interest Expense 500 500
Warranty Expense 0 2000 2000
Rent Expense 0 2588 2588
Depreciation Expense, Equipment 0 400 400
Income Tax Expense 0 6154 6154
OCI Loss on Foreign Currency 10000 10000 _________
     Total 290250 44642 334892      Total 290250 44642 334892
Income Statement
Sales Revenue 125000
Less:
Sales Returns & Allowances 200
Sales Discounts 800
Net sales 124000
Less:Cost of Goods Sold 47000
Gross Income 77000
Less: Operating expenses:
Salaries Expense 60800
Bad Debt Expense 2500
Other Operating Expenses 4200
Warranty Expense 2000
Rent Expense 2588
Depreciation Expense, Equipment 400
Gain on sale of building -16000 56488
Operating income 20512
Add/(Less) Non-operating items:
Interest Expense -500
Interest Revenue 500 0
Pre-tax income 20512
Less:Income Tax Expense(20512*30%) 6154
Net Income 14358
Weez Ltd
Statement of Comprehensive Income  
for the month ending 28 February 2018
Beginning retained Earnings 8,650
Net Income for the month 14358
Less:Dividends Declared -5000
Ending Retained earnings 18,008
OCI Loss on Foreign Currency -10000
Ending comprehensive income 8,008

Related Solutions

Aussi World Ltd sells outdoor furniture settings. The company is not registered for GST. The accounting...
Aussi World Ltd sells outdoor furniture settings. The company is not registered for GST. The accounting records at 30 June 2019 reveal the following balances:                                                                                                                     $ Credit sales (for year)                                                                         1,070,000 Credit sales returns & allowances                                                           90,000 Accounts receivable                                                                               323,500 Allowance for doubtful debts (credit balance)                                         1,500 In the past, the company’s yearly bad debts expense had been estimated at 2% of credit sales. It was decided to compare that method with an...
Matt’s Landscaping Pty Ltd is registered for GST purposes. It accounts for GST on the accruals...
Matt’s Landscaping Pty Ltd is registered for GST purposes. It accounts for GST on the accruals basis and submits its Business Activity Statements monthly. Assume that all amounts in the question include GST when applicable. The business operates from Brisbane’s north-side and its main business is to design and establish new gardens at shopping centres and office parks, and to provide ongoing garden maintenance services to clients. During October 2018, Matt’s Landscaping Pty Ltd was involved in the following transactions:...
Shetland Ltd is a carpet retailing business. The business is registered for GST. Shetland Ltd uses...
Shetland Ltd is a carpet retailing business. The business is registered for GST. Shetland Ltd uses a periodic inventory system. The transactions for January 2019 are provided below. All transactions are inclusive of GST. The relevant customer and supplier account balances at 31 December, 2018 were: Accounts Receivable                            Accounts Payable S. Devine           $6,050                         D. Harms        $18,150 R. Burton           3,025 Jan 5     Sold inventory to B. Senton for $4,400, terms 2/7, n/30.         6     Purchased inventory from S. Warren for $2,750,...
Question 1: Mihir Ltd is a retailer of widgets. A part-time bookkeeper prepared the following Balance...
Question 1: Mihir Ltd is a retailer of widgets. A part-time bookkeeper prepared the following Balance Sheet as at 30 June 2017, the end of the financial year. The company’s Board of Directors suspects adjustments/corrections may be necessary. Mihir Ltd Balance Sheet For the Year Ending June 30, 2017 Liabilities Mortgage Payable $380,000 Accounts Payable 23,000 Warranty Provision 13,200 Accrued Expenses Payable 15,000 Debentures Payable 103,000 $534,200 Equity Share Capital 1,000,000 Retained Earnings 2,366,650 Revaluation Reserve 300,000 3,666,650 Total Equity...
Tennis Shop Ltd (the “Shop”), a GST registered company, has a 30 June year-end. Stock takes...
Tennis Shop Ltd (the “Shop”), a GST registered company, has a 30 June year-end. Stock takes are performed at the end of each quarter, i.e., 30 June is the end of the second quarter. Included in the general ledger are accounts for Cash, Accounts Receivable, Inventory, Accounts Payable, GST Clearing, Discounts Lost, Cost of Goods Sold, Sales, Sales Discounts, Sales Returns and Allowances. All suppliers are GST registered, as well. The Shop has been operating under the gross purchases method...
1. Parent Ltd(P) and Sub Ltd(S) are a consolidated group for financial accounting purpose. Ignore GST...
1. Parent Ltd(P) and Sub Ltd(S) are a consolidated group for financial accounting purpose. Ignore GST in this question. Both companies use the perpetual inventory system. On the first day of the current year P bought $10,000 worth of inventory on credit. A few months later it sold $1000 of this inventory to S for $3000 on credit. By the end of the current year, S had sold 90% of this inventory to an outsider for $2100. Select the correct...
Illustrative Example: Retailer Ltd: Preparation of financial statements Retailer Ltd, recorded the following transactions during the...
Illustrative Example: Retailer Ltd: Preparation of financial statements Retailer Ltd, recorded the following transactions during the year: Rm Sales :57,959 Other non-current assets : 6,304 Cost of sales :55,033 Trade and other receivables: 1,607 Trade and other payables: 8,568 Administration expenses :1,860 Loans (due after one year) :10,711 Loans (due within one year): 2,826 Other current liabilities :7,901 Property, plant and equipment: 17,978 Goodwill :2,874 Finance income :29 Other current assets: 4,246 Cash :3,082 Share capital and premium :5,502 Pension...
Accounting for share issues On 1 February 2017, Beach Supplies Ltd was registered and issued a...
Accounting for share issues On 1 February 2017, Beach Supplies Ltd was registered and issued a prospectus inviting applications for 2,000,000 shares, at an issue price of $3.50, payable as follows: $1.00 on application $1.50 on allotment (payment due within 1 month of allotment) $0.60 on first call $0.40 on final call The issue is underwritten at a commission of $30,000. By 28 February 2017, applications had been received for 1,900,000 shares. On 3 March, shares are allotted, and the...
Accounting for share issues On 1 February 2017, Beach Supplies Ltd was registered and issued a...
Accounting for share issues On 1 February 2017, Beach Supplies Ltd was registered and issued a prospectus inviting applications for 2,000,000 shares, at an issue price of $3.50, payable as follows: $1.00 on application $1.50 on allotment (payment due within 1 month of allotment) $0.60 on first call $0.40 on final call The issue is underwritten at a commission of $30,000. By 28 February 2017, applications had been received for 1,900,000 shares. On 3 March, shares are allotted, and the...
The following information relates to the inventory of Margaret’s Megamart Ltd during December. Ignore GST. Date...
The following information relates to the inventory of Margaret’s Megamart Ltd during December. Ignore GST. Date Units Units cost Total cost 1/12 Beginning inventory 700 $ 12.00 $ 8,400 10/12 Purchase 500 12.60 6,300 15/12 Purchase 300 13.20 3,960 23/12 Purchase 500 14.00 7,000 Totals 2,000 $25,660 Margaret’s Megamart Ltd uses the periodic inventory system. A physical count on 31 December verified that 650 units were on hand. Required: a) Determine the Ending inventory and Cost of Sales for the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT