Prepare the reconciliation of operating profit to operating


Topic: Cash Flow Statements

QUESTION ONE - The account details are provided to you for Darwin Ltd for the year ending 30 June 2019 (with comparatives).

Darwin Ltd Statement of Profit and Loss and Other Comprehensive Income for the Year ending 30 June 2019

 

2018

2019

 

$

$

Sales for the Year (all on credit)

700 000

885 000

 

 

 

Less Expenses Incurred for Year

 

 

Cost of Goods Sold

200 000

240 000

Depreciation - Buildings

20 000

20 000

Depreciation - Plant

60 000

70 000

Doubtful Debts

30 000

40 000

Electricity and Rates

20 000

45 000

Income Tax

76 000

84 000

Interest Expense

10 000

11 000

Salaries and Wages Expense

200 000

270 000

Total Expenses

540 000

696 000

Net Profit Before Tax

160 000

189 000

Less Income Tax Expense

76 000

84 000

Net Profit for the Year

84 000

105 000

Darwin Ltd Statement of Financial Position as at 30 June 2019

 

2018

2019

 

$

$

Current Assets

 

 

Cash

176 000

239 000

Accounts Receivable

220 000

280 000

Allowance for Doubtful Debts

-30 000

-40 000

Inventory

90 000

100 000

Deferred Tax Asset

.....

4 000

 

456 000

583 000

 

 

 

Non Current Assets

 

 

Land

100 000

250 000

Buildings

400 000

400 000

Accumulated Depreciation - Buildings

-40 000

-60 000

Plant and Equipment

400 000

420 000

Accumulated Depreciation - Plant

-40 000

-40 000

 

820 000

970 000

TOTAL ASSETS

1276 000

1 553 000

Creo Ltd Statement of Financial Position as at 30 June 2019 (cont.)

 

2018

2019

 

$

$

Current Liabilities

 

 

Trade Creditors

80 000

70 000

Salaries and Wages Payable

10 000

20 000

Income Tax Payable

76 000

88 000

 

166 000

178 000

 

 

 

Non Current Liabilities

 

 

Long Term Loans

100 000

130 000

 

 

 

 

 

 

Shareholders' Funds

 

 

Share Capital

400 000

500 000

Revaluation Surplus

Nil

30 000

Retained Earnings

610 000

715 000

 

1 010 000

1 245 000

TOTAL LIABILITIES AND SHAREHOLDERS' FUNDS

1276 000

1 553 000

Additional Information

  • The trade creditors account is used for the purchase of inventory.
  • The company tax rate is 40%.

Required

(i) Prepare the statement of cash flows (operating activities only) showing all workings including the reconstruction of all relevant ledger accounts for the year ending 30 June 2019.

(ii) Prepare the reconciliation of operating profit to operating cash flows for the year ending 30 June 2019 showing all workings.

Topic: Statement of Cash Flows

QUESTION TWO - The following information is provided to you for Yee Ltd for the year ending 30 June 2019:

 

$

Accounts Receivable 1 July 2018

930 000

Accounts Receivable 30 June 2019

840 000

Trade Creditors 1 July 2018

270 000

Trade Creditors 30 June 2019

330 000

Tax Payable 1 July 2018

150 000

Tax Payable 30 June 2019

60 000

Cost of Goods Sold

1 350 000

Bad Debts Expense

165 000

Discount received for early payment to suppliers

90 000

Credit Sales for the Year

3 300 000

Tax Expense

15 000

Rent Expense Paid

51 000

Insurance Expense Paid

21 000

Dividends Paid

189 000

Inventory 1 July 2018

204 000

Inventory 30 June 2019

450 000

Discounts provided to customers for early payment

330 000

Sales Returns

300 000

Proceeds from sale of delivery vehicle

90 000

Required - Reconstructing any ledger accounts as required, prepare an extract of the cash flow statement for Yee Ltd for the year ending 30 June 2019 - operating activities only.

Topic: Statement of Cash Flows

QUESTION THREE- Horace Ltd has provided you with an extract of the statement of financial position (with comparatives) as at 30 June 2019 with comparatives.

Horace Ltd Statement of Financial Position (with comparatives) Extract as at 30 June 2019

 

2018

2019

Current Assets

 

 

Cash

125 000

175 000

Accounts Receivable

150 000

200 000

Less Provision for Doubtful Debts

-17 500

-25 000

Inventory

55 000

70 000

 

312 500

420 000

 

 

 

Non Current Assets

 

 

Land

325 000

437 500

Buildings

75 000

75 000

Less Accumulated Depreciation

-30 000

-45 000

Plant and Equipment

137 500

125 000

Less Accumulated Depreciation

-27 500

-60 000

 

480 000

532 500

TOTAL ASSETS

792 500

952 500

 

 

 

Current Liabilities

 

 

Trade Creditors

62 500

67 500

Accrued Expenses

12 500

5 000

Income Tax Payable

57 500

62 500

 

530 000

135 000

 

 

 

Non Current Liabilities

 

 

Long Term Loans

50 000

50 000

TOTAL LIABILTIES

182 500

185 000

Additional Information for the year ending 30 June 2019

  • profit after tax amounted to $75 000
  • non cash expenses/income included:
  • depreciation of plant and equipment $32 500
  • depreciation of buildings $40 000
  • profit on sale of plant and equipment $2 500

