Free Essay

Term

In:

Submitted By amitjhajiml
Words 4886
Pages 20
gtÇtç eÉç XåvÄâá|äx
COMPANY FINALYTICS

Cipla 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 tanay.roy2008@gmail.com

Wednesday, September 14, 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: tanay.roy2008@gmail.com

Page 2

Summary Latest Results
Yearly Latest Results EBDITA Reported Net Profit Adjusted PAT March ' 11 1385.39 2659.46 960.39 Growth (6.08) 145.91 9.80 Quarterly June ' 11 394.39 253.34 253.34 Growth (1.48) (3.68) (3.68) TTM June ' 11 1443.92 963.04 NA Growth 1.91 (0.42) NA Price Market Cap(Rs. In Cr) 289.3 22487.03 At a Glance Industry Business Group Face Value Number of Equity shares Pharmaceuticals Cipla Group 2 8029.21

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 24.19 3.79 3.51 0.01 0.04 22487.03 TTM Ratio March ' 11 24.01 3.68 NA NA 0.04 FII 15% Other 8% General Public 21%

Share Holding

Promote r 37%

BFI 12%

MF 7%

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.86 0.82 0.99 0.22 0.81 1.36 21% 20% March ' 08 0.91 0.82 0.98 0.19 0.73 1.53 19% 17% March ' 09 0.69 0.89 0.96 0.23 0.76 1.58 18% 24% March ' 10 0.84 0.81 0.98 0.23 0.66 1.43 18% 17% March ' 11 2.31 0.83 1.00 0.19 0.73 1.27 41% 15% Reported ROE Adjusted ROE 50% 40% 30% 20% 10% 0% March ' March ' March ' March ' March ' 07 08 09 10 11

ROE Factors
45% 40% 35% 30% 25% 20% 15% 10% 5% 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 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 1785.62 273.18 184.59 226.08 270.69 0.00 2740.16 821.83 65.78 887.61 103.37 0.00 784.24 11.16 773.08 139.95 633.13 34.90 0.00 668.03 155.46 0.00 26.42 486.15 2121.11 330.80 255.45 284.63 359.13 0.00 3351.12 852.17 64.91 917.08 130.68 0.00 786.40 18.05 768.35 136.93 631.42 70.01 0.00 701.43 155.46 0.00 26.42 519.55 2399.56 354.36 271.33 375.59 588.61 0.00 3989.45 1244.84 90.05 1334.89 151.79 0.00 1183.10 52.23 1130.87 124.50 1006.37 (229.56) 0.00 776.81 155.46 0.00 26.42 594.93 2503.45 351.82 318.87 326.48 724.14 0.00 4224.76 1380.93 94.21 1475.14 165.25 0.00 1309.89 28.30 1281.59 243.50 1038.09 31.50 11.90 1081.49 160.58 0.00 26.67 894.24 2960.16 434.50 464.20 0.00 1189.63 0.00 5048.49 1086.67 298.72 1385.39 228.86 0.00 1156.53 5.14 1151.39 191.00 960.39 0.00 1699.07 2659.46 224.81 0.00 36.72 2397.93 3000.00 2000.00 1000.00 0.00 March March March March March ' 07 ' 08 ' 09 ' 10 ' 11 Net Sales Operating Profit EBDITA 6000.00 5000.00 4000.00 7000.00 March ' 07 3561.99 March ' 08 4203.29 March ' 09 5234.29 March ' 10 5605.69 March ' 11 6135.16

Operating Income

Profit Levels
1600.00 1400.00 1200.00 1000.00 800.00 600.00 400.00 200.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

15% 3% 0% 4%

78%

Operating Profit EBT

EBDITA Adjusted PAT

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) 117.80 0.00 1586.64 7772.91 94.75 0.00 1664.58 7772.91 81.32 0.00 730.75 7772.91 265.10 0.00 423.87 8029.21 570.28 0.00 478.26 8029.21 155.46 0.00 0.00 3071.84 3227.30 7.25 116.31 123.56 3350.86 155.46 0.00 0.00 3591.39 3746.85 16.98 563.55 580.53 4327.38 155.46 0.00 0.00 4186.32 4341.78 2.79 937.45 940.24 5282.02 160.58 0.00 0.00 5744.54 5905.12 0.41 4.66 5.07 5910.19 160.58 0.00 0.00 6452.37 6612.95 2.95 438.44 441.39 7054.34 7000.00 6000.00 5000.00 4000.00 3000.00 2000.00 2834.68 1053.91 1780.77 0.00 3350.86 3743.98 1396.86 2347.12 0.00 4327.38 4419.57 1568.71 2850.86 0.00 5282.02 5483.42 2524.77 2958.65 0.00 5910.19 4733.57 1000.00 1370.60 3362.97 0.00 7054.34 0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 Total Owners fund Total Loan fund March ' 07 March ' 08 March ' 09 March ' 10 March ' 11

