Airtel - Bharti Airtel/u107092/u107093/u107094 Financial...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Financial Accounting Bharti Airtel/u107092/u107093/u107094 Financial Accounting Project Report on Bharti Airtel Limited Submitted by: Nidhi Agarwal (u107092) Niraj Kumar Mall (u107093) Nishith Sahu(u107094) 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Financial Accounting Bharti Airtel/u107092/u107093/u107094 Table of Contents 1. ACKNOWLEDGEMENTS 4 2. OBJECTIVE 5 3. EXECUTIVE SUMMARY 5 4. ENVIRONMENT ANALYSIS 6 4.1 GOVERNMENT POLICIES 6 4.2 NEW TELECOM POLICY, 1994 6 4.3 NEW TELECOM POLICY, 1999 7 4.4 BROADBAND POLICY, 2004 8 5. INDIAN ECONOMY AND THE TELECOM SECTOR 11 5.1 GUIDELINES FOR FOREIGN DIRECT INVESTMENT IN TELECOM SECTOR 18 5.2 TRAI GUIDELINES AND OBJECTIVES 20 5.3 (TDSAT) 21 5.4 CELLULAR OPERATORS ASSOCIATION OF INDIA (COAI) 21 6. COMPANY ANALYSIS 22 6.1 ABOUT THE COMPANY 22 6.2 CAPITAL STRUCTURE OF BHARTI-AIRTEL 27 6.3 FINANCIAL STATEMENTS 30 6.4 ACCOUNTING POLICIES 32 7. Ratio Analysis 38 7.1 LIQUIDITY RATIOS 38 7.1.1 Current Ratio 38 7.1.2 Liquid Ratio 39 7.1.3 Absolute Cash Ratio 40 7.1.4 Debtor Days 40 7.1.5 Creditor Days 41 7.1.6 Inventory Days 42 7.2 SOLVENCY RATIOS 42 7.2.1 Debt Ratio 43 7.2.2 Equity Ratio 43 7.2.3 Debt to Equity Ratio 44 7.2.4 Interest Coverage Ratio 45 7.2.5 Debt Service Coverage Ratio 46 7.3 PROFITABILITY RATIOS 47 7.3.1 Gross Profit (PBDITA) / Sales Ratio 47 7.3.2 Operating Profit (PBIT) / Sales Ratio 48 7.3.3 Net Profit (PAT) / Sales Ratio 49 7.4 RETURN ON INVESTMENT 50 7.4.1 RONW 50 7.4.2 ROCE 51 7.4.3 ROTA 51 7.4.4 EPS 52 7.5 EFFICIENCY RATIOS 53 2
Background image of page 2
Financial Accounting Bharti Airtel/u107092/u107093/u107094 7.5.1 Total Assets Turnover Ratio 53 7.5.2 Debt Turnover Ratio 54 7.5.3 Fixed Asset Turnover 55 7.5.4 Current Asset Turnover 56 7.5.5 Inventory Turnover 57 8. DUPONT ANALYSIS 59 8.1 THE DUPONT RATIO DECOMPOSITION 60 8.1.1 Profitability: Net Profit Margin (NPM: PBIT/Sales) 60 8.1.2 Operating Efficiency or Asset Utilization: Total Asset Turnover (Sales/Total Assets) 60 8.1.3 Leverage: The Leverage Multiplier (Total Assets/Capital Employed) 61 8.2 HIGHLIGHTS OF DUPONT ANALYSIS 62 9. CASH FLOW ANALYSIS 67 10. CALCULATION OF EVA 70 11. CONCLUSION 71 12. APPENDIX 73 13. REFERENCES 75 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Financial Accounting Bharti Airtel/u107092/u107093/u107094 1. ACKNOWLEDGEMENTS We wish to express our heartfelt gratitude and immense respect to Dr. D.V.Ramana, our Faculty and Mentor in Financial Accounting. His threadbare explanation of the minutest of concepts helped in generating a lot of interest in the subject. We would also like to thank XIMB for providing the necessary infrastructure which made our work easier. 4
Background image of page 4
Financial Accounting Bharti Airtel/u107092/u107093/u107094 2. OBJECTIVE The basic objective of doing the project is to analyze the financial statements of a company, analyze the environment in which it is operating and evaluate its performance over the last 3 years. Hence a thorough Environment Industry & Company analysis is done to understand the external factors influencing the company. 3.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course ECON 101 taught by Professor Flah during the Spring '10 term at Punjab Engineering College.

Page1 / 83

Airtel - Bharti Airtel/u107092/u107093/u107094 Financial...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online