Reference no: EM131257339
Assignment
You can see that the Balance Sheet and Profit and Loss statement have been 'reformulated' to separate out operating, investment and financing items. [See Rows 32 and below for the income statement and Rows 43 and below for the Balance Sheet].
1. Examine the way in which the reformulation has been done (ie look at the cell references to determine what is operating, financing etc). Identify at least two items in the Balance Sheet that could have been reclassified in a different way. Explain why the alternative classification would be plausible or valid.
2. Analyse Qantas' profitability in the past three years.by calculating the following ratios (do not use the ratios from the "Ratio Analysis" tab - they will give you the wrong numbers. You can submit this as an excel spreadsheet. Do each of the ratios below on a new row.
a. Return on equity (use average shareholders' equity as the denominator)
b. Net operating profit after tax
c. Operating asset turnover [from b. and c. you can, and should, then calculate Return on operating assets]
d. Return on (average) investment assets
f. Return on business assets (hint: it's the 'weighted' average of the return on operating and investment assets)
e. Spread [net interest expense after tax - return on business assets]
g. Financial leverage
h. Financial leverage gain
i. Calculate ROE as Return on Business Assets + Financial leverage gain to ensure your calculations are correct. This serves as a useful checking mechanism
3. Create a chart in Excel that shows ROE, Net operating profit margin, operating asset turnover for 2013-2015 using the ratios you have calculated above. Use a separate vertical axis for the operating asset turnover to the ROE and Net operating profit margin. [There is a ton of material out on the googlemachine about creating excel charts.]
4. a) Briefly describe Qantas' performance by making references to the ratios you have just calculated. b) Discuss in particular how you would interpret the 2014 profit margin and therefore Return on Operating Assets. Identify the main concern you have with the 2014 results.
|
Explain the meaning of the term fallacy in logic
: Remember that a fallacy is a faulty argument, so, in order to properly identify the fallacy you need to first identify the argument with its two crucial parts (what are those parts? review the material discussed in week 3 if you are not sure).
|
|
Compute the debt-equity ratio for the year
: Cartel Company's financial statement for the year 2013 reported total liabilities and stockholders' equity of $1,400,000; total liabilities of $750,000; total current assets of $680,000; and total property, plant, and equipment of $720,000. Comput..
|
|
Analyze briefly the different components of the product
: Identify and describe its manufacturer. - Analyze briefly the different components of the product and breakdown each component into materials till reaching the raw materials.
|
|
Understanding of the aggregate supply and demand model
: Based on your understanding of the aggregate supply and demand model and the IS-LM model, graphically illustrate and explain what effect an increase in the money supply will have on the economy. In your graphs, clearly illustrate the short-run and..
|
|
Calculate roe as return on business assets
: Calculate ROE as Return on Business Assets + Financial leverage gain to ensure your calculations are correct. This serves as a useful checking mechanism.
|
|
Market segment for new investment
: Assume that an investor wants to select one market segment for new investment. A forecast shows improving to declining economic conditions with the following probabilities: improving (0.2); stable (0.5); and declining (0.3). What is the preferred ..
|
|
Determine the sample mean and variance for the yield
: 10 materials samples have been tested, with their Yield Strengths being recorded. This data is available on Blackboard, along with a script to load the data. Determine the sample mean and variance for the Yield Strengths using MATLAB.. Determine th..
|
|
If you were fedex or ups how would you respond
: What is your reaction? - Do you think this is a wise strategy for Amazon, or does it risk losing focus on what it does best?
|
|
Average participation rate and the average match rate
: For example, if "mrate" =0.50, then a $1 contribution by the worker is matched by a 50 cent contribution by thefirm.(i) Find the average participation rate and the average match rate in the sample of plans.
|