Question

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

Total Liabilities & Equity

$4,200,850

Assets

Cash

6,000

Accounts Receivable

3,350

Office Supplies

1,500

Inventory

1,990,000

Investment Property

1,000,000

Land & Buildings

1,200,000

Total Assets

$4,200,850

Knowing that you are an experienced accountant, the Board of Directors asks you to review the Balance Sheet and other data. Your interviews disclose the following:

The mortgage is payable monthly for another ten years. A review of the amortisation schedule shows that the balance on 30 June 2018 will be $350,000.

The widgets come with a one-year warranty. The $13,200 provision shown on the balance sheet was calculated with the following facts:

Sales for the year ending 30 June 2017 were 100,000 units.

2% of total sales are estimated to require warranty work at an average cost of $3 per unit.

Actual repairs incurred for units sold in the year just ended were $1,800.

For the next financial year (beginning on 1 July 2017), the bookkeeper estimated sales to be 150,000 units with the same 2% defect rate and $3 repair cost per unit.

The 9% $100,000 face value debentures, due in four more years, were issued when the market interest rate was 6%. They pay interest semi-annually on 1 March and 1 September. The balance shown in the Balance Sheet is the correct balance after the 1 March payment. The bookkeeper, new to the job and unfamiliar with the effective interest rate method, failed to journalise an adjusting entry on 30 June 2017.

The $300,000 balance in Revaluation Reserve was calculated as follows:

In the unadjusted trial balance, the Revaluation Reserve account contained the correct balance (prior to revaluation) of $400,000.

Investment Property was revalued from $800,000 to $1,000,000.

Land & Buildings were revalued from $1,500,000 to $1,200,000.

The bookkeeper forgot to reconcile the bank account, so the $6,000 cash balance shown on the Balance Sheet is incorrect. The 30 June bank statement showed a $7,200 balance. Deposits in transit were $800 and outstanding cheques totalled $1,200. Also, the bank incorrectly recorded a $80 June deposit as $800.

Mihir Ltd accounts for inventory using FIFO under the periodic system. 25,000 widgets were on hand as at 30 June 2017. An additional 10,000 units had been purchased at $5 each, FOB shipping point, and were in transit on 30 June. The $1,990,000 balance for Inventory in the Balance Sheet was calculated as follows:

Beginning inventory (as at July 1, 2016) of 20,000 widgets at $2 each;

150,000 units purchased at $3 per unit during the first quarter of the year;

200,000 units purchased at $4 per unit during the second quarter of the year;

200,000 units purchased at $3 per unit during the third quarter of the year;

20,000 units purchased at $5 per unit during the fourth quarter of the year, including the in-transit items.

Required:

For 30 June 2017, prepare a correct Balance Sheet . Ignore GST. (Hint: The balance for Retained Earnings will be a plug, so there is no need to separately reconcile the retained earnings balance.)

Homework Answers

Answer #1

Mihir Ltd.

Balance Sheet for the year ending 30 June 2017

Liabilities      
Mortgage payable $380000
Accounts payable $23000
Warranty provision $6000
Accrued expenses payable $15000
Debentures payable $101500 $525500
Equity
Share capital $1000000
Retained earnings (bal. fig.) $500340
Revaluation reserve $300000 $1800430
Total liabilities and equity $2325930
Assets
Cash $6080
Accounts receivable $3350
Office supplies $1500
Inventory $115000
Investment property $1000000
Land and buildings $1200000
Total assets $2325930

Working Notes :

1. Bank balance = 7200 + 800 - 1200 - 720 = 6080.

2. Inventory as per FIFO = 5000 units @ $3/- and 20000 units @ $5/- = $115000

3. Debentures payable = 103000 less (interest upto June 2017) 1500 = 101500

4. Warranty provision = 2% of sales = 2000 units @ $3/unit = $6000

5. Revaluation reserve = 400000 + 200000 - 300000 = 300000

