ASIA 350- Final Exam Guide - Comprehensive Notes for the exam ( 29 pages long!)
Document Summary
Get access
Related Documents
Related Questions
Emerald Ltd, a manufacturing company, commenced operations on 1 July 2016 by issuing 350 000 $5.00 shares, payable in full on application on a first-come, first-served basis. By 31 July 2016 the shares were fully subscribed and duly allotted. There were share issue costs of $10 000. No additional shares were issued during the year ending 30 June 2017.
For the year ending 30 June 2018, the company recorded the following aggregate transactions:
$ | |
Sales | 5 120 000 |
Interest income | 34 000 |
Sundry income | 25 000 |
Cost of Sales | 2 465 000 |
Employee benefit expenses | 856 000 |
Depreciation expense | 244 000 |
Amortisation - franchise | 25 000 |
Rental expense | 120 000 |
Advertising expense | 147 000 |
Insurance expense | 48 000 |
Freight out expense | 110 000 |
Doubtful debts expense | 16 000 |
Interest expense | 36 000 |
Borrowing Costs | 9 000 |
Other expenses | 8 000 |
Income tax expense | 320 000 |
The following additional information was noted during the preparation of financial statements for the year ended 30 June 2018:
75 000 fully paid ordinary shares have been issued on 1 October 2017 at the price of $4.00.
$135 000 dividends (31.76 cents per share) were declared and paid during the 2018 financial year. A final dividend for 2018 of $51 850 was proposed but not recognised in the financial statements.
There was a gain of $20 000 from the cash flow hedge arrangement during the 2018 financial year. Any gain or loss associated with the cash flow hedge is directly recognised in equity. There was no previously recognised cash flow hedge reserve before the 2018 financial year.
$25 000 of bank loans is repayable within 1 year.
$90 000 of other loans is repayable within 1 year.
The employee benefits of $32 000 are expected to be settled wholly within 12 months.
Emerald Ltd measures inventory at the lower of cost and net realizable value and property, plant and equipment using a cost model.
The summarised balances are provided below:
Year-end balances, 30 June 2018 | $ |
Cash on hand | 960 000 |
Cash on deposit, at call | 82 000 |
Accounts Receivables | 665 000 |
Allowance for doubtful debts/ Impairments | 24 000 |
Other debtors | 27 000 |
Finished goods inventories, 30 June 2018 | 600 000 |
Work in Progress inventories 30 June 2018 | 105 000 |
Land | 94 000 |
Buildings | 230 000 |
Accumulated depreciation â buildings | 60 000 |
Plant and equipment | 1 385 000 |
Accumulated depreciation â plant and equipment | 330 000 |
Franchises | 140 000 |
Accumulated amortisation of franchise | 50 000 |
Goodwill | 620 000 |
Bank loans | 92 000 |
Other loans | 440 000 |
Accounts payable | 696 000 |
Provision for employee benefits | 116 000 |
Income tax payable | 35 000 |
Deferred tax liability | 140 000 |
Retained earnings, 30 June 2017 | 225 000 |
Dividends paid | 135 000 |
Cash flow hedge reserve (equity) | 20 000 |
Required:
For the year ending 30 June, 2018,
a) Using the pro forma table supplied in appendix B, prepare a preliminary trial balance for Emerald Ltd; (5 Marks)
b) Prepare a statement of profit or loss and comprehensive income for Emerald Ltd in accordance with the requirements of AASB 101. Emerald Ltd uses the single statement format for the statement of comprehensive income and classifies expenses by function within the statement; (18 marks)
c) Prepare a statement of changes in equity for Emerald Ltd in accordance with the requirements of AASB 101; (15 marks)
d) Prepare a statement of financial position for Emerald Ltd in accordance with AASB 101. Use the current/non-current presentation format; (17 marks)
e) Prepare appropriate notes to the accounts. (You do not need to prepare notes related to income taxes. Include the following note as note 1. You may optionally add accounting policies to this note): (25 marks).
â1. Summary of significant accounting policies
Basis of accounting
The financial report is a general purpose financial report which has been prepared on the historical cost basis, except where stated otherwise.
Statement of Compliance
The financial statements have been prepared in accordance with the requirements of the Corporations Act, Australian Accounting Standards which include Australian equivalents to International Financial Reporting Standards (AIFRSs) and AASB Interpretations. Compliance with AIFRSs ensures the financial statements and notes comply with International Financial Reporting Standardsâ
APPENDIX A: PRESENTATION REQUIREMENTS (Departures attract a penalty)
The hard copy of the assignment must be handed in to the lecturer in class. It is also required to be submitted through Turnitin by the due date;
It is worth 20% of the final grade but will be marked out of 100;
The assignment will be marked on the basis of a requirement of "suitable for publication", that is, the relevant statements/notes comprise an external report and each statement is to be presented on one page;
The assignment must be performed individually.
You are to employ an aggregated format whenever appropriate and consistent with provision of minimum line items prescribed in AASB101;
The financial statements and the notes are to be typed in 12 point font;
You are not to use specialized accounting software packages, such as are employed by professional accounting firms, to produce your financial reports;
You are to apply the âcost of salesâ method to the classification of expenses in the income statement (see AASB101 paras 97-105);
You are directed to use the current/non-current format for the statement of financial position (balance sheet) and supply a ânet assetsâ line item;
The notes are to be simplified equivalences to published reports; that means a list of constituent components of a given line item with their respective dollar amounts, not footnotes
Your hard copy assignment is to be collated in the following order:
Coversheet (optional for electronic version but mandatory, signed with ticked module and Turnitin ID, for hard copy), Part A followed by Part B (trial balance, statement of profit or loss comprehensive income, statement of changes in equity, statement of financial position, and notes to the accounts.
APPENDIX B
Emerald Ltd - Trial Balance as at 30 June 2018 | DR | CR |
Sales | $â000 | $â000 |
Interest income | ||
Sundry income | ||
Cost of sales | ||
Employee benefit expenses | ||
Depreciation expense | ||
Amortisation - franchise | ||
Rental expense | ||
Advertising expense (selling) | ||
Insurance expense | ||
Freight out expense | ||
Doubtful debts expense | ||
Interest expense | ||
Borrowing costs | ||
Other expenses | ||
Income tax expense | ||
Cash on hand | ||
Cash on deposit, at call | ||
Accounts Receivables | ||
Allowance for doubtful debts/ Impairments | ||
Other debtors | ||
Finished goods inventories, 30 June 2018 | ||
Work in Progress inventories 30 June 2018 | ||
Land | ||
Buildings | ||
Accumulated depreciation â buildings | ||
Plant and equipment | ||
Accumulated depreciation â plant and equipment | ||
Franchise | ||
Accumulated amortisation of franchise | ||
Goodwill | ||
Bank loans | ||
Other loans | ||
Accounts payable | ||
Provision for employee benefits | ||
Income tax payable | ||
Deferred tax liability | ||
Retained earnings, 30 June 2017 | ||
Dividends paid | ||
Cash flow hedge reserve | ||
Share capital | ||
Totals |
NIKE:
Need the following ratios to be calculated using the financial sheets copied at the bottom. Each ratio needs to be calculated using the information from 2016. Each ratio also needs to be broken down and illustrated by the step by step process. Finally, please include any and all observations for each ratio and analysis.
1) Common Size analysis
2) Common size vertical analysis & graph
3) Current Ratio
4) Quick Ratio
5) Cash Ratio
6) Inventory Turnover
7) Receivables Turnover
8) Total Asset Turnover
9) Fixed Asset Turnover
10) Gross profit margin
11) Operating Profit margin
12) Net profit margin
13) Return on total assets
14) return on equity
15) basic earning power
16) Deb/net worth ratio
17) debt ratio
18) DuPont System
19) Times-interest-earned
Balance Sheet:
Consolidated Balance Sheets - USD ($) $ in Millions | May 31, 2017 | May 31, 2016 |
Current assets: | ||
Cash and equivalents | $ 3,808 | $ 3,138 |
Short-term investments | 2,371 | 2,319 |
Accounts receivable, net | 3,677 | 3,241 |
Inventories | 5,055 | 4,838 |
Prepaid expenses and other current assets | 1,150 | 1,489 |
Total current assets | 16,061 | 15,025 |
Property, plant and equipment, net | 3,989 | 3,520 |
Identifiable intangible assets, net | 283 | 281 |
Goodwill | 139 | 131 |
Deferred income taxes and other assets | 2,787 | 2,422 |
TOTAL ASSETS | 23,259 | 21,379 |
Current liabilities: | ||
Current portion of long-term debt | 6 | 44 |
Notes payable | 325 | 1 |
Accounts payable | 2,048 | 2,191 |
Accrued liabilities | 3,011 | 3,037 |
Income taxes payable | 84 | 85 |
Total current liabilities | 5,474 | 5,358 |
Long-term debt | 3,471 | 1,993 |
Deferred income taxes and other liabilities | 1,907 | 1,770 |
Commitments and contingencies | ||
Redeemable preferred stock | 0 | 0 |
Shareholdersâ equity: | ||
Capital in excess of stated value | 8,638 | 7,786 |
Accumulated other comprehensive (loss) income | (213) | 318 |
Retained earnings | 3,979 | 4,151 |
Total shareholdersâ equity | 12,407 | 12,258 |
TOTAL LIABILITIES AND SHAREHOLDERSâ EQUITY | 23,259 | 21,379 |
Class A Convertible Common Stock | ||
Shareholdersâ equity: | ||
Common stock at stated value | 0 | 0 |
Class B Common Stock | ||
Shareholdersâ equity: | ||
Common stock at stated value | $ 3 | $ 3 |
Income Statement:
Consolidated Statements of Income - USD ($) $ in Millions | 12 Months Ended | ||
May 31, 2017 | May 31, 2016 | May 31, 2015 | |
Income Statement [Abstract] | |||
Revenues | $ 34,350 | $ 32,376 | $ 30,601 |
Cost of sales | 19,038 | 17,405 | 16,534 |
Gross profit | 15,312 | 14,971 | 14,067 |
Demand creation expense | 3,341 | 3,278 | 3,213 |
Operating overhead expense | 7,222 | 7,191 | 6,679 |
Total selling and administrative expense | 10,563 | 10,469 | 9,892 |
Interest expense (income), net | 59 | 19 | 28 |
Other (income) expense, net | (196) | (140) | (58) |
Income before income taxes | 4,886 | 4,623 | 4,205 |
Income tax expense | 646 | 863 | 932 |
NET INCOME | $ 4,240 | $ 3,760 | $ 3,273 |
Earnings per common share: | |||
Basic (in dollars per share) | $ 2.56 | $ 2.21 | $ 1.90 |
Diluted (in dollars per share) | 2.51 | 2.16 | 1.85 |
Dividends declared per common share (in dollars per share) | $ 0.70 | $ 0.62 | $ 0.54 |
Cash Flow Sheet
Consolidated Statements of Cash Flows - USD ($) $ in Millions | 12 Months Ended | ||
May 31, 2017 | May 31, 2016 | May 31, 2015 | |
Cash provided by operations: | |||
Net income | $ 4,240 | $ 3,760 | $ 3,273 |
Income charges (credits) not affecting cash: | |||
Depreciation | 706 | 649 | 606 |
Deferred income taxes | (273) | (80) | (113) |
Stock-based compensation | 215 | 236 | 191 |
Amortization and other | 10 | 13 | 43 |
Net foreign currency adjustments | (117) | 98 | 424 |
Changes in certain working capital components and other assets and liabilities: | |||
(Increase) decrease in accounts receivable | (426) | 60 | (216) |
(Increase) in inventories | (231) | (590) | (621) |
(Increase) in prepaid expenses and other current assets | (120) | (161) | (144) |
(Decrease) increase in accounts payable, accrued liabilities and income taxes payable | (364) | (889) | 1,237 |
Cash provided by operations | 3,640 | 3,096 | 4,680 |
Cash used by investing activities: | |||
Purchases of short-term investments | (5,928) | (5,367) | (4,936) |
Maturities of short-term investments | 3,623 | 2,924 | 3,655 |
Sales of short-term investments | 2,423 | 2,386 | 2,216 |
Investments in reverse repurchase agreements | 0 | 150 | (150) |
Additions to property, plant and equipment | (1,105) | (1,143) | (963) |
Disposals of property, plant and equipment | 13 | 10 | 3 |
Other investing activities | (34) | 6 | 0 |
Cash used by investing activities | (1,008) | (1,034) | (175) |
Cash used by financing activities: | |||
Net proceeds from long-term debt issuance | 1,482 | 981 | 0 |
Long-term debt payments, including current portion | (44) | (106) | (7) |
Increase (decrease) in notes payable | 327 | (67) | (63) |
Payments on capital lease and other financing obligations | (17) | (7) | (19) |
Proceeds from exercise of stock options and other stock issuances | 489 | 507 | 514 |
Excess tax benefits from share-based payment arrangements | 177 | 281 | 218 |
Repurchase of common stock | (3,223) | (3,238) | (2,534) |
Dividends â common and preferred | (1,133) | (1,022) | (899) |
Cash used by financing activities | (1,942) | (2,671) | (2,790) |
Effect of exchange rate changes on cash and equivalents | (20) | (105) | (83) |
Net increase (decrease) in cash and equivalents | 670 | (714) | 1,632 |
Cash and equivalents, beginning of year | 3,138 | 3,852 | 2,220 |
CASH AND EQUIVALENTS, END OF YEAR | 3,808 | 3,138 | 3,852 |
Cash paid during the year for: | |||
Interest, net of capitalized interest | 98 | 70 | 53 |
Income taxes | 703 | 748 | 1,262 |
Non-cash additions to property, plant and equipment | 266 | 252 | 206 |
Dividends declared and not paid | $ 300 | $ 271 | $ 240 |