Particulars

Sales
Less: Excise Duty
Net Sales
Add: Operating Income
Total Operating Income
Less: Cost of Goods Sold (COGS)
Gross Profit
Less: Selling and Admin Expenses (SAE)
EBIDTA
Less: Depreciation and Amortization
Less: Impairment of Goodwill
Less: Impairment of Intangible Assets
EBIT
Less: Interest
Add: Non Operating Income
Less: Non Operating Expense
PBT
Less: Provision for Tax
Current Tax
Deffered Tax

Notes

2009
Amount(in millions)
68326
422
67904
1363.2
69267.2
20151.9
49115.3
5779
43336.3
4977
13766
862
23731.3
972
185.7
1864.3
21080.7
2608

PAT
Balnce of profit and loss carried forward
Less: proposed dividend
Transferred to Reserves and Surplus

18472.7
12001
1053
29420.7

Particulars
Sales
Less: Excise Duty
Net Sales
Add: Operating Income
Total Operating Income
Less: Cost of Goods Sold (COGS)
Gross Profit
Less: Selling and Admin Expenses (SAE)
EBIDTA
Less: Depreciation and Amortization
Less: Impairment of Goodwill
Less: Impairment of Intangible Assets
EBIT
Less: Interest
Add: Non Operating Income
Less: Non Operating Expense
PBT
NoPat
Nopat Margin
Tax rates

COMMONSIZE STATEMENT
2009
98.64%
0.61%
98.03%
1.97%
100.00%
29.09%
70.91%
8.34%
62.56%
7.19%
19.87%
1.24%
34.26%
1.40%
0.27%
2.69%
30.43%
14300.48138
20.65%
39.74%

Du Pont Analysis
NOPAT/Sales
Sales/Capital Employed
ROC

2009
0.21
1.33
0.28

2010
0.05
1.36
0.06

Operating PAT
Operating PAT/Sales
Sales/Capital Employed
Capital Employed/Equity
ROE
Drivers
Sales/Net Fixed Assets
Sales/Intangible Assets
Sales/Operating Working Capital
Sales/Total Working Capital
Sales/Recievables
Collection Period
Sales/Inventories
Inventory Holding Period

13714.75
0.20

3140.07
0.04
1.36
1.45
0.09

5.42
155.09
5.44
3.23
7.93
45.42
8.04
44.80

2010
Amount(in millions)
68,833
316
68517
2002
70519
44530
25989
11488
14501
4131
887
3,696
5787
312
805
24
6256
2668
3252
-560
-24
3588
1036
1,900
2724

2011
Amount(in millions)
72,724
356
72368
2119
74487
46518
27969
12705
15264
3981

11283
234
1005
0
12054
1839
2106
-267

2012
Amount (in millions)
94734
405
94329
3816
98145
57539
40606
16170
24436
5180
46
1307
17903
1056
1321
40
18128
5461
5248
213

10215
1162
1,904
9473

12667
8073
2331
18409

2010
97.61%
0.45%
97.16%
2.84%
100.00%
63.15%
36.85%
16.29%
20.56%
5.86%
1.26%
5.24%
8.21%
0.44%
1.14%
0.03%
8.87%
3319.015
4.71%
42.65%

2011
97.63%
0.48%
97.16%
2.84%
100.00%
62.45%
37.55%
17.06%
20.49%
5.34%
0.00%
0.00%
15.15%
0.31%
1.35%
0.00%
16.18%
9561.626
12.84%
15.26%

2012
96.52%
0.41%
96.11%
3.89%
100.00%
58.63%
41.37%
16.48%
24.90%
5.28%
0.05%
1.33%
18.24%
1.08%
1.35%
0.04%
18.47%
12509.781
12.75%
30.12%

2011
0.13
1.55
0.20

2012
0.13
1.62
0.21

2013
0.12
2.25
0.26

SIZE STATEMENT

9363.33
0.13
1.55
1.64
0.32

11771.90
0.12
1.62
1.46
0.28

13191.87
0.11
2.25
1.27
0.32

4.29
25.94
9.28
4.00
6.42
56.06
5.56
64.73

4.22
21.67
8.10
3.91
5.95
60.55
6.14
58.66

4.58
40.33
11.81
4.66
4.65
77.50
6.06
59.37