Required - Prepare a reconciliation of operating profit to operating cash flows for Horace Ltd for the year ending 30 June 2019.

Topic: Earnings per Share

QUESTION FOUR - For the year ending 30 June 2019, David Ltd reported net profit after tax amounting to $840 000.  At the beginning of the year 1 July 2018, David Ltd had 700 000 ordinary shares as well as a total of 96 000, $1, 15% cumulative preference shares outstanding. On 1 December 2018 the company issued another additional fully paid ordinary shares by way of a rights issue. The right provided an additional share for every 5 held and required payment of $1.10. The last cum rights share price was $1.40. The basic earnings per share for the year ended 30 June 2018 was $1.20.

Required

(i) Calculate the basic earnings per share for the year ending 30 June 2019.

(ii) Calculate the adjusted comparative earnings per share for 2018 to be disclosed in the financial statements for the year ending 30 June 2019.

Topic: Earnings per Share

QUESTION FIVE - For the year ending 30 June 2019, Woo Ltd earned a net profit after tax amounted to $1 500 000.  Dividends on 300 000 convertible, cumulative preference shares amounted to $600 000.  As at 1 July 2018, 500 000 fully paid ordinary shares had been issued.  There were no additional shares issued during the year ending 30 June 2019.

As at 1 July 2019 there were also:

  • $225 000 in convertible debentures, which incurred interest at a rate of 7.5% per year and which could be converted to 112 500 ordinary shares at the option of the debenture holder
  • 22 500 ordinary share options currently on issue with an exercise price of $1.05
  • 300 000 convertible, cumulative preference shares issued in 2016 which could be convertible into a total of 120 000 ordinary shares at the option of the preference shareholders

Additional Information - The company tax rate is 30% and the average market price for ordinary shares during the year was $1.50.

Required - Calculate diluted earnings per share for the year ending 30 June 2019. Show all workings and each of the five steps required in determining diluted earnings per share for the year ending 30 June 2019.

Topic:Translation of Foreign Operations

QUESTION SIX - On 1 July 2018 Neville Ltd, an Australian company acquired all of the issued shares of Oakie Ltd, a company based overseas. The presentation currency is in Australian dollars.  Relevant exchange rates for the year ending 30 June 2019 are as follows:

1 July 2018

FC$1.00 = A$0.65

Average Rate for the Year

FC$1.00 = A$0.80

Ending inventory acquired before year end

FC$1.00 = A$0.85

30 June 2019

FC$1.00 = A$0.95

FC = Foreign Currency

The statement of profit and loss and other comprehensive income for the year ending 30 June 2019 and statement of financial position as at 30 June 2019 for Oakie Ltd is provided below.  The financial statements are stated in the appropriate foreign currency (FC) which represents the functional currency of the foreign operation.

Oakie Ltd Statement of Profit and Loss and Other Comprehensive Income for year ending 30 June 2019

 

FC$

FC$

Sales Revenue

 

15 000

Less Cost of Goods Sold

 

 

Inventory 1 July 2018

2 000

 

Add Purchases

7 500

 

Less Inventory 30 June 2019

-1 125

 

Cost of Goods Sold

 

8 375

Gross Profit

 

 6 625

Selling Expenses

 

-600

Depreciation - Plant and Equipment

 

  -200

Operating Profit before income tax

 

5 825

Less Income tax expense

 

 -1 750

Net Profit after tax

 

4 075

Other Comprehensive Income

 

        -

Total Comprehensive Income

 

4 075

 

Oakie Ltd Statement of Changes in Equity for year ending 30 June 2019

 

Share Capital FC$

Retained Earnings FC$

Balance at 30 June 2018

6 000

500

From Statement of Profit and Loss and Other Comprehensive Income

 

         -

 

4 075

Balance at 30 June 2019

6 000

4 575

 

Oakie Ltd Statement of Financial Position as at 30 June 2019

 

 

FC$

Shareholders' Equity

 

 

Share Capital

 

6 000

Retained Earnings

 

4 575

Liabilities

 

 

Accounts payable

 

450

Long-term loan

 

  1 400

Total equity and liabilities

 

12 425

 

 

 

Current assets

 

 

Cash

 

3 000

Inventory

 

1 125

Non-current assets

 

 

Plant and equipment

 

 8 950

Less Accumulated depreciation

 

   -650

Total assets

 

12 425

Additional information:

  • All revenues and expenses were earned or incurred evenly throughout the year.
  • All plant and equipment was purchased using a long-term loan when the exchange rate was FC$1.00 = A$0.70.
  • Inventory was purchased evenly over the period, with the inventory on hand at the end of the year purchased over the quarter ending on 30 June.

Required -

(i) Prepare a translation of the statement of profit and loss and other comprehensive income from the functional currency into the presentation currency (Australian dollars).

(ii) Prepare a statement of changes in equity for Oakie Ltd from the functional foreign currency into the presentation currency (Australian dollars)

(iii) Calculate the gain (or loss) on the translation from the functional foreign currency into the presentation currency.

(iv) Prepare a translation of the statement of financial position of Oakie Ltd as at 30 June 2019 from its functional currency into the relevant presentation currency (Australian dollars).

Attachment:- Assignment Files.rar

Solution Preview :

Prepared by a verified Expert
Managerial Accounting: Prepare the reconciliation of operating profit to operating
Reference No:- TGS02416223

Now Priced at $40 (50% Discount)

Recommended (91%)

Rated (4.3/5)