Please make Vertical AND Horizontal analysis for company DEUTSCHE LUFTHANSA AG. You can find their financial reports online or on their website.

The analysis needs to be for 3-5 years.

Key figures Lufthansa Group 2015 Revenue and result Total revenue 32,056 of which traffic revenue 25,322 EBI 676 Adjusted EBIT 817 EBITDA 3,395 Net profit/loss Key balance sheet and cash flow statement figures Total assets 32,462 Equity ratio 8.0 Net indebtedness 3,347 Cash flow from operating activities 3,393 Capital expenditure (gross) 2,569 Key profitability and value creation figures EBIT margin 5.2 Adjusted EBIT margin 5.7 EBITDA margin 0.6 323 ROCE 7.7 Lufthansa share Share price at year-end 4.57 Earnings per share 3.67 Proposed dividend per share 0.50 Traffic figuresa Passengers thousands 07.679 Freight and mail thousand tonnes Passenger load factor Cargo load factor Flights numbe 1,003,660 Employees Average number of employees numbe 119,559 Employees as of 31.12. numbe 20,652 Previous year's figures have been adjusted due to the new reporting method. Previous year's figures have been adjusted. Date of publicaton: 17 March 2016. 2014 30,011 24.38B 1,000 1.17 2,530 30,474 13.2 3,418 1,977 2,777 3.3 3.9 8.4 4.6 13.83 05,99 1,924 69.9 001,96 118,973 118,78 Change 6.8 3.8 67.6 55.2 34.2 2,987.3 6.5 4.8 pts 7.5 1.9 pts 1.8 pts 2.2 pts 3.1 pts 5.3 2,958.3 1.6 0.3 pts 3.6 pts 0.2 0.5