2013
Amount(in millions)
114933
718
114215
3629
117844
73734
44110
17912
26198
5502
505
37
20154
1003
2611
34
21728
6761
6570
191
14967
16577
2548
28996

2013
97.53%
0.61%
96.92%
3.08%
100.00%
62.57%
37.43%
15.20%
22.23%
4.67%
0.43%
0.03%
17.10%
0.85%
2.22%
0.03%
18.44%
13882.774
11.78%
31.12%

Notes on Cost of good sold

Raw material consumed
Purchase of stock in trade
changes in inventory of finished goods
Conversion charges
Excise duty
Employee benefit
Research and development expenses
chemicals consumed
power and Fuel
Repairs and maintanence expenses
Insurance
Rent
Rates and taxes
Total

-289
104.4
904.2
34.7
952
470.5
1183.2
243.9
84.1
10.2
37.7
20151.9

2010
14557
5813
247
811
424
11832
3731
2680
1415
1996
262
519
243
44530

2011
11,895
7,098
-1,573
962
617
12,786
5,077
4713
1833
2126
265
419
300
46,518

2012
19493
7182
-1526
2278
534
15912
5952
1837
2259
2303
376
523
416
57539

2009

2010

2011

2012

2457.4
339

2989
5613

2796.4

0
8602

8,355

4091
2566
146
3197
10000

2504.6
581.2
3085.8
-289.4

3901
4454
8355
247

4,091
5,837
9,928
-1,573

4986
2196
7182
2818

Notes on Employee Benefit expenses

Salaries and wages
Contribution to PF
Staff welfare expenses
Stock compensation expenses
TOTAL

2009
8195
706
815
204
9920

2010
9477
614
1543
198
11832

2011
10,827
654
1,037
268
12,786

2012
13679
672
1158
403
15912

Notes on operating income

service income
export interest
sale of spent chemicals
royalty income
dividend from subsidary company
Misc income
Total income

2007
1060
46.9
211

2010
1658

2011
1741

209

254

0.9
44.4
1363.2

135
2002

124
2119

2012
2336
111
382
57
421
509
3816

2009

2010

2011

2012

Notes on changes in inventory of finished goods

Opening
Work in progress
finished goods
Stock acquired from acquisition
Stock in trade
total
less closing
Work in progress
finished goods
total

Notes on non operating income

Income from settlement of litigation

2009
16416

3,901
4,454

Interest income from fixed deposits

other interest income
Profit on sale of fixed assets
Profit on sales of current investment
Dividend
Misc incomes
Forex gain
Total income

0
185.7

47
436
73
805

Notes on selling adminstrative expenses

Advertisements
Commision on sales
Carriage outward
selling expenses
legal and professional fees
Travel and conveyance expenses
analytical charges
printing and stationary
Donation
Provison for Doubtful debts
Provision for advances
Director sitting fees
Non executive director remuneration
Auditors remuneration

2009
675
349
1699
32.1
270.4
51.9
102.2
47.4
2.1
28
23
0.6
189
6.6

2010
477
401
1703
4329
1688
760
273
117
152
77
-17
0
0
16

2011
851
338
2025
4,235
2,345
963
330
136
132
75
-4

rebate & Discounts

Sundry expensea
settlement of legal claim from innovator
Bad debts written off
Postage, telegram & telephone

63.3
1277
916
46.4
30.4

1164
91

1010
80
84

Commision on sales
total

275.9
5779

11488

48
12705

Notes on Depreciation
Land -freelease hold
Building
Owned
Assets undertaken on lease
Plant and machinery
Owned
Assets undertaken on lease
Electrical Equipment
Laboratory
Owned
Assets undertaken on lease

2009

2010
2

2011
2

2012

194
8

229
9

269
9

375
10

1219

1456
0
180

1626
6
208

2570

325
0

362

76

174.7
10.1
0.9

137
317

197
52

86
19
251
10
58
581
1005

46
11

353
24
31
158
44
711
1321
2012
1288
433
3036
5087
2394
1098
557
154
177
168
467
1
54
15
1241

16170

18

Furniture and Fixtures

Owned
Assest undertaken on lease
Vehicles
Owned
Assets undertaken on lease
Total

297

353
0

351

419

82
10
2264

