Prepare a vertical analysis of the income statement

Assignment Help Financial Management

Reference no: EM131174101 , Length: word count:1500

ASSESSMENT: Financial Statement Analysis

Aim

This assignment is a comparative financial analysis of two airlines in Australia: Qantas ('Qantas') and Virgin Australia Holdings Limited Group ('Virgin'), as public companies listed on the ASX. This is to be presented in the form of a business report to advise potential investors as to which company would be the better investment.

Resources

To complete this assignment, you will need to access the Annual Reports of both Qantas and Virgin, found on their websites. The Investor/Shareholder Information sections of the Qantas and Virgin websites may also provide you with other relevant resources for your analysis.

Qantas: https://investor.qantas.com/investors/?page=annual-reports

Virgin: https://www.virginaustralia.com/au/en/about-us/companyoverview/investor-information/annual-reports/

Required-

Task 1 - Prepare the Analytical Data

1. Vertical analysis - For both companies, prepare a Vertical Analysis of the following statements for the years 2014 and 2015: (a) Income Statement

2. Horizontal analysis - For both companies, prepare a Horizontal Analysis of the following statements, comparing the data for the year 2015 with the previous year (2014): (a) Balance Sheet

3. Trend analysis - For both companies, prepare a Trend Analysis for the following accounts/items for the years 2012, 2013, 2014 and 2015:

(a) Sales revenue

(b) EBIT

(d) Net cash flow from Operating Activities

4. Ratio analysis - For both companies, show the mathematical formula for each of the following ratios and calculate them (show workings) for the years 2013, 2014 and 2015:

(a) Return on Assets (Profitability)

(b) Current Ratio (Liquidity)

(d) Debt to Equity Ratio (Capital Structure)

There is no word limit for task 1, as you will be preparing tables of data only and the interpretation will take place in task 2.

Task 2 - Analyse and Interpret the Data Separately for Each Company

1. Vertical analysis - For each company separately, identify and describe two key differences between the two years that have been highlighted with the vertical analysis. Comment on whether they are favourable or unfavourable.

2. Horizontal analysis - For each company separately, identify and describe two key differences between the two years that have been highlighted with the horizontal analysis. Comment on whether they are favourable or unfavourable.

3. Trend analysis - For each company separately, describe the trends that have occurred over the last 4 years for each of the items analysed. Comment on whether the trend is favourable or unfavourable, and why you think the trend may be occurring.

4. Ratio analysis - For each company separately, describe the trends that has occurred over the last 3 years for each of the ratios calculated. Comment on whether the trend is favourable or unfavourable, and why you think the trend may be occurring.

For all of the above analyses, you can use Internet research and examine the other information in the financial reports to try and identify and explain what has happened with each company. Good research will be rewarded in the marking. Remember you MUST REFERENCE all sources by using in-text references and a reference list. There is a maximum of 1,000 words total for task 2.

Task 3 - Compare the Companies to Develop a Recommendation

Using your interpretations of the vertical, horizontal, trend and ratio analyses for each company above, compare the two companies and develop a clear argument towards your final recommendation to invest in EITHER Qantas OR Virgin (maximum of 350 words).

Task 4 - Write an Executive Summary of your Findings and Recommendations

Prepare a brief executive summary of your findings and investment recommendation (maximum of 150 words) to appear at the beginning of your report.

Task 5 - Format your Reference List and Report Appropriately

Ensure you provide appropriate in-text referencing when referring to sources, and include these sources on a reference list.
Ensure you have used good English expression with correct grammar and spelling.
Ensure professional presentation of your report.
While there are no marks directly allocated to this task, your overall mark will be adjusted for poor referencing and presentation. A lack of referencing may also be a breach of academic integrity.

1500 words.

10 references.

Reference no: EM131174101

Questions Cloud

Why are foreign investors more likely to invest : Why are foreign investors more likely to invest in U.S. government bonds than in U.S. corporate bonds or? stocks?

Different from wip in kanban : Can WIP (work in progress) works in SCRUM? If yes how it is different from WIP in Kanban?

Pre-residency assignment : Pre-Residency Assignment. Reflection on the personal and professional context that has shaped your identity.

Automatic mechanism adjusting the economy : Suppose the economy is at a short−run equilibrium GDP that lies above potential GDP. Which of the following will occur because of the automatic mechanism adjusting the economy back to potential? GDP?

Prepare a vertical analysis of the income statement : Vertical analysis - For both companies, prepare a Vertical Analysis of the following statements for the years 2014 and 2015: (a) Income Statement

Define asymmetrical power relation : Define Asymmetrical power relation in recruitment and selection. The answer should be in a 1000 word essay.

Economies are expected to move toward equilibrium : In the long run, economies are expected to move toward equilibrium at the full- employment level of production. Governments, particularly in democratic countries with frequent elections, often try to use economic policy in the shortrun to improve the..

Why are fad diets so appealing to many people : Discuss the external factors that control your food intake and physical activity patterns. What improvements can you make in these areas?

What was the main character goal : The movies in Unit II all deal with major decision making. Start by identifying your movie selection and providing a brief synopsis of the core issue. What was the main character's goal? What major decision needed to be made, and by whom? What was..

User Account

All Pages