Description
FINANCIAL ANALYSIS OF BHARAT PETROLEUM
gtÇtç eÉç XåvÄâá|äx
COMPANY FINALYTICS
Bharat Petroleum Corporation Ltd
Exclusive Financial Analysis of Indian Companies
Prepared and Edited By?
Tanay Roy, CFA Peu Karak, MBA
Disclaimer The information, opinions, estimates and forecasts contained in this document have been arrived at or obtained from public sources believed to be reliable and in good faith which has not been independently verified and no warranty, express or implied, is made as to their accuracy, completeness or correctness.
For more information about this sample and our other services, please write to [email protected]
Tuesday, September 13, 2011
Description Summary Latest Result Valuation Matrix ROE Analysis Income Statement Balance Sheet Cashflow Statement Quarterly Result Growth Analysis Comparative Analysis Income Statement Balance Sheet Index Analysis Income Statement Balance Sheet Ratio Analysis Annual Quarterly TTM Analysis
Page 3 3 3 3 4 5 6 6 7 8 8 8 9 9 9 10 10 11 11 12
CONTENT
Technical Analysis
About Tanay & Peu
Our passion lies in the field of financial research & Investment management and we intend to apply our knowledge gained over a period of years through intense study and keen observation of the nuances of financial markets and instruments to real life scenarios. We possess expert knowledge of financial products and markets as evidenced by top notch qualifications earned by us , all in the first attempt and keep ourselves abreast with the latest happenings and innovations taking place in financial landscape. 1. Expertise in Portfolio Management, Product optimization, Product performance Analysis, Financial Reporting/ Planning, Cash Flow Analysis, Ratio Analysis, Budgeting, Forecasting, Mergers & Acquisition and knowledge of GAAP/ IFRS 2. Possess Strong Financial Modeling skills including DCF, LBO and other techniques. Possess ability to research all asset classes in a broad range of industries and geographies. 3. Strong equity research, finance, accounting and advisory and assurance experience 4. Expertise in Technical analysis, fundamental analysis, developing trading systems. 5. Conduct in?depth financial analysis of company financials. 6. Write analytical or trend based reports on companies, sectors or markets. 7. Expert level application in Bloomberg, Thomson Banker, Factset, Datastream, StockVal, Merger markets, Reuters Knowledge, Haver Analytics, Factiva, PackHedge, 8. Building Excel/VBA based customized tools to perform detailed analysis.
Contact Us: [email protected]
Page 2
Summary Latest Results
Yearly Latest Results EBDITA Reported Net Profit Adjusted PAT March ' 11 5178.92 1546.68 1646.50 Growth 0.29 0.59 (0.01) Quarterly June ' 11 (1736.90) (2561.89) (2561.89) Growth 30.21 (219.59) (219.59) TTM June ' 11 4516.94 702.89 NA Growth (12.61) (54.55) NA Price Market Cap(Rs. In Cr) 662.15 23939.50 At a Glance Industry Business Group Face Value Number of Equity shares Refineries Public Sector 10 3615.42
Valuation Matrix
Particulars Reported P/E Price/Sales Per Share Price/ Book Value Dividend Yield Earning Yield Market Cap(Rs. In Cr) Annual March ' 11 15.48 0.16 1.70 0.02 0.06 23939.50 TTM Ratio March ' 11 15.48 0.16 NA NA 0.06 BFI 10% MF 10% Other 15% FII 7%
Share Holding
General Public 3%
Promote r 55%
ROE Analysis
ROE
Particulars Reported PAT / PBT Adjusted PAT / PBT PBT / PBIT PBIT / Sales Sales / Total Assets Total Assets / Net Worth Reported ROE Adjusted ROE March ' 07 0.58 0.69 0.87 0.04 2.83 3.32 19% 23% March ' 08 0.67 0.57 0.78 0.03 2.56 3.69 15% 13% March ' 09 0.26 0.91 0.56 0.04 2.79 3.96 6% 23% March ' 10 0.53 0.72 0.74 0.03 2.21 4.15 11% 15% March ' 11 0.64 0.68 0.69 0.02 2.71 3.98 10% 10% Reported ROE Adjusted ROE 25% 20% 15% 10% 5% 0% March ' March ' March ' March ' March ' 07 08 09 10 11
ROE Factors
20% 18% 16% 14% 12% 10% 8% 6% 4% 2% 0% March ' 07 March ' 08 Reported ROE PBIT / Sales March ' 09 Reported PAT / PBT Sales / Total Assets March ' 10 PBT / PBIT Total Assets / Net Worth March ' 11 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00
Page 3
Income Statement
Particulars (Rs. In Cr) Net Sales Operating Expenses Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit Equity Dividend Preference Dividend Dividend Tax Retained Earnings 88539.75 310.08 1003.70 1875.82 1109.72 0.00 92839.07 3717.78 768.63 4486.41 904.11 0.00 3582.30 477.35 3104.95 955.33 2149.62 (217.64) (126.50) 1805.48 578.47 0.00 91.87 1135.14 102136.48 291.29 1297.21 2052.39 1279.79 0.00 107057.16 3150.97 982.98 4133.95 1098.21 0.00 3035.74 672.47 2363.27 1010.00 1353.27 108.65 118.65 1580.57 144.62 0.00 9.16 1426.79 123567.17 414.26 1884.88 2426.14 1240.35 0.00 129532.80 4540.63 1491.16 6031.79 1075.53 0.00 4956.26 2166.37 2789.89 261.12 2528.77 (1789.90) (2.97) 735.90 253.08 0.00 31.45 451.37 109894.18 621.84 2141.12 2585.47 1489.82 0.00 116732.43 3484.56 1679.64 5164.20 1242.32 0.00 3921.88 1010.95 2910.93 823.75 2087.18 (489.45) (60.11) 1537.62 506.16 0.00 72.77 958.69 138971.98 886.02 2802.85 0.00 5397.59 0.00 148058.44 3423.95 1754.97 5178.92 1655.40 0.00 3523.52 1100.78 2422.74 776.24 1646.50 0.00 (99.82) 1546.68 506.16 0.00 71.08 969.44 Net Sales Operating Profit EBDITA 160000.00 140000.00 120000.00 100000.00 80000.00 60000.00 40000.00 20000.00 0.00 March ' 07 96556.85 March ' 08 110208.13 March ' 09 134073.43 March ' 10 120216.99 March ' 11 151482.39
Operating Income
Profit Levels
7000.00 6000.00 5000.00 4000.00 3000.00 2000.00 1000.00 0.00 March ' 07 March ' 08 March ' 09 March ' 10 EBIT March ' 11
Total Income Break?up
Total Operating Expenses Other Write offs Income Tax Depreciation Interest Adjusted PAT
0% 1% 1% 0% 1%
Operating Profit EBT
EBDITA Adjusted PAT
97%
Page 4
Balance Sheet
Particulars (Rs. In Cr) SOURCES OF FUNDS Owner's Fund Equity Share Capital Share Application Money Preference Share Capital Reserves & Surplus Total Owners fund Loan Funds Secured Loans Unsecured Loans Total Loan fund Total USES OF FUNDS Fixed Assets Gross Block Less : Revaluation Reserve Less : Accumulated Depreciation Net Block Capital Work?in?progress Investments Net Current Assets Current Assets, Loans & Advances Less : Current Liabilities & Provisions Total Net Current Assets Miscellaneous expenses not written Total Note : Book Value of Unquoted Investments Market Value of Quoted Investments Contingent liabilities Number of Equity shares outstanding (in Lacs) 636.48 7369.30 3590.62 3615.42 707.04 9628.55 5083.23 3615.42 1118.63 15338.25 5862.61 3615.42 1385.62 12137.83 5682.54 3615.42 3594.54 9871.70 5535.17 3615.42 361.54 0.00 0.00 9912.00 10273.54 2593.96 8235.28 10829.24 21102.78 361.54 0.00 0.00 11315.30 11676.84 2730.21 12292.17 15022.38 26699.22 361.54 0.00 0.00 11766.57 12128.11 3661.60 17509.81 21171.41 33299.52 361.54 0.00 0.00 12725.17 13086.71 10443.87 11751.33 22195.20 35281.91 361.54 0.00 0.00 13696.08 14057.62 4033.10 14938.77 18971.87 33029.49 25000.00 March ' 07 March ' 08 March ' 09 March ' 10 March ' 11
Capital Structure
19457.58 0.00 8476.53 10981.05 852.34 7385.42
21500.93 0.00 9532.26 11968.67 766.71 9358.01
22522.33 0.00 10556.54 11965.79 2037.48 16715.19
25412.52 0.00 11743.17 13669.35 2517.75 12201.32
29334.23 0.00 13334.90 15999.33 1012.23 11377.96
20000.00
15000.00
10000.00
14841.40 12957.44 1883.96 0.00 21102.77
20971.33 16365.51 4605.82 0.00 26699.21
17275.18 14694.12 2581.06 0.00 33299.52
25928.12 19034.63 6893.49 0.00 35281.91
27605.83 22965.86 4639.97 0.00 33029.49
5000.00
0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 Total Owners fund Total Loan fund
Sources of Capital
Application of capital
Total Net Current Assets 14%
Total Owners fund 43% Total Loan fund 57% Investments 35%
Net Block 48%
Capital Work? in?progress 3%
Page 5
Cash Flow Statement
Particulars (Rs. In Cr) Profit Before Tax Net CashFlow?Operating Activity Net Cash Used In Investing Activity NetCash Used in Fin. Activity Net Inc/Dec In Cash And Equivlnt Cash And Equivalnt Begin of Year Cash And Equivalnt End Of Year March ' 06 390.60 1349.92 (4616.77) (626.12) (3892.98) (2335.54) (6228.52) March ' 07 1017.57 6212.34 (9908.75) (2285.32) (5981.73) (11139.67) (17121.40) March ' 08 2471.91 417.13 (3553.95) (197.74) (3334.56) (7805.11) (11139.67) March ' 09 2887.95 4646.65 (5899.60) (323.65) (1576.59) (6228.52) (7805.11) March ' 10 2421.48 (1515.15) 1538.43 652.09 675.37 (17121.40) (626.12) (16446.03) (197.74) Net CashFlow?Operating Activity Net Cash Used In Investing Activity NetCash Used in Fin. Activity 1349.92 6212.34 417.13 (9908.75) (3553.95) (2285.32) (323.65) (5899.60) (1515.15)
Net Cash Flow
652.09 4646.65 1538.43
(4616.77)
Quarterly Result
Particulars (Rs. In Cr) Sales Less: Excise Net Sales Other Income Total Income Stock Adjustment Raw Material Power And Fuel Employee Expenses Admin And Selling Expenses Research And Devlopment Expe Expenses Capitalised Other Expeses Total Expenses EBDITA Provisions Made Depreciation EBIT Interest EBT Taxation Net Profit / Loss Extra Ordinary Item Prior Year Adjustments June ' 10 34,232.52 0.00 34,232.52 320.88 34,553.40 (323.02) 15,332.45 0.00 541.23 0.00 0.00 0.00 20,087.75 35,638.41 (1,085.01) 0.00 400.74 (1,485.75) 232.35 (1,718.10) 0.00 (1,718.10) 0.00 0.00 September ' 10 December ' 10 45,271.97 0.00 45,271.97 510.08 45,782.05 (450.49) 16,991.30 0.00 1,239.42 0.00 0.00 0.00 25,827.19 43,607.42 2,174.63 0.00 482.77 1,691.86 315.71 1,376.15 440.97 935.18 0.00 0.00 36,685.93 0.00 36,685.93 310.29 36,996.22 836.17 14,745.03 0.00 569.58 0.00 0.00 0.00 19,786.32 35,937.10 1,059.12 0.00 370.00 689.12 274.74 414.38 227.00 187.38 0.00 0.00 March ' 11 35,434.77 0.00 35,434.77 533.59 35,968.36 (2,118.71) 15,661.62 0.00 452.62 0.00 0.00 0.00 18,952.74 32,948.27 3,020.09 0.00 401.89 2,618.20 277.98 2,340.22 198.00 2,142.22 0.00 0.00 June ' 11 46,139.61 0.00 46,139.61 427.32 46,566.93 (631.72) 19,244.44 0.00 657.43 0.00 0.00 0.00 29,033.68 48,303.83 (1,736.90) 0.00 490.07 (2,226.97) 334.92 (2,561.89) 0.00 (2,561.89) 0.00 0.00 EBDITA EBT EBIT Net Profit / Loss
Profit Levels
Page 6
Growth Analysis
Particulars (%) Net Sales Operating Expenses Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit Equity Dividend Preference Dividend Dividend Tax Retained Earnings 15.36 (6.06) 29.24 9.41 15.33 0.00 15.31 (15.25) 27.89 (7.86) 21.47 0.00 (15.26) 40.88 (23.89) 5.72 (37.05) 149.92 193.79 (12.46) (75.00) 0.00 (90.03) 25.69 20.98 42.22 45.30 18.21 (3.08) 0.00 20.99 44.10 51.70 45.91 (2.07) 0.00 63.26 222.15 18.05 (74.15) 86.86 (1747.40) (102.50) (53.44) 75.00 0.00 243.34 (68.36) (11.07) 50.11 13.59 6.57 20.11 0.00 (9.88) (23.26) 12.64 (14.38) 15.51 0.00 (20.87) (53.33) 4.34 215.47 (17.46) 72.65 (1923.91) 108.94 100.00 0.00 131.38 112.40 26.46 42.48 30.91 (100.00) 262.30 0.00 26.84 (1.74) 4.48 0.29 33.25 0.00 (10.16) 8.89 (16.77) (5.77) (21.11) 100.00 (66.06) 0.59 0.00 0.00 (2.32) 1.12 March ' 08 14.14 March ' 09 21.65 March ' 10 (10.33) March ' 11 26.01 Average Growth 13.05 0.00 13.00 39.86 28.43 (33.45) 111.87 0.00 13.50 (0.38) 18.71 4.20 19.69 0.00 0.80 36.08 (4.19) 48.08 (0.01) (272.69) (604.72) 20.98 37.50 0.00 78.15 23.07 5 year CAGR 9.42 0.00 9.44 23.37 22.80 (100.00) 37.21 0.00 9.78 (1.63) 17.95 2.91 12.86 0.00 (0.33) 18.19 (4.84) (4.07) (5.19) (100.00) (4.63) (3.05) (2.64) 0.00 (5.00) (3.11)
Growth Factors
100.00 80.00 60.00 40.00 10.00 20.00 0.00 March ' 08 (20.00) (40.00) (60.00) Net Sales EBDITA Adjusted PAT Total Operating Expenses EBT (10.00) (5.00) 0.00 March ' 09 March ' 10 March ' 11 5.00 15.00 20.00
5 Year CAGR
Page 7
Comparative Analysis
Income Statement
Particulars (Rs. In Cr) Net Sales Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit March ' 07 100.00 91.70 0.32 1.04 1.94 1.15 0.00 96.15 3.85 0.80 4.65 0.94 0.00 3.71 0.49 3.22 0.99 2.23 (0.23) (0.13) 1.87 March ' 08 100.00 92.68 0.26 1.18 1.86 1.16 0.00 97.14 2.86 0.89 3.75 1.00 0.00 2.75 0.61 2.14 0.92 1.23 0.10 0.11 1.43 March ' 09 100.00 92.16 0.31 1.41 1.81 0.93 0.00 96.61 3.39 1.11 4.50 0.80 0.00 3.70 1.62 2.08 0.19 1.89 (1.34) 0.00 0.55 March ' 10 100.00 91.41 0.52 1.78 2.15 1.24 0.00 97.10 2.90 1.40 4.30 1.03 0.00 3.26 0.84 2.42 0.69 1.74 (0.41) (0.05) 1.28 March ' 11 100.00 91.74 0.58 1.85 0.00 3.56 0.00 97.74 2.26 1.16 3.42 1.09 0.00 2.33 0.73 1.60 0.51 1.09 0.00 (0.07) 1.02 March ' March ' 07 08 March ' March ' March ' 09 10 11
Comparative Net Sales
Total Operating Expenses Other Income Depreciation Other Write offs Interest
Balance Sheet
Particulars (Rs. In Cr) SOURCES OF FUNDS Equity Share Capital Share Application Money Preference Share Capital Reserves & Surplus Total Owners fund Secured Loans Unsecured Loans Total Loan fund Total March ' 07 1.71 0.00 0.00 46.97 48.68 12.29 39.02 51.32 100.00 March ' 08 1.35 0.00 0.00 42.38 43.73 10.23 46.04 56.27 100.00 March ' 09 1.09 0.00 0.00 35.34 36.42 11.00 52.58 63.58 100.00 March ' 10 1.02 0.00 0.00 36.07 37.09 29.60 33.31 62.91 100.00 March ' 11 1.09 0.00 0.00 41.47 42.56 12.21 45.23 57.44 100.00 12.21 USES OF FUNDS Fixed Assets Gross Block Less : Revaluation Reserve Less : Accumulated Depreciation Net Block Capital Work?in?progress Investments Net Current Assets Current Assets, Loans & Less : Current Liabilities & Provisions Total Net Current Assets Miscellaneous expenses not written Total 1.09 0.00 0.00 92.20 0.00 40.17 52.04 4.04 35.00 80.53 0.00 35.70 44.83 2.87 35.05 67.64 0.00 31.70 35.93 6.12 50.20 72.03 0.00 33.28 38.74 7.14 34.58 88.81 0.00 40.37 48.44 3.06 34.45
Comparative Analysis?Source of Fund
41.47 45.23
70.33 61.40 8.93 0.00 100.00
78.55 61.30 17.25 0.00 100.00
51.88 44.13 7.75 0.00 100.00
73.49 53.95 19.54 0.00 100.00
83.58 69.53 14.05 0.00 100.00
Page 8
Index Analysis
Income Statement
Particulars Net Sales Operating Expenses Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit 100.00 100.00 100.00 100.00 100.00 0.00 100.00 100.00 100.00 100.00 100.00 0.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 115.36 93.94 129.24 109.41 115.33 0.00 115.31 84.75 127.89 92.14 121.47 0.00 84.74 140.88 76.11 105.72 62.95 (49.92) (93.79) 87.54 139.56 133.60 187.79 129.34 111.77 0.00 139.52 122.13 194.00 134.45 118.96 0.00 138.35 453.83 89.85 27.33 117.64 822.41 2.35 40.76 124.12 200.54 213.32 137.83 134.25 0.00 125.74 93.73 218.52 115.11 137.41 0.00 109.48 211.78 93.75 86.23 97.10 224.89 47.52 85.16 156.96 285.74 279.25 0.00 486.39 0.00 159.48 92.10 228.32 115.44 183.10 0.00 98.36 230.60 78.03 81.25 76.59 0.00 78.91 85.67 EBIT EBT Adjusted PAT Reported Net Profit Net Sales March ' March ' March ' March ' March ' 07 08 09 10 11 March ' 07 100.00 March ' 08 114.14 March ' 09 138.85 March ' 10 124.50 March ' 11 156.88
Profit Index
Balance Sheet
Particulars SOURCES OF FUNDS Equity Share Capital Share Application Money Preference Share Capital Reserves & Surplus Total Owners fund Loan Funds Secured Loans Unsecured Loans Total Loan fund Total USES OF FUNDS Fixed Assets Gross Block Less : Revaluation Reserve Less : Accumulated Net Block Capital Work?in?progress Investments Net Current Assets Current Assets, Loans & Advances Less : Current Liabilities & Provisions Total Net Current Assets Miscellaneous expenses not written Total 100.00 0.00 0.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 0.00 0.00 114.16 113.66 105.25 149.26 138.72 126.52 100.00 0.00 0.00 118.71 118.05 141.16 212.62 195.50 157.80 100.00 0.00 0.00 128.38 127.38 402.62 142.69 204.96 167.19 100.00 0.00 0.00 138.18 136.83 155.48 181.40 175.19 156.52 March ' March ' March ' March ' March ' 07 08 09 10 11 100.00 0.00 100.00 100.00 100.00 100.00 110.50 0.00 112.45 108.99 89.95 126.71 115.75 0.00 124.54 108.97 239.05 226.33 130.60 0.00 138.54 124.48 295.39 165.21 150.76 0.00 157.32 145.70 118.76 154.06 Total Owners fund Total Loan fund March ' 07 March ' 08 March ' 09 March ' 10 March ' 11
Liability Index
100.00 100.00 100.00 0.00 100.00
141.30 126.30 244.48 0.00 126.52
116.40 113.40 137.00 0.00 157.80
174.70 146.90 365.90 0.00 167.19
186.01 177.24 246.29 0.00 156.52
Page 9
Ratio Analysis
Particulars(Yearly) PER SHARE RATIOS Adjusted E P S (Rs.) Adjusted Cash EPS (Rs.) Reported EPS (Rs.) Reported Cash EPS (Rs.) Dividend Per Share Operating Profit Per Share (Rs.) Book Value (Excl Rev Res) Per Share (Rs.) Book Value (Incl Rev Res) Per Share (Rs.) Net Operating Income Per Share (Rs.) Free Reserves Per Share (Rs.) PROFITABILITY RATIOS Operating Margin (%) Gross Profit Margin (%) Net Profit Margin (%) Adjusted Cash Margin (%) Adjusted Return On Net Worth (%) Reported Return On Net Worth (%) Return On long Term Funds (%) LEVERAGE RATIOS Long Term Debt / Equity Total Debt/Equity Owners fund as % of total Source Fixed Assets Turnover Ratio LIQUIDITY RATIOS Current Ratio Current Ratio (Inc. ST Loans) Quick Ratio Inventory Turnover Ratio PAYOUT RATIOS Dividend payout Ratio (Net Profit) Dividend payout Ratio (Cash Profit) Earning Retention Ratio Cash Earnings Retention Ratio COVERAGE RATIOS Adjusted Cash Flow Time Total Debt Financial Charges Coverage Ratio Fin. Charges Cov.Ratio (Post Tax) COMPONENT RATIOS Material Cost Component(% earnings) Selling Cost Component Exports as percent of Total Sales Import Comp. in Raw Mat. Consumed Long term assets / Total Assets Bonus Component In Equity Capital (%) 91.90 1.94 5.78 72.14 0.56 76.61 92.31 1.86 6.75 70.99 0.51 76.61 90.98 1.80 4.89 72.72 0.63 76.61 94.73 2.15 8.56 72.07 0.52 76.61 93.09 0.00 8.17 74.90 0.50 76.61 Current Ratio Quick Ratio March ' March ' March ' March ' March ' 07 08 09 10 11 3.55 9.40 6.68 6.13 6.15 4.98 5.87 2.78 1.84 6.67 5.11 3.75 5.75 4.70 3.91 1.15 0.61 0.45 12.58 1.28 0.73 0.61 11.64 1.18 0.49 0.66 21.91 1.36 0.72 0.67 11.09 1.20 1.20 0.53 10.62 0.21 1.05 48.68 4.98 0.33 1.29 43.73 5.14 0.30 1.75 36.42 5.97 0.93 1.70 37.09 4.75 1.35 1.35 42.56 5.16 60.00 50.00 40.00 30.00 20.00 10.00 0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 Net Profit Margin (%) Operating Margin (%) 24.73 68.82 78.05 5.74 88.64 93.73 15.70 88.75 92.11 20.82 72.27 82.62 18.02 64.95 82.52 Adjusted Return On Net Worth (%) Return On long Term Funds (%) 3.85 2.91 1.85 3.13 20.92 17.57 28.81 2.85 1.86 1.42 2.20 11.58 13.53 19.46 3.38 2.58 0.54 2.65 20.85 6.06 31.19 2.89 1.86 1.26 2.73 15.94 11.74 15.52 2.26 1.16 1.00 2.15 11.71 11.00 10.66 59.46 84.46 49.94 74.95 16.00 102.83 284.16 284.16 2670.69 273.74 37.43 67.81 43.72 74.09 4.00 87.15 322.97 322.97 3048.28 312.56 69.94 99.69 20.35 50.10 7.00 125.59 335.46 335.46 3708.38 316.74 57.73 92.09 42.53 76.89 14.00 96.38 361.97 361.97 3325.12 323.90 45.54 91.33 42.78 88.57 14.00 5000.00 94.70 388.83 388.83 4189.90 0.00 4000.00 3000.00 2000.00 1000.00 0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 March ' 07 March ' 08 March ' 09 March ' 10 March ' 11
Per Share Ratio
Net Operating Income Per Share (Rs.) Adjusted E P S (Rs.) Adjusted Cash EPS (Rs.) Dividend Per Share Book Value (Incl Rev Res) Per Share (Rs.)
Profit Margin
37.12
9.72
38.66
37.65
37.32
Liquidity Ratio
Page 10
Ratio Analysis
Particulars(Quarterly) PER SHARE RATIOS Operating Income Per Share(Rs.) Operating Profit Per Share(Rs.) Adjusted EPS(Rs.) PROFITABILITY RATIOS OPM(%) GPM(%) NPM(%) (4.10) (3.81) (4.97) 7.01 7.62 5.95 2.04 2.12 0.50 3.67 4.06 2.04 (4.69) (4.44) (5.50) 946.85 (30.01) (47.52) 1252.20 60.15 25.87 1014.71 29.29 5.18 980.11 83.53 59.25 1276.20 (48.04) (70.86) June ' 10 September ' 10 December ' 10 March ' 11 June ' 11
Quarterly Profit Margin
TTM Analysis
Particulars (Rs. In Cr) Sales Less: Excise Net Sales Other Income Total Income Stock Adjustment Raw Material Power And Fuel Employee Expenses Admin And Selling Expenses Research And Devlopment Expe Expenses Capitalised Other Expeses Total Expenses EBDITA Provisions Made Depreciation EBIT Interest EBT Taxation Net Profit / Loss Extra Ordinary Item Prior Year Adjustments TTM EPS TTM SPS March ' 11 151625.19 0.00 151625.19 1674.84 153300.03 (2056.05) 62730.40 0.00 2802.85 0.00 0.00 0.00 84654.00 148131.20 5168.83 1655.40 3513.43 1100.78 2412.65 865.97 1546.68 0.00 0.00 42.78 4193.87 % of Sales 100.00 0.00 100.00 1.10 101.10 (1.36) 41.37 0.00 1.85 0.00 0.00 0.00 55.83 97.70 3.41 1.09 2.32 0.73 1.59 0.57 1.02 0.00 0.00 June ' 11 163532.28 0.00 163532.28 1781.28 165313.56 (2364.75) 66642.39 0.00 2919.05 0.00 0.00 0.00 93599.93 160796.62 4516.94 1744.73 2772.21 1203.35 1568.86 865.97 702.89 0.00 0.00 19.44 4523.21 % of Sales 100.00 0.00 100.00 1.09 101.09 (1.45) 40.75 0.00 1.78 0.00 0.00 0.00 57.24 98.33 2.76 1.07 1.70 0.74 0.96 0.53 0.43 0.00 0.00 Growth(%) 7.85 NA 7.85 6.36 7.84 15.01 6.24 NA 4.15 NA NA NA 10.57 8.55 (12.61) 5.40 (21.10) 9.32 (34.97) 0.00 (54.55) NA NA ?1.51 0.22
OPM(%)
GPM(%)
NPM(%)
TTM Growth (%)
7.85 8.55
(12.61) (21.10) (34.97)
(54.55)
TTM EPS & SPS(%)
March ' 11
June ' 11
Page 11
Technical Analysis
Price Chart
720.00 700.00 680.00 660.00 640.00 620.00 600.00 580.00 560.00 540.00 19?May Volume Close 28?Jul EMA(200) EMA(50) 700000.00 600000.00 500000.00 400000.00 300000.00 200000.00 100000.00 0.00
20.00 15.00 10.00 5.00 0.00
MACD
Signal line
80 60 40 20 0 RSI(14)
Technical Indicators Price EMA(13) EMA(26) EMA(50) EMA(200) RSI(14) MACD William(%R) 662.15 675.21 667.52 655.07 626.48 47.55 7.69 ?100.00 AS On: ADX DX +DI ?DI %K(Fast) %K(Slow) %d(Slow) 09/09/2011 22 20 14 21 0 16.67 14.1
Page 12
doc_372955036.pdf
FINANCIAL ANALYSIS OF BHARAT PETROLEUM
gtÇtç eÉç XåvÄâá|äx
COMPANY FINALYTICS
Bharat Petroleum Corporation Ltd
Exclusive Financial Analysis of Indian Companies
Prepared and Edited By?
Tanay Roy, CFA Peu Karak, MBA
Disclaimer The information, opinions, estimates and forecasts contained in this document have been arrived at or obtained from public sources believed to be reliable and in good faith which has not been independently verified and no warranty, express or implied, is made as to their accuracy, completeness or correctness.
For more information about this sample and our other services, please write to [email protected]
Tuesday, September 13, 2011
Description Summary Latest Result Valuation Matrix ROE Analysis Income Statement Balance Sheet Cashflow Statement Quarterly Result Growth Analysis Comparative Analysis Income Statement Balance Sheet Index Analysis Income Statement Balance Sheet Ratio Analysis Annual Quarterly TTM Analysis
Page 3 3 3 3 4 5 6 6 7 8 8 8 9 9 9 10 10 11 11 12
CONTENT
Technical Analysis
About Tanay & Peu
Our passion lies in the field of financial research & Investment management and we intend to apply our knowledge gained over a period of years through intense study and keen observation of the nuances of financial markets and instruments to real life scenarios. We possess expert knowledge of financial products and markets as evidenced by top notch qualifications earned by us , all in the first attempt and keep ourselves abreast with the latest happenings and innovations taking place in financial landscape. 1. Expertise in Portfolio Management, Product optimization, Product performance Analysis, Financial Reporting/ Planning, Cash Flow Analysis, Ratio Analysis, Budgeting, Forecasting, Mergers & Acquisition and knowledge of GAAP/ IFRS 2. Possess Strong Financial Modeling skills including DCF, LBO and other techniques. Possess ability to research all asset classes in a broad range of industries and geographies. 3. Strong equity research, finance, accounting and advisory and assurance experience 4. Expertise in Technical analysis, fundamental analysis, developing trading systems. 5. Conduct in?depth financial analysis of company financials. 6. Write analytical or trend based reports on companies, sectors or markets. 7. Expert level application in Bloomberg, Thomson Banker, Factset, Datastream, StockVal, Merger markets, Reuters Knowledge, Haver Analytics, Factiva, PackHedge, 8. Building Excel/VBA based customized tools to perform detailed analysis.
Contact Us: [email protected]
Page 2
Summary Latest Results
Yearly Latest Results EBDITA Reported Net Profit Adjusted PAT March ' 11 5178.92 1546.68 1646.50 Growth 0.29 0.59 (0.01) Quarterly June ' 11 (1736.90) (2561.89) (2561.89) Growth 30.21 (219.59) (219.59) TTM June ' 11 4516.94 702.89 NA Growth (12.61) (54.55) NA Price Market Cap(Rs. In Cr) 662.15 23939.50 At a Glance Industry Business Group Face Value Number of Equity shares Refineries Public Sector 10 3615.42
Valuation Matrix
Particulars Reported P/E Price/Sales Per Share Price/ Book Value Dividend Yield Earning Yield Market Cap(Rs. In Cr) Annual March ' 11 15.48 0.16 1.70 0.02 0.06 23939.50 TTM Ratio March ' 11 15.48 0.16 NA NA 0.06 BFI 10% MF 10% Other 15% FII 7%
Share Holding
General Public 3%
Promote r 55%
ROE Analysis
ROE
Particulars Reported PAT / PBT Adjusted PAT / PBT PBT / PBIT PBIT / Sales Sales / Total Assets Total Assets / Net Worth Reported ROE Adjusted ROE March ' 07 0.58 0.69 0.87 0.04 2.83 3.32 19% 23% March ' 08 0.67 0.57 0.78 0.03 2.56 3.69 15% 13% March ' 09 0.26 0.91 0.56 0.04 2.79 3.96 6% 23% March ' 10 0.53 0.72 0.74 0.03 2.21 4.15 11% 15% March ' 11 0.64 0.68 0.69 0.02 2.71 3.98 10% 10% Reported ROE Adjusted ROE 25% 20% 15% 10% 5% 0% March ' March ' March ' March ' March ' 07 08 09 10 11
ROE Factors
20% 18% 16% 14% 12% 10% 8% 6% 4% 2% 0% March ' 07 March ' 08 Reported ROE PBIT / Sales March ' 09 Reported PAT / PBT Sales / Total Assets March ' 10 PBT / PBIT Total Assets / Net Worth March ' 11 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00
Page 3
Income Statement
Particulars (Rs. In Cr) Net Sales Operating Expenses Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit Equity Dividend Preference Dividend Dividend Tax Retained Earnings 88539.75 310.08 1003.70 1875.82 1109.72 0.00 92839.07 3717.78 768.63 4486.41 904.11 0.00 3582.30 477.35 3104.95 955.33 2149.62 (217.64) (126.50) 1805.48 578.47 0.00 91.87 1135.14 102136.48 291.29 1297.21 2052.39 1279.79 0.00 107057.16 3150.97 982.98 4133.95 1098.21 0.00 3035.74 672.47 2363.27 1010.00 1353.27 108.65 118.65 1580.57 144.62 0.00 9.16 1426.79 123567.17 414.26 1884.88 2426.14 1240.35 0.00 129532.80 4540.63 1491.16 6031.79 1075.53 0.00 4956.26 2166.37 2789.89 261.12 2528.77 (1789.90) (2.97) 735.90 253.08 0.00 31.45 451.37 109894.18 621.84 2141.12 2585.47 1489.82 0.00 116732.43 3484.56 1679.64 5164.20 1242.32 0.00 3921.88 1010.95 2910.93 823.75 2087.18 (489.45) (60.11) 1537.62 506.16 0.00 72.77 958.69 138971.98 886.02 2802.85 0.00 5397.59 0.00 148058.44 3423.95 1754.97 5178.92 1655.40 0.00 3523.52 1100.78 2422.74 776.24 1646.50 0.00 (99.82) 1546.68 506.16 0.00 71.08 969.44 Net Sales Operating Profit EBDITA 160000.00 140000.00 120000.00 100000.00 80000.00 60000.00 40000.00 20000.00 0.00 March ' 07 96556.85 March ' 08 110208.13 March ' 09 134073.43 March ' 10 120216.99 March ' 11 151482.39
Operating Income
Profit Levels
7000.00 6000.00 5000.00 4000.00 3000.00 2000.00 1000.00 0.00 March ' 07 March ' 08 March ' 09 March ' 10 EBIT March ' 11
Total Income Break?up
Total Operating Expenses Other Write offs Income Tax Depreciation Interest Adjusted PAT
0% 1% 1% 0% 1%
Operating Profit EBT
EBDITA Adjusted PAT
97%
Page 4
Balance Sheet
Particulars (Rs. In Cr) SOURCES OF FUNDS Owner's Fund Equity Share Capital Share Application Money Preference Share Capital Reserves & Surplus Total Owners fund Loan Funds Secured Loans Unsecured Loans Total Loan fund Total USES OF FUNDS Fixed Assets Gross Block Less : Revaluation Reserve Less : Accumulated Depreciation Net Block Capital Work?in?progress Investments Net Current Assets Current Assets, Loans & Advances Less : Current Liabilities & Provisions Total Net Current Assets Miscellaneous expenses not written Total Note : Book Value of Unquoted Investments Market Value of Quoted Investments Contingent liabilities Number of Equity shares outstanding (in Lacs) 636.48 7369.30 3590.62 3615.42 707.04 9628.55 5083.23 3615.42 1118.63 15338.25 5862.61 3615.42 1385.62 12137.83 5682.54 3615.42 3594.54 9871.70 5535.17 3615.42 361.54 0.00 0.00 9912.00 10273.54 2593.96 8235.28 10829.24 21102.78 361.54 0.00 0.00 11315.30 11676.84 2730.21 12292.17 15022.38 26699.22 361.54 0.00 0.00 11766.57 12128.11 3661.60 17509.81 21171.41 33299.52 361.54 0.00 0.00 12725.17 13086.71 10443.87 11751.33 22195.20 35281.91 361.54 0.00 0.00 13696.08 14057.62 4033.10 14938.77 18971.87 33029.49 25000.00 March ' 07 March ' 08 March ' 09 March ' 10 March ' 11
Capital Structure
19457.58 0.00 8476.53 10981.05 852.34 7385.42
21500.93 0.00 9532.26 11968.67 766.71 9358.01
22522.33 0.00 10556.54 11965.79 2037.48 16715.19
25412.52 0.00 11743.17 13669.35 2517.75 12201.32
29334.23 0.00 13334.90 15999.33 1012.23 11377.96
20000.00
15000.00
10000.00
14841.40 12957.44 1883.96 0.00 21102.77
20971.33 16365.51 4605.82 0.00 26699.21
17275.18 14694.12 2581.06 0.00 33299.52
25928.12 19034.63 6893.49 0.00 35281.91
27605.83 22965.86 4639.97 0.00 33029.49
5000.00
0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 Total Owners fund Total Loan fund
Sources of Capital
Application of capital
Total Net Current Assets 14%
Total Owners fund 43% Total Loan fund 57% Investments 35%
Net Block 48%
Capital Work? in?progress 3%
Page 5
Cash Flow Statement
Particulars (Rs. In Cr) Profit Before Tax Net CashFlow?Operating Activity Net Cash Used In Investing Activity NetCash Used in Fin. Activity Net Inc/Dec In Cash And Equivlnt Cash And Equivalnt Begin of Year Cash And Equivalnt End Of Year March ' 06 390.60 1349.92 (4616.77) (626.12) (3892.98) (2335.54) (6228.52) March ' 07 1017.57 6212.34 (9908.75) (2285.32) (5981.73) (11139.67) (17121.40) March ' 08 2471.91 417.13 (3553.95) (197.74) (3334.56) (7805.11) (11139.67) March ' 09 2887.95 4646.65 (5899.60) (323.65) (1576.59) (6228.52) (7805.11) March ' 10 2421.48 (1515.15) 1538.43 652.09 675.37 (17121.40) (626.12) (16446.03) (197.74) Net CashFlow?Operating Activity Net Cash Used In Investing Activity NetCash Used in Fin. Activity 1349.92 6212.34 417.13 (9908.75) (3553.95) (2285.32) (323.65) (5899.60) (1515.15)
Net Cash Flow
652.09 4646.65 1538.43
(4616.77)
Quarterly Result
Particulars (Rs. In Cr) Sales Less: Excise Net Sales Other Income Total Income Stock Adjustment Raw Material Power And Fuel Employee Expenses Admin And Selling Expenses Research And Devlopment Expe Expenses Capitalised Other Expeses Total Expenses EBDITA Provisions Made Depreciation EBIT Interest EBT Taxation Net Profit / Loss Extra Ordinary Item Prior Year Adjustments June ' 10 34,232.52 0.00 34,232.52 320.88 34,553.40 (323.02) 15,332.45 0.00 541.23 0.00 0.00 0.00 20,087.75 35,638.41 (1,085.01) 0.00 400.74 (1,485.75) 232.35 (1,718.10) 0.00 (1,718.10) 0.00 0.00 September ' 10 December ' 10 45,271.97 0.00 45,271.97 510.08 45,782.05 (450.49) 16,991.30 0.00 1,239.42 0.00 0.00 0.00 25,827.19 43,607.42 2,174.63 0.00 482.77 1,691.86 315.71 1,376.15 440.97 935.18 0.00 0.00 36,685.93 0.00 36,685.93 310.29 36,996.22 836.17 14,745.03 0.00 569.58 0.00 0.00 0.00 19,786.32 35,937.10 1,059.12 0.00 370.00 689.12 274.74 414.38 227.00 187.38 0.00 0.00 March ' 11 35,434.77 0.00 35,434.77 533.59 35,968.36 (2,118.71) 15,661.62 0.00 452.62 0.00 0.00 0.00 18,952.74 32,948.27 3,020.09 0.00 401.89 2,618.20 277.98 2,340.22 198.00 2,142.22 0.00 0.00 June ' 11 46,139.61 0.00 46,139.61 427.32 46,566.93 (631.72) 19,244.44 0.00 657.43 0.00 0.00 0.00 29,033.68 48,303.83 (1,736.90) 0.00 490.07 (2,226.97) 334.92 (2,561.89) 0.00 (2,561.89) 0.00 0.00 EBDITA EBT EBIT Net Profit / Loss
Profit Levels
Page 6
Growth Analysis
Particulars (%) Net Sales Operating Expenses Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit Equity Dividend Preference Dividend Dividend Tax Retained Earnings 15.36 (6.06) 29.24 9.41 15.33 0.00 15.31 (15.25) 27.89 (7.86) 21.47 0.00 (15.26) 40.88 (23.89) 5.72 (37.05) 149.92 193.79 (12.46) (75.00) 0.00 (90.03) 25.69 20.98 42.22 45.30 18.21 (3.08) 0.00 20.99 44.10 51.70 45.91 (2.07) 0.00 63.26 222.15 18.05 (74.15) 86.86 (1747.40) (102.50) (53.44) 75.00 0.00 243.34 (68.36) (11.07) 50.11 13.59 6.57 20.11 0.00 (9.88) (23.26) 12.64 (14.38) 15.51 0.00 (20.87) (53.33) 4.34 215.47 (17.46) 72.65 (1923.91) 108.94 100.00 0.00 131.38 112.40 26.46 42.48 30.91 (100.00) 262.30 0.00 26.84 (1.74) 4.48 0.29 33.25 0.00 (10.16) 8.89 (16.77) (5.77) (21.11) 100.00 (66.06) 0.59 0.00 0.00 (2.32) 1.12 March ' 08 14.14 March ' 09 21.65 March ' 10 (10.33) March ' 11 26.01 Average Growth 13.05 0.00 13.00 39.86 28.43 (33.45) 111.87 0.00 13.50 (0.38) 18.71 4.20 19.69 0.00 0.80 36.08 (4.19) 48.08 (0.01) (272.69) (604.72) 20.98 37.50 0.00 78.15 23.07 5 year CAGR 9.42 0.00 9.44 23.37 22.80 (100.00) 37.21 0.00 9.78 (1.63) 17.95 2.91 12.86 0.00 (0.33) 18.19 (4.84) (4.07) (5.19) (100.00) (4.63) (3.05) (2.64) 0.00 (5.00) (3.11)
Growth Factors
100.00 80.00 60.00 40.00 10.00 20.00 0.00 March ' 08 (20.00) (40.00) (60.00) Net Sales EBDITA Adjusted PAT Total Operating Expenses EBT (10.00) (5.00) 0.00 March ' 09 March ' 10 March ' 11 5.00 15.00 20.00
5 Year CAGR
Page 7
Comparative Analysis
Income Statement
Particulars (Rs. In Cr) Net Sales Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit March ' 07 100.00 91.70 0.32 1.04 1.94 1.15 0.00 96.15 3.85 0.80 4.65 0.94 0.00 3.71 0.49 3.22 0.99 2.23 (0.23) (0.13) 1.87 March ' 08 100.00 92.68 0.26 1.18 1.86 1.16 0.00 97.14 2.86 0.89 3.75 1.00 0.00 2.75 0.61 2.14 0.92 1.23 0.10 0.11 1.43 March ' 09 100.00 92.16 0.31 1.41 1.81 0.93 0.00 96.61 3.39 1.11 4.50 0.80 0.00 3.70 1.62 2.08 0.19 1.89 (1.34) 0.00 0.55 March ' 10 100.00 91.41 0.52 1.78 2.15 1.24 0.00 97.10 2.90 1.40 4.30 1.03 0.00 3.26 0.84 2.42 0.69 1.74 (0.41) (0.05) 1.28 March ' 11 100.00 91.74 0.58 1.85 0.00 3.56 0.00 97.74 2.26 1.16 3.42 1.09 0.00 2.33 0.73 1.60 0.51 1.09 0.00 (0.07) 1.02 March ' March ' 07 08 March ' March ' March ' 09 10 11
Comparative Net Sales
Total Operating Expenses Other Income Depreciation Other Write offs Interest
Balance Sheet
Particulars (Rs. In Cr) SOURCES OF FUNDS Equity Share Capital Share Application Money Preference Share Capital Reserves & Surplus Total Owners fund Secured Loans Unsecured Loans Total Loan fund Total March ' 07 1.71 0.00 0.00 46.97 48.68 12.29 39.02 51.32 100.00 March ' 08 1.35 0.00 0.00 42.38 43.73 10.23 46.04 56.27 100.00 March ' 09 1.09 0.00 0.00 35.34 36.42 11.00 52.58 63.58 100.00 March ' 10 1.02 0.00 0.00 36.07 37.09 29.60 33.31 62.91 100.00 March ' 11 1.09 0.00 0.00 41.47 42.56 12.21 45.23 57.44 100.00 12.21 USES OF FUNDS Fixed Assets Gross Block Less : Revaluation Reserve Less : Accumulated Depreciation Net Block Capital Work?in?progress Investments Net Current Assets Current Assets, Loans & Less : Current Liabilities & Provisions Total Net Current Assets Miscellaneous expenses not written Total 1.09 0.00 0.00 92.20 0.00 40.17 52.04 4.04 35.00 80.53 0.00 35.70 44.83 2.87 35.05 67.64 0.00 31.70 35.93 6.12 50.20 72.03 0.00 33.28 38.74 7.14 34.58 88.81 0.00 40.37 48.44 3.06 34.45
Comparative Analysis?Source of Fund
41.47 45.23
70.33 61.40 8.93 0.00 100.00
78.55 61.30 17.25 0.00 100.00
51.88 44.13 7.75 0.00 100.00
73.49 53.95 19.54 0.00 100.00
83.58 69.53 14.05 0.00 100.00
Page 8
Index Analysis
Income Statement
Particulars Net Sales Operating Expenses Material Consumed Manufacturing Expenses Personnel Expenses Selling Expenses Adminstrative Expenses Expenses Capitalised Total Operating Expenses Operating Profit Other Income EBDITA Depreciation Other Write offs EBIT Interest EBT Income Tax Adjusted PAT Non Recurring Items Other Non Cash adjustments Reported Net Profit 100.00 100.00 100.00 100.00 100.00 0.00 100.00 100.00 100.00 100.00 100.00 0.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 115.36 93.94 129.24 109.41 115.33 0.00 115.31 84.75 127.89 92.14 121.47 0.00 84.74 140.88 76.11 105.72 62.95 (49.92) (93.79) 87.54 139.56 133.60 187.79 129.34 111.77 0.00 139.52 122.13 194.00 134.45 118.96 0.00 138.35 453.83 89.85 27.33 117.64 822.41 2.35 40.76 124.12 200.54 213.32 137.83 134.25 0.00 125.74 93.73 218.52 115.11 137.41 0.00 109.48 211.78 93.75 86.23 97.10 224.89 47.52 85.16 156.96 285.74 279.25 0.00 486.39 0.00 159.48 92.10 228.32 115.44 183.10 0.00 98.36 230.60 78.03 81.25 76.59 0.00 78.91 85.67 EBIT EBT Adjusted PAT Reported Net Profit Net Sales March ' March ' March ' March ' March ' 07 08 09 10 11 March ' 07 100.00 March ' 08 114.14 March ' 09 138.85 March ' 10 124.50 March ' 11 156.88
Profit Index
Balance Sheet
Particulars SOURCES OF FUNDS Equity Share Capital Share Application Money Preference Share Capital Reserves & Surplus Total Owners fund Loan Funds Secured Loans Unsecured Loans Total Loan fund Total USES OF FUNDS Fixed Assets Gross Block Less : Revaluation Reserve Less : Accumulated Net Block Capital Work?in?progress Investments Net Current Assets Current Assets, Loans & Advances Less : Current Liabilities & Provisions Total Net Current Assets Miscellaneous expenses not written Total 100.00 0.00 0.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 0.00 0.00 114.16 113.66 105.25 149.26 138.72 126.52 100.00 0.00 0.00 118.71 118.05 141.16 212.62 195.50 157.80 100.00 0.00 0.00 128.38 127.38 402.62 142.69 204.96 167.19 100.00 0.00 0.00 138.18 136.83 155.48 181.40 175.19 156.52 March ' March ' March ' March ' March ' 07 08 09 10 11 100.00 0.00 100.00 100.00 100.00 100.00 110.50 0.00 112.45 108.99 89.95 126.71 115.75 0.00 124.54 108.97 239.05 226.33 130.60 0.00 138.54 124.48 295.39 165.21 150.76 0.00 157.32 145.70 118.76 154.06 Total Owners fund Total Loan fund March ' 07 March ' 08 March ' 09 March ' 10 March ' 11
Liability Index
100.00 100.00 100.00 0.00 100.00
141.30 126.30 244.48 0.00 126.52
116.40 113.40 137.00 0.00 157.80
174.70 146.90 365.90 0.00 167.19
186.01 177.24 246.29 0.00 156.52
Page 9
Ratio Analysis
Particulars(Yearly) PER SHARE RATIOS Adjusted E P S (Rs.) Adjusted Cash EPS (Rs.) Reported EPS (Rs.) Reported Cash EPS (Rs.) Dividend Per Share Operating Profit Per Share (Rs.) Book Value (Excl Rev Res) Per Share (Rs.) Book Value (Incl Rev Res) Per Share (Rs.) Net Operating Income Per Share (Rs.) Free Reserves Per Share (Rs.) PROFITABILITY RATIOS Operating Margin (%) Gross Profit Margin (%) Net Profit Margin (%) Adjusted Cash Margin (%) Adjusted Return On Net Worth (%) Reported Return On Net Worth (%) Return On long Term Funds (%) LEVERAGE RATIOS Long Term Debt / Equity Total Debt/Equity Owners fund as % of total Source Fixed Assets Turnover Ratio LIQUIDITY RATIOS Current Ratio Current Ratio (Inc. ST Loans) Quick Ratio Inventory Turnover Ratio PAYOUT RATIOS Dividend payout Ratio (Net Profit) Dividend payout Ratio (Cash Profit) Earning Retention Ratio Cash Earnings Retention Ratio COVERAGE RATIOS Adjusted Cash Flow Time Total Debt Financial Charges Coverage Ratio Fin. Charges Cov.Ratio (Post Tax) COMPONENT RATIOS Material Cost Component(% earnings) Selling Cost Component Exports as percent of Total Sales Import Comp. in Raw Mat. Consumed Long term assets / Total Assets Bonus Component In Equity Capital (%) 91.90 1.94 5.78 72.14 0.56 76.61 92.31 1.86 6.75 70.99 0.51 76.61 90.98 1.80 4.89 72.72 0.63 76.61 94.73 2.15 8.56 72.07 0.52 76.61 93.09 0.00 8.17 74.90 0.50 76.61 Current Ratio Quick Ratio March ' March ' March ' March ' March ' 07 08 09 10 11 3.55 9.40 6.68 6.13 6.15 4.98 5.87 2.78 1.84 6.67 5.11 3.75 5.75 4.70 3.91 1.15 0.61 0.45 12.58 1.28 0.73 0.61 11.64 1.18 0.49 0.66 21.91 1.36 0.72 0.67 11.09 1.20 1.20 0.53 10.62 0.21 1.05 48.68 4.98 0.33 1.29 43.73 5.14 0.30 1.75 36.42 5.97 0.93 1.70 37.09 4.75 1.35 1.35 42.56 5.16 60.00 50.00 40.00 30.00 20.00 10.00 0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 Net Profit Margin (%) Operating Margin (%) 24.73 68.82 78.05 5.74 88.64 93.73 15.70 88.75 92.11 20.82 72.27 82.62 18.02 64.95 82.52 Adjusted Return On Net Worth (%) Return On long Term Funds (%) 3.85 2.91 1.85 3.13 20.92 17.57 28.81 2.85 1.86 1.42 2.20 11.58 13.53 19.46 3.38 2.58 0.54 2.65 20.85 6.06 31.19 2.89 1.86 1.26 2.73 15.94 11.74 15.52 2.26 1.16 1.00 2.15 11.71 11.00 10.66 59.46 84.46 49.94 74.95 16.00 102.83 284.16 284.16 2670.69 273.74 37.43 67.81 43.72 74.09 4.00 87.15 322.97 322.97 3048.28 312.56 69.94 99.69 20.35 50.10 7.00 125.59 335.46 335.46 3708.38 316.74 57.73 92.09 42.53 76.89 14.00 96.38 361.97 361.97 3325.12 323.90 45.54 91.33 42.78 88.57 14.00 5000.00 94.70 388.83 388.83 4189.90 0.00 4000.00 3000.00 2000.00 1000.00 0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 March ' 07 March ' 08 March ' 09 March ' 10 March ' 11
Per Share Ratio
Net Operating Income Per Share (Rs.) Adjusted E P S (Rs.) Adjusted Cash EPS (Rs.) Dividend Per Share Book Value (Incl Rev Res) Per Share (Rs.)
Profit Margin
37.12
9.72
38.66
37.65
37.32
Liquidity Ratio
Page 10
Ratio Analysis
Particulars(Quarterly) PER SHARE RATIOS Operating Income Per Share(Rs.) Operating Profit Per Share(Rs.) Adjusted EPS(Rs.) PROFITABILITY RATIOS OPM(%) GPM(%) NPM(%) (4.10) (3.81) (4.97) 7.01 7.62 5.95 2.04 2.12 0.50 3.67 4.06 2.04 (4.69) (4.44) (5.50) 946.85 (30.01) (47.52) 1252.20 60.15 25.87 1014.71 29.29 5.18 980.11 83.53 59.25 1276.20 (48.04) (70.86) June ' 10 September ' 10 December ' 10 March ' 11 June ' 11
Quarterly Profit Margin
TTM Analysis
Particulars (Rs. In Cr) Sales Less: Excise Net Sales Other Income Total Income Stock Adjustment Raw Material Power And Fuel Employee Expenses Admin And Selling Expenses Research And Devlopment Expe Expenses Capitalised Other Expeses Total Expenses EBDITA Provisions Made Depreciation EBIT Interest EBT Taxation Net Profit / Loss Extra Ordinary Item Prior Year Adjustments TTM EPS TTM SPS March ' 11 151625.19 0.00 151625.19 1674.84 153300.03 (2056.05) 62730.40 0.00 2802.85 0.00 0.00 0.00 84654.00 148131.20 5168.83 1655.40 3513.43 1100.78 2412.65 865.97 1546.68 0.00 0.00 42.78 4193.87 % of Sales 100.00 0.00 100.00 1.10 101.10 (1.36) 41.37 0.00 1.85 0.00 0.00 0.00 55.83 97.70 3.41 1.09 2.32 0.73 1.59 0.57 1.02 0.00 0.00 June ' 11 163532.28 0.00 163532.28 1781.28 165313.56 (2364.75) 66642.39 0.00 2919.05 0.00 0.00 0.00 93599.93 160796.62 4516.94 1744.73 2772.21 1203.35 1568.86 865.97 702.89 0.00 0.00 19.44 4523.21 % of Sales 100.00 0.00 100.00 1.09 101.09 (1.45) 40.75 0.00 1.78 0.00 0.00 0.00 57.24 98.33 2.76 1.07 1.70 0.74 0.96 0.53 0.43 0.00 0.00 Growth(%) 7.85 NA 7.85 6.36 7.84 15.01 6.24 NA 4.15 NA NA NA 10.57 8.55 (12.61) 5.40 (21.10) 9.32 (34.97) 0.00 (54.55) NA NA ?1.51 0.22
OPM(%)
GPM(%)
NPM(%)
TTM Growth (%)
7.85 8.55
(12.61) (21.10) (34.97)
(54.55)
TTM EPS & SPS(%)
March ' 11
June ' 11
Page 11
Technical Analysis
Price Chart
720.00 700.00 680.00 660.00 640.00 620.00 600.00 580.00 560.00 540.00 19?May Volume Close 28?Jul EMA(200) EMA(50) 700000.00 600000.00 500000.00 400000.00 300000.00 200000.00 100000.00 0.00
20.00 15.00 10.00 5.00 0.00
MACD
Signal line
80 60 40 20 0 RSI(14)
Technical Indicators Price EMA(13) EMA(26) EMA(50) EMA(200) RSI(14) MACD William(%R) 662.15 675.21 667.52 655.07 626.48 47.55 7.69 ?100.00 AS On: ADX DX +DI ?DI %K(Fast) %K(Slow) %d(Slow) 09/09/2011 22 20 14 21 0 16.67 14.1
Page 12
doc_372955036.pdf