6. Retained earnings is the balancing figure.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
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...
For the financial year ending 30 June 2020, Malkin Ltd has some liability issues for which...
For the financial year ending 30 June 2020, Malkin Ltd has some liability issues for which it seeks your help: The company sells widgets and provides a one-year warranty. 100,000 widgets were sold for the year ended 30 June 2020, and 150,000 are expected to be sold next year. 2% of units sold are estimated to require warranty work, at an average cost of $3 per unit. Actual repairs incurred for units sold in the year just ended were $1,800....
Question 1: (25 marks) On 1 July 2015, I Ltd. acquired a 30% interest in one...
Question 1: On 1 July 2015, I Ltd. acquired a 30% interest in one of its suppliers, G Ltd., at a cost of 13,650. The directors of I Ltd. believe they exert 'significant influence' over G Ltd. The equity of G Ltd. at acquisition was: Share capital (20000 shares) $20,000 Retained earnings $10,000 All the identifiable assets and liabilities of G Ltd. at 1 July 2015 were recorded at fair value except for some depreciable non-current assets with a fair...
Tem Ora Ltd supplied the following information on its shareholders’ equity as at 30 June 2015....
Tem Ora Ltd supplied the following information on its shareholders’ equity as at 30 June 2015. Tem Ora Ltd Balance Sheet as at 30 June 2015 (extract) Shareholders’ equity $ $ Capital (400,000 ordinary shares paid to $ 1.00) 400,000 Capital (100,000 7% preference shares paid to $2.00 each) 200,000 Retained earnings 165,000 Dividend equalisation reserve 150,000 Total shareholders’ equity 915,000 Additional information: Profit after tax for the year ended 30 June 2016 was $250,000; On 29 July 2015, buildings...
The bookkeeper for Riverbed Company has prepared the following balance sheet as of July 31, 2017....
The bookkeeper for Riverbed Company has prepared the following balance sheet as of July 31, 2017. RIVERBED COMPANY BALANCE SHEET AS OF JULY 31, 2017 Cash $ 72,350 Notes and accounts payable $ 47,350 Accounts receivable (net) 43,850 Long-term liabilities 78,350 Inventory 63,350 Stockholders’ equity 158,850 Equipment (net) 84,000 $284,550 Patents 21,000 $284,550 The following additional information is provided. 1. Cash includes $1,200 in a petty cash fund and $12,050 in a bond sinking fund. 2. The net accounts receivable...
The bookkeeper for Ayayai Company has prepared the following balance sheet as of July 31, 2017....
The bookkeeper for Ayayai Company has prepared the following balance sheet as of July 31, 2017. AYAYAI COMPANY BALANCE SHEET AS OF JULY 31, 2017 Cash $ 70,290 Notes and accounts payable $ 45,290 Accounts receivable (net) 41,790 Long-term liabilities 76,290 Inventory 61,290 Stockholders’ equity 156,790 Equipment (net) 84,000 $278,370 Patents 21,000 $278,370 The following additional information is provided. 1. Cash includes $1,200 in a petty cash fund and $12,940 in a bond sinking fund. 2. The net accounts receivable...
Question 1: (25 marks) On 1 July 2015, I Ltd. acquired a 30% interest in one...
Question 1: On 1 July 2015, I Ltd. acquired a 30% interest in one of its suppliers, G Ltd., at a cost of 13,650. The directors of I Ltd. believe they exert 'significant influence' over G Ltd. The equity of G Ltd. at acquisition was: Share capital (20000 shares) $20,000 Retained earnings $10,000 All the identifiable assets and liabilities of G Ltd. at 1 July 2015 were recorded at fair value except for some depreciable non-current assets with a fair...
Section 1 – Presentation of financial statements (10 MARKS) The adjusted trial balance of Timber Ltd...
Section 1 – Presentation of financial statements The adjusted trial balance of Timber Ltd as at 30 June 2017 is as follows:     Timber Ltd     Debit     Credit         $          $ Account names 5% debentures – due 30/11/2017(secured over inventories) 60,000 Accounts payable 447,000 Accounts receivable 850,000 Accumulated amortisation – patents & trademarks 45,000 Accumulated depreciation - Accumulated impairment loss – goodwill 210,000 Administrative staff salaries expense 590,000 Advertising expense 70,000 Allowance for doubtful debts 71,500 Asset Revaluation Reserve...
On 1 January 20X0, Zed Ltd acquired 90 % of the share capital of Ned Ltd...
On 1 January 20X0, Zed Ltd acquired 90 % of the share capital of Ned Ltd for $900 000 cash. At that date, the equity section of Ned Ltd’s balance sheet was as follows:    $ Share capital                                         700 000 Retained profits                                      50 000 Asset revaluation reserve 100 000 Assume all assets and liabilities were recorded at their fair values, except for a piece of equipment recorded at $50 000 but Zed Ltd considers it to have a fair value...