Nothing Special   »   [go: up one dir, main page]

Poddar Pigments

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 19

PODDAR PIGMENTS LTD SCREENER.

IN

Narration Mar-06 Mar-07 Mar-08 Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Trailing Best Case Worst Case
Sales 75.38 91.69 98.74 119.73 153.09 186.48 221.92 275.55 313.23 318.31 313.54 358.98 323.40
Expenses 74.30 83.06 91.01 109.75 139.59 171.73 212.62 257.21 289.62 297.09 292.01 333.98 301.95
Operating Profit 1.08 8.63 7.73 9.98 13.50 14.75 9.30 18.34 23.61 21.22 21.53 25.00 21.44
Other Income 2.48 2.54 3.06 2.51 10.01 2.51 1.13 1.93 1.74 2.94 4.06 - -
Depreciation 2.23 2.26 2.35 2.16 2.16 2.33 2.70 2.65 2.60 2.85 2.65 2.65 2.65
Interest 1.19 1.40 1.15 1.90 1.19 2.10 2.13 2.06 1.71 1.10 0.43 0.43 0.43
Profit before tax 1.68 3.00 5.29 5.97 17.16 13.99 14.42 17.53 19.10 21.93 22.55 21.92 18.36
Tax 0.49 1.30 1.49 2.00 2.97 4.44 4.58 4.74 5.64 5.62 5.60 25% 25%
Net profit 1.19 1.70 3.80 3.97 14.19 9.55 9.84 12.79 13.47 16.31 16.97 16.48 13.80
EPS 0.98 1.39 3.11 3.25 13.37 9.00 9.27 12.05 12.70 15.37 15.99 15.53 13.01
Price to earning 15.08 21.03 9.27 5.30 2.97 4.95 4.19 3.86 3.91 8.78 9.33 9.33 5.41
Price 14.71 29.30 28.86 17.25 39.74 44.54 38.89 46.52 49.66 134.93 149.30 144.95 70.40

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 29.11% 21.54% 16.58% 17.74% 16.25%
OPM 1.43% 9.41% 7.83% 8.34% 8.82% 7.91% 4.19% 6.66% 7.54% 6.67% 6.87%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST


Sales Growth 17.36% 18.20% 15.77% 12.78% 1.62% 12.78% 1.62%
OPM 6.91% 6.97% 6.63% 6.96% 6.87% 6.96% 6.63%
Price to Earning 8.06 5.41 5.84 6.47 9.33 9.33 5.41
PODDAR PIGMENTS LTD SCREENER.IN

Narration Sep-13 Dec-13 Mar-14 Jun-14 Sep-14 Dec-14 Mar-15 Jun-15 Sep-15 Dec-15
Sales 82.63 74.43 85.85 85.23 76.01 81.62 75.41 75.31 78.98 83.84
Expenses 77.19 69.59 79.85 79.40 70.58 75.51 70.39 69.99 73.74 77.89
Operating Profit 5.44 4.84 6.00 5.83 5.43 6.11 5.02 5.32 5.24 5.95
Other Income -0.17 1.06 0.50 0.45 0.65 0.67 1.17 0.67 1.07 1.15
Depreciation 0.63 0.67 0.67 0.63 0.84 0.69 0.68 0.65 0.66 0.66
Interest 0.15 0.43 0.27 0.20 0.16 0.13 0.11 0.13 0.10 0.09
Profit before tax 4.50 4.81 5.20 5.47 5.10 5.96 5.30 5.27 5.62 6.36
Tax 1.38 1.32 1.69 1.50 1.43 1.50 1.20 1.45 1.45 1.50
Net profit 3.12 3.49 3.90 3.97 3.65 4.48 4.22 3.77 4.12 4.86

OPM 7% 7% 7% 7% 7% 7% 7% 7% 7% 7%
PODDAR PIGMENTS LTD SCREENER.IN

Narration Mar-06 Mar-07 Mar-08 Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15
Equity Share Capital 12.20 12.20 12.20 12.20 10.61 10.61 10.61 10.61 10.61 10.61
Reserves 16.52 18.22 22.02 25.99 36.10 42.87 50.24 60.55 71.23 84.03
Borrowings 7.56 6.10 13.27 10.95 9.07 23.99 21.64 14.73 6.37 0.75
Other Liabilities 16.70 19.67 16.53 20.81 26.70 36.11 20.90 28.21 32.54 27.87
Total 52.98 56.19 64.02 69.95 82.48 113.58 103.39 114.10 120.75 123.26