Capital Structure

1799.71 8.97 411.64 1379.10 73.19 117.80

2201.79 8.97 540.43 1652.39 233.12 94.75

2693.29 8.97 700.80 1983.52 366.32 81.32

2895.44 8.97 884.27 2002.20 684.24 265.10

3929.00 0.00 1060.98 2868.02 253.07 570.28

Sources of Capital
Total Loan fund 6%

Application of capital

Total Net Current Assets 48% Total Owners fund 94%

Net Block 41%

Investments 8%

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 ' 07 807.98 334.42 (485.97) 238.56 87.01 44.48 131.49 March ' 08 1324.99 1041.68 (562.23) (471.61) 7.84 53.00 60.84 March ' 09 901.31 373.27 (578.47) 178.92 (26.28) 79.28 53.00 March ' 10 838.36 380.20 (687.25) 254.84 (52.21) 131.49 79.28 March ' 11 1151.39 987.49 (1136.26) 172.06 23.29 (562.23) 60.84 84.13 Net CashFlow‐Operating Activity Net Cash Used In Investing Activity NetCash Used in Fin. Activity (485.97) (471.61) (578.47) (687.25) (1136.26) 238.56 1041.68 334.42

Net Cash Flow
172.06 987.49

178.92 373.27

254.84 380.20

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 1,479.76 0.00 1,479.76 16.75 1,496.51 20.86 522.47 0.00 137.56 0.00 0.00 0.00 448.27 1,129.16 367.35 0.00 54.82 312.53 0.11 312.42 55.00 257.42 0.00 0.00 September ' 10 December ' 10 1,669.20 0.00 1,669.20 20.35 1,689.55 (62.49) 663.98 0.00 130.75 0.00 0.00 0.00 634.85 1,367.09 322.46 0.00 69.65 252.81 1.81 251.00 37.00 214.00 0.00 0.00 1,553.67 0.00 1,553.67 25.69 1,579.36 (66.35) 574.26 0.00 135.09 0.00 0.00 0.00 592.49 1,235.49 343.87 0.00 65.25 278.62 2.93 275.69 43.00 232.69 0.00 0.00 March ' 11 1,615.35 0.00 1,615.35 16.64 1,631.99 39.72 538.41 0.00 137.58 0.00 0.00 0.00 533.08 1,248.79 383.20 0.00 63.91 319.29 0.28 319.01 56.00 263.01 0.00 0.00 June ' 11 1,591.42 0.00 1,591.42 24.85 1,616.27 (21.22) 541.04 0.00 171.23 0.00 0.00 0.00 530.83 1,221.88 394.39 0.00 70.25 324.14 4.25 319.89 66.55 253.34 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 18.79 21.09 38.39 25.90 32.67 0.00 22.30 3.69 (1.32) 3.32 26.42 0.00 0.28 61.74 (0.61) (2.16) (0.27) 100.60 0.00 5.00 0.00 0.00 0.00 6.87 13.13 7.12 6.22 31.96 63.90 0.00 19.05 46.08 38.73 45.56 16.15 0.00 50.45 189.36 47.18 (9.08) 59.38 (427.90) 0.00 10.75 0.00 0.00 0.00 14.51 4.33 (0.72) 17.52 (13.08) 23.03 0.00 5.90 10.93 4.62 10.51 8.87 0.00 10.72 (45.82) 13.33 95.58 3.15 113.72 0.00 39.22 3.29 0.00 0.95 50.31 18.24 23.50 45.58 (100.00) 64.28 0.00 19.50 (21.31) 217.08 (6.08) 38.49 0.00 (11.71) (81.84) (10.16) (21.56) (7.48) (100.00) 14177.90 145.91 40.00 0.00 37.68 168.15 March ' 08 18.00 March ' 09 24.53 March ' 10 7.10 March ' 11 9.45 Average Growth 12.62 0.00 13.10 12.72 28.57 (34.94) 48.67 0.00 15.61 4.34 95.83 10.17 23.93 0.00 8.65 (2.44) 9.31 18.02 9.80 (81.40) 5671.16 72.78 16.99 0.00 15.36 85.94 5 year CAGR 11.49 0.00 10.64 9.73 20.25 (100.00) 34.46 0.00 13.00 5.75 35.34 9.31 17.23 0.00 8.08 (14.36) 8.29 6.42 8.69 (100.00) 0.00 31.83 7.66 0.00 6.81 37.60

