HI5002 Company Performance Analysis: Macquarie Group Assessment Answer

pages Pages: 4word Words: 890

Question :

Assessment Details and Submission Guidelines
TrimesterT1 2019
Unit CodeHI5002
Unit TitleFinance for Business
Assessment TypeGroup Assignment
Assessment TitleCompany Performance Analysis
Purpose of the assessment (with ULO Mapping)
Students are required to form a group from 2 to 5 members to study, undertake research, analyse and conduct academic work within the areas of business finance covered in learning objectives 1, 3, 4, 5, 8, 10 & 11. The assignment should examine the main issues, including underlying theories, implement performance measures used and explain the firm financial performance. Your group is strongly advised to reference
professional websites, journal articles and text books in this assignment.
Weight30 % of the total assessments
Total Marks30
Word limitNot more than 3,000 words
Submission Guidelines
  • All work must be submitted on Blackboard by the due date along with a completed Assignment Cover Page. Make sure that your group member’s name and surname, student ID, unit name, and code and lecture’s name are written on the cover sheet of the submitted assignment.
  • The assignment must be in MS Word format, no spacing, 12-pt Arial font and 2 cm margins on all four sides of your page with appropriate section headings and page numbers.
  • Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using Harvard referencing style.
  • Submitted work should be your original work showing your creativity. Please ensure the self-check for plagiarism to be done before final submission in accordance with SafeAssign Student Guide in Black Board. As a guide, a similarity score of over 30% is considered as excessive except in the cases where the similarity is caused by the use of template provided by the lecturer, references or sources of data. Please note that it takes 48 hours for the self- check report to be available for your viewing.
  • When you submit your assignment electronically, please save the file as ‘Group Assignment- your group name .doc’. You are required to submit the assignment at Group Assignment Final Submission, which is under Assignment and Due Dates on Black Board. Always keep an electronic copy until you have received the final grade for the Unit. Please make sure that you submit the correct file. Any appeal relating to submitting wrong files after the deadline will not be considered.

Assignment Tasks


This assignment task is a written report and analysis of the financial performance of one selected listed company on the ASX in order to provide financial and investment advice to a wealthy investor. This assignment requires your group to undertake a comprehensive examination of a firm’s financial performance based on update financial statements of the selected company.


You’re a group of investment analysts who work for a large investment consulting firm based in Australia. There’s one big institutional investor from overseas that is interested in investing in the Australian market. You’ve been asked to choose one listed company the industry you think will have the most promising future for investment in Australia, then evaluate the performance of that company. Finally make a recommendation through your Report to the investor whether and why they should or should not invest in the company.

Create your group’s “business name” under which your group will be providing the financial advisory services. Choose one listed company that your group will investigate/analyse for the purposes of possible recommendation to your client. The group should obtain all information about the selected company from this web site: www.asx.com.au.


Obtain copies of Annual Reports including Income Statements, Balance Sheets, and Statement of Changes in Equity, Cash Flows Statements and Notes for three (3) financial year 2015-2016, 2016- 2017 and 2017-2018. Your group can download these documents from the suggested web site using the firm’s code (example, BHP- for BHP Billiton Company, etc.). The assignment should cover the contents described in Part 1 to 7 bellows.

1Description of operation and comparative advantages of the selected company.
2Identify and conduct a trend analysis with two groups of financial ratiosincluding
profitability, and operating efficiency of the selected company.
3Identify the marketable securities that are available in current assets of the company. Discuss using of these securities as an instrument for cash management by the company.
4Perform a sensitivity analysis with data provided.
5Identify and discuss the systemic risks and un-systemic risks that may affect performance of
the selected company.
6Calculate the dividend payout ratio and comment on the dividend policy of the chosen
company through 3 years
7Recommendation Letter

Final Submission of Complete Assignment on Blackboard (Week 10)

Assignment Structure and Details of Assignment Tasks

Assignment structure and assignment tasks should be as the following:


(no more than 200 words)

1. Introduction

Briefly introduction of you work: the purpose of assignment, the selected company, your findings and structure of your assignment

(not more than 300 words)

2. Financial Analysis of selected company

Description of the company