Net Block 18.76 16.40 18.71 18.44 20.09 30.87 31.75 30.33 28.15 26.19
Capital Work in Progress 0.03 - - 1.45 0.02 0.05 - 0.01 - -
Investments 1.00 - - 3.80 6.26 6.68 4.08 3.59 - 6.01
Other Assets 33.19 39.79 45.31 46.26 56.11 75.98 67.56 80.17 92.60 91.06
Total 52.98 56.19 64.02 69.95 82.48 113.58 103.39 114.10 120.75 123.26

Working Capital 16.49 20.12 28.78 25.45 29.41 39.87 46.66 51.96 60.06 63.19
Debtors 8.96 11.71 15.14 18.54 19.16 25.52 28.85 39.06 42.46 33.87
Inventory 18.61 19.13 16.63 17.11 19.76 29.58 30.04 35.28 37.83 39.48

Debtor Days 43.39 46.62 55.97 56.52 45.68 49.95 47.45 51.74 49.48 38.84
Inventory Turnover 4.05 4.79 5.94 7.00 7.75 6.30 7.39 7.81 8.28 8.06

Return on Equity 4% 6% 11% 10% 30% 18% 16% 18% 16% 17%
Return on Capital Emp -5% 14% 8% 13% 17% 11% 3% 13% 17% 14%
PODDAR PIGMENTS LTD SCREENER.IN

Narration Mar-06 Mar-07 Mar-08 Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15
Cash from Operating Activity 1.56 1.95 -0.11 6.51 6.60 2.03 18.71 9.76 13.98 19.33
Cash from Investing Activity -0.85 1.68 -3.48 -6.91 2.05 -13.58 -2.53 -0.76 2.42 -7.12
Cash from Financing Activity -0.15 -2.46 6.43 -3.53 -9.30 11.61 -14.99 -10.89 -12.38 -9.41
Net Cash Flow 0.56 1.17 2.84 -3.93 -0.65 0.06 1.19 -1.89 4.02 2.80
PODDAR PIGMENTS LTD 3/31/2006 3/31/2007 3/31/2008 3/31/2009

Year On Year Growth %


PROFIT & LOSS
Sales 21.64% 7.69% 21.26%
Raw Material Cost 17.42% 7.53% 21.87%
Change in Inventory -189.20% -73.89% 19.51%
Power and Fuel -2.25% 0.46% 9.17%
Other Mfr. Exp 6.80% 12.36% 29.00%
Employee Cost 14.44% 20.63% 25.75%
Selling and admin 15.34% 0.51% -2.35%
Other Expenses 77.42% 36.36% 31.33%
Other Income 2.42% 20.47% -17.97%
Depreciation 1.35% 3.98% -8.09%
Interest 17.65% -17.86% 65.22%
Profit before tax 78.57% 76.33% 12.85%
Tax 165.31% 14.62% 34.23%
Net profit 42.86% 123.53% 4.47%
Dividend Amount #DIV/0! #DIV/0! #DIV/0!

Year On Year Growth %


BALANCE SHEET
Equity Share Capital 0.00% 0.00% 0.00%
Reserves 10.29% 20.86% 18.03%
Borrowings -19.31% 117.54% -17.48%
Other Liabilities 17.78% -15.96% 25.89%
Total 6.06% 13.93% 9.26%
Net Block -12.58% 14.09% -1.44%
Capital Work in Progress -100.00% #DIV/0! #DIV/0!
Investments -100.00% #DIV/0! #DIV/0!
Other Assets 19.89% 13.87% 2.10%
Total 6.06% 13.93% 9.26%
Receivables 30.69% 29.29% 22.46%
Inventory 2.79% -13.07% 2.89%
Cash & Bank 71.34% 100.71% -69.50%
No. of Equity Shares 0.00% 0.00% 0.00%
New Bonus Shares #DIV/0! #DIV/0! #DIV/0!
Face value 0.00% 0.00% 0.00%
Year On Year Growth %
CASH FLOW:
Cash from Operating Activity 25.00% -105.64% -6018.18%
Cash from Investing Activity -297.65% -307.14% 98.56%
Cash from Financing Activity 1540.00% -361.38% -154.90%
Net Cash Flow 108.93% 142.74% -238.38%