Growth Factors
70.00 60.00 50.00 40.00 30.00 20.00 10.00 0.00 (10.00) (20.00) Net Sales EBDITA Adjusted PAT Total Operating Expenses EBT March ' 08 March ' 09 March ' 10 March ' 11 40.00 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.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 50.13 7.67 5.18 6.35 7.60 0.00 76.93 23.07 1.85 24.92 2.90 0.00 22.02 0.31 21.70 3.93 17.77 0.98 0.00 18.75 March ' 08 100.00 50.46 7.87 6.08 6.77 8.54 0.00 79.73 20.27 1.54 21.82 3.11 0.00 18.71 0.43 18.28 3.26 15.02 1.67 0.00 16.69 March ' 09 100.00 45.84 6.77 5.18 7.18 11.25 0.00 76.22 23.78 1.72 25.50 2.90 0.00 22.60 1.00 21.61 2.38 19.23 (4.39) 0.00 14.84 March ' 10 100.00 44.66 6.28 5.69 5.82 12.92 0.00 75.37 24.63 1.68 26.32 2.95 0.00 23.37 0.50 22.86 4.34 18.52 0.56 0.21 19.29 March ' 11 100.00 48.25 7.08 7.57 0.00 19.39 0.00 82.29 17.71 4.87 22.58 3.73 0.00 18.85 0.08 18.77 3.11 15.65 0.00 27.69 43.35 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 4.64 0.00 0.00 91.67 96.31 0.22 3.47 3.69 100.00 March ' 08 3.59 0.00 0.00 82.99 86.58 0.39 13.02 13.42 100.00 March ' 09 2.94 0.00 0.00 79.26 82.20 0.05 17.75 17.80 100.00 March ' 10 2.72 0.00 0.00 97.20 99.91 0.01 0.08 0.09 100.00 March ' 11 2.28 0.00 0.00 91.47 93.74 0.04 6.22 6.26 100.00 6.22

Comparative Analysis‐Source of Fund
91.47

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

2.28 0.00 0.00 53.71 0.27 12.28 41.16 2.18 3.52 50.88 0.21 12.49 38.18 5.39 2.19 50.99 0.17 13.27 37.55 6.94 1.54 48.99 0.15 14.96 33.88 11.58 4.49 55.70 0.00 15.04 40.66 3.59 8.08

0.04

84.60 31.45 53.14 0.00 100.00

86.52 32.28 54.24 0.00 100.00

83.67 29.70 53.97 0.00 100.00

92.78 42.72 50.06 0.00 100.00

67.10 19.43 47.67 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 0.00 100.00 118.79 121.09 138.39 125.90 132.67 0.00 122.30 103.69 98.68 103.32 126.42 0.00 100.28 161.74 99.39 97.84 99.73 200.60 0.00 105.00 134.38 129.72 146.99 166.13 217.45 0.00 145.59 151.47 136.90 150.39 146.84 0.00 150.86 468.01 146.28 88.96 158.95 (657.77) 0.00 116.28 140.20 128.79 172.75 144.41 267.52 0.00 154.18 168.03 143.22 166.19 159.86 0.00 167.03 253.58 165.78 173.99 163.96 90.26 0.00 161.89 165.78 159.05 251.48 0.00 439.48 0.00 184.24 132.23 454.12 156.08 221.40 0.00 147.47 46.06 148.94 136.48 151.69 0.00 0.00 398.10 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 118.00 March ' 09 146.95 March ' 10 157.38 March ' 11 172.24

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 116.91 116.10 234.21 484.52 469.84 129.14 100.00 0.00 0.00 136.28 134.53 38.48 805.99 760.96 157.63 103.29 0.00 0.00 187.01 182.97 5.66 4.01 4.10 176.38 103.29 0.00 0.00 210.05 204.91 40.69 376.96 357.23 210.52 March ' March ' March ' March ' March ' 07 08 09 10 11 100.00 100.00 100.00 100.00 100.00 100.00 122.34 100.00 131.29 119.82 318.51 80.43 149.65 100.00 170.25 143.83 500.51 69.03 160.88 100.00 214.82 145.18 934.88 225.04 218.31 0.00 257.74 207.96 345.77 484.11 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

132.08 132.54 131.80 0.00 129.14