Prepare a brief description of the selected company, outlining the core activities, the market(s) in which they operate within and any factors in the company’s history which you consider help present the pictures of your company. Identify and comment on their comparative advantages.

Calculation and analysis of selected performance ratios

Using financial data obtained from current financial statements of your selected companies for the past 3 years. Annual reports are accessible via company websites or ASX website. Your client requests a comprehensive analysis of two groups of financial ratios, including profitability and operating efficiency of the company. Choose the relevant financial ratios for your analysis to meet your client’s requirement. Do a research to explain the trend of financial ratios of the selected company through 3 years to your client. You need to provide charts and/or tables for analysis and justification.

Cash management analysis: Identify the marketable securities that are available in current assets of the company. Discuss using of these securities as an instrument for cash management by the company. Tips: try to do a little research about instruments of cash management to enrich your comments and analysis.

Perform a sensitivity analysis with data provided

Assume that your selected company is considering a potential project with a new product that is expected to sell for an average price of $20 per unit and the company expects it can sell 300 000 unit per year at this price for a period of 4 years. Launching this project will require purchase of a

$2 000 000 equipment that has residual value in four years of $200 000 and adding $ 600 000 in working capital which is expected to be fully retrieved at the end of the project. Other information is available below:

Depreciation method: straight line Variable cost per unit: $12

Cash fixed costs per year $300 000 Discount rate: 10%

Tax Rate: 30%

Do an analysis with cash flows of the project to determine the sensitivity of the project NPV with the following changes in the value drivers and provide your results in (a) relevant tables:

Unit sales decrease by 10% Price per unit decreases by 10%

Variable cost per unit increases 10%

Cash fixed cost per year increases by 10%

Show More

Answer :

Company Performance Analysis     (HI 5002)
Macquarie Group


As a group of investment analysts who work for an investment consulting firm based in Australia, the following report provides a comprehensive financial analysis for an Australian publically listed company. 

The objective is to provide investment recommendation to a large investor overseas. The company selected for the purpose is the Macquarie Group Limited which is a large group in Australia. 

The report will provide overview of the company, its operational segments and its key performance parameters from 2016 till 2018. For this purpose, key ratios analysis will also be performed. Additionally, a sensitivity analysis will also be done. 

Basis the above analysis, conclusion and recommendation will be drawn for the purpose of investment in the Group.


The following pages present a financial analysis of the Australian company Macquarie Group Limited on behalf of the Group XXX. The objective is to provide financial and investment advice to investor XXX from XXX. Hence, the report will provide a comprehensive analysis of the company, including the core business of the company, operations, its performance during three years from 2016 till 2018, performance basis various key ratios as well as the trend analysis, sensitivity analysis, dividend policy, risk analysis, thereby, to provide an overview of the company’s investment prospects.

The key performance ratios that will be covered are: (i) Profitability Ratios which indicate the margins and profitability of the company on year-on-year basis, (ii) Efficiency Ratios which indicate the level of efficiency with which various resources are being utilized in the company. These are famously also known as Turnover Ratios, (iii) Liquidity Ratios which indicate the level of liquidity (mainly cash level) of the organization. These ratios are important as at any time a company may be required to discharge some liabilities or meet some urgent expenses for which liquidity plays a crucial role, (iv) Leverage Ratios which indicate the leverage or debt level in the capital structure and how well the organization is insulated from the impact of fixed obligations that come along with the debt and (v) Investment Ratios which indicate various parameters that an investor or a prospective investor will be interested in such as the dividend pay-out ratio and earnings per share etc.

Basis the above analysis of the Macquarie Group, a conclusion would be formed regarding the financial state of the company, various parameters on which it is doing very good and issues or concerns that can be seen currently or in nearby future. This conclusion will form the basis for recommendation to investor XXX regarding the investment in Macquarie Group limited and linked risks.

Financial Analysis of the Company

(i) Description of the Company

As discussed above, the selected company is Macquarie Group (ASX: MQG) which is headquartered in Sydney, Australia and was founded in 1969. The company is involved in the business of providing investment banking and financial services and currently employs around 14,500 employees across 25 countries. A total of AUD 497billion assets were under management of the group as of 31st March, 2018, an increase of almost AUD 15billion over previous period.