PRICE: 99.18% -1.50% -40.23%

DERIVED:
Adjusted Equity Shares in Cr 0.00% 0.00% 0.00%

Margins % of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Raw Material Cost 77.54% 74.85% 74.74% 75.12%
Change in Inventory 2.33% -1.71% -0.42% -0.41%
Power and Fuel 2.95% 2.37% 2.21% 1.99%
Other Mfr. Exp 3.32% 2.91% 3.04% 3.23%
Employee Cost 4.78% 4.49% 5.03% 5.22%
Selling and admin 6.83% 6.48% 6.05% 4.87%
Other Expenses 0.82% 1.20% 1.52% 1.65%
Other Income 3.29% 2.77% 3.10% 2.10%
Depreciation 2.96% 2.46% 2.38% 1.80%
Interest 1.58% 1.53% 1.16% 1.59%
Profit before tax 2.23% 3.27% 5.36% 4.99%
Tax 0.65% 1.42% 1.51% 1.67%
Net profit 1.58% 1.85% 3.85% 3.32%
Dividend Amount 0.00%

invested Capital1(Equity + Long Debt) 36.28 36.52 47.49 49.14


invested Capital2(Equity + Long Debt-Cash) 34.64 33.71 41.85 47.42
invested Capital3(Net Block + Work in Progress + 33.64 33.71 41.85 43.62
invested Capital4(Net Block + WC w/o cash) 33.61 33.71 41.85 42.17
WC1 (Current Assets -Current Liabilities) 16.49 20.12 28.78 25.45
WC 2(Without Cash) 14.85 17.31 23.14 23.73
EBIT 2.87 4.4 6.44 7.87
EBIT/Invested Capital 1 0.08 0.12 0.14 0.16
EBIT/Invested Capital 2 0.08 0.13 0.15 0.17
EBIT/Invested Capital 3 0.09 0.13 0.15 0.18
EBIT/Invested Capital 4 0.09 0.13 0.15 0.19
Tax 0.29 0.43 0.28 0.34
ROIC 1 5.60% 6.83% 9.74% 10.65%
ROIC 2 5.87% 7.40% 11.05% 11.04%
ROIC 3 6.04% 7.40% 11.05% 12.00%
ROIC 4 6.05% 7.40% 11.05% 12.41%
EPA 1 -1.60 -1.16 -0.12 0.32
EPA 2 -1.43 -0.88 0.44 0.49
EPA 3 -1.33 -0.88 0.44 0.87
EPA 4 -1.33 -0.88 0.44 1.02
EPA1/Sales -2.12% -1.26% -0.12% 0.27%
EPA2/Sales -1.90% -0.96% 0.45% 0.41%
EPA3/Sales -1.77% -0.96% 0.45% 0.73%
EPA4/Sales -1.76% -0.96% 0.45% 0.85%
Decomposition of ROE
Total Asset Turns 1.42 1.63 1.54 1.71
Financial Leverage 1.84 1.85 1.87 1.83
Net Profit 1.58% 1.85% 3.85% 3.32%
ROE 4.14% 5.59% 11.10% 10.40%
ROCE -4.65% 13.88% 8.19% 13.26%
ROA 2.25% 3.03% 5.94% 5.68%

NOPLAT 2.03291667 2.49333333333 4.6260869565 5.2334840871


ROIIC 1 888.65% 5.54%
ROIIC 2 -229.33% 7.46%
ROIIC 3 3046.79% 7.46%
ROIIC 4 2132.75% 7.46%

Efficiency Ratio
Capital Turns 1 2.07772878 2.51067907996 2.0791745631 2.4365079365
Capital Turns 2 2.24 2.72 2.36 2.74
Fixed Asset Turns 4.02 5.59 5.28 6.49
Working Capital1/Sales 0.22 0.22 0.29 0.21
Working Capital2/Sales 19.70% 18.88% 23.44% 19.82%
Debtor Days 43.39 46.62 55.97 56.52
Inventory Days 18.61 19.13 16.63 17.11
Debtors turnover 8.41 7.83 6.52 6.46
Inventory turnover 4.05 4.79 5.94 7.00

Financial Health
Long term debt/Earning 6.35 3.59 3.49 2.76
Current liablility/Earning 14.03 11.57 4.35 5.24
Total liability/Earning 20.39 15.16 7.84 8.00
Debt/Equity 0.26 0.20 0.39 0.29
Interest Coverage 2.4 3.1 5.6 4.1
Owners Earning
Fixed Asset/Sales 0.25 0.18 0.19 0.15
Fixed Asset/Sales 10 yrs
Fixed Asset/Sales 7 yrs
Fixed Asset/Sales 5 yrs
Fixed Asset/Sales 3 yrs 0.21 0.17
YoY Increase in Sales 16.31 7.05 20.99
Capex -0.13 4.66 3.34
Growth Capex-5Yr
Maintenance Capex-5yr

Growth Capex-3Yr 1.4504751897 3.6548088955


Maintenance Capex-3yr 3.2095248103 -0.314808895

Owners Earning 5Yr Maintenace Capex


Owners Earning 3 Yr Maintenace Capex 2.9404751897 6.4448088955
Owners Earning with capex 4.09 1.49 2.79
Net profit 1.19 1.70 3.80 3.97

OE5Yr/Sales
OE3Yr/Sales 2.98% 5.38%
OE/Sales 4.46% 1.51% 2.33%
NPM 1.58% 1.85% 3.85% 3.32%

Capex/Depriciation -0.0575221239 1.9829787234 1.5462962963

Net Profit 1.19 1.7 3.8 3.97


Increase in Invested Capital 1 0.24 10.97 1.65
Increase in Invested Capital 2 -0.93 8.14 5.57
Increase in Invested Capital 3 0.07 8.14 1.77
Increase in Invested Capital 4 0.10 8.14 0.32

Defensive earnings1 1.46 -7.17 2.32


Defensive earnings2 2.63 -4.34 -1.6
Defensive earnings3 1.63 -4.34 2.20
Defensive earnings4 1.60 -4.34 3.65

Defensive Earning From Balance Sheet Kindly Enter Data from Balance sheet in
Fixed Asset (with Capital work in progress) 18.79 16.4 18.71 19.89
Working Capital 0 0 0 0
Current Assets-Cash 0 0 0 0
Inventories
Trade Receivables
Cash and Bank Balances
Short - Term Loans and Advances
Other Current Assets
Current Liabilities 0 0 0 0
Short - Term Borrowings
Trade Payables
Other Current Liabilities
Short - Term Provisions

Increase in Fixed Asset1(with Capital work in progress) -2.39 2.31 1.18


Increase in WC(Without Cash) 0 0 0

Defensive earnings 4.09 1.49 2.79

PODDAR PIGMENTS LTD 10 YR CAGR 5 YR CAGR 3 YR CAGR 1 YR CAGR


Sales 17.36% 14.30% 7.48% 1.60%
Raw Material Cost 17.76% 14.82% 7.05% 1.21%
Change in Inventory -7.65% 10.35% -6.32% 212.79%
Power and Fuel 8.03% 8.34% 0.11% 6.52%
Other Mfr. Exp 5.30% 11.12% -0.13% -3.77%
Employee Cost 17.17% 14.80% 19.09% 15.41%
Selling and admin 13.72% 17.34% 11.99% 7.69%
Other Expenses 12.92% 4.02% -4.06% -62.16%
Other Income 1.91% 4.03% 23.42% 40.82%
Depreciation 2.76% 5.17% 3.70% 8.77%
Interest -0.87% -14.93% -26.93% -55.45%
Profit before tax 33.04% 11.89% 11.85% 12.90%
Tax 31.14% 6.07% 8.89% -0.36%
Net profit 33.76% 14.32% 12.93% 17.41%
Dividend Amount #DIV/0! -1.19% 11.80% 9.81%
ROIC 1 13.81% 6.08% 3.88% 8.00%
ROIC 2 14.85% 7.39% 9.48% 19.35%
EPA1 -218.92% 23.75% 15.35% 29.86%
EPA2 -223.62% 22.16% 20.91% 41.70%
EPA1/Sales -201.33% 8.26% 7.32% 27.79%
EPA2/Sales -205.34% 6.88% 12.50% 39.43%
ROE #REF! #REF! #REF! #REF!
ROCE -213.26% 6.04% 3.54% -18.13%
BALANCE SHEET
Report Date 0.91% 0.89% 0.88% 0.87%
Equity Share Capital -1.54% 0.00% 0.00% 0.00%
Reserves 19.81% 18.32% 17.80% 15.23%
Borrowings -22.64% -57.95% -77.44% -749.33%
Other Liabilities 5.86% -6.27% -0.60% -16.76%
Total 9.84% 2.07% 3.94% 2.04%
Net Block 3.78% -4.03% -7.08% -7.48%
Capital Work in Progress -100.00% -100.00% -100.00% #DIV/0!
Investments 22.05% -2.61% 29.39% 100.00%
Other Assets 11.87% 4.63% 6.58% -1.69%
Total 9.84% 2.07% 3.94% 2.04%
Receivables 15.92% 7.33% -6.88% -25.36%
Inventory 8.72% 7.48% 5.79% 4.18%
Cash & Bank 19.00% 58.30% 221.39% 37.58%
No. of Equity Shares -1.54% 0.00% 0.00% 0.00%
New Bonus Shares #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Face value 0.00% 0.00% 0.00% 0.00%

CASH FLOW:
Report Date 0.89% 0.88% 0.87%
Cash from Operating Activity 75.66% 40.73% 27.68%
Cash from Investing Activity -14.91% 206.08% 133.99%
Cash from Financing Activity #NUM! -7.04% -31.56%
Net Cash Flow 161.37% #NUM! -43.57%
3/31/2010 3/31/2011 3/31/2012 3/31/2013 3/31/2014 3/31/2015

27.86% 21.81% 19.00% 24.17% 13.67% 1.62%


30.10% 25.17% 21.06% 25.29% 13.21% 1.22%
30.61% -190.63% 660.34% -77.78% -198.98% -188.66%
19.75% 13.33% 15.17% 19.35% -6.31% 6.97%
22.74% -45.05% 43.30% 6.68% 3.51% -3.63%
12.96% 22.24% 3.36% 18.50% 19.96% 18.22%
30.53% 13.53% 26.27% 19.71% 15.77% 8.33%
-51.78% 66.32% 128.48% -44.32% 49.25% -38.33%
298.80% -74.93% -54.98% 70.80% -9.84% 68.97%
0.00% 7.87% 15.88% -1.85% -1.89% 9.62%
-37.37% 76.47% 1.43% -3.29% -16.99% -35.67%
187.44% -18.47% 3.07% 21.57% 8.96% 14.82%
48.50% 49.49% 3.15% 3.49% 18.99% -0.35%
257.43% -32.70% 3.04% 29.98% 5.32% 21.08%
#DIV/0! #DIV/0! -23.74% 0.00% 12.74% 10.88%

-13.03% 0.00% 0.00% 0.00% 0.00% 0.00%


38.90% 18.75% 17.19% 20.52% 17.64% 17.97%
-17.17% 164.50% -9.80% -31.93% -56.75% -88.23%
28.30% 35.24% -42.12% 34.98% 15.35% -14.35%
17.91% 37.71% -8.97% 10.36% 5.83% 2.08%
8.95% 53.66% 2.85% -4.47% -7.19% -6.96%
-98.62% 150.00% -100.00% #DIV/0! -100.00% #DIV/0!
64.74% 6.71% -38.92% -12.01% -100.00% #DIV/0!
21.29% 35.41% -11.08% 18.66% 15.50% -1.66%
17.91% 37.71% -8.97% 10.36% 5.83% 2.08%
3.34% 33.19% 13.05% 35.39% 8.70% -20.23%
15.49% 49.70% 1.56% 17.44% 7.23% 4.36%
-37.79% 16.82% 99.20% -69.48% 544.74% 60.20%
-13.03% 0.00% 0.00% 0.00% 0.00% 0.00%
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
1.38% -69.24% 821.67% -47.84% 43.24% 38.27%
-129.67% -762.44% -81.37% -69.96% -418.42% -394.21%
163.46% -224.84% -229.11% -27.35% 13.68% -23.99%
-83.46% -109.23% 1883.33% -258.82% -312.70% -30.35%

130.38% 12.08% -12.69% 19.62% 6.75% 171.71%

-13.03% 0.00% 0.00% 0.00% 0.00% 0.00%

100.00% 100.00% 100.00% 100.00% 100.00% 100.00%


76.43% 78.54% 79.90% 80.62% 80.29% 79.98%
-0.42% 0.31% 1.99% 0.36% -0.31% 0.27%
1.86% 1.73% 1.68% 1.61% 1.33% 1.40%
3.10% 1.40% 1.69% 1.45% 1.32% 1.25%
4.61% 4.63% 4.02% 3.84% 4.05% 4.71%
4.97% 4.63% 4.92% 4.74% 4.83% 5.15%
0.62% 0.85% 1.63% 0.73% 0.96% 0.58%
6.54% 1.35% 0.51% 0.70% 0.56% 0.92%
1.41% 1.25% 1.22% 0.96% 0.83% 0.90%
0.78% 1.13% 0.96% 0.75% 0.55% 0.35%
11.21% 7.50% 6.50% 6.36% 6.10% 6.89%
1.94% 2.38% 2.06% 1.72% 1.80% 1.77%
9.27% 5.12% 4.43% 4.64% 4.30% 5.12%

55.78 77.47 82.49 85.89 88.21 95.39


54.71 76.22 80 85.13 83.31 87.54
48.45 69.54 75.92 81.54 83.31 81.53
48.43 69.49 75.92 81.53 83.31 81.53
29.41 39.87 46.66 51.96 60.06 63.19
28.34 38.62 44.17 51.20 55.16 55.34
18.35 16.09 16.55 19.59 20.81 23.03
0.33 0.21 0.20 0.23 0.24 0.24
0.34 0.21 0.21 0.23 0.25 0.26
0.38 0.23 0.22 0.24 0.25 0.28
0.38 0.23 0.22 0.24 0.25 0.28
0.17 0.32 0.32 0.27 0.30 0.26
27.20% 14.18% 13.69% 16.64% 16.63% 17.96%
27.74% 14.41% 14.12% 16.79% 17.60% 19.57%
31.32% 15.79% 14.88% 17.53% 17.60% 21.01%
31.33% 15.81% 14.88% 17.53% 17.60% 21.01%
9.60 3.24 3.04 5.70 5.84 7.59
9.70 3.36 3.29 5.78 6.33 8.37
10.33 4.03 3.70 6.14 6.33 8.98
10.33 4.03 3.70 6.14 6.33 8.98
6.27% 1.74% 1.37% 2.07% 1.87% 2.38%
6.34% 1.80% 1.48% 2.10% 2.02% 2.63%
6.75% 2.16% 1.67% 2.23% 2.02% 2.82%
6.75% 2.16% 1.67% 2.23% 2.02% 2.82%

1.86 1.64 2.15 2.41 2.59 2.58


1.77 2.12 1.70 1.60 1.48 1.30
9.27% 5.12% 4.43% 4.64% 4.30% 5.12%
30.38% 17.86% 16.17% 17.97% 16.46% 17.23%
16.91% 11.28% 2.58% 13.31% 17.42% 14.26%
17.20% 8.41% 9.52% 11.21% 11.16% 13.23%

15.174038462 10.983523946 11.29348128 14.29298916 14.665057592 17.128103055


602.46% -63.11% 1.43% 59.75% 10.94% 106.17%
178.47% -57.48% 1.44% 79.35% 7.25% -135.33%
561.61% -86.76% 1.47% 47.01% 6.62% 139.16%
3106.42% -66.94% 1.47% 46.65% 6.63% 138.37%

2.7445320904 2.4071253388 2.690265487 3.208173245 3.5509579413 3.3369325925


3.16 2.68 2.92 3.38 3.76 3.90
7.62 6.04 6.99 9.09 11.13 12.15
0.19 0.21 0.21 0.19 0.19 0.20
18.51% 20.71% 19.90% 18.58% 17.61% 17.39%
45.68 49.95 47.45 51.74 49.48 38.84
19.76 29.58 30.04 35.28 37.83 39.48
7.99 7.31 7.69 7.05 7.38 9.40
7.75 6.30 7.39 7.81 8.28 8.06

0.64 2.51 2.20 1.15 0.47 0.05


1.88 3.78 2.12 2.21 2.42 1.71
2.52 6.29 4.32 3.36 2.89 1.75
0.19 0.45 0.36 0.21 0.08 0.01
15.4 7.7 7.8 9.5 12.2 20.9
0.13 0.17 0.14 0.11 0.09 0.08
0.15
0.17 0.15 0.14 0.13
0.18 0.16 0.16 0.14 0.13 0.12
0.16 0.15 0.15 0.14 0.11 0.09
33.36 33.39 35.44 53.63 37.68 5.08
2.38 13.14 3.53 1.24 0.41 0.89
6.0212576674 5.470182444 5.552319945 7.550289623 4.8213891765 0.6002824961
-3.641257667 7.669817556 -2.02231994 -6.31028962 -4.411389176 0.2897175039

5.2790057713 5.0172229408 5.19597784 7.48461858 4.3082106957 0.4778910318


-2.899005771 8.1227770592 -1.66597784 -6.24461858 -3.898210696 0.4121089682

19.991257667 4.210182444 14.56231994 21.75028962 20.481389176 18.870282496


19.249005771 3.7572229408 14.20597784 21.68461858 19.968210696 18.747891032
13.97 -1.26 9.01 14.20 15.66 18.27
14.19 9.55 9.84 12.79 13.47 16.31

13.06% 2.26% 6.56% 7.89% 6.54% 5.93%


12.57% 2.01% 6.40% 7.87% 6.37% 5.89%
9.13% -0.68% 4.06% 5.15% 5.00% 5.74%
9.27% 5.12% 4.43% 4.64% 4.30% 5.12%

1.1018518519 5.6394849785 1.307407407 0.467924528 0.1576923077 0.3122807018

14.19 9.55 9.84 12.79 13.47 16.31


6.64 21.69 5.02 3.4 2.32 7.18
7.29 21.51 3.78 5.13 -1.82 4.23
4.83 21.09 6.38 5.62 1.77 -1.78
6.26 21.06 6.43 5.61 1.78 -1.78

7.55 -12.14 4.82 9.39 11.15 9.13


6.9 -11.96 6.06 7.66 15.29 12.08
9.36 -11.54 3.46 7.17 11.70 18.09
7.93 -11.51 3.41 7.18 11.69 18.09

cell
20.11 30.92 31.75 30.34 28.15 26.19
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0

0.22 10.81 0.83 -1.41 -2.19 -1.96


0 0 0 0 0 0

13.97 -1.26 9.01 14.2 15.66 18.27


COMPANY NAME PODDAR PIGMENTS LTD
LATEST VERSION 2.00 PLEA
CURRENT VERSION 2.00

META
Number of shares 1.06
Face Value 10.00
Current Price 149.30
Market Capitalization 158.41

PROFIT & LOSS


Report Date Mar-06 Mar-07 Mar-08 Mar-09
Sales 75.38 91.69 98.74 119.73
Raw Material Cost 58.45 68.63 73.80 89.94
Change in Inventory 1.76 -1.57 -0.41 -0.49
Power and Fuel 2.22 2.17 2.18 2.38
Other Mfr. Exp 2.50 2.67 3.00 3.87
Employee Cost 3.60 4.12 4.97 6.25
Selling and admin 5.15 5.94 5.97 5.83
Other Expenses 0.62 1.10 1.50 1.97
Other Income 2.48 2.54 3.06 2.51
Depreciation 2.23 2.26 2.35 2.16
Interest 1.19 1.40 1.15 1.90
Profit before tax 1.68 3.00 5.29 5.97
Tax 0.49 1.30 1.49 2.00
Net profit 1.19 1.70 3.80 3.97
Dividend Amount

Quarters
Report Date Sep-13 Dec-13 Mar-14 Jun-14
Sales 82.63 74.43 85.85 85.23
Expenses 77.19 69.59 79.85 79.40
Other Income -0.17 1.06 0.50 0.45
Depreciation 0.63 0.67 0.67 0.63
Interest 0.15 0.43 0.27 0.20
Profit before tax 4.50 4.81 5.20 5.47
Tax 1.38 1.32 1.69 1.50
Net profit 3.12 3.49 3.90 3.97

BALANCE SHEET
Report Date Mar-06 Mar-07 Mar-08 Mar-09
Equity Share Capital 12.20 12.20 12.20 12.20
Reserves 16.52 18.22 22.02 25.99
Borrowings 7.56 6.10 13.27 10.95
Other Liabilities 16.70 19.67 16.53 20.81
Total 52.98 56.19 64.02 69.95
Net Block 18.76 16.40 18.71 18.44
Capital Work in Progress 0.03 1.45
Investments 1.00 3.80
Other Assets 33.19 39.79 45.31 46.26
Total 52.98 56.19 64.02 69.95
Receivables 8.96 11.71 15.14 18.54
Inventory 18.61 19.13 16.63 17.11
Cash & Bank 1.64 2.81 5.64 1.72
No. of Equity Shares 12,200,000.00 12,200,000.00 12,200,000.00 12,200,000.00
New Bonus Shares
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-06 Mar-07 Mar-08 Mar-09
Cash from Operating Activity 1.56 1.95 -0.11 6.51
Cash from Investing Activity -0.85 1.68 -3.48 -6.91
Cash from Financing Activity -0.15 -2.46 6.43 -3.53
Net Cash Flow 0.56 1.17 2.84 -3.93

PRICE: 14.71 29.30 28.86 17.25

DERIVED:
Adjusted Equity Shares in Cr 1.22 1.22 1.22 1.22
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15


153.09 186.48 221.92 275.55 313.23 318.31
117.01 146.46 177.31 222.16 251.50 254.58
-0.64 0.58 4.41 0.98 -0.97 0.86
2.85 3.23 3.72 4.44 4.16 4.45
4.75 2.61 3.74 3.99 4.13 3.98
7.06 8.63 8.92 10.57 12.68 14.99
7.61 8.64 10.91 13.06 15.12 16.38
0.95 1.58 3.61 2.01 3.00 1.85
10.01 2.51 1.13 1.93 1.74 2.94
2.16 2.33 2.70 2.65 2.60 2.85
1.19 2.10 2.13 2.06 1.71 1.10
17.16 13.99 14.42 17.53 19.10 21.93
2.97 4.44 4.58 4.74 5.64 5.62
14.19 9.55 9.84 12.79 13.47 16.31
2.78 2.12 2.12 2.39 2.65

Sep-14 Dec-14 Mar-15 Jun-15 Sep-15 Dec-15


76.01 81.62 75.41 75.31 78.98 83.84
70.58 75.51 70.39 69.99 73.74 77.89
0.65 0.67 1.17 0.67 1.07 1.15
0.84 0.69 0.68 0.65 0.66 0.66
0.16 0.13 0.11 0.13 0.10 0.09
5.10 5.96 5.30 5.27 5.62 6.36
1.43 1.50 1.20 1.45 1.45 1.50
3.65 4.48 4.22 3.77 4.12 4.86

Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15


10.61 10.61 10.61 10.61 10.61 10.61
36.10 42.87 50.24 60.55 71.23 84.03
9.07 23.99 21.64 14.73 6.37 0.75
26.70 36.11 20.90 28.21 32.54 27.87
82.48 113.58 103.39 114.10 120.75 123.26
20.09 30.87 31.75 30.33 28.15 26.19
0.02 0.05 0.01
6.26 6.68 4.08 3.59 6.01
56.11 75.98 67.56 80.17 92.60 91.06
82.48 113.58 103.39 114.10 120.75 123.26
19.16 25.52 28.85 39.06 42.46 33.87
19.76 29.58 30.04 35.28 37.83 39.48
1.07 1.25 2.49 0.76 4.90 7.85
10,610,000.00 10,610,000.00 10,610,000.00 10,610,000.00 10,610,000.00 10,610,000.00

10.00 10.00 10.00 10.00 10.00 10.00

Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15


6.60 2.03 18.71 9.76 13.98 19.33
2.05 -13.58 -2.53 -0.76 2.42 -7.12
-9.30 11.61 -14.99 -10.89 -12.38 -9.41
-0.65 0.06 1.19 -1.89 4.02 2.80

39.74 44.54 38.89 46.52 49.66 134.93

1.06 1.06 1.06 1.06 1.06 1.06

You might also like