December 18, 2016 at 8:47 pm
@mayanisa: The problem with most students is that they don’t really have real life experience of ratio analysis so they approach it by using a text book and think that all they have to do is calculate and compare lots of ratios. This is NOT how it works at all in the real world of business and commerce! Businesses use Key Performance Indicators to measure how they are doing (alongside financial data) and these differ according to the industry sector.
The RAP should be a study of the business environment and how this impacts on financial performance. KPIs invaluable in assisting with this – aircraft utilisation for example is an efficiency ratio (airlines don’t make much money unless the aircraft is in the air and the seat occupied) and therefore a high utilisation rate is likely to correlate with higher operational profit. It may however take many complicated calculations and adjustments to work out operational profit but load factors are readily available by the day, week or month (as well as average for the year) for every route the airline operates and therefore will also influence decisions: whether to introduce more seat capacity per route/ discontinue a route, whether to invest in new aircraft etc. Normal accounting ratios are not so useful in this respect and so KPIs in many respects are more important for overall strategy formulation.
So your comment “Just curious because they don’t exactly come under financial ratios” is a typical student type of reaction because you have no experience of actually working in the airline business which operate in a very complex and dynamic environment.
PS Please if doing an airline (or a RAP on Telecommunications) DON’T bother mentioning the Quick Ratio / Acid Test. If you don’t immediately understand why, you should think about this sensibly and ask yourself a few basic questions:
Do these companies make or sell a physical product?
How much stock do they therefore have?
Now do you understand why it is pointless?December 19, 2016 at 2:18 pm
The KPI’s given on financial statements of the airlines, we need to be included in the Excel as well or just mentioned the reference of the annual report in the project and then analysed them further?
Also, do they need to compare the kPI’s of one airline to the other?
What do you suggest?
Thank you!December 20, 2016 at 8:48 am
Thank you so much @ehsan and @trephena for your response. I understand what you mean Trephena and that’s why i asked for clarity purposes. Yes i understand that Quick Ratio and all the Debtor and Inventory Days should be neglected. Thanks to this forum.
My next question is again to ask you more clearly which is :
so for Load Factors and Yield and all these statistics, i should talk about them under their own label/heading or i should discuss them under Sales growth and Profit?December 20, 2016 at 10:03 am
These statistics drive revenue, so should be used to explain revenue and profit.December 25, 2016 at 11:35 am
Merry Xmas to everyone!
I want to ask about the Excel document where the ratios will be done.
The ratios that i will be used need to take them from some academic sources? or i can do ratios that i think are most useful and do the formula in order for the examiner to find out how i calculated them?
Also, the KPI’s given in FS of the companies that i used, do i need to show them in Excel?December 27, 2016 at 12:09 pm
is EPS of QAN and VAH even discuss worthy under investor ratio even if VAH is at loss for the last three years?December 31, 2016 at 8:37 am
@pete28 – The ratios derive from the financial statements and yes you need to show the calculation formulas.
KPIs relating to load factors and ASK (available seat per kilometre) come from the company’s annual report so cite the page in your report but there is no need to put them in the spreadsheet unless you are producing a graph of them yourself.
All sources need to be referenced in your report – see the Open Tuition Ultimate Guide to Referencing on our homepage http://www.opentuition.com/obuJanuary 1, 2017 at 9:14 am
i’d appreciate if someone reply my above asked question, thank you.
I also have some other questions:
1. is it necessary to do operating statistics analysis of the comparator as well? like if i do a detailed revenue analysis of my main company including ask, rpk etc, and see the company’s progress over the years, do i need to do the same for my comparator? do i have to do as detailed analysis of my findings as that of my comparator?
2. when i emailed obu, they told me we are basically doing “comparator analysis” instead of competitor analysis. so can i mention the word “comparator” in my research when i’m making a reference to my other company?January 2, 2017 at 12:02 pm
You need to do sufficient analysis for the comparative too, maybe not much in detail, but pretty much. Many people fail because they haven’t analysed in detail with their comparator too.January 2, 2017 at 2:16 pm
Operating KPIs are used in the industry and therefore comparing companies’ KPIs is always a good idea. If you just state throughout your analysis that the main company (or comparator) out performed the other company without backing it up with reasons why this happened in relation to SWOT / PEST / operational factors you are unlikely to pass Evaluation & Analysis.
Comparator / competitor are virtually interchangeable and therefore do not worry about the terminology here as I doubt the marker will either – it is the detail behind the analysis they will mark you on 🙂January 12, 2017 at 8:49 am
January 13, 2017 at 10:45 am
Yes you could. It may be worth looking at gearing and whether the companies lease or buy their aircraft (read the notes to the accounts) as this will impact. Although depreciation will affect operating profit remember it is not a cash flow whereas lease payments have to be made (however the company may have financed the purchase through long term loans which similarly have to be repaid). Another alternative is that share issues can be used to finance assets and dividends are only ‘discretionary’ – so you need to read the notes (possibly also CEO and directors’ reports) and look at the figures to get the full picture !January 14, 2017 at 3:44 pm
I have some questions to ask:
1.The ratios that i will be used to do the Excel calculations and graphs needs to derive from the books and need to referenced them? and if yes where? in excel or word?
2. for the graphs do i need to write in the word like ‘ Figure 1: Operating and net profit margin (Appendix 2)” and need to do a list of figures after the contents of page? (that’s many words if this is a must to do)
3. Some of my ratios calculations are quite different from some websites i found that have calculated the same ratios? Is this gonna have an effect to my project? (such as ROCE, gearing ratio and trade payables)
Thank you !January 17, 2017 at 8:19 am
@trephena i will be using gearing ratios and explain all that you said however, i wasn’t able to find enough information to give details on current ratio as mostly, the airline is talking about their cash flows and operating cash flows under the liquidity heading so i was wondering if i could add along the operating cash flow ratio with current ratio to give details.January 17, 2017 at 9:03 am
@mayanisa – it does not surprise me that there is little information about the current ratio and that more focus is on cash flows. (The airline working capital model is very complex as I try to explain in the Topic 15 forum and why not to choose an airline for that topic). So yes go with operating cash flows but explain why you are taking this approachJanuary 17, 2017 at 9:11 am
@ trephena right, thank you for the advice!January 17, 2017 at 9:17 am
1. See the Ultimate Guide to Referencing. Graphs normally derive from figures from the financial statements
2. First part see the UGR ; second part – not mandatory
3. They should either be from the annual report or your own. Differences should not be material – if they are, go with the annual report (as explained above and in T15 – airline cash models are complex – read my post on this on T15 if you want to know why). It is stability in some of these ratios that is important. As long as you explain why you are taking a specific approach that should be acceptable.
The Open Tuition Ultimate Guide to Referencing is found on our homepage http://www.opentuition.com/obuJanuary 17, 2017 at 4:15 pm
I am using Flybe as my main Airline and am having difficulty in producing CASK and RASK figures.
Available Km are not quoted in any of the financial reports.
Luckily in the FY16 result presentation they quote RASK & CASK figures in the small print, but nothing for FY14.
I have searched many sources trying to find these figures or at least the available km for FY14 to no avail.
Would it be acceptable to only include the FY15 and FY16 figures in my analysis and note the lack of availability in the section on problems encountered?
ThanksJanuary 18, 2017 at 9:38 am
1) Revenue analysis with Yield ASK and Load factor
2) Operating profit
3) Net profit
@ehsan i wanted to know how you dealt with finding information on gearing ratio (specifically debt to equity ratio). Information on debt to equity is available for Qantas in annual reports 2013 and 2014 however 2015 onward, they don’t mention gearing ratio at all. In my appendices, i took out gearing ratio as total debt / total equity which is not how Qantas takes out. They take it out on net debt and include some other complicated things. My mentor said that i should not calculate the debt to equity ratio the way i have done it but instead use the gearing ratio given in annual report. is that a right approach? also, even if i use the gearing ratio given in annual report, they stop providing that from 2015 annual report onward. how do i analyse the debt to equity ratio? should i separately look for information on debt and equity and combine that together? i am not able to find accurate information on debt to equity ratio.
You must be logged in to reply to this topic.