90
9
2653

106
2939

112
15
3595

Notes on Ammortisation
Customer related assets
Goodwill
Patents, trademarks
Technology related intangibles
Product related inatngibles
No-competition arrangements
Total

2009
73
1404
1207
29

2010
253
700
508
17

2011
15
531
475
21

2012
59
767
649
110

2713

1478

1042

1585

Notes on Interest
Interest expenses
Other borrowing cost
market to market(gain)/ loss on interest swap
interest on packing loans
interest on long term loans
shorterm loans
interest on debenture
total
Notes on non operating expenses
loss on sale on fixed assets
foreign exchange loss

2009

2010

2011

2012
1029
27

82

22

149
741

41
249

972
2009
0.3
1864.3
1864.6

312
2010

38
99
87
10
234
2011

1056
2012
40

2013
28166
8057
-1685
1880
630
19287
7915
1648
3354
2970
450
603
459
73734
2013
4986
2196
4344
11526
5638
5992
11630
-104
2013
16544
955
1367
421
19287
2013
2070
140
588
54
533
244
3629
2013
1112

877
23
212
53
334
2611
2013
1406
290
3630
5797
3005
1402
394
178
176
108
67
2
60
15
1382

17912

2013

431
13
2074
3
309
470

394

92
25
3811
2013
13
796
880
2

1691
2013
1000
44
-41

1003
2013
34

Consolidated balance sheet of Dr Reddy as on 31st march 2013

Particulars
LIABILITIES
1. Shareholders fund
Equity Sharecapital
Reserve and Surplus

(In millions)
Amount(2009)

(In millions)
Amount(2010)

bi
842
34420

37,769
844
36,925

2.Deferred tax liabilty( net)

914

3.Debts
Secured loans
Unsecured loans
Deferred payment liabilities

19975
385
19590

14571

4.Minority interest

0
20889

0
53358

454.7
8233
13007.5
4296
6
17189.2
4656
47842.4

2872
3267
17383
7622
6
13215
5419
49784

2009
35,262
6
4237.656
914
31,932
19975

2010
37,769
6
5189.62
750
33,323
14839

Total

51,907

48,162

Assets
Intangible assets
Goodwill
Net fixed assets

2009
454.7
8233
13007.5

2010
2872
3267
17383

TOTAL LIABILITIES
ASSETS
1. Intangible assets
2. Goodwill
3. Net fixed Assets
Capital work in progress
4. Investments
5. Net working capital
6.Long term working capital
Total Assets

Operating balance sheet of Dr reddy of the year 2013

Liabilitiy
Equity
Less: non operating invt
Less : Excess cash
Net DTL
Core Equity
Debts
Minority interest

750
14839
268

opearing investment
Operating working capital
Long term working cap
Capital work in progress
Total

12952
4656
4296
43599

8025
5419
7622
44588

In millions
Amount(2011)

in millions
in millions
Amount(2012) Amount(2013)

40,318
846
39,472
999
23705
295
5,078
18332
0
65022

49890
848
49042

63691
849
62842

191

1070

16419
261
5078
11080

12659
802

11857

66500

77420

4530
6059
23266
6045
9
16374
8739
65022

2922
5463
25732
7085
9
24076
1213
66500

2898
6192
31425
5653
4
29322
1935
77429

2011
40,318
9
4261.26
999
37,047
23705

2012
49,890
9
14098.1
191
35,974
16419

2013
63,691
4
17814.12
1070
46,943
12659

60,752

52,393

59,602

2011
4530
6059
23266

2012
2922
5463
25732

2013
2898
6192
31425

12113
8739
6045
60752

9978
1213
7085
52393

11508
1935
5653
59611

Notes on share capital

no of share outstanding at the beginning of the year

no of share
53,765,268

Share Issued during the year

Number of share outstanding

Notes on reserve and surplus

Capital reserve
Balance at the beginning of the year
Movement during the year

2009
14
14

Securities premium
Balance at the beginning of the year
Add: addition during the yar on ESOP

Employee stock option outstanding

Balance at the beginning of the year
Add: Amortisation during the year, net of forfeiture
less : options exercised during the year
(A)
General reserve
Balance at the beginning of the year
Add: Transferred from surplus
Less: Transferred to surplus