As of March 2018, the group reported total assets of AUD 191.3billion with equity of AUD 18.2billion. The company reported a net profit of AUD 2.6million for the year which is an increase of 15% over previous year. In fact, the company has reported profits continuously for 49 years, which is a record in itself. The Return on Equity for the period was reported at 16.8%, an increase over 15.2% in previous period.

The numbers above indicate that the company has been doing well with various businesses such as, Macquarie Asset Management, Corporate and Asset Finance, Banking & Financial Services, Commodities and Global Markets segments all contributing to the organization’s growth. The Company has even been able to sail through difficult economic times with record profits through the contribution of various segments and unmatched expertise of the Company.

As discussed above, the subject Company is a financial group that is involved in the variety of financial services such as, advisory, baking, financial solutions and risk / capital solutions. The main operating segments and their contribution to Net Profit of the company can be seen as below (the first three segments together are known as ‘Annuity-Style Businesses’ while the last two segments are together known as ‘Capital Markets Facing Businesses’):

 Macquarie Group

  1. Macquarie Asset Management: The segment is further divided basis the sector, such as Infrastructure and Real Assets, Investment Management, and Specialised Investment Solutions. The group is worldwide leader in this segment, especially in alternative asset management, such as, infrastructure, agriculture, real estate etc. The group also offers multiple solutions across debt and equity markets.
  2. Corporate and Asset Finance: The segment is further divided into Asset Finance and Principal Finance. Asset Finance provides customised asset management solutions in variety of sectors. Principal Finance provides customised financing solutions in primary and secondary markets globally.
  3. Banking and Financial Services: This segment is operational in Australian market only and is further divided into Personal Banking, Wealth Management and Business Banking. Personal Banking segment provides retail banking products to its clients. Wealth Management segment provides cash management services, investment products and advisory services to its clients. Business Banking segment provides lending solutions to its customers. This segment mainly caters to business clients and professional firms.
  4. Commodities and Global Markets: This segment provides comprehensive solutions in global markets to clients who need these solutions in any market, equity shares, commodities or fixed income markets. This segment is further divided into seven divisions based on the type of market, such as, equity, commodity, fixed income, cash, credit etc.
  5. Macquarie Capital: This segment is involved in providing capital market advisory services to such corporate, institutional clients and government etc. who are involved in transactions such as, mergers and acquisitions, fund raisings, restructuring etc.

(ii) Calculation and Analysis of Selected Performance Ratios

As discussed earlier, we will be calculating major performance ratios under following five heads:

  1. Profitability Ratios indicate the margins and profitability of the company on year-on-year basis. The Return on Equity ratio for the Group has improved consistently on year-on-year basis. The ratio was at 13.8% in 2016, 14.4% in 2017 and 15.8% in 2018. Net Interest Margin indicates the interest income earned with respect to the earning assets of the bank. The ratio improved slightly in 2017 but has again declined in 2018. The ratio was at 1.53% in 2016, 1.54% in 2017 and 1.45% in 2018.
  2. Efficiency Ratios indicate the level of efficiency with which various resources are being utilized in the company. These are famously also known as Turnover Ratios. In case of given Company, we can calculate the efficiency ratio by dividing operating expenses excluding interest expense by net operating income. This indicates the control over expenses with respect to income earned. The ratio has declined consistently indicating that the Group is becoming more efficient with respect to expenses. The ratio was at 70.3% in 2016, 70.1% in 2017 and 68.3% in 2018.
  3. Liquidity Ratios indicate the level of liquidity (mainly cash level) of the organization. These ratios are important as at any time a company may be required to discharge some liabilities or meet some urgent expenses for which liquidity plays a crucial role. The current ratio as well as the quick ratio for the Group has consistently declined over the period, indicating reduced liquidity. However, the current levels seem sufficient and hence, may indicate better utilization of available liquidity. The current ratio was at 1.16 in 2016, 1.01 in 2017 and 0.96 in 2018. The quick ratio was at 0.62 in 2016, 0.52 in 2017 and 0.36 in 2018.
  4. Leverage Ratios indicate the leverage or debt level in the capital structure and how well the organization is insulated from the impact of fixed obligations that come along with the debt. The debt ratio in capital structure of the group is high at 0.77 in 2018. However, the ratio has been declining since 2016 which indicate a positive trend as heavy reliance on debt is risky. The ratio was at 0.82 in 2016, 0.77 in 2017 and 0.77 in 2018. With the decline in debt and improvement in profit, the interest coverage ratio has also improve dover the period indicating better buffer to absorb debt interest related expenses. The ratio was at 1.95 in 2016, 2.05 in 2017 and 2.17 in 2018.
  5. Investment Ratios indicate various parameters that an investor or a prospective investor will be interested in such as the dividend pay-out ratio and earnings per share etc. The dividend pay-out ratio is high but stabilises in 2018. The high ratio indicates that major part of profits is paid as dividend instead of ploughing back into the business. The ratio was at 0.58 in 2016, 0.65 in 2017 and 0.64 in 2018. At the same time, the earning per share has improved due to high profits. The EPS (cents) was at 619.2 in 2016, 657.6 in 2017 and 758.2 in 2018.

