Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

can anyone help me with my assignment, which is consist part 1 and 2. but i already done the part 1 and now i need

can anyone help me with my assignment, which is consist part 1 and 2. but i already done the part 1 and now i need someone to settle this out. here i attach the question including my answer for part 1

image text in transcribed BAO1101 ACCOUNTING FOR DECISION MAKING 2016 SEMESTER 2 / MAJOR ASSIGNMENT ... DECISION MAKING IN THE SHAREMARKET SUBMIT IN LECTURE : Part 1 SUBMIT IN LECTURE Group 1 Seek Limited AGL Energy Limited : Part 2 and 3 Week 11 4 October 2016 Group 2 SEK Super Retail Group AGL Commonwealth Bank Of Australia WES Qantas Airways Limited Wesfarmers Limited Week 5 16 August 2016 SUL CBA QAN Financial Information and links to these companies may be accessed through www.asx.com.au PART 1 SHAREMARKET ASSIGNMENT SHEET - complete and submit sheets on p.5-7 Select a share portfolio consisting of one company from each group listed above. The total value of your portfolio should add up to $10,000 worth of shares for group of 2 students or $15,000 worth of shares for group of 3 students based on the closing share prices posted on the ASX website on Friday 12 August 2016. Check after 6pm to ensure that the latest price has been updated. During the tracking period, Friday 12 August 2016 to Friday 9 September 2016, your team is to monitor the performance of the shares and the overall performance of the Australian sharemarket. Can you maximize the value of your share portfolio? My answer This multinational company provide various leisure traveling services such as student flight, travel associate and Cruiseabout. The services provided does not limit to travel only, but also include services such as foreign exchange business, Healthwise and Advance Trader. The result for most of the company business has exceed its expectation so far. Besides, this company also shows an increasing trend in their dividend summary since 1996 until 2015. Flight Centre Travel Group (FCTG) is a foundation of convenient travel brands arise in Australian market in 1982 as it opens its first store. This company now owned more than 680 stores in Australia and had been expand to 14 countries. In addition, their corporate travel management network has spread across more than 90 countries. FCTG is one of world's largest travel agency with astonishing growth of $1.8 billion businesses that consisting of more than 40 brands. FCTG provide opportunity to share in the company's success through outcome-based incentives, profit share, BOS (franchises) and Employee and Leadership Share Schemes. This company price share is 3.42 AUD per share . Dear students, Remember to check and jot down the share prices, especially the 52 week High and Low. After which, you may proceed with the graph plotting and analysis. Significant movements in the share prices and ASX200 need to be explained and supported with evidencesews articles. Also, please ensure that the Harvard Referencing System is closely adhered to. PART 2 COMPANY RESEARCH / GRAPHS / INVESTOR INFORMATION [55 marks] [A] A brief description of each company in your team's portfolio. It should be presented as a comparative table and should include: Products And Services Provided By The Company [brief outline] Name Of Chief Executive Officer [or Managing Director] Salary of Chief Executive Officer [or Managing Director] Profit / Loss after Tax from 2015 Annual Report for the full financial year - consolidated figures Latest Dividend Paid - Dividend Per Share and Date Paid Size Of The Business By Total Assets - from 2015 Annual Report - consolidated figures Number Of Employees Share Price - 52 week High And Low on 9 September 2016- from The Age Business section link below:http://markets.theage.com.au/apps/qt/index.ac [100 word maximum for each company] [10 marks] [B] For the tracking period only, using an Excel spreadsheet, prepare your own graph of the daily share price movements for each of your shares. Information should be shown in a table with separate columns for Date and Closing Price ($). For the tracking period only, using an Excel spreadsheet prepare your own graph of the daily movement of the ASX200 Index. Information should be shown in a table with separate columns for Date and Closing Value [points]. Copy and Paste Excel Tables and Graphs into a Word Document to include in your report. [10 marks] [C] For each company, provide an overview of the share price performance and describe the overall trend of the Australian share-market over the tracking period. Describe how each of your shares performed against the ASX200 Index. Explain major movements in your share prices and the share-market with evidence from newspapers, business magazines, internet information or other relevant sources. Evidence should be included and news articles should be photocopied (see p.21 to 24 of your Subject Resource Workbook) and neatly presented in an appendix to your report. Harvard Referencing is required to acknowledge all sources of information used. Please be aware of penalties for Plagiarism. See \"Harvard Referencing\" links on BAO1101 website. [300 word maximum for each company and comparison with the ASX200 Index] [25 marks] [D] Calculate the Gain or Loss made on your portfolio during the tracking period. [5 marks] [E] Provide a recommendation [buy / sell / hold] for each of your shares. Support each recommendation with relevant information you have found in Part [C]. [50 words maximum for each company] [5marks] BAO1101 ACCOUNTING FOR DECISION MAKING 2016 SEMESTER 2 / MAJOR ASSIGNMENT ... DECISION MAKING IN THE SHAREMARKET SUBMIT IN LECTURE : Part 1 SUBMIT IN LECTURE Group 1 Seek Limited AGL Energy Limited : Part 2 and 3 Week 11 4 October 2016 Group 2 SEK Super Retail Group AGL Commonwealth Bank Of Australia WES Qantas Airways Limited Wesfarmers Limited Week 5 16 August 2016 SUL CBA QAN Financial Information and links to these companies may be accessed through www.asx.com.au PART 1 SHAREMARKET ASSIGNMENT SHEET - complete and submit sheets on p.5-7 Select a share portfolio consisting of one company from each group listed above. The total value of your portfolio should add up to $10,000 worth of shares for group of 2 students or $15,000 worth of shares for group of 3 students based on the closing share prices posted on the ASX website on Friday 12 August 2016. Check after 6pm to ensure that the latest price has been updated. During the tracking period, Friday 12 August 2016 to Friday 9 September 2016, your team is to monitor the performance of the shares and the overall performance of the Australian sharemarket. Can you maximize the value of your share portfolio? My answer This multinational company provide various leisure traveling services such as student flight, travel associate and Cruiseabout. The services provided does not limit to travel only, but also include services such as foreign exchange business, Healthwise and Advance Trader. The result for most of the company business has exceed its expectation so far. Besides, this company also shows an increasing trend in their dividend summary since 1996 until 2015. Flight Centre Travel Group (FCTG) is a foundation of convenient travel brands arise in Australian market in 1982 as it opens its first store. This company now owned more than 680 stores in Australia and had been expand to 14 countries. In addition, their corporate travel management network has spread across more than 90 countries. FCTG is one of world's largest travel agency with astonishing growth of $1.8 billion businesses that consisting of more than 40 brands. FCTG provide opportunity to share in the company's success through outcome-based incentives, profit share, BOS (franchises) and Employee and Leadership Share Schemes. This company price share is 3.42 AUD per share . Dear students, Remember to check and jot down the share prices, especially the 52 week High and Low. After which, you may proceed with the graph plotting and analysis. Significant movements in the share prices and ASX200 need to be explained and supported with evidencesews articles. Also, please ensure that the Harvard Referencing System is closely adhered to. PART 2 COMPANY RESEARCH / GRAPHS / INVESTOR INFORMATION [55 marks] [A] A brief description of each company in your team's portfolio. It should be presented as a comparative table and should include: Products And Services Provided By The Company [brief outline] Name Of Chief Executive Officer [or Managing Director] Salary of Chief Executive Officer [or Managing Director] Profit / Loss after Tax from 2015 Annual Report for the full financial year - consolidated figures Latest Dividend Paid - Dividend Per Share and Date Paid Size Of The Business By Total Assets - from 2015 Annual Report - consolidated figures Number Of Employees Share Price - 52 week High And Low on 9 September 2016- from The Age Business section link below:http://markets.theage.com.au/apps/qt/index.ac [100 word maximum for each company] [10 marks] [B] For the tracking period only, using an Excel spreadsheet, prepare your own graph of the daily share price movements for each of your shares. Information should be shown in a table with separate columns for Date and Closing Price ($). For the tracking period only, using an Excel spreadsheet prepare your own graph of the daily movement of the ASX200 Index. Information should be shown in a table with separate columns for Date and Closing Value [points]. Copy and Paste Excel Tables and Graphs into a Word Document to include in your report. [10 marks] [C] For each company, provide an overview of the share price performance and describe the overall trend of the Australian share-market over the tracking period. Describe how each of your shares performed against the ASX200 Index. Explain major movements in your share prices and the share-market with evidence from newspapers, business magazines, internet information or other relevant sources. Evidence should be included and news articles should be photocopied (see p.21 to 24 of your Subject Resource Workbook) and neatly presented in an appendix to your report. Harvard Referencing is required to acknowledge all sources of information used. Please be aware of penalties for Plagiarism. See \"Harvard Referencing\" links on BAO1101 website. [300 word maximum for each company and comparison with the ASX200 Index] [25 marks] [D] Calculate the Gain or Loss made on your portfolio during the tracking period. [5 marks] [E] Provide a recommendation [buy / sell / hold] for each of your shares. Support each recommendation with relevant information you have found in Part [C]. [50 words maximum for each company] [5marks] PART 3 - IDENTIFICATION OF KEY FINANCIAL DATA AND RATIO ANALYSIS [35 marks] [A] IDENTIFICATION OF KEY FINANCIAL DATA For each company you have selected, complete the following table of Key Financial Data. Find the figures from the 2015 Annual Report with results for the full financial year for 1 July 2014 to 30 June 2015 The \"consolidated\" figures are required. Company 1 Company 2 Company 3 For Teams of 3 Revenue / Sales Interest Expense EBIT Net Profit Before Tax Net Profit After Tax Current Assets Total Assets Current Liabilities Total Liabilities Total Equity References are required to identify the source of all figures in your table. Attach Consolidated Income Statement and Balance Sheet for each company with relevant figures highlighted. This must be included in the appendix of your report. [5 marks] [B] RATIO ANALYSIS From the Key Financial Data, calculate relevant ratios provide an overview of each company's:*Profitability *Stability *Liquidity At least 6 ratios for each company should be used for this overview. The ratios may vary depending on the availability of information provided in each company's Financial Statements. For each of the headings listed above, your overview should identify the name of the ratio used and interpret your results. Provide an explanation of why these ratios may differ between your companies. Which do you consider to be the better investment? Explain your reasoning. Refer to your Subject Resource Workbook p.117 to p.119 for formulae and interpretation. Please note that Topic 4 - Ratio Analysis and Interpretation will be covered in lecture 8. All formulae and calculations must be clearly shown. [30 marks] [250 words maximum for each company] PART 2 - COMPANY RESEARCH / GRAPHS / INVESTOR INFORMATION ... [ Total 55 Marks ] [A] Description Of Each Company [ 5 marks for each company * ] 10 marks ... Products And Services Name Of Chief Executive Officer [or Managing Director] Salary of Chief Executive Officer [or Managing Director]* Profit / Loss After Tax from 2015 Annual Report - consolidated figures Latest Dividend Paid - Dividend Per Share and Date Paid Size By Total Assets - 2015 Annual Report - consolidated figures Number Of Employees * Share Price 52 week High / Low - 9 September 2016 from The Age Business link Total Marks * [0.5 marks for points 1 to 8 = 4 marks] + [*extra 0.5 marks each for point 3 salary and point 7 no. of employees] [B] Graphs - Share Prices and ASX200 10 marks... [2.5 marks * 3 graphs] +2.5 Presentation Students are required to prepare their own graphs using Excel Students should include all prices per week. Graphs should have appropriate labels and scales. Marks should be subtracted for graphs that are hard to read and interpret. Table with share prices of each company and ASX200 dates and value should be included [subtract 2.5 marks if table with share prices and ASX200 dates and values not included] [C] Overview Of Share Performance / Trend of Share-market 25 marks... [300 word maximum for each company and comparison with the ASX200= 600 words] Description of the share price performance over the tracking period Description of the overall trend of the share-market Comparison of share performance with the ASX200 Evidence of research on the share price to be included in the appendix / bibliography [at least one relevant article for each company - scanned and neatly presented] Analysis and interpretation of the evidence [D] Calculation Of Gain / Loss On Portfolio 5 marks... Calculations for each share should be clearly shown as well as a portfolio total. [E] Recommendation On The Share Portfolio [50 words each company = 100 words] 5 marks... Allocate up to 2.5 marks for a basic recommendation with some logical support PART 3 - IDENTIFICATION OF KEY FINANCIAL DATA AND RATIO ANALYSIS... [ Total 35 Marks ] [A] KEY FINANCIAL DATA ** 5 marks ... Revenue / Sales Interest Expense EBIT Net Profit Before Tax Net Profit After Tax Current Assets Total Assets Current Liabilities Total Liabilities Total Equity ** [0.2 marks for each item * 20 = 4 marks] + [Reference / Source of Information = 1 mark] [B] RATIO ANALYSIS [250 word maximum for each company] ... mark should reflect quality of answer Overview of each company's Profitability Stability Liquidity Identify the name of ratio used and interpret results. 10 marks ... At least 6 ratios in total should be used for this overview. Additional marks for extra initiative. 5 marks ... For each ratio, explain why they may differ between your 2 companies. 5 marks ... Identification of which company to be the better investment / explain reasoning 5 marks ... All formulae and calculations must be clearly shown. 5 marks ... GENERAL PRESENTATION ... Referencing - using Harvard References other than textbook and Subject Resource Workbook Complete / Alphabetical By Surname/ Proper Format Format and Presentation Report Format / Typed / Cover Page / Table Of Contents / Page Numbers / Spelling / English Expression / Comparative Tables / Professional Presentation / Word Limit TOTAL MARKS 5 marks 5 marks 100 Fiscal data as of Jun 30 2016 2016 2015 2014 965.00 873.00 724.00 39.00 29.00 ### 570.00 551.00 431.00 40.00 (264.00) 5.60 421.00 545.00 -- -(100.00) 0.80 510.00 362.00 -- -3.20 491.00 233.00 -- REVENUE AND GROSS PROFIT Total revenue OPERATING EXPENSES Cost of revenue total Selling, general and admin. expenses, total Depreciation/amortization Unusual expense(income) Other operating expenses, total Total operating expense Operating income Other, net INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS Net income before taxes Provision for income taxes Net income after taxes Minority interest Net income before extra. Items Total extraordinary items Net income 557.00 157.00 399.00 (42.00) 357.00 -357.00 384.00 69.00 315.00 (34.00) 281.00 281.00 252.00 53.00 198.00 (28.00) 171.00 25.00 196.00 Inc.avail. to common excl. extra. Items 357.00 281.00 171.00 357.00 281.00 196.00 344.00 343.00 339.00 1.04 1.04 (3.60) 347.00 1.02 0.82 0.82 (4.30) 347.00 0.80 0.50 0.58 344.00 0.50 1.02 0.80 0.57 0.40 138.00 0.36 124.00 0.30 103.00 -36.00 -30.00 -28.00 Inc.avail. to common incl. extra. Items EPS RECONCILIATION Basic/primary weighted average shares Basic/primary eps excl. extra items Basic/primary eps incl. extra items Dilution adjustment Diluted weighted average shares Diluted eps excl. extra items Diluted eps incl. extra items COMMON STOCK DIVIDENDS DPS - common stock primary issue Gross dividend - common stock PRO FORMA INCOME Pro forma net income Interest expense, supplemental SUPPLEMENTAL INCOME Depreciation, supplemental Total special items 14.00 (264.00) 12.00 (100.00) ### - 292.00 284.00 252.00 (85.00) 30.00 6.30 73.00 99.00 60.00 220.00 185.00 192.00 177.00 151.00 164.00 0.51 0.50 0.44 0.42 0.48 0.48 NORMALISED INCOME Normalized income before taxes Effect of special items on income taxes Income tax excluding impact of special items Normalized income after tax Normalized income avail. to common Basic normalized EPS Diluted normalized EPS PROFITABILITY RATIO 2016 PROFIT AFTER TAX REVENUE 220.00 965.00 23% RETURN ON ASSET PROFIT AFTER TAX Total assets RETURN ON EQUITY PROFIT AFTER TAX EQUITY 2015 2014 185.00 192.00 873.00 724.00 21% 0.26519337 220 327800% 7% 185 329900% 6% 192 223200% 9% 0 220 185 192 1,355 16% 1,134 16% 902 21% STABILITY RATIO DEBT TO EQUITY DEBT EQUITY debt to equity 823.00 1,355.00 984.00 1,134.00 402.00 902.00 61% 87% 45% 220 185 192 INTEREST COVER PROFIT AFTER TAX INTEREST EXPENSE interest cover 36.00 30.00 28.00 6.17 6.86 737 642 446 575 599 285 6.11 liquidity ratio Total current Total assets current liabilities current ratio 1.2817391304 1.0717863105 1.564912281 Fiscal data as of Jun 30 2016 2016 2015 2014 499 302 108 -22 14 642 79 -18 48 446 28 21 1,945 463 196 --3,299 1,196 318 215 --2,232 118 15 117 15 80 8.1 0 0 0 71 215 22 370 575 752 823 101 469 27 1,923 252 599 769 984 105 667 25 2,165 175 285 380 402 76 566 23 1,330 223 -- 223 -- 204 -- 1,089 772 668 -1.9 41 1,355 -4.9 135 1,134 --31 902 3,278 3,299 2,232 344 344 340 ASSETS Cash And Short Term 637 Investments 71 Total Receivables, Net -Total Inventory 27 Prepaid expenses 1.1 Other current assets, total 737 Total current assets Property, plant & equipment, 28 net 1,931 Goodwill, net 457 Intangibles, net 99 Long term investments -Note receivable - long term -Other long term assets 3,278 Total assets LIABILITIES Accounts payable Accrued expenses Notes payable/short-term debt Current portion long-term debt/capital leases Other current liabilities, total Total current liabilities Total long term debt Total debt Deferred income tax Minority interest Other liabilities, total Total liabilities SHAREHOLDERS EQUITY Common stock Additional paid-in capital Retained earnings (accumulated deficit) Treasury stock - common Unrealized gain (loss) Other equity, total Total equity Total liabilities & shareholders' equity Total common shares outstanding Treasury shares - common primary issue 1.33 0.3 0.41 date Friday, September 09, 2016 Thursday, September 08, 2016 Open High Low Close 15.55 15.64 15.36 15.45 15.57 15.72 15.52 15.62 Wednesday, September 07, 2016 15.9 15.94 15.68 15.8 Tuesday, September 06, 2016 16.07 16.11 15.93 15.97 16.17 16.23 15.96 16.12 16.2 16.25 15.99 16.14 15.99 16.13 15.94 16.08 16.04 16.17 15.94 16.07 16.21 16.26 15.97 16.03 16 16.12 15.9 15.98 16.13 16.28 15.97 15.99 16.35 16.55 16.23 16.26 16.5 16.5 16.13 16.34 16.27 17.04 15.88 16.41 16.14 16.71 16.03 16.36 16.5 16.59 16.4 16.53 16.68 16.68 16.41 16.5 16.24 16.6 16.23 16.53 16.07 16.21 15.99 16.21 16.1 16.18 16 16.14 16.11 16.18 16.03 16.14 Monday, September 05, 2016 Friday, September 02, 2016 Thursday, September 01, 2016 Wednesday, August 31, 2016 Tuesday, August 30, 2016 Monday, August 29, 2016 Friday, August 26, 2016 Thursday, August 25, 2016 Wednesday, August 24, 2016 Tuesday, August 23, 2016 Monday, August 22, 2016 Friday, August 19, 2016 Thursday, August 18, 2016 Wednesday, August 17, 2016 Tuesday, August 16, 2016 Monday, August 15, 2016 Friday, August 12, 2016 Thursday, August 11, 2016 Wednesday, August 10, 2016 15.69 15.97 15.66 15.92 15.75 15.86 15.65 15.79 Volume gain/loss 816,925 832,275 1,229,096 416,312 584,414 1,524,185 684,000 943,404 749,209 728,971 1,054,136 1,118,213 744,536 1,889,917 1,793,984 425,588 652,657 754,398 566,850 420,762 482,534 (0.17) (0.18) (0.17) (0.15) (0.02) 0.06 0.01 0.04 0.05 (0.01) (0.27) (0.08) (0.07) 0.05 (0.17) 0.03 (0.03) 0.32 0.07 - 2000000 1800000 1600000 1400000 1200000 1000000 800000 600000 400000 200000 0 400000 200000 0 574,404 0.22 578,543 0.13 Open High Low Close 0 5 10 15 20 25 Open High Low Close Volume High Low Close Volume Open High Low Close 25 Fiscal data as of Jul 02 2016 2016 2015 2014 2,422 2,239 2,090 1,372 1,273 1,156 944 814 758 -- -- -- -- -0.6 -- -- -- 2,317 2,087 1,915 106 152 176 1.6 1.9 12 REVENUE AND GROSS PROFIT Total revenue OPERATING EXPENSES Cost of revenue total Selling, general and admin. expenses, total Depreciation/amorti zation Unusual expense(income) Other operating expenses, total Total operating expense Operating income Other, net 0 INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS Net income before taxes Provision for income taxes 88 132 162 30 39 50 Net income after taxes Minority interest 58 93 112 4.8 4.2 0 63 97 112 0 -16 -3.8 63 81 108 Inc.avail. to common excl. extra. Items 63 97 112 Inc.avail. to common incl. extra. Items 63 81 108 197 197 197 Net income before extra. Items Total extraordinary items Net income EPS RECONCILIATION Basic/primary weighted average shares Basic/primary eps excl. extra items Basic/primary eps incl. extra items Dilution adjustment Diluted weighted average shares Diluted eps excl. extra items 0.32 0.49 0.57 0.32 0.41 0.55 Diluted eps incl. extra items -- 0 0 199 199 198 0.32 0.49 0.57 0.32 0.41 0.55 0.42 0.4 0.4 82 79 79 COMMON STOCK DIVIDENDS DPS - common stock primary issue Gross dividend common stock PRO FORMA INCOME Pro forma net income Interest expense, supplemental -- -- -- 20 22 25 67 49 43 52 8.8 0.8 Normalized income before taxes 140 140 163 Effect of special items on income taxes 18 2.57 0.25 Income tax excluding impact of special items 47 41 50 Normalized income after tax 92 99 113 97 104 113 0.49 0.53 0.57 0.49 0.52 0.57 SUPPLEMENTAL INCOME Depreciation, supplemental Total special items NORMALISED INCOME Normalized income avail. to common Basic normalized EPS Diluted normalized EPS PROFITABILITY RATIO PROFIT AFTER TAX REVENUE 2016 92 2,422 2015 99 2,239 2014 113 2,090 4% 4% 0.0540669856 92 99 113 1,583 1,575 6% 6% 7% 0 92 99 113 768 760 13% 15% 416 392 407 735.00 768.00 760.00 RETURN ON ASSET PROFIT AFTER TAX total asset 1,570 RETURN ON EQUITY PROFIT AFTER TAX EQUITY 735 13% STABILITY RATIO DEBT TO EQUITY DEBT EQUITY debt to equity 57% 51% 54% 92 99 113 INTEREST COVER PROFIT AFTER TAX INTEREST EXPENSE interest cover 20 22 25 4.50 4.52 560 558 555 330 324 318 1.6969697 1.72222222 1.7452830189 4.60 liquidity ratio Total current Total assets current liabilities current ratio Fiscal data as of Jul 02 2016 2016 2015 2014 16 13 24 18 23 35 502 25 506 9 490 6.6 0 6.8 0 560 558 555 237 224 198 448 325 448 354 441 372 -- 0 4.7 -- 0 3.7 -- -- -- 1,570 1,583 1,575 Accounts payable Accrued expenses 167 45 195 38 205 33 Notes payable/short-term debt 0 0 0 5.7 2.2 2.7 112 89 77 330 324 318 410 390 404 416 392 407 25 52 53 -1.1 -3 0 71 53 40 834 815 814 ASSETS Cash And Short Term Investments Total Receivables, Net Total Inventory Prepaid expenses Other current assets, total Total current assets Property, plant & equipment, net Goodwill, net Intangibles, net Long term investments Note receivable long term Other long term assets Total assets LIABILITIES Current portion long-term debt/capital leases Other current liabilities, total Total current liabilities Total long term debt Total debt Deferred income tax Minority interest Other liabilities, total Total liabilities SHAREHOLDERS EQUITY Common stock Additional paid-in capital Retained earnings (accumulated deficit) Treasury stock common Unrealized gain (loss) Other equity, total Total equity Total liabilities & shareholders' equity Total common shares outstanding Treasury shares common primary issue 542 542 542 -- -- 221 218 -- -- -- -- -- -- -9.4 735 5.4 768 -0.3 760 1,570 1,583 1,575 197 197 197 0 0 0 -202 date Friday, September 09, 2016 Thursday, September 08, 2016 Wednesday, September 07, 2016 Tuesday, September 06, 2016 Monday, September 05, 2016 Friday, September 02, 2016 Thursday, September 01, 2016 Wednesday, August 31, 2016 Tuesday, August 30, 2016 Monday, August 29, 2016 Friday, August 26, 2016 Thursday, August 25, 2016 Wednesday, August 24, 2016 Tuesday, August 23, 2016 Monday, August 22, 2016 Friday, August 19, 2016 Thursday, August 18, 2016 Wednesday, August 17, 2016 Tuesday, August 16, 2016 Monday, August 15, 2016 Friday, August 12, 2016 Thursday, August 11, 2016 Wednesday, August 10, 2016 Open High Low Close 10.27 10.33 10.15 10.28 10.11 10.3 10.05 10.27 10.17 10.36 10.14 10.35 10.2 10.4 10.09 10.33 10.56 10.68 10.22 10.28 10.9 11.02 10.72 10.78 10.96 11.13 10.89 11 10.95 11 10.85 11 11.04 11.13 10.9 10.95 10.65 11.19 10.65 11.01 9.5 10.44 9.5 10.4 9.88 10.01 9.76 9.81 10.15 10.15 9.97 10.01 10.1 10.2 10.01 10.08 10.11 10.17 10.03 10.04 10.05 10.2 10.05 10.08 10.09 10.1 10 10.02 10.02 10.05 9.94 10.03 10.05 10.05 9.98 9.99 10 10.08 9.99 10.05 9.98 10.07 9.91 10 9.81 9.99 9.79 9.9 9.79 9.87 9.7 9.81 Date Friday, September 09, 2016 Thursday, September 08, 2016 Wednesday, September 07, 2016 Tuesday, September 06, 2016 Monday, September 05, 2016 Friday, September 02, 2016 Thursday, September 01, 2016 Wednesday, August 31, 2016 Tuesday, August 30, 2016 Monday, August 29, 2016 Friday, August 26, 2016 Thursday, August 25, 2016 Wednesday, August 24, 2016 Tuesday, August 23, 2016 Monday, August 22, 2016 Friday, August 19, 2016 Thursday, August 18, 2016 Wednesday, August 17, 2016 Tuesday, August 16, 2016 Monday, August 15, 2016 Friday, August 12, 2016 Thursday, August 11, 2016 Wednesday, August 10, 2016 Open High Low Close 10.27 10.33 10.15 10.28 10.11 10.3 10.05 10.27 10.17 10.36 10.14 10.35 10.2 10.4 10.09 10.33 10.56 10.68 10.22 10.28 10.9 11.02 10.72 10.78 10.96 11.13 10.89 11 10.95 11 10.85 11 11.04 11.13 10.9 10.95 10.65 11.19 10.65 11.01 9.5 10.44 9.5 10.4 9.88 10.01 9.76 9.81 10.15 10.15 9.97 10.01 10.1 10.2 10.01 10.08 10.11 10.17 10.03 10.04 10.05 10.2 10.05 10.08 10.09 10.1 10 10.02 10.02 10.05 9.94 10.03 10.05 10.05 9.98 9.99 10 10.08 9.99 10.05 9.98 10.07 9.91 10 9.81 9.99 9.79 9.9 Volume 659,079 427,352 358,376 1,158,732 1,116,045 890,098 1,147,421 887,436 924,350 1,526,516 1,437,398 516,507 419,919 429,506 377,102 217,084 330,827 1,379,229 314,405 452,293 640,027 500,858 517,367 0.01 (0.08) 0.02 0.05 (0.50) (0.22) 0.05 (0.06) 0.61 0.59 (0.20) (0.07) 0.04 (0.04) 0.06 (0.01) 0.04 (0.06) 0.05 0.10 0.09 Volume 659,079 427,352 358,376 1,158,732 1,116,045 890,098 1,147,421 887,436 924,350 1,526,516 1,437,398 516,507 419,919 429,506 377,102 217,084 330,827 1,379,229 314,405 452,293 640,027 500,858 #VALUE! #VALUE! 0.01 (0.08) 0.02 0.05 (0.50) (0.22) 0.05 (0.06) 0.61 0.59 (0.20) (0.07) 0.04 (0.04) 0.06 (0.01) 0.04 (0.06) 0.05 0.10 Open 10.27 10 .1 1 1 0.17 10 .2 10 .5 6 10.9 10.96 10 .9 5 1 1.04 10.65 9.5 9.88 10 .1 5 10.1 10.11 10 .0 5 1 0.09 10.02 10 .0 5 10 9 .98 9 .8 1 9.7 9 Open H igh 10.33 1 0.3 10 .3 6 1 0.4 10.68 1 1.0 2 1 1.13 11 1 1.13 11.1 9 10 .44 10.01 1 0.15 10.2 1 0.1 7 1 0.2 1 0.1 10.05 1 0.0 5 1 0.08 1 0.07 9.99 9 .87 High Low 10 .15 1 0.05 10.1 4 10.09 10.2 2 1 0.7 2 10.89 10.85 10.9 10 .65 9 .5 9.76 9.9 7 10.01 10 .03 1 0.05 10 9.9 4 9.98 9.99 9.91 9 .7 9 9.7 Low C lose 1 0.28 10.27 10 .3 5 1 0.33 10 .28 10 .78 11 11 1 0.95 11 .01 10 .4 9.81 1 0.01 10 .08 10 .04 10.08 1 0.02 10 .03 9.9 9 10.0 5 10 9 .9 9.81 Close Vo lume 6 59,079 4 27,352 358 ,3 76 1 ,158,73 2 1,116 ,0 45 890,09 8 1,147 ,4 21 887,43 6 924 ,3 50 1 ,526,51 6 1,437 ,3 98 516,50 7 419 ,9 19 4 29 ,50 6 377,10 2 217 ,0 84 3 30 ,82 7 1,379 ,2 29 314,40 5 452 ,2 93 6 40 ,02 7 500,85 8 517 ,3 67 Volume Open 10.27 10 .1 1 1 0.17 10 .2 10 .5 6 10.9 10.96 10 .9 5 1 1.04 10.65 9.5 9.88 10 .1 5 10.1 10.11 10 .0 5 1 0.09 10.02 10 .0 5 10 9 .98 9 .8 1 9.7 9 Open H igh 10.33 1 0.3 10 .3 6 1 0.4 10.68 1 1.0 2 1 1.13 11 1 1.13 11.1 9 10 .44 10.01 1 0.15 10.2 1 0.1 7 1 0.2 1 0.1 10.05 1 0.0 5 1 0.08 1 0.07 9.99 9 .87 High Low 10 .15 1 0.05 10.1 4 10.09 10.2 2 1 0.7 2 10.89 10.85 10.9 10 .65 9 .5 9.76 9.9 7 10.01 10 .03 1 0.05 10 9.9 4 9.98 9.99 9.91 9 .7 9 9.7 Low C lose 1 0.28 10.27 10 .3 5 1 0.33 10 .28 10 .78 11 11 1 0.95 11 .01 10 .4 9.81 1 0.01 10 .08 10 .04 10.08 1 0.02 10 .03 9.9 9 10.0 5 10 9 .9 9.81 Close Vo lume 6 59,079 4 27,352 358 ,3 76 1 ,158,73 2 1,116 ,0 45 890,09 8 1,147 ,4 21 887,43 6 924 ,3 50 1 ,526,51 6 1,437 ,3 98 516,50 7 419 ,9 19 4 29 ,50 6 377,10 2 217 ,0 84 3 30 ,82 7 1,379 ,2 29 314,40 5 452 ,2 93 6 40 ,02 7 500,85 8 517 ,3 67 Volume w 10.15 1 0.05 10.14 09 10.2 2 10 .7 2 10.89 85 10.9 10.65 9 .5 9.76 7 10.01 10.03 1 0.0 5 10 4 9.9 8 9.99 9.91 9.79 Low Close 10.28 10 .2 7 10.35 10 .3 3 10.28 10.78 1 1 1 1 10 .9 5 11.01 10.4 9.81 10 .0 1 10.08 10.04 1 0.0 8 10 .0 2 10.03 9.99 10 .05 1 0 9.9 9.81 Close Volu me 65 9,07 9 427,35 2 35 8,376 1,15 8,7 32 1,11 6,045 89 0,0 98 1,14 7,421 88 7,4 36 92 4,350 1,52 6,5 16 1,43 7,398 51 6,5 07 41 9,919 42 9,506 377 ,1 02 21 7,084 33 0,827 1,37 9,229 31 4,4 05 45 2,293 64 0,027 500 ,8 58 51 7,367 Vo lu me w 10.15 1 0.05 10.14 09 10.2 2 10 .7 2 10.89 85 10.9 10.65 9 .5 9.76 7 10.01 10.03 1 0.0 5 10 4 9.9 8 9.99 9.91 9.79 Low Close 10.28 10 .2 7 10.35 10 .3 3 10.28 10.78 1 1 1 1 10 .9 5 11.01 10.4 9.81 10 .0 1 10.08 10.04 1 0.0 8 10 .0 2 10.03 9.99 10 .05 1 0 9.9 9.81 Close Volu me 65 9,07 9 427,35 2 35 8,376 1,15 8,7 32 1,11 6,045 89 0,0 98 1,14 7,421 88 7,4 36 92 4,350 1,52 6,5 16 1,43 7,398 51 6,5 07 41 9,919 42 9,506 377 ,1 02 21 7,084 33 0,827 1,37 9,229 31 4,4 05 45 2,293 64 0,027 500 ,8 58 51 7,367 Vo lu me DATE Friday, September 09, 2016 Open High Low Close Volume 17.92 17.92 17.43 17.46 2,833,268 Thursday, September 08, 2016 18.05 18.07 17.79 17.92 3,045,066 Wednesday, September 07, 2016 18.13 Tuesday, September 06, 2016 18.5 Monday, September 05, 2016 18.73 Friday, September 02, 2016 18.55 Thursday, September 01, 2016 18.52 Wednesday, August 31, 2016 18.66 Tuesday, August 30, 2016 18.84 Monday, August 29, 2016 Friday, August 26, 2016 (0.15) 18.34 18.04 18.1 2,265,287 (0.27) 18.52 18.14 18.18 1,721,314 (0.18) 18.84 18.51 18.55 949,842 (0.32) 18.7 18.54 18.58 1,373,799 0.14 18.8 18.52 18.62 1,715,215 (0.10) 18.77 18.51 18.55 2,197,443 0.03 18.89 18.66 18.71 1,919,066 (0.12) 18.79 18.85 18.63 18.75 1,658,107 18.76 18.89 18.72 18.81 1,484,259 Thursday, August 25, 2016 18.76 19 18.71 18.75 1,937,002 Wednesday, August 24, 2016 18.9 Tuesday, August 23, 2016 19.07 Monday, August 22, 2016 Friday, August 19, 2016 0.04 (0.04) (0.11) 18.98 18.78 18.93 1,648,000 0.02 19.25 18.98 19.18 3,471,825 (0.27) 19.11 19.17 18.91 18.96 1,540,555 19.08 19.16 18.93 19.1 2,092,485 0.08 0.01 Thursday, August 18, 2016 19.07 Wednesday, August 17, 2016 19.03 Tuesday, August 16, 2016 19.18 Monday, August 15, 2016 Friday, August 12, 2016 19.12 18.8 18.88 2,584,988 0.04 19.15 19.01 19.03 1,746,306 (0.03) 19.18 19.05 19.1 2,015,329 (0.03) 19 19.16 18.91 19.07 2,389,961 19.34 19.37 19.01 19.05 4,104,626 Thursday, August 11, 2016 19.55 19.55 18.95 19.3 4,806,564 Wednesday, August 10, 2016 19.56 0.02 (0.21) (0.18) 19.8 19.33 19.58 3,348,899 (0.25) 6000000 5000000 4000000 3000000 2000000 1000000 0 Open High Low Close Volume Open High Low Close Volume Fiscal data as of Jun 30 2016 2016 2015 2014 11,150 10,678 10,445 8,110 7,856 8,129 902 891 727 478 379 326 868 801 70 479 448 279 11,406 10,111 9,466 -256 -63 567 -51 979 -50 REVENUE AND GROSS PROFIT Total revenue OPERATING EXPENSES Cost of revenue total Selling, general and admin. expenses, total Depreciation/amortization Unusual expense(income) Other operating expenses, total Total operating expense Operating income Other, net INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS -474 337 760 -67 119 190 -407 -1 218 0 570 0 Net income before extra. Items Total extraordinary items Net income -408 218 570 --408 -218 -570 Inc.avail. to common excl. extra. Items -408 218 570 Inc.avail. to common incl. extra. Items -408 218 570 675 654 580 -0.6 0.33 0.98 -0.6 0.33 0.98 Net income before taxes Provision for income taxes Net income after taxes Minority interest EPS RECONCILIATION Basic/primary weighted average shares Basic/primary eps excl. extra items Basic/primary eps incl. extra items Dilution adjustment Diluted weighted average shares Diluted eps excl. extra items -- 0 0 675 654 581 -0.6 0.33 0.98 -0.6 0.33 0.98 0.68 0.64 0.63 459 432 353 -- -- 173 199 193 445 350 272 868 801 70 Normalized income before taxes Effect of special items on income taxes Income tax excluding impact of special items 394 1,138 830 176 214 41 109 333 231 Normalized income after tax 285 805 599 Normalized income avail. to common Basic normalized EPS Diluted normalized EPS 284 805 599 0.42 0.42 1.23 1.23 1.03 1.03 Diluted eps incl. extra items COMMON STOCK DIVIDENDS DPS - common stock primary issue Gross dividend - common stock PRO FORMA INCOME Pro forma net income Interest expense, supplemental -- SUPPLEMENTAL INCOME Depreciation, supplemental Total special items NORMALISED INCOME PROFITABILITY RATIO PROFIT AFTER TAX REVENUE 2016 -408 11,150 -4% 2015 218 10,678 2014 570 10,445 2% 0.054571565 RETURN ON ASSET PROFIT AFTER TAX total asset RETURN ON EQUITY PROFIT AFTER TAX EQUITY -408 218 570 15,833 14,134 -3% 1% 4% 0 -408 218 570 768 760 28% 75% 392 768.00 407 760.00 57% 51% 54% -408 218 570 199 193 1.10 2.95 14,604 735 -56% STABILITY RATIO DEBT TO EQUITY DEBT EQUITY debt to equity 416 735.00 INTEREST COVER PROFIT AFTER TAX INTEREST EXPENSE interest cover liquidity ratio 173 (2.36) Total current Total assets current liabilities current ratio 3,587 3,459 3,411 2,553 2,373 2,166 1.4050137094 1.4576485461 1.574792244 Fiscal data as of Jun 30 2016 2016 2015 2014 327 282 474 943 776 745 414 39 396 40 191 32 1,864 1,965 1,969 3,587 3,459 3,411 6,529 7,632 6,236 2,791 441 2,792 474 2,758 490 70 91 32 44 117 172 177 555 390 14,604 15,833 14,134 -183 -154 -85 0 0 0 22 443 45 1,445 1,107 1,402 2,553 2,373 2,166 3,086 3,108 3,439 3,882 3,669 3,714 ASSETS Cash And Short Term Investments Total Receivables, Net Total Inventory Prepaid expenses Other current assets, total Total current assets Property, plant & equipment, net Goodwill, net Intangibles, net Long term investments Note receivable - long term Other long term assets Total assets LIABILITIES Accounts payable Accrued expenses Notes payable/shortterm debt Current portion longterm debt/capital leases Other current liabilities, total Total current liabilities Total long term debt Total debt Deferred income tax Minority interest Other liabilities, total Total liabilities -- 0 50 11 1,039 6,689 9 1,206 7,027 1 661 6,547 6,696 6,696 5,437 SHAREHOLDERS EQUITY Common stock Additional paid-in capital Retained earnings (accumulated deficit) Treasury stock common Unrealized gain (loss) Other equity, total Total equity Total liabilities & shareholders' equity Total common shares outstanding Treasury shares common primary issue -1,244 -- -- 2,178 2,254 -- -- -- -- -- -- -25 7,915 -68 8,806 -104 7,587 14,604 15,833 14,134 675 675 582 0 0 0 Fiscal data as of Jun 30 2016 2016 2015 2014 REVENUE AND GROSS PROFIT -- -- -- Cost of revenue total Selling, general and admin. expenses, total Depreciation/amortizatio n Unusual expense(income) Other operating expenses, total -- -- -- Total operating expense Operating income Other, net Total revenue OPERATING EXPENSES -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --- --- --- INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS Net income before taxes Provision for income taxes Net income after taxes Minority interest Net income before extra. Items Total extraordinary items Net income 12,854 12,612 11,997 3,607 3,528 3,347 9,247 9,084 8,650 -20 -21 -19 9,227 9,063 8,631 -- -- -- 9,227 9,063 8,631 Inc.avail. to common excl. extra. Items 9,177 9,011 8,586 Inc.avail. to common incl. extra. Items 9,177 9,011 8,586 1,692 1,627 1,618 5.42 5.54 5.31 5.42 5.54 5.31 195 225 190 1,771 1,711 1,691 EPS RECONCILIATION Basic/primary weighted average shares Basic/primary eps excl. extra items Basic/primary eps incl. extra items Dilution adjustment Diluted weighted average shares Diluted eps excl. extra items 5.29 5.4 5.19 5.29 5.4 5.19 4.2 4.18 3.99 7,189 6,823 6,484 Diluted eps incl. extra items COMMON STOCK DIVIDENDS DPS - common stock primary issue Gross dividend common stock PRO FORMA INCOME Pro forma net income Interest expense, supplemental -- -- -- -- -- -- SUPPLEMENTAL INCOME Depreciation, supplemental Total special items 425 404 453 22 19 82 12,876 12,631 12,079 6.17 5.31 23 3,613 3,533 3,370 Normalized income after tax 9,263 9,098 8,709 Normalized income avail. to common Basic normalized EPS 9,193 9,025 8,645 5.43 5.55 5.34 5.3 5.41 5.22 NORMALISED INCOME Normalized income before taxes Effect of special items on income taxes Income tax excluding impact of special items Diluted normalized EPS PROFITABILITY RATIO PROFIT AFTER TAX REVENUE 2016 9,247 0 2015 9,084 0 2014 8,650 0 #DIV/0! #DIV/0! 9084 8650 873,446 791,451 1% 1% 1% 0 9247 9084 8650 768 760 1183% 1138% 416 392 407 735.00 768.00 760.00 #DIV/0! RETURN ON ASSET PROFIT AFTER TAX total asset RETURN ON EQUITY PROFIT AFTER TAX EQUITY 9247 933,078 735 1258% STABILITY RATIO DEBT TO EQUITY DEBT EQUITY debt to equity 57% 51% 54% 9247 9084 8650 #DIV/0! #DIV/0! #DIV/0! INTEREST COVER PROFIT AFTER TAX INTEREST EXPENSE interest cover liquidity ratio Total curre Total nt curre asset nt s liabili ties current rat 0 0 0 2,373 2,166 0 0 #DIV/0! 0 Fiscal data as of Jun 30 2016 2016 2015 2014 ASSETS Cash And Short Term Investments Total Receivables, Net Total Inventory Prepaid expenses Other current assets, total Total current assets Property, plant & equipment, net Goodwill, net Intangibles, net Long term investments Note receivable - long term Other long term assets Total assets -- -- -- ---- ---- ---- -- -- -- -- -- -- 3,940 2,833 2,816 7,925 2,459 2,776 7,599 2,371 2,637 7,566 2,226 1,844 -- -- -- -933,078 -873,446 -791,451 34,100 2,453 42,893 2,718 30,672 2,467 LIABILITIES Accounts payable Accrued expenses Notes payable/short-term debt Current portion long-term debt/capital leases Other current liabilities, total Total current liabilities Total long term debt Total debt Deferred income tax Minority interest Other liabilities, total Total liabilities -- -- -- -- -- -- 1,112 743 688 -176,828 196,506 340 550 65,459 872,872 -167,253 182,295 351 562 59,254 821,015 -151,813 163,900 366 537 50,592 742,640 34,129 27,898 27,327 0 0 0 24,698 22,469 19,818 -284 -279 -291 451 1,212 60,206 785 619 52,431 836 182 48,811 SHAREHOLDERS EQUITY Common stock Additional paid-in capital Retained earnings (accumulated deficit) Treasury stock - common Unrealized gain (loss) Other equity, total Total equity Total liabilities & shareholders' equity Total common shares outstanding Treasury shares common primary issue 933,078 873,446 791,451 1,711 1,623 1,625 4.08 4.65 5.55 DATE Friday, September 09, 2016 Thursday, September 08, 2016 Wednesday, September 07, 2016 Tuesday, September 06, 2016 Monday, September 05, 2016 Friday, September 02, 2016 Thursday, September 01, 2016 Wednesday, August 31, 2016 Tuesday, August 30, 2016 Monday, August 29, 2016 Friday, August 26, 2016 Thursday, August 25, 2016 Wednesday, August 24, 2016 Tuesday, August 23, 2016 Monday, August 22, 2016 Friday, August 19, 2016 Thursday, August 18, 2016 Wednesday, August 17, 2016 Tuesday, August 16, 2016 Monday, August 15, 2016 Thursday, August 11, 2016 Wednesday, August 10, 2016 Open High Low Close 71.5 71.6 70.87 70.87 72.6 72.66 71.51 72.06 72.2 72.56 71.81 72.56 72.47 72.47 71.61 71.76 71.62 72.31 71.43 72.31 71.38 71.45 70.82 70.91 71.62 71.93 71.14 71.51 72.53 72.61 71.69 71.81 73.06 73.26 72.84 72.9 73.1 73.35 72.47 72.64 74.13 74.16 73.25 73.26 74.47 74.5 73.93 74 74 74.79 74 74.46 73.59 73.99 73.45 73.85 73.46 73.69 73 73.12 73.12 73.66 72.77 73.45 73.97 74.39 73.08 73.12 73.5 74.2 73.44 74.04 76.72 76.72 76 76 76.2 76.68 75.67 76.3 76.68 76.7 75.5 76.01 76.73 76.85 75.56 75.95 78 79.09 77.21 77.4 Volume gain/loss 3,309,369 3,063,887 3,360,622 2,054,767 2,493,060 3,370,159 2,982,612 6,289,559 2,403,744 2,904,787 4,685,969 2,072,246 2,530,008 2,596,089 2,485,948 2,114,342 4,316,515 6,372,697 3,271,475 2,708,901 4,395,273 4,329,874 4,090,305 -1.19 -0.5 0.8 -0.55 1.4 -0.6 -0.3 -1.09 0.26 -0.62 -0.74 -0.46 0.61 0.73 -0.33 0.33 -0.92 -1.96 -0.3 0.29 0.06 -1.45 O pen Close Hig Vol Open Close High Volume Low Date Friday, September 09, 2016 Thursday, September 08, 2016 Wednesday, September 07, 2016 Tuesday, September 06, 2016 Monday, September 05, 2016 Friday, September 02, 2016 Thursday, September 01, 2016 Wednesday, August 31, 2016 Tuesday, August 30, 2016 Monday, August 29, 2016 Friday, August 26, 2016 Thursday, August 25, 2016 Wednesday, August 24, 2016 Tuesday, August 23, 2016 Monday, August 22, 2016 Friday, August 19, 2016 Thursday, August 18, 2016 Wednesday, August 17, 2016 Tuesday, August 16, 2016 Monday, August 15, 2016 Friday, August 12, 2016 Thursday, August 11, 2016 Wednesday, August 10, 2016 Open High Low Close 42.91 42.93 42.36 42.65 43.16 43.63 42.89 43.11 42.44 43.17 42.44 43.04 42.31 42.76 42.31 42.58 42.63 42.77 42.45 42.6 42.38 42.5 42.06 42.4 42.4 42.77 42.1 42.53 43.12 43.12 42.34 42.44 43.13 43.24 42.88 43.03 43.25 43.34 42.64 42.86 43.79 44.56 43.66 44.33 42.75 43.81 42.75 43.66 43.28 43.28 42.2 42.63 43.34 43.8 43.34 43.58 42.92 43.48 42.86 43.23 42.85 43.23 42.77 43.03 43.27 43.3 42.82 42.98 42.86 43.3 42.84 43.22 42.46 42.7 42.36 42.64 42.6 42.74 42.52 42.6 42.76 42.79 42.33 42.59 42.14 42.67 42.06 42.46 42.3 42.38 42.06 42.27 Volume gain/loss 2,786,721 4,109,409 3,134,939 2,005,402 1,855,754 2,881,275 2,522,755 2,711,462 2,436,503 3,827,696 5,423,904 4,037,511 3,137,855 2,386,021 1,643,937 1,387,970 2,168,652 2,180,490 1,577,074 1,332,196 2,273,403 1,382,809 1,627,433 -0.46 0.07 0.46 -0.02 0.2 -0.13 0.09 -0.59 0.17 -1.47 0.67 1.03 -0.95 0.35 0.2 0.05 -0.24 0.58 0.04 0.01 0.13 0.19 6000000 5000000 4000000 3000000 2000000 1000000 0 Open High Low Close Volume Fiscal data as of Jun 30 2016 2016 2015 2014 65,981 62,447 60,181 45,525 43,045 41,424 12,884 11,854 11,280 1,296 2,111 1,219 -20 1,082 693 2,933 2,672 2,972 64,635 58,688 57,386 1,346 -42 3,759 -44 2,795 -61 1,038 3,444 2,449 631 407 -- 1,004 2,440 -- 939 1,510 -- 407 2,440 1,510 -407 0 2,440 1,179 2,689 Inc.avail. to common excl. extra. Items 407 2,440 1,510 Inc.avail. to common incl. extra. Items 407 2,440 2,689 1,123 1,129 1,126 0.36 2.16 1.34 0.36 2.16 2.39 -- -- 1,125 1,131 1,128 0.36 2.16 1.34 0.36 2.16 2.38 REVENUE AND GROSS PROFIT Total revenue OPERATING EXPENSES Cost of revenue total Selling, general and admin. expenses, total Depreciation/amortization Unusual expense(income) Other operating expenses, total Total operating expense Operating income Other, net INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS Net income before taxes Provision for income taxes Net income after taxes Minority interest Net income before extra. Items Total extraordinary items Net income EPS RECONCILIATION Basic/primary weighted average shares Basic/primary eps excl. extra items Basic/primary eps incl. extra items Dilution adjustment Diluted weighted average shares Diluted eps excl. extra items Diluted eps incl. extra items COMMON STOCK DIVIDENDS -- DPS - common stock primary issue Gross dividend - common stock 1.86 2 1.93 -- 2,247 2,286 -- -- -- 266 271 285 981 1,101 1,047 2,111 -20 693 Normalized income before taxes Effect of special items on income taxes Income tax excluding impact of special items 3,149 3,424 3,142 739 -5.83 266 1,370 998 1,205 Normalized income after tax 1,779 2,426 1,937 Normalized income avail. to common Basic normalized EPS Diluted normalized EPS 1,779 2,426 1,937 1.58 1.58 2.15 2.14 1.72 1.72 PRO FORMA INCOME Pro forma net income Interest expense, supplemental SUPPLEMENTAL INCOME Depreciation, supplemental Total special items NORMALISED INCOME PROFITABILITY RATIO PROFIT AFTER TAX REVENUE 2016 407 65,981 1% 2015 2440 62,447 2014 2689 60,181 4% 0.0446818763 RETURN ON ASSET PROFIT AFTER TAX 407 total asset 40,783 2440 2689 40,402 39,727 1% 6% 7% 0 407 2440 2689 24,781 25,987 10% 10% 6,528 24,781.00 5,065 25,987.00 32% 26% 19% 407 2440 2689 271 285 9.00 9.44 9,684 9,093 9,311 10,424 9,726 8,229 RETURN ON EQUITY PROFIT AFTER TAX 22,949 EQUITY 2% STABILITY RATIO DEBT TO EQUITY DEBT EQUITY debt to equity 7,303 22,949.00 INTEREST COVER PROFIT AFTER TAX INTEREST EXPENSE interest cover 266 1.53 liquidity ratio Total current assets liabiliti es current ratio 0.929009977 0.9349167181 1.1314862073 Fiscal data as of Jun 30 2016 2016 2015 2014 611 711 2,067 2,463 6,260 -350 9,684 2,269 5,497 -616 9,093 1,584 5,336 -324 9,311 9,612 10,205 9,952 14,448 4,625 605 14,708 4,601 562 14,510 4,446 540 -- -- 767 40,783 675 40,402 527 39,727 6,491 -- 5,761 1,042 5,417 967 ASSETS Cash And Short Term Investments Total Receivables, Net Total Inventory Prepaid expenses Other current assets, total Total current assets Property, plant & equipment, net Goodwill, net Intangibles, net Long term investments Note receivable - long term Other long term assets Total assets -- LIABILITIES Accounts payable Accrued expenses Notes payable/short-term debt Current portion long-term debt/capital leases Other current liabilities, total Total current liabilities Total long term debt Total debt Deferred income tax Minority interest Other liabilities, total Total liabilities -- 6 1 1,632 1,907 744 2,301 1,010 1,100 10,424 5,671 7,303 --1,739 17,834 9,726 4,615 6,528 --1,280 15,621 8,229 4,320 5,065 --1,191 13,740 Common stock Additional paid-in capital Retained earnings (accumulated deficit) Treasury stock - common Unrealized gain (loss) Other equity, total Total equity 21,937 -- 21,844 24 22,708 24 1,040 2,920 3,068 ---28 22,949 ---7 24,781 --187 25,987 Total liabilities & shareholders' equity 40,783 40,402 39,727 SHAREHOLDERS EQUITY Total common shares outstanding Treasury shares - common primary issue 1,126 1,124 1,123 0 0 0 Fiscal data as of Jun 30 2016 2016 2015 2014 16,200 15,816 15,352 10,758 11,039 11,865 2,156 2,037 2,034 1,224 1,096 1,422 -143 93 3,342 563 461 465 14,557 14,768 19,124 1,643 -- 1,048 -40 -3772 -39 REVENUE AND GROSS PROFIT Total revenue OPERATING EXPENSES Cost of revenue total Selling, general and admin. expenses, total Depreciation/amortization Unusual expense(income) Other operating expenses, total Total operating expense Operating income Other, net INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS 1,424 789 -3976 395 229 -1133 1,029 0 560 -3 -2843 0 Net income before extra. Items Total extraordinary items Net income 1,029 557 -2843 -1,029 -557 --2843 Inc.avail. to common excl. extra. Items 1,029 557 -2843 Inc.avail. to common incl. extra. Items 1,029 557 -2843 2,062 2,062 2,077 0.5 0.27 -1.37 0.5 0.27 -1.37 Net income before taxes Provision for income taxes Net income after taxes Minority interest EPS RECONCILIATION Basic/primary weighted average shares Basic/primary eps excl. extra items Basic/primary eps incl. extra items Dilution adjustment Diluted weighted average shares Diluted eps excl. extra items -- -- -- 2,062 2,062 2,077 0.5 0.27 -1.37 Diluted eps incl. extra items 0.5 0.27 -1.37 0.07 0 0 COMMON STOCK DIVIDENDS DPS - common stock primary issue Gross dividend - common stock -- 0 0 -- -- -- -- 307 246 PRO FORMA INCOME Pro forma net income Interest expense, supplemental SUPPLEMENTAL INCOME Depreciation, supplemental Total special items 1,224 1,014 1,351 -143 164 3,867 1,281 953 -109 -40 48 1,353 355 277 220 Normalized income after tax 926 676 -329 Normalized income avail. to common Basic normalized EPS Diluted normalized EPS 926 673 -329 0.45 0.45 0.33 0.33 -0.16 -0.16 NORMALISED INCOME Normalized income before taxes Effect of special items on income taxes Income tax excluding impact of special items PROFITABILITY RATIO 2016 PROFIT AFTER TAX REVENUE 1,029.00 16,200.00 6% 2015 2014 560.00 (2,843.00) 15,816.00 15,352.00 4% -0.1851875977 RETURN ON ASSET PROFIT AFTER TAX 1029 560 -2843 16705 17530 17318 6% 3% -16% RETURN ON EQUITY PROFIT AFTER TAX 0 1029 560 -2843 EQUITY 3,255 3,442 2,862 32% 16% -99% total assets STABILITY RATIO DEBT TO EQUITY DEBT EQUITY debt to equity 5,126.00 1,355.00 5,562.00 1,134.00 6,483.00 902.00 378% 490% 719% 1029 560 -2843 INTEREST COVER PROFIT AFTER TAX INTEREST EXPENSE interest cover liquidity ratio -#VALUE! 307.00 1.82 246.00 (11.56) Total current Total assets current liabilities current ratio 3,458 5,049 4,932 7,028 7,470 7,525 68% 66% 49% iscal data as of Jun 30 2016 2016 2015 2014 Cash And Short Term Investments Total Receivables, Net Total Inventory Prepaid expenses Other current assets, total 2,209 2,908 3,001 795 959 1,196 336 -- 322 109 317 104 118 751 314 Total current assets Property, plant & equipment, net Goodwill, net Intangibles, net Long term investments Note receivable long term Other long term assets Total assets 3,458 5,049 4,932 11,670 10,715 10,500 -909 206 597 195 546 243 134 143 134 134 158 252 362 296 16,705 17,530 17,318 1,986 550 613 ASSETS LIABILITIES Accounts payable Accrued expenses Notes payable/short-term debt Current portion long-term debt/capital leases Other current liabilities, total Total current liabilities Total long term debt Total debt Deferred income tax Minority interest -- 682 781 0 0 0 644 771 1,210 4,398 5,467 4,921 7,028 7,470 7,525 4,482 4,791 5,273 5,126 5,562 6,483 -5 -- -5 4 Other liabilities, total Total liabilities 1,935 1,822 1,654 13,450 14,088 14,456 3,625 4,630 4,630 SHAREHOLDERS EQUITY Common stock Additional paid-in capital Retained earnings (accumulated deficit) Treasury stock common Unrealized gain (loss) Other equity, total Total equity Total liabilities & shareholders' equity Total common shares outstanding Treasury shares common primary issue -- -- -- -320 -1068 -1639 -50 -7 -16 -- -- -- -3,255 -113 3,442 -113 2,862 16,705 17,530 17,318 1,905 2,059 2,055 14 3.3 7.73 date Open High Low Close Friday, September 09, 2016 3.31 3.35 3.3 3.31 Thursday, September 08, 2016 3.35 3.37 3.33 3.33 Wednesday, September 07, 2016 3.33 3.41 3.31 3.39 Tuesday, September 06, 2016 3.29 3.4 3.26 3.39 Monday, September 05, 2016 3.26 3.3 3.25 3.28 Friday, September 02, 2016 3.29 3.29 3.24 3.26 Thursday, September 01, 2016 3.25 3.31 3.24 3.27 Wednesday, August 31, 2016 3.25 3.26 3.23 3.24 3.3 3.33 3.24 3.24 3.35 3.35 3.28 3.29 3.34 3.41 3.31 3.35 3.48 3.48 3.34 3.36 Wednesday, August 24, 2016 3.48 3.58 3.42 3.45 Tuesday, August 23, 2016 3.45 3.47 3.39 3.4 Monday, August 22, 2016 3.38 3.44 3.38 3.43 Tuesday, August 30, 2016 Monday, August 29, 2016 Friday, August 26, 2016 Thursday, August 25, 2016 Friday, August 19, 2016 Thursday, August 18, 2016 3.35 3.38 3.35 3.36 3.39 3.39 3.32 3.37 Wednesday, August 17, 2016 3.34 3.38 3.31 3.35 Tuesday, August 16, 2016 3.33 3.34 3.3 3.34 Monday, August 15, 2016 3.22 3.34 3.22 3.34 3.22 3.23 3.19 3.21 3.14 3.21 3.13 3.21 3.16 3.17 3.12 3.16 Friday, August 12, 2016 Thursday, August 11, 2016 Wednesday, August 10, 2016 Volume gain/loss 9,463,162 9,097,714 -0.02 14,311,484 -0.06 13,947,194 0 5,056,074 0.11 7,944,290 0.02 7,072,304 -0.01 8,061,537 0.03 7,148,418 0 5,500,818 -0.05 11,422,812 -0.06 13,683,610 -0.01 21,641,493 -0.09 11,390,337 0.05 12,416,660 -0.03 25000000 20000000 15000000 10000000 5000000 0 5,707,357 0.07 7,031,346 -0.01 8,486,129 0.02 7,656,122 0.01 11,736,370 0 7,341,905 0.13 4,197,517 0 6,114,417 0.05 Open High Low Close Volume GENERAL PRESENTATION ... Referencing - using Harvard References other than textbook and Subject Resource Workbook Complete / Alphabetical By Surname/ Proper Format Format and Presentation Report Format / Typed / Cover Page / Table Of Contents / Page Numbers / Spelling / English Expression / Comparative Tables / Professional Presentation / Word Limit TOTAL MARKS 5 marks 5 marks 100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles

Authors: Jerry Weygandt, Paul Kimmel, Donald Kieso

11th Edition

9781118566671

Students also viewed these Accounting questions