Abbot Calculations

MASTER SHEET

ABBOTT PHARMACEUTICALS BALANCE SHEET ASSETS

2003

2004

2005

2006

2007

697047 43658 97057 757948 25215 76569 2094 42679

1083182 44933 88050 917621 17444 62968 491 14219

1160775 49983 147297 1217900 19429 67156 8111 106139

1608841 52498 208742 1256141 21812 63078 11739 45384

CURRENT ASSETS Cash & Bank Balance Stores & Spares Net Receivables Stock-in-Trade Loans & Advances Trade Deposits Interets Accrued Other Receivables Other Financial Assets Taxation Recoverable Total Current Assets Long Term Prepayments Fixed Assets Long Term Loans & Advances Long Term Deposits Total Assets

131233 2908023

295934 3564169

496118 47875 128817 1363508 33369 101988 5576 197280 600000 154598 3129129

600 NIL NIL 943246 972968 1187749 31304 27937 28336 3205 3332 4947 2958071 3368623 4129055

5533 1437023 25306 3394 5035425

5133 1516821 25892 4393 4681368

NIL

NIL 237449 1979716

NIL 135478 2364386

NIL

LIABILITIES & EQUITY CURRENT LIABILITIES Creditors, Accrued & Other Liabilities Proposed Dividend Total Current Liabilities

604781 554876 696130 749439 661681 141638 NIL NIL NIL NIL 746419 554876 696130 749439 881681

Long Term Liabilities Deferred Taxation Total Liabilities

27531 Err:522

24145 579021

21081 717211

44100 793539

110414 992095

OWNER'S EQUITY Paid-In-Capital i) Ordinary ii) Preferred iii) Total Paid-in-Capital Retained Earnings Total Owner's Equity

472127 NIL NIL 472127 1711994 2184121

566552 2223050 2789602

679862 2731982 3411844

979003 3262883 4241886

979003 2710270 3689273

TOTAL LIABILITIES & EQUITY

2958071

3368623

4129055

5035425

4681368

35.4300%

20.7564%

21.0212%

18.7072%

26.8913%

toatl debt/equiy

566552

679862 NIL

979003 NIL

979003 NIL

ltd- equity ta- ca tangible assets debt cvrg

26.16%

17.19%

17.37%

15.76%

21.19%

0.93%

0.87%

0.62%

1.04%

2.99%

978355 35.54

1004237 41.59

1221032 57.92

1471256 33.36

1552239 14.06

Total Owner's Equity 0

0

0

0

0

2003 2004 2005 2006 2007 sales 4277322 4598074 5176264 5887748 6546371 assets 2958071 3368623 4129055 5035425 4681368 assets turnover

1.4460

1.3650

1.2536

1.1693

1.3984

current assets current liabilities current ratio wc acid test ratio cash+sec+rec/cl

1979716 746419 2.6523 1233297

2364386 554876 4.2611 1809510

2908023 696130 4.1774 2211893

3564169 749439 4.7558 2814730

3129129 881681 3.5490 2247448

697047 97057 794104 891161 0.8911

1083182 88050 1171232 554876 2.1108

1160775 147297 1308072 696130 1.8791

1608841 208742 1817583 749439 2.4253

496118 128817 624935 881681 0.7088

c+r cl

receivables 97057 88050 147297 208742 128817 sales 4277322 4598074 5176264 5887748 6546371 2.27% 1.91% 2.85% 3.55% 1.97%

ebit Total Assets earning power

902744 2958071 30.52%

1173522 3368623 34.84%

1369081 4129055 33.16%

1443630 5035425 28.67%

1772230 4681368 37.86%

1- Sales 2- CGS 3- Gross Profit on Sales 4- Operating Expenses 5- Operating Income 6- Other Revenues & Expenses Net 7- Net Income before Tax 8- Net Income after Tax 9- Total Assets 10- Owner's Investment 11- Paid-up Capital Long Term Debt Total Investment EBIT Finance Cost Depreciation ebit+dep Cash flow RATIOS 1- Net Profit Margin(%) 2- Earning Power (%) 3- Rate of Profit on Owner's Equity(%) 4- Rate of Profit on Paid-up Capital(%) 5- Rate of Profit on Total Investment