155.91 148.85 160.09 0.00 157.63

193.44 239.56 166.14 0.00 176.38

166.99 130.05 188.85 0.00 210.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 (%) 49.26 6.34 52.36 42.17 0.35 97.55 51.44 6.77 53.65 44.03 0.34 97.55 48.01 7.17 56.55 42.63 0.35 97.55 47.94 5.82 54.54 43.85 0.34 94.44 50.29 0.00 55.70 40.63 0.43 94.44 Current Ratio Quick Ratio March ' March ' March ' March ' March ' 07 08 09 10 11 0.16 79.53 70.12 0.76 50.81 47.10 0.81 25.56 18.78 0.00 52.13 45.05 0.37 269.53 232.37 2.69 2.65 1.76 3.74 2.68 2.62 1.88 3.83 2.82 1.81 1.93 3.79 2.17 2.17 1.57 3.74 3.45 3.45 2.08 3.28 0.03 0.03 96.31 1.98 0.15 0.15 86.58 1.91 0.01 0.21 82.19 1.94 0.00 0.00 99.91 1.94 0.06 0.06 93.74 1.56 100.00 80.00 60.00 40.00 20.00 0.00 March ' March ' March ' March ' March ' 07 08 09 10 11 Net Profit Margin (%) Operating Margin (%) 23.57 71.28 75.31 21.85 71.20 76.14 19.58 81.93 84.30 15.01 81.97 84.44 21.99 72.77 78.01 Adjusted Return On Net Worth (%) Return On long Term Funds (%) 23.07 20.17 18.41 20.30 19.61 20.69 23.45 20.27 17.16 16.43 17.85 16.85 18.72 18.24 23.78 20.88 14.58 21.75 23.17 17.89 26.79 24.63 21.68 18.97 21.11 17.57 18.31 22.16 17.71 13.98 14.92 18.48 14.52 14.52 16.39 8.15 9.48 8.59 9.92 2.00 10.57 41.52 41.63 45.83 39.52 8.12 9.80 9.02 10.71 2.00 10.96 48.20 48.32 54.08 46.20 12.95 14.90 9.99 11.95 2.00 16.02 55.86 55.97 67.34 53.86 12.93 14.99 13.47 15.53 2.00 17.20 73.55 73.66 69.82 71.54 11.96 14.81 11.96 14.81 2.80 200.00 13.53 82.36 82.36 76.41 0.00 150.00 100.00 50.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

27.22

25.92

23.41

17.31

27.23

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(%) 23.69 24.53 17.20 22.69 23.46 16.11 20.47 21.58 14.73 18.09 18.97 12.66 23.22 24.13 15.67 18.43 4.58 3.21 20.79 4.02 2.67 19.35 4.28 2.90 20.12 4.77 3.28 19.82 4.91 3.16 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 6317.98 0.00 6317.98 79.43 6397.41 (68.26) 2299.12 0.00 540.98 0.00 0.00 0.00 2208.69 4980.53 1416.88 253.63 1163.25 5.13 1158.12 191.00 967.12 0.00 0.00 12.05 78.69 % of Sales 100.00 0.00 100.00 1.26 101.26 (1.08) 36.39 0.00 8.56 0.00 0.00 0.00 34.96 78.83 22.43 4.01 18.41 0.08 18.33 3.02 15.31 0.00 0.00 June ' 11 6429.64 0.00 6429.64 87.53 6517.17 (110.34) 2317.69 0.00 574.65 0.00 0.00 0.00 2291.25 5073.25 1443.92 269.06 1174.86 9.27 1165.59 202.55 963.04 0.00 0.00 11.99 80.08 % of Sales 100.00 0.00 100.00 1.36 101.36 (1.72) 36.05 0.00 8.94 0.00 0.00 0.00 35.64 78.90 22.46 4.18 18.27 0.14 18.13 3.15 14.98 0.00 0.00 Growth(%) 1.77 NA 1.77 10.20 1.87 61.65 0.81 NA 6.22 NA NA NA 3.74 1.86 1.91 6.08 1.00 80.70 0.65 6.05 (0.42) NA NA ‐0.01 0.02

OPM(%)

GPM(%)

NPM(%)

TTM Growth (%)
1.77 1.86 1.91

1.00 0.65

(0.42)

TTM EPS & SPS(%)

March ' 11

June ' 11

Page 11

Technical Analysis

Price Chart
400.00 350.00 300.00 250.00 200.00 150.00 100.00 50.00 0.00 22‐Apr Volume Close 3‐Jul EMA(200) EMA(50) 1500000.00 1000000.00 500000.00 0.00 3500000.00 3000000.00 2500000.00 2000000.00