(iii) Cash Management Analysis

Looking at the Balance Sheet of the Company, we can see that the liquid assets include Trading portfolio assets, Derivative assets and Investment securities available for sale. These assets classes formed 26.9% of total assets in 2016, 25.1% in 2017 and 18.1% in 2018. Hence, it can be seen that liquidity is slowly reducing for the Group as the Group tries to allocate its resources in the most profitable and efficient manner.

Through the Cash Flow Statement, we can see the ending cash balance was AUD 14.3million in 2016, AUD 11.8million in 2017 and AUD 13.0million in 2018. 

Hence, the cash flow seems to be stable and improved slightly in 2018 despite major financing activities in 2018 out of which dividend pay-out was the largest cash outflow. The increased cash flow from operating activities could assist in taking the burden of increased investment and financing activities in 2018.

(iv) Sensitivity Analysis

A sensitivity analysis was performed for the Group, assuming a hypothetical new project whereby a product is launched. The timeframe is 4 years with certain assumptions as available in Appendix. The four scenarios were created in order to see the sensitivity of net present value of the project. These can be summarised as follows:

Scenario Summary     
  Current Values:Unit Sales decrease by 10%Price per unit decreases by 10%Variable Costs increases by 10%Fixed Cost increases by 10%
Changing Cells:      
Result Cells:      

It can be seen that maximum NPV is at current assumed values at $3.03 million. The next closest NPV occurs at the assumption where fixed cost increases by 10%. The NPV is $29.7 million. The lowest NPV occurs when the unit price falls by 10% when NPV stands at $17.02 million.

Hence, we can see that the scenario is least sensitive to changes in fixed cost and most sensitive to changes in price per unit. The scenario is also reasonably sensitive to changes in variable cost and number of units sold.

(v) Systemic & Unsystemic Risks

The group has a robust risk management system which is a part and parcel of each group and division within the organization. This helps the organization to sail through the worst times and minimise disruptions as far as possible. 

The Group also takes a conservative approach such that it has been able to report profits for 49 consecutive years irrespective of the global economic conditions. Further, the business is well-diversified across segments as discussed earlier such that it is able to deliver consistent results.

Apart from these measures, the Group boasts of deep expertise in the field combined with knowledge of the nuances of local markets such that it has been able to become a leader in many areas. 

The Group continues to remain dynamic by pursuing relevant and organic growth opportunities.

However, despite all of these, the Group remains exposed to multiple risks which are systemic as well as unsystemic. 

The Group cannot control market conditions or economic conditions of a market which is bound to impact the Group’s numbers. Similarly, the exchange rate of Australian Dollar against major currencies is another major risk. Due to large portion of income being in foreign currencies, this risk prevails although the Group makes efforts to hedge it to the maximum extent possible. Additionally, any regulatory changes related to the area of business in domestic or international environment may impact the Group adversely (or favourably).

Further, there are certain types of risks that arise due to nature of business despite all the risk management procedures. For example, the Group is exposed to risks of wilful misconduct by employees, cyber-crime, information and data security related risks, liquidity risks due to increased cost of financing, operational risks etc.

