In: Accounting
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 - Held to maturity investment (revaluation increment on 30/06/2017 after tax deduction) |
21,000 |
|
|
Asset Revaluation Reserve - Land (revaluation increment on 30 June 2017 - after tax deduction) |
168,000 |
|
|
Bank loan (unsecured –long-term repayable amount) |
210,000 |
|
|
Bank loan (unsecured –short-term repayable due) |
90,000 |
|
|
Buildings |
90,000 |
|
|
Buildings |
1,100,000 |
|
|
Carrying amount of plant and machinery sold |
24,000 |
|
|
Cash at bank |
800,000 |
|
|
Cost of sales |
2,924,000 |
|
|
Current tax liabilities |
141,000 |
|
|
Debentures held in Rome Ltd (mature on 30/4/2018) |
714,000 |
|
|
Deferred tax asset |
190,000 |
|
|
Deferred tax liability |
103,000 |
|
|
Deposits at call |
100,000 |
|
|
Dividends receivable |
8,000 |
|
|
Dividends revenue |
68,000 |
|
|
Final dividend declared – ord |
145,360 |
|
|
Final dividend declared - pref |
45,300 |
|
|
Final dividend payable |
190,660 |
|
|
Fixtures & fittings |
97,000 |
|
|
Fixtures & fittings - at cost |
243,520 |
|
|
Freight inwards |
90,000 |
|
|
Freight outwards |
115,000 |
|
|
General reserve |
780,000 |
|
|
Goodwill |
832,000 |
|
|
Held to maturity investment (at fair value) |
145,000 |
|
|
Income tax expense |
401,000 |
|
|
Interest expense |
74,000 |
|
|
Interest payable |
19,000 |
|
|
Interest revenue |
30,000 |
|
|
Interim dividend paid - ord |
109,020 |
|
|
Inventories |
1,850,000 |
|
|
Land (at fair value) |
1,476,000 |
|
|
Loan to Jets Ltd (due on 30/6/2025) |
420,000 |
|
|
Mortgage loan (secured over land and buildings – due 30/9/2022) |
504,000 |
|
|
Ordinary shares, fully paid |
3,634,000 |
|
|
Other administrative expense |
360,000 |
|
|
Other expenses |
137,000 |
|
|
Other selling expense |
220,000 |
|
|
Patents and trademarks |
145,000 |
|
|
Plant & machinery |
226,000 |
|
|
Plant & machinery - at cost |
884,000 |
|
|
Preference shares, fully paid |
226,500 |
|
|
Prepayments |
50,000 |
|
|
Proceeds on sale of plant and machinery |
50,000 |
|
|
Provision for annual leave |
62,000 |
|
|
Provision for long service leave - long term liable |
134,000 |
|
|
Provision for long service leave -short term liable |
85,000 |
|
|
Retained earnings as at 1/7/2016 |
850,000 |
|
|
Sales returns |
32,000 |
|
|
Sales revenue |
6,968,340 |
|
|
Sales staff salaries and commission expense |
750,000 |
|
|
Sundry revenue |
46,200 |
|
|
Total Asset revaluation reserve as at 1/7/2016 |
364,000 |
|
|
Transfer to general reserve |
60,000 |
|
|
Underwriting commission and other share issue costs |
37,000 |
|
|
Total |
15,991,200 |
15,991,200 |
Prepare a statement of profit or loss and other comprehensive income for Timber Ltd for the year ended 30 June 2017 (classify expenses by functions). Cross reference all workings
| Timber Ltd | ||
| Statement of Profit or Loss and Other Comprehensive Income | ||
| For the year ended 30/06/2017 | ||
| Reference # | ||
| Revenue | ||
| Cost of sales | ||
| Gross profit | ||
| Other revenue | ||
| Other income (loss) | ||
| Selling expenses | ||
| Administrative expenses | ||
| Other expenses | ||
| Finance costs | ||
| Profit before income tax | ||
| Income tax expense | ||
| Profit for the period | ||
| Other comprehensive income: | ||
| Items that will not be reclassified to profit or loss | ||
| Gain arising during the year on revaluation of land | ||
| Gain arising during the year on investments in equity instruments | ||
| Income tax relating to items not reclassified | ||
| Other comprehensive income during the year, net of tax | ||
| Total comprehensive income for the year | ||
| Timber Ltd | |||
| Statement of Profit and Loss and Other Comprehensive Income | |||
| for the year ended 30/06/2017 | |||
| Account names | Ref # | $ | $ |
| Revenue | A | 69,36,340 | |
| Cost of sales | -29,24,000 | ||
| Gross profit | 40,12,340 | ||
| Other revenue | B | 144200 | |
| Other income (loss) | C | 50000 | 42,06,540 |
| Selling expenses | D | -1040000 | |
| Administrative expenses | E | -1065000 | |
| Other expenses | F | -288000 | |
| Finance costs | -74000 | -2467000 | |
| Profit before income tax | 17,39,540 | ||
| Income tax expense | -4,01,000 | ||
| Profit for the period | 13,38,540 | ||
| Other comprehensive income: | |||
| Items that will not be reclassified to profit or loss | |||
| Final dividend declared – ord | -1,45,360 | ||
| Final dividend declared - pref | -45,300 | ||
| Interim Dividend paid - ordinary | -1,09,020 | -2,99,680 | |
| Gain arising during the year on revaluation of land | |||
| Gain arising during the year on investments in equity instruments | |||
| Income tax relating to items not reclassified | |||
| Other comprehensive income during the year, net of tax | |||
| Total comprehensive income for the year | 10,38,860 | ||
| Timber Ltd | |||
| Balance Sheet as on 30th June, 2017 | |||
| Account names | Ref # | $ | $ |
| SOURCES OF FUNDS | |||
| 1) Owned Funds | |||
| Share Capital | 3634000 | ||
| Preference Shares fully paid | 226500 | ||
| General Reserve | 780000 | ||
| Less: Transfer | -60000 | 720000 | |
| Retained earnings as at 1/7/2016 | 850000 | ||
| Add: Profits during the year | 10,38,860 | 18,88,860 | |
| Total Asset revaluation reserve as at 1/7/2016 | 364000 | ||
| Asset Revaluation Reserve | 21000 | 385000 | |
| 2) Borrowed Funds | |||
| 5% Debentures | 60000 | ||
| Bank loan (unsecured –long-term) | 210000 | ||
| Bank loan (unsecured –short-term) | 90000 | ||
| Mortage Loan | 504000 | 864000 | |
| Total Capital Employed | 7718360 | ||
| APPLICATION OF FUNDS | |||
| Fixed Assets | |||
| Land | 1476000 | ||
| Asset Revaluation Reserve - Land | -168000 | 1308000 | |
| Buidings | 1100000 | ||
| Less: Accumulated depreciation | -90000 | 1010000 | |
| Fixtures & fittings - at cost | 2,43,520 | ||
| Less: Accumulated depreciation | -97000 | 146520 | |
| Plant & machinery - at cost | 884000 | ||
| Less: Accumulated depreciation | -226000 | 658000 | |
| Patents & Trade Marks | 145000 | ||
| Less: Accumulated amortisation | -45000 | 100000 | |
| Goodwill | 832000 | ||
| Accumulated impairment loss – goodwill | -210000 | 622000 | |
| Investments | |||
| Debentures held in Rome Ltd | 714000 | ||
| Deposits at call | 100000 | ||
| Held to maturity investment (at fair value) | 145000 | ||
| Accounts Receivable | 850000 | ||
| Allowance for doubtful debts | -71500 | ||
| Net Accounts Receivables | 778500 | ||
| Cash at Bank | 800000 | ||
| Inventories | 1850000 | ||
| Deferred Tax Asset | 190000 | ||
| Dividends receivable | 8000 | ||
| Loan to Jets Ltd | 420000 | ||
| Prepayments | 50000 | ||
| Total Current Assets | G | 4096500 | |
| Less: | |||
| Current Liabilities | |||
| Accounts Payable | 447000 | ||
| Current Tax Liabilities | 141000 | ||
| Deferred tax liability | 103000 | ||
| Final dividend payable | 1,90,660 | ||
| Interest Payable | 19000 | ||
| Provision for annual leave | 62000 | ||
| Provision for long service leave - long term liable | 1,34,000 | ||
| Provision for long service leave -short term liable | 85,000 | ||
| H | 11,81,660 | ||
| Net Current Assets | G-H | 29,14,840 | |
| TOTAL NET ASSETS | 7718360 | ||
| Workings | |||
| Selling expenses | D | $ | |
| Advertising expense | 70000 | ||
| Other selling expense | 220000 | ||
| Sales staff salaries and commission expense | 750000 | ||
| 1040000 | |||
| Administrative expenses | E | $ | |
| Administrative staff salaries expense | 590000 | ||
| Freight Outwards | 115000 | ||
| Other Admin expenses | 360000 | ||
| 1065000 | |||
| Other expenses | F | ||
| Freight inwards | 90000 | ||
| Other expenses | 137000 | ||
| Underwriting commission and other share issue costs | 37000 | ||
| Carrying amount of plant and machinery sold | 24000 | ||
| 288000 | |||
| Revenue | A | ||
| Sales | |||
| Less: Returns | 69,68,340 | ||
| -32000 | 69,36,340 | ||
| Other revenue | B | ||
| Dividends Revenue | |||
| Sundry Revenue | 68000 | ||
| Interest Revenue | 46200 | 144200 | |
| 30000 | |||
| Other income (loss) | C | ||
| Proceeds on sale of plant and machinery | 50000 | ||