17642
171
17813

616
278
-266
628

12651
561
13212

foreign currency translation reserve

Balance at the beginning of the year
Movement during the year

1478
714
2192

Debenture redemption reserve

Balance at the beginning of the year
Add : transferred fronm surplus

Hedging reserve
Balance at the beginning of the year
Movement during the year

Surplus
Balnce at the beginning of the year

-10
-227
-237

12001

Add: Transfer from general reserve

Add: current year profit
Amoutn availabe for appropiaiton
Less : appropiation
Propsed Dividend
Tax on proposed dividend
Dividend on previous years
Debenture redemption reserve
Dividend distribution tax on distribution
Bonus debentures as per court approved scheme
Transferred to general reserve

Defered stock compensation cost

Balance at the beginning of the year
Add: options granted during the year
Less : Amortisation during the year
options forfieted during the year
balance at the end of the year (B)
A-B

18,473
30473.7
1053
178
1

561
28680.7

264
278
-204
-99
239
389

TOTAL

34420

Deffered tax liability/assets (net)

tax loss carried forward
provisions
inventories
trade recievables
other current assets
current liabilities
stock based compensation cost
excess of depreciation allowed on income tax over depreciation provided

2009
438
64
10
100

Notes on debts
Secured loans
term loans from bank
Working Capital loan from bank
shirt term loan
interest accrued and due
Hire purchase loan from bank
Total
Unsecured loans
from banks short term loans

2009
1635.1
8189.7
50.8
0.7
0.4
9876.7
2422

current account credit balance

short term loans
interest accrued and due
zero coupon foreign currency convertible bonds
sales tax deferement loans
Total
Deferred payment liabilities
Sales tax deferment loan from Government of andhra pradesh
Long term loans from banks

Investments
Non current investment
1.Quoted(listed) investments
Equity shares (fully paid)
12,000 equity shares of rs 10 each of SBI
2.unquoted Investments
Ordinary shares of roubles of rs 1000 each

3.6
171
45.9
9866.2
944.3
13453

60
19530
66249.4
2009

71

2,00,000 ordinary shares of Rs 10 each of Altek engineering limited, india

8859 equity share of Rs 100 each of Jeedimetla effluent treatment limited, india
24,000 equity share Rs 100 each of Progressive effluent treatment limited india
20,250 equity share of Rs 10 each of Shivalik solid waste management limited , india
less: provision for decline, in the value of long term investment

Total

-68
3
6

Notes investment
2009
CURRENT INVESTMENTS
Quoted investment other than trade - Equity shares fully paid of andhra bank of Rs.10 each 0.2
Unquoted Trad-equity shares fully paid 70,000 ofcitadel aurobindo biotech ltd
Less: Provision for diminution in the value of investment
Total
LONG TERM INVESTMENTS
Equity Shares (Fully Paid-up)
753 (753) equity shares of Jeedimetla Effluent
Treatment Limited of Rs.100 each
103,709 (103,709) equity shares of Patancheru
Enviro-Tech Limited of Rs.10 each

7
-7
0.2

0.1
1

1,000 (1,000) equity shares of Progressive Effluent

Treatment Limited of Rs.100 each
Government securities:Kisan Vikas Patra
National Savings Certificates
TOTAL

0.1
1
0.2
2.4

Total
Cash and Bank balances
Cash on hand

2.6
2009
15

Bank balance
In current account
in EEFC account
In deposit account (maturity less than 3 months)
Cash and Cash equivalent (A)

2638
70
4702
7425

in unclaimed dividend account