(vi) Dividend Pay-out Ratio & Dividend Policy

The Company has been paying very high dividends which is a delight for the shareholder but may indicate limited growth opportunities. Instead of heavy reliance on debt, equity funds can be ploughed back into the business. Further, the high dividend pay-out also creates expectations and unnecessary burden on the company to pay even higher dividends. Ultimately, this is a loss for the equity shareholder in the long run as the dividends paid out could have been utilised in a better way to earn larger profits for them.

However, over the period, the Group seems to be reducing the ratio slowly.

Recommendation Letter & Conclusion

It can be seen from above analysis that the Macquarie Group is one of the oldest and most experienced organizations in the field of financial and banking services. The Group has wide and extensive experience in various types of markets, be it based on geography or the type of security or the type of solution required by customer. The organization is leader in providing customised solutions in a variety of sectors such as real assets, real estate, infrastructure etc. Apart from this, it also provides banking services in Australia.

Hence, the group is well diversified such that it can absorb multiple types of risks and continue to provide good refutes to its stakeholders. This is clearly evident in the fact that the organization has reported profits for 49 consecutive years which is a record in itself. The group has reported profit even when the global economic scenario was not particularly upbeat indicating the strength of the Group.

Further, the Group keeps focus on organic growth opportunities such that it can avail these opportunities to provide magnified benefits to its stakeholders.

The results are evident in high dividend pay-out ratio and consistently increasing earnings per share. The Return on Investment ratio also indicates increasing trend which is a positive sign. The performance ratios as analysed above also indicate good control over expenses and increased profits trend. The group is able to utilize and appropriate its resources in an efficient manner. The debt is on the higher side but shows a declining trend over the period with increased interest coverage which indicates that the group is aware about the same.

Hence, it is recommended to include the above discussed company, The Macquarie Group Limited in the investment portfolio as it is expected to enhance the value of your portfolio.


Income Statement

Interest and similar income 5,461 5,138 4,943
Interest expense and similar charges -3,182 -2,953 -2,957
Net interest income/(expense) 2,279 2,185 1,986
Fee and commission income 4,862 4,331 4,670
Net trading income 2,067 1,758 1,957
Share of net profits of associates and joint ventures 880 921 935
accounted for using the equity method 4 51 241
Other operating income and charges 66 1,118 1,131
Net operating income 10,158 10,364 10,920
Employment expenses -4,244 -4,379 -4,493
Brokerage, commission and trading-related expenses -892 -852 -830
Occupancy expenses -397 -392 -402
Non-salary technology expenses -587 -644 -604
Other operating expenses -1,023 -993 -1,127
Total operating expenses -7,143 -7,260 -7,456
Operating profit before income tax 3,015 3,104 3,464
Income tax expense -927 -868 -883
Profit after income tax 2,088 2,236 2,581
(Profit)/loss attributable to non-controlling interests:   
Macquarie Income Securities -16 -15 -14
Macquarie Income Preferred Securities -1 0 0
Other non-controlling interests -8 -4 -10
Profit attributable to non-controlling interests -25 -19 -24
Profit attributable to ordinary equity holders of Macquarie Group Limited 2,063 2,217 2,557
Basic earnings per share 619 658 758
Diluted earnings per share 600 645 744

Balance Sheet

Receivables from financial institutions33,12827,47138,559
Trading portfolio assets23,53726,93315,585
Derivative assets17,98312,10612,937
Investment securities available for sale11,4566,8936,166
Other assets12,49616,55818,370
Loan assets held at amortised cost80,36676,66381,150
Other financial assets at fair value through profit or loss1,6491,5021,434
Due from subsidiaries000
Property, plant and equipment11,52111,00911,426
Interests in associates and joint ventures2,6912,0954,055
Intangible assets1,0781,009993
Investments in subsidiaries000
Deferred tax assets850638650
Total assets1,96,7551,82,8771,91,325
Trading portfolio liabilities5,0305,0678,061
Derivative liabilities14,74411,12811,925
Other liabilities13,10315,03116,086
Payables to financial institutions23,86017,07215,440
Due to subsidiaries000
Debt issued at amortised cost63,68550,82853,717
Other debt issued at fair value through profit or loss2,6722,4042,363
Deferred tax liabilities543621749
Total liabilities excluding loan capital1,75,8821,59,8591,67,753
Loan capital5,2095,7485,392
Total liabilities1,81,0911,65,6071,73,145
Net assets15,66417,27018,180
Contributed equity6,4226,2906,243
Retained earnings7,1587,8778,817
Total capital and reserves attributable to ordinary equity holders of Macquarie Group Limited15,11615,56316,357
Non-controlling interests5481,7071,823
Total equity15,66417,27018,180