10.00 5.00 0.00 ‐5.00 ‐10.00 ‐15.00

MACD

Signal line

100 80 60 40 20 0 RSI(14)

Technical Indicators Price EMA(13) EMA(26) EMA(50) EMA(200) RSI(14) MACD William(%R) 289.30 288.94 299.03 307.52 314.93 50.90 ‐10.09 ‐17.82 AS On: ADX DX +DI ‐DI %K(Fast) %K(Slow) %d(Slow) 12/09/2011 24 0 18 18 82.18 84.75 72.42

Page 12

Similar Documents

Premium Essay

Long Term Short Term Financing

...Long-Term Short-Term Financing Gwen Florence University of Phoenix June 19, 2012 Long-Term Short-Term Financing Both new and established businesses will find it necessary to incur debts during the course of business operations. Financing may be sought for a multitude of reasons – like smoothing cash flow, purchasing equipment, or expanding operations. The choice between short- and long-term financing options should be determined based on each business’ individual needs. To make that determination, businesses also need to understand when each type of financing is appropriate. For financing needs over a period of a year or less, sort term financing can be used to inject capital into businesses (Ross, Thompson, Christensen, Westerfield, Jordan, 2001). Short term financing options include short-term loans, letters of credit, promissory notes, over drafting, and inventory loans. These options are often used by businesses to cover day-to-day costs like supplies, inventory orders, and wages. Due to the nature of their shifting demands, seasonal businesses in particular often use short term finance arrangements. An example of short-term financing is a company signing a short-term loan in order to purchase more inventories. Proceeds from sales of goods would be used to repay the loan. This is appropriate only if the capital required by the firm can be paid off within the loan’s timeframe. For financing needs over a longer...

Words: 353 - Pages: 2

Premium Essay

Term Paper

...develop ethical and environmental guidelines for the sourcing of its coffee beans. Starbucks is committed to enhancing and providing an excellent work environment for its employees and partners are treated with respect and dignity. Starbucks, founded in 1985, by Howard Shultz has achieved an impressive rate of growth in earning per share of 20% per year for the past decade. The company has witnessed steady revenue growth in this time period, in spite of overall economic downturns. In addition, an impressive growth rate in store openings and success in maintaining the profitability of current operations. Starbucks has demonstrated its ability to grow steadily and responsibly. Although short term margins have tightened as a result of this aggressive expansion, its long term growth projections show promising growth in retail locations, steady sales growth at existing locations, and a continuously expanding product line that differentiate it from the competition and keep its customers coming back. Starbucks’ ability to combat the risks and external threats that it faces from world economic factors, competitive forces come from its solid brand image, and its dedication to continual product innovation and the quality services that it offers its customers prove it to be a worthy investment. The financial analysis of the company also provides us with more than ample reason to purchase Starbucks stock. Through our analysis using the SWOT Model, we’ve found that Starbucks...

Words: 328 - Pages: 2

Premium Essay

Planning Shor Term and Long Term

...technological era, there are softwares that can help people carry out their budget planning. Firstly, it is important to make mental and physical note on your current expenses and then think critically on every penny that is spent. Next, one has to create the budget for the current month observing the expenses done in the previous step. Lastly, proper plans on how to spend need to be made with the help of online planning budget and it can help in the business as well as for the family expenses. There are two budgeting terms. One is long term budgeting other one is short term budgeting. Long term budgeting is looking at the future in order to know what the market needs.Short-term budgeting involves making budgets that is short-term, such as inventory purchases, over-time costs, marketing and one-off expenses such as cash purchases of equipment or buildings. Long term planning are usually used by companies and short term planning are usually used by individuals. Long term budgeting is making decision for more than one year. The company first look at the environment, internal and external factors and then how much profit the company...

Words: 761 - Pages: 4

Premium Essay

Long Term and Short Term Financing