In unclaimed fractional share pay order account
In unclaimed debenture interest account
In deposit account ( more than 3 months less than 12 months
Other bank balances (B)
Total Cash balances (A+B)
Notes on net working capital
Current Investment
Inventory
sundry debtors
Less: provision for doubtful debts
Cash and bank
loan and advances
Other current assets
TOTAL
Less: Current Liabilities
Short liabilities
current liabilities
Short term provisions
Trade payable
TOTAL

Notes on Long term working capital

Non current assets
Other non current assets
Long term loans and advances
Deferred tax assets

14
1

15
7440
2009
8776.3
8897.6
0
1276.5
3869.2
70.1
22889.7

5434.6
265.9
5700.5
17189.2
2009

5043
376

5419
Less: Non current liabilities
Other long term liabilities
Long term provision

Notes on Fixed assets

763
763
4656

free hold Land

Lease hold land
Lease hold building
free hold Building
Plant and Machinary
Electric equipments
Laboratory equipments
Furniture and Fixtures
Vechicles

2009
424.1
269
53.5
2815.8
9230.6
0
0
163.8
50.7
13007.5

Notes on Net intangible assets

2009

computer software
product development cost
licences & patents

-0.1
0
454.8
454.7

Notes on operating working capital

Current working capital
Less: excess cash

2009
17189.2
4237.656
12951.544

Working notes on Equity

Paid up share capital
Reserve and surplus

2009
842
34,420
35,262

Working notes on Excess cash

Total cash
Less: operating cash

2009
5623
1385.344
4237.656

Working notes on net DTL

Deffered tax liabilities

2009
914

2009

no of share

2010

No of share

2011

No.of shares

268.8

168845585

844

168,845,585

844

169252732

407147

307,614

268.8

844

846

2010

2011

2012

2013

14
260
274

274

274

274

274

274
-7
267

17813
224
18037

18037
241
18278

18279
253
18532

18,352
283
18,635

628
264
-319
573

573
424
-281
716

405
403
-257
551

551
421
-283
689

13,212
846

8979
945

9924
1265

14,058

14058
893
-5972
8979

9924

11189

2192
343
2535

2535
363
2898

2898
775
3673

3673
137
3810

19
19

19
848
867

867
845
1712

-237
745
508

508
38
546

546
-1902
-1356

-1356
965
-391

1036

1162

8073

16577

3,588
4624
1,900
316
1

846
1561

5972
10,215
17349
1,904
309
4
19
843
5078
893
8299

12,667
20740

14,967
31544

2331
378
3
848

2548
433
3
845

945
16235

1265
26450

223
424
-268
-68
311
405
36925

40239

48700

62842

2010
380
191
70

2011

2012
361
254
174
186
358
1124
-119

2013
435
250
207
387
214
594
-158

-1189
1149

-1257
672

2010

2011

2012

2013

253
15

256
39

261

802

55
14516
14839

52
18280
18627

47
11033
11341

28
11829
12659

2010

2011

2012

2013

71

71

66

66

-68
3

-65
6

-65
6

-70
1

2010

2011

2012

2013

2010
9

2011
6

2012
5

2013
5

3298
4
3271
6582

5150
25
549
5730

4607
110
2640
7362

4479

17
1

20
1

18

21

23
1
7
8668
8699

28
1
10
14928
14967

6600

5751

16061

20171

2010
0
13,394
12018
-419
6600
584

2011
0
15992
17001
-494
5751
525

32177

38775

2012
2070
19433
25905
-537
16061
6629
429
69990

2013
1966
21707
32386
-582
20171
9256
1006
85910
18986
21204
6741
9657
56588
29322

720
5204

16,746
2216

20188
2213

18962
13215

22401
16374

15888
17492
4968
7566
45914
24076

2010

2011

2012

2013

6025
680

8,742
1,224

701
1340

209
848
1742

6705

9,966

2041

2799

1286
1286
5419

0
1227
1227
8739

495
333
828
1213

350
514
864
1935

2010
2152

2011
3710

2012
3592

2013
3652

4799
7369
973
1231
636
223
17383

6410
9102
1223
1721
827
273
23266

7545
10429
1241
1754
945
226
25732

10035
13164
1524
1947
903
200
31425

2010
2760
81
31

2011
4440
66
24

2012
2889
33

2872

4530

2922

2013
2279
24
81
514
2898

2010
13215
5189.62
8025.38

2011
16374
4261.26
12112.74

2012
24076
14098.1
9977.9

2013
29322
17814.12
11507.88

2010
844
36,925
37,769

2011
846
39,472
40,318

2012
848
49,042
49,890

2013
849
62,842
63,691

2010
6600
1410.38
5189.62

2011
5751
1489.74
4261.26

2012
16061
1962.9
14098.1

2013
20171
2356.88
17814.12

2010
682

2011
999

2012
191

2013
1070

2012

no of shares

2013

846

169,560,346

848

276219

848

849

OPERATING BALANCE SHEET