Forums › OBU Forums › Using an AIRLINE for T8
- This topic has 420 replies, 63 voices, and was last updated 2 years ago by trephena.
- AuthorPosts
- April 15, 2016 at 3:15 pm #310249
@Usman Saadat – the two are not quite the same. Asset Turnover is a financial ratio and brings in all assets including buildings and might be skewed if the company leased rather than owned their aircraft. Whereas aircraft utilisation is an efficiency KPI and refers to the average percentage of aircraft usage (whether leased or owned) – that is when aircraft are actually in service. It reflects on various departments performances e.g. how well aircraft are serviced as unscheduled maintenance would push the ratio down as would having too large a fleet for the routes flown (tying up too much capital in expensive planes or commitments to lease payments). Although arguably both are efficiency ratios aircraft utilisation is more relevant (if it is available) for monitoring operational performance and useful as an appropriate more specific measure of assessing how well capital is being used to generate income than the Asset turnover.
April 15, 2016 at 3:58 pm #3102611. Should KPIs and ratios like aircraft utilization and load factor be calculated in appendices right? 2. If my company leases aircraft to other companies and gain revenues this way, should i consider it under resource utilisation?
3. If i submit in november session, i can still use annual reports or i would have to adjust annual reports by including quarterly results?April 15, 2016 at 5:24 pm #310265You normally cannot calculate most KPIs yourself as you probably won’t have sufficient information. Look in the annual reports for them and load them as an appendix. Here are the type of things BA produced (and hopefully still produces) but you will have to look for the most recent ones.
https://www.britishairways.com/cms/global/microsites/ba_reports0910/financial/opfin_stats.html
No adjustments are necessary if you follow the RAP rules on financial statements.
April 16, 2016 at 10:52 am #310343Thank you and can you also guide me what ratios to calculate for airlines? apart from operating margin and net margin, i calculated current ratio, debt to equity ratio, interest cover, earnings per share and P/E ratio. what other ratios should be calculated? and which ones from what i have calculated shouldn’t be included?
and i’m re-writing my previous question again: If my company leases aircraft to other companies and gain revenues this way, should i consider it under resource utilization?April 19, 2016 at 2:18 am #311546Hi @trephena
I’m writing on T8 using Ryanair as a case study and Easyjet as a comparatorI’m in part three of my RAP and I’m getting stuck of how to structure my words in other for me not to missed the point and also not write too much as the word count is limited to 4500,
just your candid advice on how best to structure my ratio analysis since it is a 3yrs performance I’m looking into and that of its competitors1 would it be better for me to do analysis on a straight 3years trend of the coy performance?
e.g The above graph clearly shows that Ryanair outperformed Easyjet in terms of higher operating margin, as Ryanair operating margin fluctuate from 14.7% in 2013 to 13% in 2014 and 18% in 2015 a year on year increase of 38.5% btw 2014 ad 2015 a turning point after a three-year decline in growth, as prophecy between 2012 and 2013 shows there was a decrease in growth of 5.5% and the trend continue between 2013 and 2014 where it suffer a further decrease in growth of 11.6%
although Ryanair outperformed Easyjet in terms of higher operating margin it could be observed Easy jet has witnessed a steady increase in the last 3yrs first time easy jet recorded a double-digit margin since 2002 from 11.7% in 2013 to 12.8% in 2014 and 14.7% respectively in 2015 a growth of 9% btw 2013 and 2014 and a growth of 15% btw 2014 and 2015 fiscal year whilst highlighting the reason for the increase such as passenger volume, or decrease in fuel cost, rise in flight ticket and increase in ancillary revenue etc.
or
2 to do a year on year performance analysis such as
e.g 2013
at 14.7% operating margin as a proportion of revenue is lower compared to 2012 15.5% operating margin a drop in growth of 5.2%there was an increase in sales revenue of 11.2% in 2013 which is slower than the increase of 12.4% in operating expenses
the increase in op expenses is largely due to 18.3% increase cost of fuel which represent 45% of total operating cost compare to prior year 43%
Other factors also include growth in the airline which reflects 7.5% increase in op expenses per passenger capacity in 2013 fiscal year, exchange rate differential attributable to the cost of operations
total operating profit went up by 5% to €718m
2014 will also follow, and at what point do I bring in the comparator company? having in mind that I have another 4 or 5 ratios to write about such as the KPI
this is just to give you the idea of what my problem is and I hope you will be able to proffer a lasting solution and remove the doubt in my mind.
April 19, 2016 at 7:38 am #311587Hello guys,
Just a quick clarification, am kind of confused. The financial year of a company from 1st April 2014 to 31 March 2015, would you say it as FY 2014 or FY 2015?
Thanks
April 19, 2016 at 10:01 am #311646I@abolorelegacy -you asked me to be candid so I shall be. Although a 3 year review is better IMO, that first paragraph of the first version is doomed! You just do not overwhelm the reader with percentages or they drown in a sea of numbers! Remember too the marker is not blind so they can ‘read’ the trend from the graph (as long as you show it with the earliest year on the left and the latest year on the right)
Strip out all those unnecessary numbers first. I think you can generally go for a 3 year period review (rather than year by year) but if something significant happened in a particular year then bring it in.
So you might start with 2013 and comment something like ” operating margin which slipped slightly back in 2014 has improved by 3.3% over the whole period. The market fall in the price of oil being a major input cost has contributed to this (reference required) [ give more reasons if you can + references]. This turning point follows a 3 year decline in profitability [ I don’t know what decline in growth you are really referring to as it is not clear and all those numbers do not help! – decline in passenger volumes? Revenue? Operating margin?so a need to express yourself clearly.
Next bit: although Ryanair outperformed Easyjet in terms of higher operating margins overall, with EJ struggling previously to achieve a double digit operating margin, EJ has experienced steady growth over the 3 year period with an OM of 14.7% in 2015 (an improvement of x% since 2012) mainly due to…. (referenced reasons)
As you will note I am using numbers sparingly to HIGHLIGHT key points That way the reader has a much better picture of what has been significant and does not lose sight of what you are trying to get across
Start Part 3 with your models and KPIs in the business analysis and then link the financial/ratio analysis to these. Discuss a ratio for main company, then do comparison as above with other company -you can usually show both companies’ ratios on same graph or chart.
April 19, 2016 at 11:43 am #311664In addition to the above comments, i’m kinda struggling to choosing which ratios to use in my analysis… btw, my main is easyJet and comparator is Ryanair.
Please please advise!April 19, 2016 at 2:18 pm #311700@trephena thank you so much for the prompt response!
this your advice has just given me a head start and I will incorporate in my RAP
just to draw your attention as most of the growth would be openings of new base and route, delivery of new fleet which enhances its operation capacity also revenue growth would be combinations of non-schedule flight product mix such as hotel accommodation, car rental service, on flight sales of bus and train ticket using POS, commission on sales through its website.
lastly, I wish you can be my mentor or perhaps because of your sensitive position recommend someone who can be a mentor as most of the mentor I have been fortunate to meet are either base in Dubai or Pakistani or united state who don’t have little knowledge of European market.
April 19, 2016 at 5:54 pm #311747@trephena said:
I@abolorelegacy -you asked me to be candid so I shall be. Although a 3 year review is better IMO, that first paragraph of the first version is doomed! You just do not overwhelm the reader with percentages or they drown in a sea of numbers! Remember too the marker is not blind so they can ‘read’ the trend from the graph (as long as you show it with the earliest year on the left and the latest year on the right)Strip out all those unnecessary numbers first. I think you can generally go for a 3 year period review (rather than year by year) but if something significant happened in a particular year then bring it in.
So you might start with 2013 and comment something like ” operating margin which slipped slightly back in 2014 has improved by 3.3% over the whole period. The market fall in the price of oil being a major input cost has contributed to this (reference required) [ give more reasons if you can + references]. This turning point follows a 3 year decline in profitability [ I don’t know what decline in growth you are really referring to as it is not clear and all those numbers do not help! – decline in passenger volumes? Revenue? Operating margin?so a need to express yourself clearly.
Next bit: although Ryanair outperformed Easyjet in terms of higher operating margins overall, with EJ struggling previously to achieve a double digit operating margin, EJ has experienced steady growth over the 3 year period with an OM of 14.7% in 2015 (an improvement of x% since 2012) mainly due to…. (referenced reasons)
As you will note I am using numbers sparingly to HIGHLIGHT key points That way the reader has a much better picture of what has been significant and does not lose sight of what you are trying to get across
Start Part 3 with your models and KPIs in the business analysis and then link the financial/ratio analysis to these. Discuss a ratio for main company, then do comparison as above with other company -you can usually show both companies’ ratios on same graph or chart.
I ‘ am seriously your fan, I follow all your comments!
Can you please please give one example on how could we use the KPIs and where do we put that in?
April 19, 2016 at 9:28 pm #311781@abolorelegacy – I do not act as a mentor but offer advice to all students on the forum. (At Open Tuition we recommend The Learning Luminarium, which has a high pass rate [100% for the report in P31 – although they themselves admit that this is both unsustainable and exceptional and they would anticipate a pass rate of about 90% to be realistic going forward] as offering a high standard of mentorship. Admittedly they are based in Singapore rather than the UK but offer a quality and professionalism).
Your explanations are fine as long as you include them so that the reader can pick up on this and you show from where you have extracted this information by means of references.
@darkangel5 – as mentioned in a previous post Part 3 should start with the Business Analysis (models and KPIs) which will then help put the financial analysis into a better context especially if when discussing ratios you cross refer the results to the models and bring in the KPIs if and when relevant. As examples of KPIs and applications of them take a look at p.5 of the British Airways plc Annual Report and Accounts ended 31 December 2014 (I can’t get it to link unfortunately) but you should be able to find it easily if you google it. Whether you are doing a RAP on BA or not, the written part of this report may give you some ideas of areas you could cover in your analysis.April 19, 2016 at 11:08 pm #311786Thanks a lot @trephena, but just to be clear, should I include the KPIs in SWOT or write it separately as a separate heading apart from the SWOT analysis?
I have just been reading all this while that I feel I should start writing now!
April 20, 2016 at 6:11 am #311806@Trephena i’d be grateful if you reply to my question too. If my question is a typical one, again i’m sorry but i wasn’t able to find it anywhere. Please can you tell what ratios for airlines should be calculated?
April 20, 2016 at 8:56 am #311842@MahinAdnan – it is difficult to be prescriptive and state EXACTLY which ratios you should use. I try to get the message out that whatever companies are used you need to avoid a text-book approach, generalisations when it comes to explanations and making comments that read like the notes to the accounts. That said you must talk about profitability, liquidity (but avoid most inventory measures), gearing and investor ratios. For an airline bring in some detailed revenue analysis – maybe beginning with this and referring to those KPIs that specifically deal with aspects of revenue.
@darkangle5 -again it is difficult to be prescriptive about how exactly to arrange work when it comes to detail -it is what ‘works’ best where when organising your ideas and approach so your work ‘flows’.
However the SWOT and PESTLE should be distinct sections in the report and the KPIs and discussion of revenue would come after these. (Note in the BA Report referred to above how they have identified certain risks -depending on whether these are internal or external, most of them constitute weaknesses or potential threats)
April 20, 2016 at 9:07 am #311846@trephena you recommend pestle. However if both airlines are of the same country and function in same environment, how would pestle be useful? Shouldn’t i use porter then?
Also the financial statements of the airlines are also available from google finance. My question is that a lot of things differ from the financial statements available in annual reports. Like the operating expense amounts both differ but the end result is the same. Which financial statements should i follow?April 20, 2016 at 4:23 pm #311921True doing PESTLE for companies which may operate in the same geographic areas would be very similar however it is how those companies react to those factors that you discuss in the analysis (mainly for the main company). How companies react to innovations in technology for example. Most airlines allow online check in, seat selection for example but technology may be linked to loyalty programs, target marketing and building up customer profiles through data analytics. This may give one company the edge when formulating their strategic decisions e.g. operation schedules, product offering, pricing etc.
All financial statements will vary between companies that is where policies and the notes to the accounts come in to explain to the reader the basis of the figures.
I am not a personal fan of Porter’s as it tends to be used by students in what I call a ‘backwards looking approach’ to justify how the company has arrived at the current position, whereas SWOT and PESTLE are more dynamic IMO as they encourage a more forward thinking approach and assess not just what has gone on but the direction the management intend to take the company in. The models are intended to help you put together a good reasoned analysis and assist in following management strategies and decisions when doing the evaluation so again IMO Porter’s is of limited use in the RAP.
April 20, 2016 at 6:23 pm #311943Okay. So i just explained sales revenue and revenue growth yearly wise under financial ratios. If i have to write about a kpi that is relevant to revenues, do i add it under the sales revenue heading or i should explain that seperately? I’m confused where to add kpis.
April 28, 2016 at 12:31 pm #312946Dear, @trephena
In airlines annual report they have provided measurements such as RPK, ASK, Yield, Break-even load factor and few others.
Should these form part of my ratio calculations in Appendix or they should be used in RAP for analyzing the trends of other ratios?
Lastly I am planning to submit in P33
right now I am busy with P1 paper so do you think if I start from June, there will be sufficient time?Regards
April 28, 2016 at 7:03 pm #312979April 29, 2016 at 9:59 pm #313108Hi guys,
what is the good source to average share price for the P/E ratio? I seem cannot locate it and when doing ranges on yahoo finance it does not give average numbers.
I found weighted average in the fin statements but it looks it is more in regards with stock options section of employees.thanks a lot
April 30, 2016 at 7:43 pm #313199@darkangel5 – Aircraft utilisation refers to the usage of aircraft and is often expressed as the average daily hours aircraft are in flight – it is an asset utilisation KPI that can also be used to give an indication of efficiency.
ASK is available seats per kilometre and is sometimes called ‘load factor’ and therefore is not the same – it relates to passenger seat occupancy and is an efficiency KPI. Many of the costs for flights are fixed e.g. crew salaries and landing fees, some are semi-fixed with a fixed element but slightly variable element e,g. fuel consumption mainly depends on weight of total aircraft and distance (but also weather conditions and the altitude flown at). So the higher the load factor the more the likelihood of making a profit. However the more premium passengers (first class and business class the greater the potential profit per passenger).
@Ehsan – yes those are exactly the type of ratios that you should include along with profitability, liquidity (not stock or anything to do with inventory though!) when doing your analysis and evaluation in the main report. Starting now should give you the time to do a solid and quality report as long as you stick at it 🙂Sorry but I have no idea what ‘blockhours’ are.
April 30, 2016 at 9:29 pm #313206Thank you @trephena for your efforts and your time 🙂
When writing about the KPIs should I not compare it with its competitor due to the word limit?
May 5, 2016 at 3:45 pm #313833Hi
I am doing my rap on ryanair and easyjet as competitors, the roce that i have calculated is different than reported in the annual report!! I just cant seem to get it right!!
should I go ahead wid my calculations and explain on my calculations ??
May 7, 2016 at 3:35 am #313984Hi Trephena and Hammad Ahmed, quick question: how to reference correctly governmental sites: budget of a country? there is no author etc. do I put just name of finance minister and what about year
thank you
nbMay 7, 2016 at 10:57 pm #314061@trephena This forum is a great help however im struggling to find an answer for a particular question. In the infopack its mentioned that, “The Programme Director has advised that any Company results that are published (in any form) less than 90 days before the start of submission do not have to be used”
My question is that if its mentioned that results can be in any form, can the half year results be used?Im doing my analysis on EasyJet & my comparator is RyanAir. As you’re probably aware they both have different year ends. So if i choose RyanAirs H1 2016 results it will be comparable to EasyJets FY2015 results. This will also adhere to the 90 days rule.
- AuthorPosts
- You must be logged in to reply to this topic.