Financial Analysis For Managers’ Assignment

This assignment will be based on real data which can be taken primarily from the annual reports ofIndigo and SpiceJet airlinesfor the 3 years ended 2016.  Full copies of both airlinesannual financial reports can be accessed through their web pages and are copied for your information on Moodle.         

Scenario

Flying high: Low-cost carriers driving India’s aviation growth

“Low-cost carriers like IndiGo and SpiceJet have been instrumental in driving growth in India’s aviation industry

Things have never been this good for India’s aviation industry. In a report released this month, International Air Transport Association (IATA) has named India among the five fastest growing aviation markets in the world. India is expected to become the world’s third largest market by 2026, bringing an additional 322 million fliers into the fold.

Low-cost carriers (LCCs) like IndiGo and SpiceJet have been instrumental in driving this growth. The market share of LCCs increased from 25 to 65 percent in the past decade, while full-service carriers (FSCs) like Jet Airways saw their market share sliced in half, from 70 to 35 percent, according to Centre for Asia Pacific Aviation, aviation advisory and research body.

Popularity of online travel services like MakeMyTrip that allow people to compare air ticket prices is one of the ways the LCCs were able to expand their customer base. More than 40 percent of Indians booked their air tickets online in 2015, up from 20 percent in 2008, according to Phocus Wright, a travel market research company.

“The convenience of booking online is certainly a part of the growth,” says ChetanKapoor, research analyst at Phocus Wright. Kapoor added that LCCs’ prices, which tend to be cheaper thanthe FSCs, have helped drive their growth.

The Indian aviation industry’s long-term growth is pegged to be the world’s highest, at 8.9 percent, according to Boeing.

Yet for all its opportunities, the aviation industry is likely to face growing pains, said Dinesh Keskar, senior vice president, Asia Pacific and India sales, Boeing Commercial Airlines, whose major Indian clients are Air India and SpiceJet.India has around 450 commercial aircraft, and it will need more than 1,800 new aircraft in the next 20 years, according to Boeing’s internal research. Almost 85 percent of those will be single aisle planes that usually fly domestic routes, while wide-body planes that fly international routes will account for about 15 percent of the total.

To sustain its growth, Keskar said, the industry will need to work on developing its infrastructure, maintenance, and repair facilities at airports as well as training personnel.

You have been commissioned to conduct a financial analysis of these two LCCs in the Indian airlinesector and to report your findings in a formal written report.

Required

A professionally produced report which should include a detailed analysis of the following areas:-

(a)   Profitability

(b)   Efficiency

(c)    Liquidity

(d)   Gearing

(e)   Horizontal common size analysis (using 2014 as a base)

(f)     Vertical common size analysis (using total assets as a base)

(g)   The evaluation of performance of business units in either Indigo or SpiceJet using financial and non-financial measures 

(h)   Conclusions and Recommendations

You should state any assumptions made and you are not required to comment on the investment performance of Indigo nor SpiceJet

Please make sure you are aware of the rules regarding plagiarism. Whilst we encourage you to discuss ideas and issues with your colleagues, the final piece of work must be entirely your own.

A sample of students may be selected to come and present their work in a 15 minute question and answer session with one or more members of the postgraduate council

Assessment Criteria (marking scheme is attached for your reference)

Executive Summary                                  750 words

Introduction                                                           500 words

Profitability Ratios                                  1200 words

• Gross Profit Margin
• Net Profit Margin
• Return on Capital Employed
• Return on Shareholder Funds
• Summary

Efficiecny Ratios                                        1250 words

• Sales Revenue: Capital Employed
• Debtor Turnover
• Stock Turnover
• Noncurrent Asset Turnover
• Summary

Liquidity Ratios                                         750 words

• Current
• Acid Test Ratio
• Summary

Gearing Ratios                                           750 words

• Loans: Capital Employed
• Interest Cover
• Summary

Horizontal Analysis                                 750 words

Vertical Analysis                                       750 words

Comparative Analysis                             800 words

Evaluation of Business Perofrmance using Financial and Non-financial Measures 1000 words

Conclusion                                                   500 words

Recommendations                                   1000 words