Description
This is a spreadsheet about financial analysis of Bharti Airtel.
Bharti Airtel
« Previous Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths
Balance Sheet
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities
1,853.37 1,853.37 2.72 0 2,675.38 2.13 4,533.60 3,959.88 1,034.41 4,994.29 9,527.89 Mar '05 12 mths
1,893.88 1,893.88 12.13 0 5,437.42 2.13 7,345.56 2,863.37 1,932.92 4,796.29 12,141.85 Mar '06 12 mths
1,895.93 1,895.93 30 0 9,515.21 2.13 11,443.27 266.45 5,044.36 5,310.81 16,754.08 Mar '07 12 mths
1,897.91 1,897.91 57.63 0 18,283.82 2.13 20,241.49 52.42 6,517.92 6,570.34 26,811.83 Mar '08 12 mths
Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances
13,240.63 3,475.64 9,764.99 994.46 931.9 31.58 715.74 174.96 922.28 1,354.85 209.17 2,486.30
17,951.74 4,944.86 13,006.88 2,341.25 719.7 17.74 1,076.17 201.81 1,295.72 1,937.54 105.61 3,338.87
26,509.93 7,204.30 19,305.63 2,375.82 705.82 47.81 1,418.52 239.11 1,705.44 3,160.02 541.35 5,406.81
28,115.65 9,085.00 19,030.65 2,751.08 10,952.85 56.86 2,776.46 200.86 3,034.18 5,103.13 302.08 8,439.39
Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets Contingent Liabilities Book Value (Rs)
0 4,458.80 249.32 4,708.12 -2,221.82 58.35 9,527.88 3,017.26 24.44
0 6,735.36 537.44 7,272.80 -3,933.93 7.94 12,141.84 4,740.34 38.71
0 9,809.83 1,232.84 11,042.67 -5,635.86 2.66 16,754.07 7,615.04 60.19
0 12,400.38 1,961.95 14,362.33 -5,922.94 0.2 26,811.84 7,140.59 106.34
Source : Asian CERC
Mar '09 12 mths
1,898.24 1,898.24 116.22 0 25,627.38 2.13 27,643.97 51.73 7,661.92 7,713.65 35,357.62 Mar '09 12 mths
37,266.70 12,253.34 25,013.36 2,566.67 11,777.76 62.15 2,550.05 153.44 2,765.64 5,602.83 2,098.16 10,466.63
0 13,832.49 634.4 14,466.89 -4,000.26 0.09 35,357.62 4,104.25 145.01
Bharti Airtel
Profit & Loss account
« Previous Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths Mar '09 12 mths
Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustment s Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturi ng Expenses Selling and Admin Expenses Miscellaneo us Expenses Preoperativ e Exp Capitalised Total Expenses
8,142.44 0 8,142.44 -1,707.95
11,259.12 0 11,259.12 26.94
17,851.61 0 17,851.61 105.62
25,761.11 0 25,761.11 104.04
34,048.32 0 34,048.32 -1,261.75
11.57 6,446.06
-13.84 11,272.22
30.07 17,987.30
9.05 25,874.20
5.29 32,791.86
83.67 0 475.86
53.56 0 734.2
52.16 0 1,076.95
42.9 0 1,297.88
17.7 0 1,397.54
2,365.51
3,299.73
5,017.27
7,339.01
8,627.13
1,951.25
2,804.85
4,030.48
5,892.50
9,385.68
280.05
314.37
444.28
535.46
1,409.89
0 5,156.34 Mar '05 12 mths
0 7,206.71 Mar '06 12 mths
0 10,621.14 Mar '07 12 mths
0 15,107.75 Mar '08 12 mths
0 20,837.94 Mar '09 12 mths
Operating Profit PBDIT Interest PBDT Depreciatio n Other Written Off Profit Before Tax Extraordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition
2,997.67 1,289.72 317 972.72 1,019.36 161.34
4,038.57 4,065.51 236.81 3,828.70 1,432.34 127.39
7,260.54 7,366.16 282.07 7,084.09 2,353.30 137.8
10,662.41 10,766.45 393.43 10,373.02 3,166.58 266.07
13,215.67 11,953.92 434.16 11,519.76 3,206.28 178.82
-207.98
2,268.97
4,592.99
6,940.37
8,134.66
22.23
17.64
9.92
-60.67
-46.15
-185.75 353.6 1,210.67
2,286.61 273.68 2,012.08
4,602.91 566.79 4,033.23
6,879.70 632.43 6,244.19
8,088.51 321.78 7,743.84
5,072.66
7,153.15
10,568.98
15,064.84
20,820.24
Preference Dividend 0 Equity Dividend 0 Corporate Dividend Tax 0 Per share data (annualised) Shares in issue (lakhs) 18,533.67 Earning Per Share (Rs) 6.53 Equity Dividend (%) 0 Book Value (Rs)
0 0
0 0
0 0
0 379.65
0
0
0
64.52
18,938.79
18,959.34
18,979.07
18,982.40
10.62
21.27
32.9
40.79
0
0
0
20
24.44
38.71
60.19
106.34
145.01
Mar '05
Mar '06
Mar '07
PROFITABILITY RATIOS
PROFIT MARGIN=PROFIT AFTER TAX /SALES ASSET TURNOVER =SALES/TOTAL ASSET RETURN ON ASSETS OR TURNOVER RETURN ON EQUITY=PAT/AVG. SHAREHOLDER EQUITY RETURN ON NET WORTH = PAT/NET WORTH LIQUIDITY RATIOS CURRENT RATIO =CURRENT ASSETS/CURRENT LIAB. QUICK RATIO =QUICK ASSETS/CURRENT LIAB. DEBTOR TURNOVER RATIO=SALES/DEBTORS INVENTORY TURNOVER=COGS/INVENTORIES TOTAL ASSET TURNOVER SOLVENCY RATIOS DEBT TO EQUITY RATIO INTEREST COVER RATIO=EBIT/INT. EXPENSE CAPITAL MARKET RATIOS EARNINGS PER SHARE DIVIDEND PER SHARE
14.86864 0.854591 12.7066 0.653226 26.70439
17.87067 0.927299 16.57146 1.062412 27.39178
22.59309 1.065509 24.07314 2.12731 35.24543
0.528088 0.52138 11.37625 257.8353 0.854591
0.45909 0.456651 10.46221 634.6742 0.927299
0.489629 0.485299 12.58467 373.3865 1.065509
2.694707 2.532521 2.801164 0.85 11.12 17.77
40.59 0
48.64 0
42.96
0
Mar '08
Mar '09
24.23882 0.960811 23.28893 3.290035 30.84847
22.74368 0.96297 21.90147 4.079484 28.01276
0.587606 0.723489 0.583647 0.719193 9.278401 13.35202 453.0621 547.841 0.960811 0.96297
3.461882 19.32
4.06358 20.15
42.87
64.19
0 2.000011
ANALYSIS PROFIT MARGIN
THIS REPRESENTS THE PROFIT MADE ON TE SALES MADE. THIS MUST ME HIGH AS THIS IS G DECREASES AND AGAIN INCREASES SES.SO THERE IS A VARIATION IN IT AND IT SHOULD NOT
ASSET TURNOVER
THIS REPRESENENTS HOW WELL THE IS UTILISING IT ASSETS ,AS WE SEE THIS RATIO DECRA EFFICIENTLY
RETURN ON ASSET RETURN ON EQUITY CURRENT RATIO
THIS REPRESENTS THE RATIO OF PROFIT AFTER TAX DIVIDED BY TOTAL ASSET , SO THIS T ESENTS THIS MEASURES THE EFFICIENCY WITH WHICH SHAREHOLDERS FUNDS AE EMPLOYED
THIS IS USED AS AN INDICATOR OF A COMPANYS ABILITY TO PAY ITS DEBT IN THE SHORT T FOR THE COMPANY
QUICK RATIO
THIS IS USED AS A SUPPLEMENT TO THE CURRENT RATIO , THIS MUST BE EQUAL TO 1:1 , A
DEBTOR TURNOVER RATIO THIS MEASURES THE EFFICACY OF A FIRMS CREDIT AND COLLECTION POLICY RATIO BETTRER IT WILLILL BE . BE AS WE SEE THIS IS FLACTUATING THIS IS NOT THIS
INVENTORY TURNOVER RATIO THIS REPRESENTS HOW WELL THE COMPANY IS CONVERTING ITS INVENTORIES IN
DEBT TO EQUITY RATIO THIS SHOWS THE AMOUNT OF DEBT IN THE CAPITAL STRUCTURE , AS DEBT INCREASES TH
INTEREST RATIO THIS REFLECTS THE ABILITY TO PAY ITS INTEREST ON DEBT , MORE THIS RATIO BETTER IT WILL BE EARNINGS PER SHARE THIS RATIO IS USEFUL FROM THE INVESTORS POINT OF VIEW, THIS MUST BE HIGH DVIDEND PER SHARE
THIS IS AMOUNT OF THE DIVIDEND PAID PER PER SHARE , COMPANY IS PAYING DIVIDEND
. THIS MUST ME HIGH AS THIS IS GOOD FOR THE COMPANY RIATION IN IT AND IT SHOULD NOT BE THERE.
AS WE SEE PROFIT MARGIN OF THE COMPANY
ETS ,AS WE SEE THIS RATIO DECRAESES FO THE COMPANY AND IT'S NOT GOOD FOR THE COMPANY . ASSET IS
IDED BY TOTAL ASSET , SO THIS TELLS US ABOUT THE HOW MUCH PROFIT ARE WE GETTING PER UNIT OF SALES , AS THIS RATIO DECREAS .AS THIS IS INCREASING SO THIS IS GOOD FROM THE SHAREHOLDER POINT OF VIEW.
LDERS FUNDS AE EMPLOYED
TO PAY ITS DEBT IN THE SHORT TERM
.THIS RATIO MUST BE EQUAL TO 1:1 , AS WE THIS IS LESS THAN ONE FOR THE COMPANY SO 2:1, AS WE SEE THIS IS LESS THAN THE REQUIRED , SO S LESS
, THIS MUST BE EQUAL TO 1:1 , AS THIS IS LESS THAN ONE ITS NOT GOOD FOR THE COMPANY
CREDIT AND COLLECTION POLICY AND SHOWS THE NUMBER OF TIMES EACH YEAR THE DEBTORS TURNS IN TO CASH , HIGHER THE THIS IS FLACTUATING THIS IS NOT GOOD FO THE COMPANY .
CONVERTING ITS INVENTORIES IN TO FINISHED GOODS , AS THIS IS INCRESING THIS IS GOOD FOR THE COMPNY
RUCTURE , AS DEBT INCREASES THE RISK , SO THIS MUST BE LESS .THSI RATIO DECEASE FOR THE COMPANY , SO IT IS BENEFICIAL .
ORE THIS RATIO BETTER IT WILL BE , AS WE SEE ITS INCREASING ITS GOO VIEW, THIS MUST BE HIGH AS THIS IS INCREASING THIS IS GOOD .
OD
E , COMPANY IS PAYING DIVIDEND OF 20 PERCENT .
ANY FIRST INCREASES THEN DECREASES
IS NOT BEING ULTILISED
ASSETS
POINT OF VIEW. S LESS THAN THE REQUIRED , SO THIS IS NOT GOOD
S IN TO CASH , HIGHER THE
S IS GOOD FOR THE COMPANY
ANY , SO IT IS BENEFICIAL .
doc_505927268.xls
This is a spreadsheet about financial analysis of Bharti Airtel.
Bharti Airtel
« Previous Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths
Balance Sheet
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities
1,853.37 1,853.37 2.72 0 2,675.38 2.13 4,533.60 3,959.88 1,034.41 4,994.29 9,527.89 Mar '05 12 mths
1,893.88 1,893.88 12.13 0 5,437.42 2.13 7,345.56 2,863.37 1,932.92 4,796.29 12,141.85 Mar '06 12 mths
1,895.93 1,895.93 30 0 9,515.21 2.13 11,443.27 266.45 5,044.36 5,310.81 16,754.08 Mar '07 12 mths
1,897.91 1,897.91 57.63 0 18,283.82 2.13 20,241.49 52.42 6,517.92 6,570.34 26,811.83 Mar '08 12 mths
Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances
13,240.63 3,475.64 9,764.99 994.46 931.9 31.58 715.74 174.96 922.28 1,354.85 209.17 2,486.30
17,951.74 4,944.86 13,006.88 2,341.25 719.7 17.74 1,076.17 201.81 1,295.72 1,937.54 105.61 3,338.87
26,509.93 7,204.30 19,305.63 2,375.82 705.82 47.81 1,418.52 239.11 1,705.44 3,160.02 541.35 5,406.81
28,115.65 9,085.00 19,030.65 2,751.08 10,952.85 56.86 2,776.46 200.86 3,034.18 5,103.13 302.08 8,439.39
Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets Contingent Liabilities Book Value (Rs)
0 4,458.80 249.32 4,708.12 -2,221.82 58.35 9,527.88 3,017.26 24.44
0 6,735.36 537.44 7,272.80 -3,933.93 7.94 12,141.84 4,740.34 38.71
0 9,809.83 1,232.84 11,042.67 -5,635.86 2.66 16,754.07 7,615.04 60.19
0 12,400.38 1,961.95 14,362.33 -5,922.94 0.2 26,811.84 7,140.59 106.34
Source : Asian CERC
Mar '09 12 mths
1,898.24 1,898.24 116.22 0 25,627.38 2.13 27,643.97 51.73 7,661.92 7,713.65 35,357.62 Mar '09 12 mths
37,266.70 12,253.34 25,013.36 2,566.67 11,777.76 62.15 2,550.05 153.44 2,765.64 5,602.83 2,098.16 10,466.63
0 13,832.49 634.4 14,466.89 -4,000.26 0.09 35,357.62 4,104.25 145.01
Bharti Airtel
Profit & Loss account
« Previous Years
------------------ in Rs. Cr. -----------------Mar '05 12 mths Mar '06 12 mths Mar '07 12 mths Mar '08 12 mths Mar '09 12 mths
Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustment s Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturi ng Expenses Selling and Admin Expenses Miscellaneo us Expenses Preoperativ e Exp Capitalised Total Expenses
8,142.44 0 8,142.44 -1,707.95
11,259.12 0 11,259.12 26.94
17,851.61 0 17,851.61 105.62
25,761.11 0 25,761.11 104.04
34,048.32 0 34,048.32 -1,261.75
11.57 6,446.06
-13.84 11,272.22
30.07 17,987.30
9.05 25,874.20
5.29 32,791.86
83.67 0 475.86
53.56 0 734.2
52.16 0 1,076.95
42.9 0 1,297.88
17.7 0 1,397.54
2,365.51
3,299.73
5,017.27
7,339.01
8,627.13
1,951.25
2,804.85
4,030.48
5,892.50
9,385.68
280.05
314.37
444.28
535.46
1,409.89
0 5,156.34 Mar '05 12 mths
0 7,206.71 Mar '06 12 mths
0 10,621.14 Mar '07 12 mths
0 15,107.75 Mar '08 12 mths
0 20,837.94 Mar '09 12 mths
Operating Profit PBDIT Interest PBDT Depreciatio n Other Written Off Profit Before Tax Extraordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition
2,997.67 1,289.72 317 972.72 1,019.36 161.34
4,038.57 4,065.51 236.81 3,828.70 1,432.34 127.39
7,260.54 7,366.16 282.07 7,084.09 2,353.30 137.8
10,662.41 10,766.45 393.43 10,373.02 3,166.58 266.07
13,215.67 11,953.92 434.16 11,519.76 3,206.28 178.82
-207.98
2,268.97
4,592.99
6,940.37
8,134.66
22.23
17.64
9.92
-60.67
-46.15
-185.75 353.6 1,210.67
2,286.61 273.68 2,012.08
4,602.91 566.79 4,033.23
6,879.70 632.43 6,244.19
8,088.51 321.78 7,743.84
5,072.66
7,153.15
10,568.98
15,064.84
20,820.24
Preference Dividend 0 Equity Dividend 0 Corporate Dividend Tax 0 Per share data (annualised) Shares in issue (lakhs) 18,533.67 Earning Per Share (Rs) 6.53 Equity Dividend (%) 0 Book Value (Rs)
0 0
0 0
0 0
0 379.65
0
0
0
64.52
18,938.79
18,959.34
18,979.07
18,982.40
10.62
21.27
32.9
40.79
0
0
0
20
24.44
38.71
60.19
106.34
145.01
Mar '05
Mar '06
Mar '07
PROFITABILITY RATIOS
PROFIT MARGIN=PROFIT AFTER TAX /SALES ASSET TURNOVER =SALES/TOTAL ASSET RETURN ON ASSETS OR TURNOVER RETURN ON EQUITY=PAT/AVG. SHAREHOLDER EQUITY RETURN ON NET WORTH = PAT/NET WORTH LIQUIDITY RATIOS CURRENT RATIO =CURRENT ASSETS/CURRENT LIAB. QUICK RATIO =QUICK ASSETS/CURRENT LIAB. DEBTOR TURNOVER RATIO=SALES/DEBTORS INVENTORY TURNOVER=COGS/INVENTORIES TOTAL ASSET TURNOVER SOLVENCY RATIOS DEBT TO EQUITY RATIO INTEREST COVER RATIO=EBIT/INT. EXPENSE CAPITAL MARKET RATIOS EARNINGS PER SHARE DIVIDEND PER SHARE
14.86864 0.854591 12.7066 0.653226 26.70439
17.87067 0.927299 16.57146 1.062412 27.39178
22.59309 1.065509 24.07314 2.12731 35.24543
0.528088 0.52138 11.37625 257.8353 0.854591
0.45909 0.456651 10.46221 634.6742 0.927299
0.489629 0.485299 12.58467 373.3865 1.065509
2.694707 2.532521 2.801164 0.85 11.12 17.77
40.59 0
48.64 0
42.96
0
Mar '08
Mar '09
24.23882 0.960811 23.28893 3.290035 30.84847
22.74368 0.96297 21.90147 4.079484 28.01276
0.587606 0.723489 0.583647 0.719193 9.278401 13.35202 453.0621 547.841 0.960811 0.96297
3.461882 19.32
4.06358 20.15
42.87
64.19
0 2.000011
ANALYSIS PROFIT MARGIN
THIS REPRESENTS THE PROFIT MADE ON TE SALES MADE. THIS MUST ME HIGH AS THIS IS G DECREASES AND AGAIN INCREASES SES.SO THERE IS A VARIATION IN IT AND IT SHOULD NOT
ASSET TURNOVER
THIS REPRESENENTS HOW WELL THE IS UTILISING IT ASSETS ,AS WE SEE THIS RATIO DECRA EFFICIENTLY
RETURN ON ASSET RETURN ON EQUITY CURRENT RATIO
THIS REPRESENTS THE RATIO OF PROFIT AFTER TAX DIVIDED BY TOTAL ASSET , SO THIS T ESENTS THIS MEASURES THE EFFICIENCY WITH WHICH SHAREHOLDERS FUNDS AE EMPLOYED
THIS IS USED AS AN INDICATOR OF A COMPANYS ABILITY TO PAY ITS DEBT IN THE SHORT T FOR THE COMPANY
QUICK RATIO
THIS IS USED AS A SUPPLEMENT TO THE CURRENT RATIO , THIS MUST BE EQUAL TO 1:1 , A
DEBTOR TURNOVER RATIO THIS MEASURES THE EFFICACY OF A FIRMS CREDIT AND COLLECTION POLICY RATIO BETTRER IT WILLILL BE . BE AS WE SEE THIS IS FLACTUATING THIS IS NOT THIS
INVENTORY TURNOVER RATIO THIS REPRESENTS HOW WELL THE COMPANY IS CONVERTING ITS INVENTORIES IN
DEBT TO EQUITY RATIO THIS SHOWS THE AMOUNT OF DEBT IN THE CAPITAL STRUCTURE , AS DEBT INCREASES TH
INTEREST RATIO THIS REFLECTS THE ABILITY TO PAY ITS INTEREST ON DEBT , MORE THIS RATIO BETTER IT WILL BE EARNINGS PER SHARE THIS RATIO IS USEFUL FROM THE INVESTORS POINT OF VIEW, THIS MUST BE HIGH DVIDEND PER SHARE
THIS IS AMOUNT OF THE DIVIDEND PAID PER PER SHARE , COMPANY IS PAYING DIVIDEND
. THIS MUST ME HIGH AS THIS IS GOOD FOR THE COMPANY RIATION IN IT AND IT SHOULD NOT BE THERE.
AS WE SEE PROFIT MARGIN OF THE COMPANY
ETS ,AS WE SEE THIS RATIO DECRAESES FO THE COMPANY AND IT'S NOT GOOD FOR THE COMPANY . ASSET IS
IDED BY TOTAL ASSET , SO THIS TELLS US ABOUT THE HOW MUCH PROFIT ARE WE GETTING PER UNIT OF SALES , AS THIS RATIO DECREAS .AS THIS IS INCREASING SO THIS IS GOOD FROM THE SHAREHOLDER POINT OF VIEW.
LDERS FUNDS AE EMPLOYED
TO PAY ITS DEBT IN THE SHORT TERM
.THIS RATIO MUST BE EQUAL TO 1:1 , AS WE THIS IS LESS THAN ONE FOR THE COMPANY SO 2:1, AS WE SEE THIS IS LESS THAN THE REQUIRED , SO S LESS
, THIS MUST BE EQUAL TO 1:1 , AS THIS IS LESS THAN ONE ITS NOT GOOD FOR THE COMPANY
CREDIT AND COLLECTION POLICY AND SHOWS THE NUMBER OF TIMES EACH YEAR THE DEBTORS TURNS IN TO CASH , HIGHER THE THIS IS FLACTUATING THIS IS NOT GOOD FO THE COMPANY .
CONVERTING ITS INVENTORIES IN TO FINISHED GOODS , AS THIS IS INCRESING THIS IS GOOD FOR THE COMPNY
RUCTURE , AS DEBT INCREASES THE RISK , SO THIS MUST BE LESS .THSI RATIO DECEASE FOR THE COMPANY , SO IT IS BENEFICIAL .
ORE THIS RATIO BETTER IT WILL BE , AS WE SEE ITS INCREASING ITS GOO VIEW, THIS MUST BE HIGH AS THIS IS INCREASING THIS IS GOOD .
OD
E , COMPANY IS PAYING DIVIDEND OF 20 PERCENT .
ANY FIRST INCREASES THEN DECREASES
IS NOT BEING ULTILISED
ASSETS
POINT OF VIEW. S LESS THAN THE REQUIRED , SO THIS IS NOT GOOD
S IN TO CASH , HIGHER THE
S IS GOOD FOR THE COMPANY
ANY , SO IT IS BENEFICIAL .
doc_505927268.xls