PROFITABILITY 2003 2004 4277322 4598074 2632614 2673535 2296119 1958390 800903 836842 881064 1148548 -63244 -68725 817820 1079823 526203 747119 2958071 3368623 2184121 2789602 472127 566552

2005 5176264 2930965 2296119 840515 1455604 -89425 1366179 962172 4129055 3411844 679862

2006 5887748 3435553 2478628 1013700 1464928 -6465 1439970 1000008 5035425 4241886 979003

2007 6546371 3850568 2733886 955191 1778695 -21298 1769028 1209593 4681368 3689273 979003

3205 834109

3332 4947 3394 4393 1082965 1369081 1443630 1772230 16289 3142 2902 3660 3202 120566 148325 148787 159718 185830 954675 1231290 1517868 1603348 1958060 59 392 523 438 612 2003 2004 2005 2006 2007 12.30% 16.25% 18.59% 16.98% 18.48% 28.20% 32.15% 33.16% 28.67% 37.86% 24.09% 26.78% 28.20% 23.57% 32.79% 111.45% 131.87% 141.52% 102.15% 123.55% 16418% 22423% 19450% 29464% 27535%

150.00% 125.00% 100.00% 75.00%

4- Rate of Profit on Paid-up Cap-

50.00% 25.00% 0.00% Colu mn B

Colu mn C

Colu mn D

Colu mn E

Colu mn F

40.00% 30.00% 20.00% 10.00% 0.00% Column B Column C Column D Years

Column E

Column F

30.00% 20.00% 10.00% 0.00% Column B Column C Column D Years 1- Net Profit Margin(%)

30000% 27500% 25000% 22500% 20000% 17500% 15000% 12500% 10000% 7500% 5000% 2500% 0% Column B

2- Earning Power (%)

Column E

Column F

3- Rate of Profit on Owner's

5- Rate of Profit on Total Investment

Column C

Column D

Column E

Column F

Rate of fit on d-up Cap-

mn E

Column F

mn E

Column F

Rate of ofit on wner's

5- Rate of Profit on Total nvestment

2003 ABSOLUTE AMOUNTS 1- Number of shares i) Ordinary ii) Preferred 2- Total Book Value of Ordinary Shares 3- Net Profit after Taxes 4- Dividend paid i) Ordinary ii) Preferred AVERAGE RATIOS Ordinary Shares 1- Par Value (Rs.) 2- Book Value (Rs.) 3- Market Price (Rs.)

4- Earning per Share (Rs.) 5- Dividend per Share (Rs.) 6- Payout Ratio 7- Dividend Yield(%) 8- Capitalization Rate (%)

total common equity book value of common equity

SHARE PRICES 2004

2005

2006

472127230 566552680 679863210 979003020 472127230 566552680 679863210 979003020 Nil Nil Nil Nil $1.000000 $0.999999 $0.999998 $1.000000 526203 747119 962172 1000008 236,000,000 Nil

312,000,000 340,000,000 294,000,000 Nil Nil Nil

10 Rs.9.9999 94

10 Rs.9.9999 162

10 Rs.9.9999 182

10 Rs.10.0000 144

0.0011 0.50 448.4961 0.53%

0.0013 0.55 417.6042 0.34%

0.0014 0.50 353.3672 0.27%

0.0010 0.30 293.9976 0.21%

472127000 $1.000000

566552000 $0.999999

679862000 $0.999998

979003000 $1.000000

2007 979003020 979003020 Nil $1.000000 1209593 1,762,206,000 Nil

10 Rs.10.0000 150

0.0012 1.80 1456.8586 1.20%

979003000 $1.000000

Sales 4277322 4598074 5176264 5887748 6546371 Net Income after 526203 Tax 747119 962172 1000008 1209593

Rs.

10000000

Net Income & Sales trend

5000000 0 Column Column Column Column Column B C D E F Years Sales

Total Liabilities Err:522 Total Owner's Equity

579021 579021

717211 717211

793539 793539

992095 992095

Net Income after Tax

mn Column F

total liab iii) Total Paid-in-Capital debt to equity TOTAL capital debt to capital

773950 579021 717211 793539 47212000 556552000 679862000 979003000

992095 979003000

1.6393%

0.1040%

0.1055%

0.0811%

0.1013%

2958071 26.1640%

3368623 17.1887%

4129055 17.3699%

5035425 15.7591%

4681368 21.1924%

Total Owner's Equity

Plant & Equipment

912435