Statement of Cash Flows

Cash flows from/(used in) operating activities   
Interest and similar income received5,4555,1614,908
Interest expense and similar charges paid-3,125-2,843-2,940
Fees and other non-interest income received2264,4844,405
Fees and commissions paid4,961-909-877
Operating lease income received-8351,6071,831
Dividends and distributions received1,541209228
Employment expenses paid-2,114-3,885-3,913
Operating expenses paid-2,065-1,401-1,836
Income tax paid-4,102-723-483
Changes in operating assets and liabilities:   
  Net receipts from trading portfolio assets and other assets/liabilities-1,1783,9013,937
  Net movement in deposits1,0565,5611,499
  Net movement in debt issued at amortised cost-972-12,3032,500
  Net movement in payables to financial institutions and other borrowings-1,013-4,259182
  Net movement in loan assets and balance with related entities3141,012-3,610
  Net margin money paid15,359-1,104-184
  Net payments for assets under operating lease-685-320-1,202
Life business:   
  Life investment linked contract premiums received, disposal of investment assets and other unitholder contributions12,8231,1811,104
  Life investment linked contract payments, acquisition of investment assets and other unitholder redemptions-2,406-1,077-1,099
Net cash flows from/(used in) operating activities1,897-5,7084,450
Cash flows (used in)/from investing activities   
Net proceeds from investment securities available for sale and financial instruments designated at fair value-14,5803,212111
Proceeds from the disposal of or capital return from associates, subsidiaries and businesses, net of cash deconsolidated342,8693,510
Payments for the acquisition of associates or capital contribution, subsidiaries and businesses, net of cash acquired-183-2,619-4,224
Proceeds from the disposal of property, plant and equipment, and intangible assets-15,238058
Payments for the acquisition of property, plant and equipment, and intangible assets530-329-255
Net cash flows (used in)/from investing activities1203,133-800
Cash flows (used in)/from financing activities   
(Payments for)/Proceeds from non-controlling interests1,5031,160-33
Proceeds from the issue of loan capital-7189800
Payments on redemption of loan capital-82-221-330
Dividends and distributions paid-1,228-1,477-1,663
Payments for treasury shares-363-433-373
Net cash flows (used in)/from financing activities-2389-2,399
Net increase/(decrease) in cash and cash equivalents-2,653-2,5661,251
Cash and cash equivalents at the beginning of the financial year16,97314,32011,754
Cash and cash equivalents at the end of the financial year14,32011,75413,005

Ratio Analysis

Profitability Ratios
Net Interest Margin1.16%1.19%1.04%
Efficiency Ratios
Efficiency Ratio70.3%70.1%68.3%
Liquidity Ratios
Current Ratio          1.16           1.01           0.96 
Acid Test Ratio          0.62           0.52           0.36 
Leverage Ratios
Gearing Ratio          0.82           0.77           0.77 
Interest Cover Ratio          1.95           2.05           2.17 
Investment Ratio
Dividend Payout Ratio          0.58           0.65           0.64 
EPS (cents)619.2657.6758.2

Sensitivity Analysis

Sales price per unit$20.00

Unit sales3,00,000

Cost per unit$12.00

Fixed Annual Cost$3,00,000

Investment in fixed assets$20,00,000

Residual Value$2,00,000


Income tax rate30%

Discount rate10%

Working Capital$6,00,000

Net income 01234

– Costs

– Depreciation expense

Taxable income

– Taxes

After-tax income


Annual Net Cash Flow Estimates 01234
Investment in fixed assets

CF due to change in net working capital

Net income
Add back depreciation
Net cash flows