...Long-Term and Short-Term Financing FIN/200 November 19, 2010 David Stretton Long-Term and Short-Term Financing All business owners make profit but they also acquire debt in the process of making money. In order to make money as a business owner you have to spend money to be successful. So, in order for a business to stay afloat the business owners may decide to purchase big ticket items that they really do not have the on hand revenue for. In order for a business owner to purchase these items or even expand the business they must decide what type of financing they need to do so. Depending on the businesses needs they could either choose to go with long-term financing or short-term financing. If a business owner wants to finance something for a shorter period of time like one year or less, then it is best for them to go with short-term financing. Short-term financing really depends on what the business owner needs the loan for. The options for short-term financing could include a line of credit, a note, pledging receivables, or even factoring (Block, Hirt, Danielsen, 2009). One example of a business owner using short-term financing would be to purchase inventory for the next year. Long-term financing is done when a business owner needs a bigger amount of money and they want to pay it back in a longer period than just one year. The long-term financing options could be a term loan, preferred stock equity, or even a secured or unsecured loan (Block, Hirt, Danielsen...

Words: 319 - Pages: 2

Premium Essay

Term Paper

...I am determined to beat the odds.  I will not become another negative statistic.  I desire to become a positively contributing citizen that aides in making my surroundings a better place.  To accomplish this, there are personal goals that I have established for myself. There are several goals that I am currently working towards.  However, my short term goals have always remained simple. I am working to maintain an overall A average in the classes that I am enrolled in.  This leads to me successfully completing high school.  After  graduating from high school, I will begin studying at a college that best fits my educational needs.  My long term goals deal with my future in general. After the completion of high school, I plan to attend an accredited university where I will obtain degree in Biochemistry with a pre-dental concentration. I will become a well rounded student just as I am in high school. I also plan to run for freshman class president, not only that I also look forward to joining many prestigious organizations around the campus. I aim to complete an internship that will give me additional skills and tools that will allow me to excel in my graduate studies.  I plan to finish undergraduate studies with a grade point average of 3.5 or higher.  This will assist in me getting accepted into a school of dentistry. Being that getting accepted into dental school is so competitive, I plan to work extremely hard to prepare myself to take the Dental Acceptance Test my junior year...

Words: 513 - Pages: 3

Premium Essay

Short Term and Long Term Goals

...Deciding when Short-term or Long-term Goals Drive a Decision Rickey Paradise GEN480 MAY 09, 2013 Professor Annie Debeljak University of Phoenix Deciding when Short-term or Long-term Goals Drive a Decision To determine the difference in short-term and long-term decisions one must understand that most decisions have both. As a planner and estimator making difficult decisions is a daily occurrence. The decisions made today effect the long-term decisions because the goal may change, such as making a schedule to complete a task. The long term estimated delivery of the product may be six months away. However, the short-term goals and decisions to achieve the goal effect the scheduled date because bottlenecks occur, such as retrieving the parts to complete the task on time. Personal goals have the same consequences. Planning his or her education is a one way to understand this concept. If an individual makes a decision to obtain his or her degree in two years the long-term goal is set. However, during the course of the year a tragedy occurs and the individual has to change the long-term goal because the short-term goals are affected. Critical thinking while setting the goal may have solved the problem. Allowing for inconvenient occurrences while setting the long-term goal helps to maintain the set schedule. Setting goals require making small steps to obtain the long-range goal. Monitoring the short-term goals is one way to achieve the long-term goal. According to Rosen L...

Words: 400 - Pages: 2

Free Essay

Term Paper

... They want to asses if the spread of technology would become a distraction or a help to a student. The investigators were appealed to the topic because gadgets are now able to provide easier access to information and educational advantages. Gadgets get the attention of the students because of its engrossing and fascinating presentations of information. This also helps the parents who are unaware of the effects of gadgets to their child’s study. Overuse of gadgets may result to interference with the student determination and ability to learn. Technology can be used for many things some positive and some negative. The effects that are now being documented on children whom are left unattended for hours on end are nothing but negative. Long term damage is more prevalent in the recent studies than ever before. Researchers are finding that many parents are using the internet and other form of technology to “raise” their children. Thus...

Words: 2595 - Pages: 11

Premium Essay

Term

...23rd Psalm             The Lord is my Shepherd;             I shall not want.             In verdant pastures He gives             me repose;             Before restful waters He leads             me; He refreshes my soul.             He guides me in right paths for             His name's sake.             Even though I walk in the dark             valley I fear no evil;                 for you are at my side, with your             rod and your staff that give me             courage.             You spread a table for me in the             sight of my foes; you anoint my             head with oil; my cup overflows.             Only goodness and kindness             follow me all the days of my life;             And I shall dwell in the house of             the Lord for years to come. Family Prayer             God made us a family.             We need one another.             We love one another.             We forgive one another.             We work together.             We play together.             We worship together.             Together we use God's word.             Together we grow in Christ.             Together we love all people.             Together we serve our God.             Together we hope for heaven.             These are our hopes and ideals.             Help us to attain them,             O God, through Jesus Christ our Lord.   Motherhood             O glorious Saint Gerard,             powerful intercessor before ...

Words: 1510 - Pages: 7

Premium Essay

Setting the Short-Term and Long-Term Goals for Newlyweds

...Setting the Short-term and Long-term Goals for Newlyweds It is important for the newlyweds to have a financial plans set up as it helps them have a focus in life and have a reason for saving money. The short-term goals would involve things that would not require a lot of money and thus would be achieved in a short time. The long-term goals on the other hand would entail things that require a lot of money to accomplish and thereby take more time to complete (McKeown, 2012). Short-term Goals The first short term goal that I would advise the couple to set is improving the outlook of their house. This would include buying equipment that they do not have but they need them. These items include things such as furniture and electrical appliances. They would do a research on the prices of the gadgets in the market and thereby be able to note the specific target in terms of money. They would then set the amount that they should save monthly towards the furniture and electrical appliances (Hallman & Rosenbloom, 2003). The couple should also target at clearing all their financial debts. They should set aside a specific sum of money monthly to pay these debts. After clearing their debts they should then save up money, which they can use, in case they face a financial problem. This would help them avoid getting into debts in the future (Hallman & Rosenbloom, 2003). They should also save for their annual vacation. This should be done throughout the years since each year they...

Words: 634 - Pages: 3

Premium Essay

Short Term Decisions

...5 Short-term Decision Making 5.1 Introduction and objectives Previous chapters have focused on the nature of costs and how they behave in relation to changes in activity and over time. The nature of costs is an important factor to consider in decision making. Types of decisions are usually split into short and long-term. Chapter 14 (Capital Investment Appraisal) considers the longer-term decision-making process, whilst this chapter focuses on the short-term. After studying this chapter you will be able to: „„ Understand costs that are relevant to the decision-making process in different circumstances „„ Demonstrate working knowledge of typical short-term decisions managers have to make and how financial data can support these decisions „„ Recognise the issues of managing scarce recourses in decision making; and „„ Appreciate the implications of outsourcing in a business context. 5.2 Relevant costs in decision making Relevant costing is a management accounting term and relates to focusing on only the costs relevant to a specific decision being made. It simplifies the decision-making process as it ignores cost data that is ‘irrelevant’, or will not have an impact on the specific decision being made. When making a particular decision-relevant costs are those that may change, depending on the decision taken. Relevant costing is often used in short-term decision making and a number of specific practical examples are illustrated later in this chapter. A typical decision...

Words: 1147 - Pages: 5

Premium Essay

Short Term Financing

...CHAPTER: SHORT TERM FINANCING Topics to be Covered: 1. Meaning and nature of short-term financing. 2. Sources of Short Term Financing. 3. Advantages of Short-Term Financing. 4. Disadvantages of Short Term financing. 5. Purpose of Short-Term Financing. 6. “Ideal Concept” of Short-Term Financing. 7. What is Trade Credit? 8. Reasons for the use of Trade Credit. 9. Factors determining the amount of Trade Credit used 10. Cost of Trade Credit 11. Who bears the cost of Trade Credit? 12. What is Bank Credit? 13. Distinction between Bank Credit and Short Term credit. 14. Characteristics of Short Term financing Meaning and nature of short-term financing: Short Term financing is that from of financing which embraces borrowing or lending of funds for a short period of time. It refers to the finance obtained on short term basis, usually one year or less in duration. Short term finance is secured for financing the current assets, for example, inventories. Short term finance is also known as working capital which is the excess of current assets over current liabilities. Current liabilities become due within one year and indicate the amount of short-term credit being utilized by the business. Practically all enterprises use the short-term credit as sources of finance. We find in the balance sheets of almost all the companies some kinds of current liabilities which are the indicator of...

Words: 2541 - Pages: 11

Premium Essay

Capitalism for the Long Term

...84 Harvard Business Review March 2011 HBR.ORG Dominic Barton is the global managing director of McKinsey & Company. Long Term Business leaders face a choice: They can reform the system, or watch as the government exerts control. A call to action from McKinsey & Company’s global managing director by Dominic Barton Capitalism for the T ILLUSTRATION: JAMES JOYCE he near meltdown of the nancial system and the ensuing Great Recession have been, and will remain, the de ning issue for the current generation of executives. Now that the worst seems to be behind us, it’s tempting to feel deep relief—and a strong desire to return to the comfort of business as usual. But that is simply not an option. In the past three years we’ve already seen a dramatic acceleration in the shifting balance of power between the developed West and the emerging East, a rise in populist politics and social stresses in a number of countries, and significant strains on global governance systems. As the fallout from the crisis continues, we’re likely to see increased geopolitical rivalries, new international security challenges, and rising tensions from trade, migration, and resource competition. For business leaders, however, the most consequential outcome of the crisis is the challenge to capitalism itself. That challenge did not just arise in the wake of the Great Recession. Recall that trust in business hit historically low levels more than a decade ago. But the crisis and the surge in...

Words: 4956 - Pages: 20

Premium Essay

Long Term Goals

...According to the dictionary a Goal is a person's ambition or effort to achieve something. Everyone has a goal to accomplish whether it's a long term goal or short term goal. Long term goals take 12 months or more to achieve and short term goals take 12 months or less. Long term goals are harder to achieve than short term. My goals are definitely long term rather than short term goals. My goals are to get accepted into Virginia Tech, to play on Tech’s lacrosse team, and have a house next to a ski resort. First, I want to get accepted to go to Virginia Tech. I want to go there because it is my favorite school and my aunt went there. To get accepted I have to work harder and longer on my grades. I got to get every homework, project, and essay in on time. Its most popular majors are engineering, business, and management. I want to major in engineering because I want to learn how to build and fix things. If I have a problem with something I would be able to fix it. Getting accepted to Virginia Tech would help me later in life with problems....

Words: 489 - Pages: 2

Premium Essay

Short-Term Objectives

...Executive Summary The corporate level strategy of Dish Network is to horizontally integrate. It acquired Blockbuster and tries to maintain this studio right. Also, it purchased additional wireless licensures to implement this strategy. The business level option of Dish Network is to integrate Dish products into Blockbuster stores. In the long run, Dish Network should try to work on retaining the current customers and gain more customers as well. At the same time, it will build a good reputation to be competitive in today's television market. The ultimately purpose of any commercial organization is to maximize profit, but this should build upon being achieved these short-term objectives. Short-Term Objectives In the coming six months, Dish Network will develop the following short-term objectives: 1. Try to increase the market shares. According to the Dish Network annual report, the corporate has 13.967 million subscribers until December 31, 2011, which represent approximately 14% of pay-TV subscribers in the United States. In the first season this year, Dish has increased its customer group by 22,000. Therefore, Dish Network can keep trying to retain the existing customers and increase the potential customers to gain more market shares. With the current customer’s base, the corporate can set having 13.997 million subscribers as a goal, which means increase approximately 0.21% of the market shares in the second quarter. 2. Promote the Hopper DVR. Dish Network launched this...

Words: 782 - Pages: 4

Premium Essay

Medical Term Project

...Jacob Snyder 11/17/2014 Medical Terminology Course Project A.) Term # | Page of article/paragraph | Medical Term | Breakdown | Translation | 1. | 19/1 | Cardiovascular | Cardi/o- HeartVascular-Vessels | Relating to the vessels in the heart | 2. | 20/2 | Hematocrit | Hemat/o-BloodCrit-Judge | Instrument used to judge or gauge blood | 3. | 20/2 | Hemoglobin | Hem/o-BloodGlobin-protein | Proteins in the blood | 4. | 20/5 | Rectal | Rect-RectumAl-Pertaining to | Pertaining to the rectum | 5. | 20/5 | Respiratory | Respir/a-RespirationTory-Relating to | Relating to respiration | 6. | 20-6 | Spirometry | Spir/o- To breatheMetry- act of measuring | To measure breathe | 7. | 21-2 | Stethoscope | Steth/o-chestScope-View | Device for viewing sounds inside the chest | 8. | 21-2 | Brachial | Brach/i- ArmAl-Relating to | Relating to the arm | 9. | 26-4 | Thermoregulatory | Therm/o-HeatRegulatory-Regulation | Regulation of the body’s heat | 10 | 26-5 | Cardiopulmonary | Cardi/o-HeartPulm/o-LungsNary-Pertaining to | Pertaining to the heart and lungs | 11. | 26-6 | Metabolic | Meta-to changeBolic- to throw | To exchange and throw broken down chemicals throughout the body | 12. | 27-3 | Symptomatic | Symptom/a-symptomTic-Pertaining to | Pertaining to symptoms | 13. | 28-3 | Themal | Therm-HeatAl-Related to | Related to heat | 14. | 18-1 | Urinary | Urin-UrineAry-Pertaining to | Pertaining to urine | 15. | 18-1 | Hydration | Hyrdat-waterIon-Pertaining to | Pertaining...

Words: 665 - Pages: 3