Ratio Analysis of Indian Bank

Only available on StudyMode
  • Download(s) : 3301
  • Published : August 24, 2008
Open Document
Text Preview
BHARTI AIRTEL

Introduction
Bharti Airtel is India's leading provider of telecommunications services. The company has 27 million customers across India. It is a part of Bharti Enterprises, which manufactures and exports telecom equipment, provides telecom services in Seychelles, delivers products and services to telecom carriers, offers a range of Customer Management Services (CMS) and exports fresh agricultural products exclusively to markets in Europe and the USA. Business

The business has been structured into three individual strategic business units (SBUs) — mobile services, broadband and telephone services (B&T) and enterprise services. The last group has two sub-units — carriers (long distance services) and services to corporates. Brands

All the services of the company are bundled under the Airtel brand. Location
The company is headquartered in New Delhi. The mobile services group provides GSM mobile services across India in 23 telecom circles, while the B&T business group provides broadband & telephone services in 90 cities

P/L account of Bharti Airtel
YearMar 07(12) Mar 06(12) Mar 05(12) Mar 04(12) Mar 03(12) budgeted/mar08
INCOME :
Sales Turnover +
17,851.6011,231.477,903.030039,808.33
Excise Duty000000
Net Sales17,851.6011,231.477,903.030039,808.33
Other Income +
148.4994.3122.0263.1572.9628.11
Stock Adjustments +
30.07-13.8411.570092.31
Total Income18,030.1611,311.938,036.6263.1572.940,528.75
EXPENDITURE :
Raw Materials +
53.9554.4283.70086.85
Power & Fuel Cost+
39.7226.9816.690.380.171.89
Employee Cost +
1,102.03754.99488.1316.8418.943460.03
Other Manufacturing Expenses +
6,709.584,404.783,139.481.292.418990.83
Selling and Administration Expenses +
1,973.641,330.07869.691510.56927.22
Miscellaneous Expenses +
801.13671.92538.324.165.853036.28
Less: Pre-operative Expenses Capitalised+
1.80.850.03005.22
Total Expenditure10,678.257,242.315,135.9837.6737.822578.32
Operating Profit7,351.914,069.622,900.6425.4835.117950.18
Interest +
282.07236.8131721.3631.231052.12
Gross Profit7,069.843,832.812,583.644.123.8719002.3
Depreciation+
2,468.471,547.021,019.363.873.67602.88
Profit Before Tax4,601.372,285.791,564.280.250.2726605.18
Tax+
520.53185.578.61-0.120.05967.18
Deferred Tax+
47.6188.1434500151.61
Reported Net Profit4,033.232,012.081,210.670.370.2227723.97
Extraordinary Items +
31.1612.5728.2213.2923.1393.5
Adjusted Net Profit4,002.071,999.511,182.45-12.92-22.9127817.47
Preference Dividend000000
Equity Dividend %000000

In this project we have analyzed the change in telecom industry and did the changes for preparing the budget for Bharti Airtel for year ending 2007-08

Balance sheet of Bhartiairtel
YearMar 07 Mar 06 Mar 05 Mar 04 Mar 03 budgeted/mar08
SOURCES OF FUNDS :
Share Capital +
1,895.931,893.881,856.091,853.371,853.3710,010.51
Reserves Total +
9,517.335,439.552,677.512,971.492,971.1222,651.24
Total Shareholders Funds11,413.267,333.434,533.604,824.864,824.4932,661.75
Secured Loans +
266.452,863.373,959.881.361.18852.64
Unsecured Loans +
5,044.361,932.921,034.41625010,290.50
Total Debt5,310.814,796.294,994.29626.361.1811143.14
Total Liabilities16,724.0712,129.729,527.895,451.224,825.6743,804.90
APPLICATION OF FUNDS :
Gross Block +
26,509.9317,951.7413,240.6331.8430.6287,217.70
Less : Accumulated Depreciation +
7,204.304,944.863,475.6417.2813.7939,767.70
Net Block +
19,305.6313,006.889,764.9914.5616.8347,450.00
Lease Adjustment...
tracking img