Company Name D P WIRES LT

Current Price (INR) ₹ 622.80

No. of Shares (crores) 2
Market Cap (crores) ₹ 968
TTM Net Profit (crores) ₹ 45
P/E Ratio 21.7x
TTM Operating Profit Margin 4.57%
Latest FY ROAE 23.89%
Latest FY ROACE 31.98%
Debt to Equity Ratio 0.01x
Free Cash Flows (FCF) ₹ 39
Debt to FCF 0.1x
D P WIRES LTD
₹ 622.80
2 Revenue Growth > 10% in 5 Y YES 👌
₹ 968 Net Profit Growth > 12% in 5 YES 👌
₹ 45 P/E Ratio < 20x NO 👎
21.7x ROE Ratio > 15% YES 👌
4.57% ROCE Ratio > 14% YES 👌
23.89% Market Cap SMALLCAP 🤓
31.98% Debt to Equity Ratio < 1.5x YES 👌
0.01x Operating cash Flow in 5 Year Positive 👌
₹ 39 Free Cash Flow in 5 Years Positive 👌
0.1x

Discounted Cash Flow (DCF)UNDERVALUED

Expected ROI next 10 Years 4.0x
Expected Share price in 10 Yea ₹ 2,501 ✅
Piotroski F-Score 6.0x
 iNCOM

COMPANY NAME

INR (in crores) Mar-14

Sales 93
Operating Profit 4
Multibagger List
Other Income 1
EBITDA 5
Income Statement (Yearly)
Interest (2)
Depreciation (1)
Income Statement
Profit before tax (PBT) 2
(Quarterly)
Balance Sheet Tax (0)
Profit after tax (PAT) / Net Profit 1
Cash Flow Statement
Adjusted Equity Shares (in crores) 0.3
Ratio Analysis
Price 0
Info-graphics & Charts
Operating Profit Margin (OPM) % 4.4%
DCF Valuation Net Profit Margin (NPM) % 1.3%
Tax Payout % 26.0%
Investment Decission Dividend Payout % n/m
Interest Coverage Ratio (x) 1.7x
Stock Watchlist Earnings Per Share (EPS) 4.3
PE Ratio (x) 0.0x

Common Sizing Expenses

Year >> Mar-14

Sales 100%
Raw material Expenses 83%
Change in Inventory (1%)
Power and Fuel Cost 5%
Other Mfr. Exp 4%
Employee Cost 1%
Selling and Admin Expenses 4%
Other Expenses 0%
Operating Profit Margin (OPM) % 4.4%

As a Equity Analyst, give me financial analysis of 'Income Statement'!of D P WIRES LTD

here is the 6 years sales numbers- 207.19crores(FY18), 331.62crores(FY19)", 283.87crore
here is the 6 years operating profit numbers- 16.39crores(FY18), 25.7crores(FY19)", 23.3
here is the 6 years Other income numbers- 1.03crores(FY18), 2.5crores(FY19)", 2.27crore
here is the 6 years EBITDA numbers- 17.42crores(FY18), 28.2crores(FY19)", 25.57crore
here is the 6 years Interest numbers- 1.31crores(FY18), 2.33crores(FY19)", 1.35crores(FY
here is the 6 years Depriciation numbers- 1.18crores(FY18), 1.58crores(FY19)", 1.96crore
here is the 6 years PBT numbers- 14.93crores(FY18), 24.29crores(FY19)", 22.26crores(FY
here is the 6 years Tax numbers- 5.11crores(FY18), 6.87crores(FY19)", 5.58crores(FY20)
here is the 5 years PAT numbers- 9.82000000000001crores(FY18), 17.42crores(FY19)", 1
All figures are in Indian currency. Please comment on the financial health, trends and insig
Also, give me the historical growth of the company, and if it continues in same tragedy, w
 iNCOME sTATEMENT (yEARLY)

D P WIRES LTD

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

138 159 195 207 332 284 467 613 1,215
4 6 9 16 26 23 33 41 55
1 1 2 1 3 2 3 3 6
5 7 11 17 28 26 36 43 61
(2) (2) (3) (1) (2) (1) (1) (2) (2)
(1) (1) (1) (1) (2) (2) (2) (2) (3)
2 3 7 15 24 22 32 39 55
(0) (1) (2) (5) (7) (6) (8) (10) (14)
2 2 5 10 17 17 24 29 41

0.3 0.3 0.3 1.6 1.6 1.6 1.6 1.6 1.6

0 0 0 64 63 45 94 286 318

2.8% 3.7% 4.8% 7.9% 7.7% 8.2% 7.1% 6.6% 4.5%

1.2% 1.4% 2.6% 4.7% 5.3% 5.9% 5.2% 4.7% 3.4%
20.4% 23.7% 28.6% 34.2% 28.3% 25.1% 25.7% 25.1% 25.9%
n/m n/m n/m n/m n/m n/m n/m 4.7% 4.0%
2.1x 2.2x 3.6x 12.4x 11.4x 17.5x 30.5x 19.2x 28.5x
5.8 7.6 17.3 6.3
Volatility11.2 10.8
ANALYSIS 15.5 18.7 26.5
0.0x 0.0x 0.0x 10.1x
LAST 3 MONTHS 4.2x
5.6x 6.0x 15.3x 12.0x

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

100% 100% 100% 100% 100% 100% 100% 100% 100%

85% 77% 80% 76% 76% 77% 79% 81% 89%
(1%) 1% (1%) 0% 0% (1%) 1% (0%) (0%)
4% 4% 4% 4% 3% 4% 3% 3% 2%
4% 7% 4% 2% 7% 4% 5% 5% 2%
1% 1% 2% 3% 2% 2% 1% 1% 1%
4% 6% 5% 6% 4% 5% 4% 4% 2%
0% 0% 0% 1% 0% 1% 0% 0% 0%
2.8% 3.7% 4.8% 7.9% 7.7% 8.2% 7.1% 6.6% 4.5%

ncome Statement'!of D P WIRES LTD based on the financial numbers as follows:

8), 331.62crores(FY19)", 283.87crores(FY20), 466.72crores(FY21), 613.24crores(FY22), 1215.31crores(FY23)
 ores(FY18), 25.7crores(FY19)", 23.3crores(FY20), 33.2crores(FY21), 40.67crores(FY22), 54.7999999999999crores(FY23)
s(FY18), 2.5crores(FY19)", 2.27crores(FY20), 2.53crores(FY21), 2.74crores(FY22), 6crores(FY23)
Y18), 28.2crores(FY19)", 25.57crores(FY20), 35.73crores(FY21), 43.41crores(FY22), 60.7999999999999crores(FY23)
8), 2.33crores(FY19)", 1.35crores(FY20), 1.1crores(FY21), 2.13crores(FY22), 2.01crores(FY23)
(FY18), 1.58crores(FY19)", 1.96crores(FY20), 2.22crores(FY21), 2.47crores(FY22), 3.47crores(FY23)
), 24.29crores(FY19)", 22.26crores(FY20), 32.41crores(FY21), 38.81crores(FY22), 55.3199999999999crores(FY23)
6.87crores(FY19)", 5.58crores(FY20), 8.33crores(FY21), 9.76crores(FY22), 14.31crores(FY23)
1crores(FY18), 17.42crores(FY19)", 16.68crores(FY20), 24.08crores(FY21), 29.05crores(FY22), 41.0099999999999crores(FY23)
on the financial health, trends and insight from the finncial numbers.
and if it continues in same tragedy, what is expected revenue and net profit in 2024 and 2025.
 VERSION 7.001

TREND ANALYSIS

TTM 9 YEARS 5 YEARS 3 YEARS

1,270 33% 42% 38%
58 34% 27% 18%
22% 42% 33%
32% 28% 19%

60 47% 30% 20% 2.19 2.85

3.71 4.82
45 47% 33% 19%

n/m 38% 91%

4.6%
3.5%

22% 33% 35%

1.5154845155
2.2966933167
Mar-17 FY17
Mar-18 FY18
Mar-19 FY19

Mar-20 FY20
Mar-21 FY21
Mar-22 FY22
Mar-23 FY23
Mar-18 FY18
Mar-19 FY19

Mar-20 FY20
Mar-21 FY21
Mar-22 FY22
Mar-23 FY23
 iNCOME sTA

COMPANY NAME >>

INR (in crores) Jun-21
Sales 142
Operating Profit 11
Multibagger List Other Income 0
EBITDA 11
Income Statement (Yearly) Interest (0)

Income Statement Depreciation (1)

(Quarterly) Profit before tax (PBT) 10
Balance Sheet Tax (3)
Profit after tax (PAT) / Net Profit 8
Cash Flow Statement

Ratio Analysis
Operating Profit Margin (OPM) % 7.6%
Info-graphics & Charts Net Profit Margin (NPM) % 5.4%
Tax Payout % 26.2%
DCF Valuation Interest Coverage Ratio (x) 52.9x
Investment Decission

Stock Watchlist

As an Equity Analyst, give me financial analysis of D P WIRES LTD based o

here is the 6 Quarters sales numbers- 178.33crores(2Q23), 200.42crores(3Q22
here is the 6 Quarters Operating Profit numbers- 9.34crores(2Q23), 10.92cror
here is the 6 Quarters EBITDA numbers- 10.6crores(2Q23), 11.47crores(3Q2
here is the 6 Quarters Interest expenes numbers- 0.44crores(2Q23), 0.56crores
here is the 6 Quarters PBT numbers- 9.42crores(2Q23), 10.14crores(3Q22)", 1
here is the 6 Quarters PAT numbers- 6.98crores(2Q23), 7.62crores(3Q22)", 9
All figures are in Indian currency and numbers are in crores. Please comment
Also, give me the historical growth of the company, and if it continues in the
 iNCOME sTATEMENT (QUARTELY)

D P WIRES LTD
Sep-21 Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23
132 160 178 200 284 344 387 266 273
9 12 9 11 12 12 20 16 10
1 1 1 1 1 2 3 1 3
9 13 11 11 13 14 22 17 14
(1) (1) (0) (1) (0) (1) (1) (1) (1)

(1) (1) (1) (1) (1) (1) (1) (1) (1)

8 11 9 10 12 12 21 15 12
(2) (3) (2) (3) (3) (3) (6) (4) (3)
6 8 7 8 9 9 15 11 9

6.5% 7.4% 5.2% 5.4% 4.2% 3.5% 5.1% 5.9% 3.8%

4.5% 5.3% 3.9% 3.8% 3.2% 2.7% 3.9% 4.2% 3.3%
23.9% 24.4% 25.9% 24.9% 25.1% 24.9% 27.4% 25.2% 25.5%
11.3x 16.3x 22.4x 19.1x 44.0x 23.1x 35.0x 12.2x 20.3x

Volatility ANALYSIS
LAST 3 MONTHS

ysis of D P WIRES LTD based on the financial numbers as follows:

rores(2Q23), 200.42crores(3Q22)", 283.96crores(4Q22), 344.29crores(1Q23), 386.64crores(2Q23), 265.93crores(3Q23), 273.14crores(4Q23)
rs- 9.34crores(2Q23), 10.92crores(3Q22)", 12crores(4Q22), 12.06crores(1Q23), 19.83crores(2Q23), 15.67crores(3Q23), 10.45crores(4Q23)
6crores(2Q23), 11.47crores(3Q22)", 13.11crores(4Q22), 13.83crores(1Q23), 22.39crores(2Q23), 17.14crores(3Q23), 13.8crores(4Q23)
rs- 0.44crores(2Q23), 0.56crores(3Q22)", 0.28crores(4Q22), 0.56crores(1Q23), 0.61crores(2Q23), 1.33crores(3Q23), 0.63crores(4Q23)
es(2Q23), 10.14crores(3Q22)", 12.05crores(4Q22), 12.38crores(1Q23), 20.76crores(2Q23), 14.85crores(3Q23), 12.16crores(4Q23)
es(2Q23), 7.62crores(3Q22)", 9.03crores(4Q22), 9.3crores(1Q23), 15.07crores(2Q23), 11.11crores(3Q23), 9.06crores(4Q23)
s are in crores. Please comment on the financial health, trends and insight from the finncial numbers.
mpany, and if it continues in the same tragedy, what is the expected revenue and net profit in the next two quarters considering the seasonality effect
 VERSION 7.001

TREND ANALYSIS
QoQ (Sequential) QoQ (Yearly)
3% (4%)
(33%) (13%)
128% 202%
(19%) 5%

(18%) 1%

(18%) 0%

s(3Q23), 273.14crores(4Q23)
(3Q23), 10.45crores(4Q23)
23), 13.8crores(4Q23)
Q23), 0.63crores(4Q23)
12.16crores(4Q23)
crores(4Q23)

rs considering the seasonality effect

Mar-22 2Q21 Mar-23 2Q23
Jun-22 3Q22 Jun-22 3Q22
Sep-22 4Q22 Sep-22 4Q22
Dec-22 1Q23 Dec-22 1Q23
Mar-23 2Q23 Mar-23 2Q23
Jun-23 3Q23 Jun-23 3Q23
Sep-23 4Q23 Sep-23 4Q23
 BAL

COMPANY NAME >>

INR (in crores) Mar-14
Equity Share Capital 3
Reserves 16
Multibagger List Borrowings 7
Other Liabilities 4
Income Statement (Yearly) Total Liabilities 31

Income Statement
(Quarterly) Fixed Assets (Net Block) 5
Balance Sheet Capital Work in Progress (CWIP) 0
Investments 0
Cash Flow Statement
Other Assets 26
Ratio Analysis Total Assets 31

Info-graphics & Charts Receivables 12

Inventory 7
DCF Valuation Cash & Bank 1
Working Capital 21
Investment Decission Capital Employed 26
Total Equity 19
Stock Watchlist
Net Fixed Asset Turnover
Receivables Days
Inventory Turnover
Debt To Equity 0.4x
Return on average Equity (RoAE)
Return on average Capital Employed

Common Size Balance Sheet

Year Mar-14
Equity Share Capital 8%
Reserves 54%
Borrowings 24%
Other Liabilities 15%
Total Liabilities 100%

Fixed Assets (Net Block) 17%

Capital Work in Progress (CWIP) 0%
Investments 0%
Other Assets 83%
Total Assets 100%
Other items as % of Total Assets
Receivables 39%
Inventory 21%
Cash & Bank 3%

As a Equity Analyst, give me financial analysis of based on the financial numbe

here is the 6 Years Equity Share Capital numbers- 13.57crores(FY18)", 13.57cro
here is the 6 Years Reserve & Surplus numbers- 51.03crores(FY18)", 68.45crore
here is the 6 Years Borrowings- 6.23crores(FY18)", 22.63crores(FY19), 3.05cro
here is the 6 Years Other Liabilities- 25.57crores(FY18)", 17.02crores(FY19), 23
here is the 6 Years Total Liabilities Numbers- 96.4crores(FY18)", 121.67crores(
here is the 6 Years Fixed Assets (Net Block)- 7.99crores(FY18)", 15.74crores(FY
here is the 6 Years Capital Work in Progress- 0crores(FY18)", 3.38crores(FY19)
here is the 6 Years Investments - 0crores(FY18)", 0crores(FY19), 0crores(FY20
here is the 6 Years Other Assets - 88.41crores(FY18)", 102.55crores(FY19), 102
here is the 6 Years Total Assets - 96.4crores(FY18)", 121.67crores(FY19), 125.1
here is the 6 Years Receivables- 26.14crores(FY18)", 45.78crores(FY19), 46.37c
here is the 6 Years Inventory- 25.1crores(FY18)", 29.95crores(FY19), 24.68cror
here is the 6 Years Cash & Bank balance- 2.76crores(FY18)", 1.75crores(FY19)
here is the 6 Years Working Capital- 62.84crores(FY18)", 85.53crores(FY19), 7
here is the 6 Years Capital Employed- 70.83crores(FY18)", 104.65crores(FY19)
All figures are in Indian currency and numbers are in crores. Please comm
 BALANCE SHEET

D P WIRES LTD
Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22
3 3 3 14 14 14 14 14
18 20 25 51 68 85 109 138
8 24 30 6 23 3 8 13
22 22 23 26 17 24 23 31
50 68 81 96 122 125 154 196

6 8 8 8 16 23 23 28
0 0 0 0 3 0 0 0
0 0 0 0 0 0 0 0
45 60 73 88 103 102 131 168
50 68 81 96 122 125 154 196

24 27 31 26 46 46 62 88
11 16 26 25 30 25 25 47
2 4 2 3 2 13 5 8
23 38 50 63 86 79 108 137
28 47 58 71 105 102 131 165
21 23 28 65 82 99 123 152
Volatility ANALYSIS
25.4x 22.8x LAST
23.8x 3 MONTHS
25.6x 27.9x 14.7x 20.3x 24.1x
48 58 54 50 40 59 43 45
16.2x 12.0x 9.3x 8.1x 12.0x 10.4x 18.7x 16.9x
0.4x 1.0x 1.1x 0.1x 0.3x 0.0x 0.1x 0.1x
8.5% 10.1% 19.8% 21.2% 23.8% 18.5% 21.8% 21.2%
14.7% 14.1% 18.7% 25.1% 30.3% 22.9% 28.9% 27.7%

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22

5% 4% 3% 14% 11% 11% 9% 7%
36% 30% 31% 53% 56% 68% 71% 71%
15% 35% 37% 6% 19% 2% 5% 7%
43% 32% 28% 27% 14% 19% 15% 16%
100% 100% 100% 100% 100% 100% 100% 100%

11% 12% 10% 8% 13% 18% 15% 14%

0% 0% 0% 0% 3% 0% 0% 0%
0% 0% 0% 0% 0% 0% 0% 0%
89% 88% 90% 92% 84% 82% 85% 86%
100% 100% 100% 100% 100% 100% 100% 100%
 48% 39% 38% 27% 38% 37% 41% 45%
21% 23% 32% 26% 25% 20% 16% 24%
5% 5% 2% 3% 1% 10% 3% 4%

ased on the financial numbers as follows:

3.57crores(FY18)", 13.57crores(FY19), 13.57crores(FY20), 13.57crores(FY21), 13.57crores(FY22), 13.57crores(FY23)
3crores(FY18)", 68.45crores(FY19), 85.05crores(FY20), 109.09crores(FY21), 138.22crores(FY22), 177.9crores(FY23)
22.63crores(FY19), 3.05crores(FY20), 7.96crores(FY21), 13.18crores(FY22), 2.14crores(FY23)
18)", 17.02crores(FY19), 23.52crores(FY20), 23.08crores(FY21), 31.06crores(FY22), 57.86crores(FY23)
ores(FY18)", 121.67crores(FY19), 125.19crores(FY20), 153.7crores(FY21), 196.03crores(FY22), 251.47crores(FY23)
ores(FY18)", 15.74crores(FY19), 22.98crores(FY20), 22.93crores(FY21), 27.98crores(FY22), 31.41crores(FY23)
s(FY18)", 3.38crores(FY19), 0crores(FY20), 0crores(FY21), 0crores(FY22), 0crores(FY23)
rores(FY19), 0crores(FY20), 0crores(FY21), 0crores(FY22), 0crores(FY23)
)", 102.55crores(FY19), 102.21crores(FY20), 130.77crores(FY21), 168.05crores(FY22), 220.06crores(FY23)
, 121.67crores(FY19), 125.19crores(FY20), 153.7crores(FY21), 196.03crores(FY22), 251.47crores(FY23)
, 45.78crores(FY19), 46.37crores(FY20), 62.39crores(FY21), 87.81crores(FY22), 86.99crores(FY23)
.95crores(FY19), 24.68crores(FY20), 25.35crores(FY21), 47.1crores(FY22), 49.65crores(FY23)
(FY18)", 1.75crores(FY19), 12.86crores(FY20), 5.27crores(FY21), 8.29crores(FY22), 33.27crores(FY23)
18)", 85.53crores(FY19), 78.69crores(FY20), 107.69crores(FY21), 136.99crores(FY22), 162.2crores(FY23)
Y18)", 104.65crores(FY19), 101.67crores(FY20), 130.62crores(FY21), 164.97crores(FY22), 193.61crores(FY23)
re in crores. Please comment on the financial health, trends and insight from the finncial numbers.
 VERSION 7.001

TREND ANALYSIS
Mar-23 9 YEARS 5 YEARS 3 YEARS
14 10 14 14
178 77 116 142
2 13 10 8
58 27 31 37
251 127 170 200

31 17 24 27
0 0 1 0
0 0 0 0
220 110 145 173
251 127 170 200

87 49 66 79
50 28 35 41
33 8 12 16
162 83 114 136
194 100 139 163
191 87 129 155

40.9x 25.1x 25.6x 28.4x

26 47 42 38
25.1x 14.3x 16.6x 20.2x
0.0x 0.3x 0.1x 0.1x
23.9% 18.7% 21.8% 22.3%
32.0% 23.8% 28.4% 29.5%

25 50
Mar-23
5%
71%
1%
23%
100%

12%
0%
0%
88%
100%
35%
20%
13%
Mar-17 FY17
Mar-18 FY18
Mar-19 FY19
Mar-20 FY20
Mar-21 FY21
Mar-22 FY22
Mar-23 FY23
Mar-18 FY18
Mar-19 FY19
Mar-20 FY20
Mar-21 FY21
Mar-22 FY22
Mar-23 FY23
 COMPANY NAME
INR (in crores)
Cash from Operating Activity (CFO)
Cash from Investing Activity (CFI)
Cash from Financing Activity (CFF)
Multibagger List Net Cash Flow (CFO + CFI + CFF)
Income Statement (Yearly)
Cash & Equivalent at the end of year
Income Statement
Profit After Tax (PAT)
(Quarterly)
Balance Sheet
Cash from Operating Activity (CFO)
Cash Flow Statement

Ratio Analysis CFO/PAT (atleast 80%)

Info-graphics & Charts CAPEX

Free Cash Flows (FCF)
DCF Valuation
Re-investment (Capex/CFO)
Investment Decission FCF/CFO

Stock Watchlist Cash from Operating Activity (CFO)

CAPEX
% Capex
FCF (Weighted)

As a Equity Analyst, give me Cash Flow analysis of D P WIRES LTD based on the financi
here is the 6 Years Cash from Operating Activity numbers- -12.18crores(FY18), -5.08crore
here is the 6 Years Cash from Investing Activity numbers- -2.88crores(FY18), -8.9crores(F
here is the 6 Years Cash from Financing Activity numbers- 15crores(FY18), 13.9crores(F
here is the 6 Years Net Cash Flow numbers- -0.0599999999999987crores(FY18), -0.08000
here is the 6 Years Cash & Equivalent numbers- 2.76crores(FY18), 1.75crores(FY19), 12.
here is the 6 Capex numbers- 0.99crores(FY18), 12.71crores(FY19), 5.82crores(FY20), 2.
here is the 6 Years Free Cash Flow numbers- -13.17crores(FY18), -17.79crores(FY19), 32
All figures are in Indian currency and numbers are in crores. Please comment on th
Also, give me the historical growth of the company, and if it continues in the same
 Cash Flow Statement

D P WIRES LTD
Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
6 1 (2) 2 (12) (5) 38 (12)
1 (1) (3) 0 (3) (9) (17) 12
(6) 1 6 (2) 15 14 (21) 4
0 2 1 (0) (0) (0) 0 3

1 2 4 2 3 2 13 5

1 2 2 5 10 17 17 24

6 1 (2) 2 (12) (5) 38 (12)

477% 54% (75%) 34% (124%) (29%) 229% (51%)

2 4 1 1 13 6 2
(1) (5) 1 (13) (18) 32 (14)

176% (232%) 68% (8%) (250%) 15% (18%)

9 YEARS 5 YEARS 3 YEARS

7 14 13
2 7 6
0 0 0
16

analysis of D P WIRES LTD based on the financial numbers as follows:

Activity numbers- -12.18crores(FY18), -5.08crores(FY19), 38.24crores(FY20), -12.18crores(FY21), 4.48crores(FY22), 45.54crores(FY23)
ctivity numbers- -2.88crores(FY18), -8.9crores(FY19), -17.38crores(FY20), 11.64crores(FY21), -4.8crores(FY22), -6.08crores(FY23)
Activity numbers- 15crores(FY18), 13.9crores(FY19), -20.52crores(FY20), 3.66crores(FY21), 2.93crores(FY22), -14.75crores(FY23)
rs- -0.0599999999999987crores(FY18), -0.0800000000000001crores(FY19), 0.340000000000003crores(FY20), 3.12crores(FY21), 2.61crores(FY22), 24.71crores(FY23
mbers- 2.76crores(FY18), 1.75crores(FY19), 12.86crores(FY20), 5.27crores(FY21), 8.29crores(FY22), 33.27crores(FY23)
FY18), 12.71crores(FY19), 5.82crores(FY20), 2.17crores(FY21), 7.52crores(FY22), 6.9crores(FY23)
ers- -13.17crores(FY18), -17.79crores(FY19), 32.42crores(FY20), -14.35crores(FY21), -3.04crores(FY22), 38.64crores(FY23)
numbers are in crores. Please comment on the financial health, trends and insight from the finncial numbers.
the company, and if it continues in the same tragedy, what is the expected Free Cash flow growth in the next two years.
 VERSION 7.001

TREND ANALYSIS
Mar-22 Mar-23 TOTAL 9 YEARS 5 YEARS 3 YEARS
4 46 66 25% (255%) (255%)
(5) (6) (31)
3 (15) (1)
3 25 34

8 33

29 41 148 47% 33% 35%

4 46 66 25% (230%) 6%

15% 111% 44%

8 7
(3) 39 17 (257%) (217%) (239%)

168% 15%
29%

61crores(FY22), 24.71crores(FY23)
Mar-17 FY17 Mar-17 FY17
Mar-18 FY18 Mar-18 FY18
Mar-19 FY19 Mar-19 FY19
Mar-20 FY20 Mar-20 FY20
Mar-21 FY21 Mar-21 FY21
Mar-22 FY22 Mar-22 FY22
Mar-23 FY23 Mar-23 FY23
 COMPANY NAME
INR (in crores)
Operating Profit Margin (OPM) %
Net Profit Margin (NPM) %
Tax Payout %
Multibagger List Dividend Payout %
Interest Coverage Ratio (x)
Income Statement Earnings Per Share (EPS)
(Yearly) PE Ratio (x)
Income Statement
(Quarterly)
Net Fixed Asset Turnover
Balance Sheet Receivables Days
Inventory Turnover
Cash Flow
Debt To Equity
Statement
Return on average Equity (RoAE)
Ratio Analysis
Return on average Capital Employed
Info-graphics & Charts
CFO/PAT (atleast 80%)

DCF Valuation
Investment Decission

Stock Watchlist

As a Equity Analyst, give me Financial analysis of 0.0134901791495791 based on the financi

here is the 6 Years Operating Profit Margin - 0.0791061344659492(FY18), 0.0774983414751
here is the 6 Years Net Profit Margin - 0.0473961098508616(FY18), 0.0525300042216995(F
here is the 6 Years Dividend Payout- n/m(FY18), n/m(FY19), n/m(FY20), n/m(FY21), 0.046
here is the 6 Years Interest Coverage Ratio- 12.3969465648855x(FY18), 11.4248927038627x
here is the 6 Years EPS Number- 6.33548387096775(FY18), 11.2387096774194(FY19), 10.7
here is the 6 Years PE Ratio- 10.0813136456212x(FY18), 5.60562571756602x(FY19), 4.211
here is the 6 Years Net Fixed Asset Turnover- 25.6264687693259x(FY18), 27.949431099873
here is the 6 Years Receivables Days- 50.1546889328636(FY18), 39.5796393462397(FY19)
here is the 6 Years Inventory Turnover- 8.12509803921569x(FY18), 12.0479564032698x(FY
here is the 6 Years Debt To Equity Ratio- 0.0964396284829722x(FY18), 0.27590831504511
here is the 6 Years Return on average Equity Ratio- 0.212347280787112(FY18), 0.23762106
here is the 6 Years Return on average Capital Employed Ratio- 0.251412648037774(FY18), 0
here is the 6 Years Return on average Capital Employed Ratio- -1.24032586558045(FY18), -
Please comment on the financial health, trends, and insight from the financial numbe
Also, give me the company's historical growth, and if it continues in the same tragedy
 rATIO aNALYSIS

D P WIRES LTD
Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
4.4% 2.8% 3.7% 4.8% 7.9% 7.7% 8.2%
1.3% 1.2% 1.4% 2.6% 4.7% 5.3% 5.9%
26.0% 20.4% 23.7% 28.6% 34.2% 28.3% 25.1%
n/m n/m n/m n/m n/m n/m n/m
1.7x 2.1x 2.2x 3.6x 12.4x 11.4x 17.5x
4.31 5.79 7.55 17.34 6.34 11.24 10.76
0.0x 0.0x 0.0x 0.0x 10.1x 5.6x 4.2x

25.4x 22.8x 23.8x 25.6x 27.9x 14.7x

48 58 54 50 40 59
16.2x 12.0x 9.3x 8.1x 12.0x 10.4x
0.4x 0.4x 1.0x 1.1x 0.1x 0.3x 0.0x
8.5% 10.1% 19.8% 21.2% 23.8% 18.5%
14.7% 14.1% 18.7% 25.1% 30.3% 22.9%

477% 54% (75%) 34% (124%) (29%) 229%

Volatility ANALYSIS
LAST 3 MONTHS

AVG 5
ROCE 21.8%
ROE 28.4%

alysis of 0.0134901791495791 based on the financial ratios as follows:

n - 0.0791061344659492(FY18), 0.0774983414751824(FY19), 0.0820798252721316(FY20), 0.071134727459719(FY21), 0.066319874763551(FY22), 0.045091375862
0473961098508616(FY18), 0.0525300042216995(FY19), 0.0587592912248564(FY20), 0.0515941035310251(FY21), 0.0473713391168221(FY22), 0.033744476717874
(FY18), n/m(FY19), n/m(FY20), n/m(FY21), 0.046815834767642(FY22), 0.0397464033162643(FY23)
o- 12.3969465648855x(FY18), 11.4248927038627x(FY19), 17.4888888888889x(FY20), 30.4636363636364x(FY21), 19.2206572769953x(FY22), 28.5223880597014x(
387096775(FY18), 11.2387096774194(FY19), 10.7612903225806(FY20), 15.5354838709678(FY21), 18.741935483871(FY22), 26.458064516129(FY23)
456212x(FY18), 5.60562571756602x(FY19), 4.21139088729017x(FY20), 6.04036544850497x(FY21), 15.2550946643718x(FY22), 12.0197756644721x(FY23)
ver- 25.6264687693259x(FY18), 27.9494310998736x(FY19), 14.6627066115702x(FY20), 20.3319538226966x(FY21), 24.0911412296209x(FY22), 40.926418588988x
1546889328636(FY18), 39.5796393462397(FY19), 59.2432275337302(FY20), 42.5280682207748(FY21), 44.699465135999(FY22), 26.2492697336482(FY23)
.12509803921569x(FY18), 12.0479564032698x(FY19), 10.3924583562145x(FY20), 18.657605436738x(FY21), 16.9286404416839x(FY22), 25.1226873385013x(FY23
0.0964396284829722x(FY18), 0.275908315045111x(FY19), 0.0309267896978301x(FY20), 0.0648948312408283x(FY21), 0.0868304894920614x(FY22), 0.01117668
ity Ratio- 0.212347280787112(FY18), 0.23762106124676(FY19), 0.184676705048716(FY20), 0.2176428054953(FY21), 0.211696119511751(FY22), 0.238944240517
ital Employed Ratio- 0.251412648037774(FY18), 0.303396398449966(FY19), 0.228867778208608(FY20), 0.288518662017306(FY21), 0.277005311411076(FY22), 0.
ital Employed Ratio- -1.24032586558045(FY18), -0.291618828932262(FY19), 2.29256594724221(FY20), -0.505813953488371(FY21), 0.15421686746988(FY22), 1.1
h, trends, and insight from the financial numbers. Do not give me the definition of ratios.
l growth, and if it continues in the same tragedy. Is it a good company to invest in based on ratios?
 VERSION 7.001

Mar-21 Mar-22 Mar-23 TTM

7.1% 6.6% 4.5% 4.6%
5.2% 4.7% 3.4% 3.5%
25.7% 25.1% 25.9%
n/m 4.7% 4.0%
30.5x 19.2x 28.5x
15.54 18.74 26.46
6.0x 15.3x 12.0x

20.3x 24.1x 40.9x

43 45 26
18.7x 16.9x 25.1x
0.1x 0.1x 0.0x
21.8% 21.2% 23.9%
28.9% 27.7% 32.0%

(51%) 15% 111%

3551(FY22), 0.0450913758629485(FY23)
1(FY22), 0.0337444767178744(FY23)

FY22), 28.5223880597014x(FY23)
4516129(FY23)
7756644721x(FY23)
9x(FY22), 40.926418588988x(FY23)
92697336482(FY23)
2), 25.1226873385013x(FY23)
920614x(FY22), 0.0111766856426594x(FY23)
751(FY22), 0.238944240517392(FY23)
277005311411076(FY22), 0.319761280606838(FY23)
15421686746988(FY22), 1.1104608632041(FY23)
Mar-17 FY17 FY17
Mar-18 FY18 FY18 Mar-18 FY18
Mar-19 FY19 FY19 Mar-19 FY19
Mar-20 FY20 FY20 Mar-20 FY20
Mar-21 FY21 FY21 Mar-21 FY21
Mar-22 FY22 FY22 Mar-22 FY22
Mar-23 FY23 FY23 Mar-23 FY23
 COMPANY NAME >>

1400
Multibagger List 1200
1000 48.88%
800
Income Statement (Yearly) 600 15.56%
400
Income Statement 200
0
(Quarterly) Aug-13 93 Dec-14
138 159
May-16
Balance Sheet

Cash Flow Statement

Ratio Analysis
142 160
Info-graphics & Charts 132

DCF Valuation
Jun-21 Sep-21 Dec-21
Investment Decission
This chart isn't available in your version of Excel.
Stock Watchlist
Editing this shape or saving this workbook into a
different file format will permanently break the chart.

8% 8% Margin (%)
Operating
8%
7%
6%
5% 5%
5%

Mar-18 Mar-19 Mar-20 Mar-21

Mar-18 Mar-19 Mar-20 Mar-21

18.7% 1
14.7% 14.1%
10.1%
8.5%

Mar-15 Mar-16 Mar-1

 info-graphics & charts

D P WIRES LTD

REVENUE GROWTH

60.06% 64.41%
.88%
15.56% 22.56%
6.04%
-14.40%
467
332 284
138 159 195 207
May-16 Sep-17 Feb-19 Jun-20 Oct

REVENUE (QoQ)
38
344
284
178 200
160

1 Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar

f Excel.
Expenses NOCF
k into a Volatility ANALYSIS
ak the chart. 00%
3% % LAST 3 MONTHS Mar-23 46
DC
Mar-22 4
OC
OI -12 Mar-21
NOC
NI
Mar-20 38
93%
Mar-19
-5

8% Margin (%)
Operating Net Profit Margin (%)
7% Debt to
7%
6%
5%
5% 5%
0.28x
3%

0.03x
Mar-19 Mar-20
Mar-20 Mar-21 Mar-22 Mar-23
 3%

Mar-20 Mar-21 Mar-22 Mar-23

30.3% 28.9%
ROCE
25.1% 23.8% 22.9% 21.8%
21.2%
18.7% 19.8% 18.5%
%
10.1%

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

 VERSION 7.001

REVENUE (YoY) Revenue Growth (%)

98.18% 1.2
1
64.41% 0.8
1215
31.39% 0.6
0.4
0.2
613 0
467 -0.2
-0.4
n-20 Oct-21 Mar-23 Jul-24

387
344
266 273

Dec-22 Mar-23 Jun-23 Sep-23

CF This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a

46
different file format will permanently break the chart.

38

Debt to Equity Ratio

0.06x 0.09x
0.03x 0.01x
Mar-20 Mar-21 Mar-22 Mar-23
 32.0%
28.9%
ROCE Polynomial 27.7%
(ROCE)
23.9%
21.8% 21.2%
8.5%

0 Mar-21 Mar-22 Mar-23

COMPANY NAME

Particulars
REVENUE (YoY)
Revenue Growth (%)

Particulars
PRICE
Particulars
REVENUE (QoQ)

Particulars
Operating Margin (%)
Net Profit Margin (%)

Particulars
ROCE
ROE
 COMPANY GRAPH
D P WIRES LTD

Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

93 138 159 195 207
48.88% 15.56% 22.56% 6.04%

Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

0 0 0 0 64

1.5 2.5
Year Mar-19 Mar-20 Mar-21 Mar-22
Debt to Equity Ratio 0.28x 0.03x 0.06x 0.09x

Sales 1,215 Sales 1,215

Raw Material Cost 1,076 DC -1,125 DC
Change in Inventory 0 OC -39 OC
Power and Fuel 20 OI 6 OI
Other Mfr. Exp 25 NOC -2 NOC
Employee Cost 8 Tax -14 NI
Selling and admin 28 NI 2
Other Expenses 4
Other Income 6
Depreciation 3
Interest 2
Profit before tax 55
Tax 14
Net profit 41
Dividend Amount 2

Mar-19 Mar-20 Mar-21 Mar-22

Free Cash Flow -18 32 -14 -3
Mar-19 Mar-20 Mar-21 Mar-22
NOCF -5 38 -12 4
Jun-21 Sep-21 Dec-21 Mar-22 Jun-22
142 132 160 178 200

Mar-13 Mar-15 Mar-16 Mar-17 Mar-18

4% 3% 4% 5% 8%
1% 1% 1% 3% 5%

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19

14.7% 14.1% 18.7% 25.1% 30.3%
8.5% 10.1% 19.8% 21.2% 23.8%
NY GRAPHICS
P WIRES LTD

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

332 284 467 613 1215
60.06% -14.40% 64.41% 31.39% 98.18%

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

63 45 94 286 318

2.5
Mar-23
0.01x

93%
3%
0%
0%
0%

Mar-23
39
Mar-23
46
Sep-22 Dec-22 Mar-23 Jun-23 Sep-23
284 344 387 266 273

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

8% 8% 7% 7% 5%
5% 6% 5% 5% 3%

Mar-20 Mar-21 Mar-22 Mar-23

22.9% 28.9% 27.7% 32.0%
18.5% 21.8% 21.2% 23.9%
Multibagger List

Income Statement (Yearly)

Income Statement (Quarterly)

Balance Sheet

Cash Flow Statement

Ratio Analysis

Info-graphics & Charts

DCF Valuation
Investment Decission
Stock Watchlist
 DCF Valuat

COMPANY NAME
Initial Cash Flow (Rs Cr) ₹ 16
Estimated Growth Rate NO
Years 1-10
FCF Growth Rate 20.00%
Discount Rate 9.50%
Terminal Growth Rate 5.00%

DCF Value ₹ 1,200.35

Current Market Cap ₹ 967.79
DCF as % of Current Mkt Cap 124.03%

Terminal Year ₹ 103.47

PV of Year 1-10 Cash Flows ₹ 272.55
Terminal Value ₹ 927.80
Total PV of Cash Flows ₹ 1,200.35
Current Market Cap (Rs Cr) ₹ 967.79
Current Share Price
Value Per Share
₹ 622.80
₹ 772.46 C
FUNDAMENTAL 🧩 MANUAL
Current Share Price ₹ 622.80 ₹ 622.80
Estimated 10th Year Share Price ₹ 2,500.71 ₹ 2,500.71
Estimated 10th Year Share Price + Dividends ₹ 2,620.33 ₹ 2,610.40
Total Return 15.45% 15.41%

Investment Return = % EPS Growth + Dividend Income

FUNDAMENTAL 🧩
EPS% DIVIDEND%
Investment return = 17.38% 0.54%
Total Investment return = 17.92%

MANUAL
EPS% DIVIDEND%
Investment return = 20.00% 0.49%
Total Investment return = 20.49%

FUNDAMENTAL 🧩 MANUAL
₹ 185.89 ₹ 109.69
Capital Gains + Dividends = ₹ 401,975 ₹ 401,791
Estimated 10th Year Market Cap = ₹ 3,885.93 ₹ 3,885.93
Discounted Estimated 10th Year Market Cap = ₹ 1,568.03 ₹ 1,568.03
Discounted Dividends = ₹ 133.84 ₹ 110.37
Discounted Value = ₹ 1,701.87 ₹ 1,678.40
Disounted Earnings Valuation = ₹ 1,095.20 ₹ 1,080.10

`
DCF Valuation

D P WIRES LTD
Year FCF Growth Present Value
1 ₹ 19.10 20.00% ₹ 17.44
2 ₹ 22.92 20.00% ₹ 19.11
3 ₹ 27.50 20.00% ₹ 20.95
4 ₹ 33.00 20.00% ₹ 22.95
5 ₹ 39.60 20.00% ₹ 25.16
6 ₹ 47.52 20.00% ₹ 27.57
7 ₹ 57.03 20.00% ₹ 30.21
8 ₹ 68.43 20.00% ₹ 33.11
9 ₹ 82.12 20.00% ₹ 36.28
10 ₹ 98.54 20.00% ₹ 39.76

ROE X (1- PAYOUT RATIO) = GROWTH

YEAR ROE (1-DPR) GROWTH
CURRENT 23.9% 96.0% 22.94%
1 23.9% 96.0% 22.94%
2 23.9% 96.0% 22.94%
3 23.9% 96.0% 22.94%
4 23.9% 96.0% 22.94%
5 23.9% 96.0% 22.94%
6 23.1% 81.8% 19.36%
7 22.3% 67.6% 15.77%
8 21.6% 53.4% 12.18%
9 20.8% 39.2% 8.59%
10 20.0% 25.0% 5.00%
TERMINAL (STA 20.0% 25.0% 5.00%

GROWTH RATE (MANUALLY INPUTTED)

`
YEAR ROE (1-DPR) GROWTH
CURRENT 23.89% 83.70% 20.00%
1 23.89% 83.70% 20.00%
2 23.89% 83.70% 20.00%
3 23.89% 83.70% 20.00%
4 23.89% 83.70% 20.00%
5 23.89% 83.70% 20.00%
6 23.89% 83.70% 20.00%
7 23.89% 83.70% 20.00%
 8 23.89% 83.70% 20.00%
9 23.89% 83.70% 20.00%
10 23.89% 83.70% 20.00%

YEAR NOCF CAPEX FCF

CURRENT ₹ 14.20 49.46% ₹ 7.18
1 ₹ 15.43 49.46% ₹ 7.80
2 ₹ 16.66 49.46% ₹ 8.42
3 ₹ 17.89 49.46% ₹ 9.04
4 ₹ 19.12 49.46% ₹ 9.66
5 ₹ 20.35 49.46% ₹ 10.28
6 ₹ 21.54 49.46% ₹ 10.89
7 ₹ 22.70 49.46% ₹ 11.47
8 ₹ 23.82 49.46% ₹ 12.04
9 ₹ 24.91 49.46% ₹ 12.59
10 ₹ 25.96 49.46% ₹ 13.12
 VERSION 7.001

TD

STOCK IS UNDERVALUED
C
STOCK IS OVERVALUED D
EXPECTED DIVIDEND INCOME ANALYSIS (FUNDAMENTAL GROWTH)
YEAR EPS DPR Dividends
CURRENT 26.5 4.0% 1.05
1 32.53 4.0% 1.29
2 39.99 4.0% 1.59
3 49.17 4.0% 1.95
4 60.45 4.0% 2.40
5 74.32 4.0% 2.95
6 88.71 18.2% 16.13
7 102.69 32.4% 33.26
8 115.20 46.6% 53.67
9 125.09 60.8% 76.05
10 131.35 75.0% 98.51
Expected Dividend Income From This Stock In Next The 10 Years 288.86

EXPECTED DIVIDEND INCOME ANALYSIS (MANUAL GROWTH)

YEAR EPS DPR Dividends
CURRENT 32.53 16.30% 5.30
1 39.03 16.30% 6.36
2 46.84 16.30% 7.63
3 56.21 16.30% 9.16
4 67.45 16.30% 10.99
5 80.94 16.30% 13.19
6 97.13 16.30% 15.83
7 116.56 16.30% 19.00
8 139.87 16.30% 22.80
 9 167.84 16.30% 27.36
201.41 16.30% 32.83
Expected Dividend Income From This Stock In Next The 10 Years 170.45
ROWTH)
Pr. Value

₹ 1.18
₹ 1.33
₹ 1.49
₹ 1.67
₹ 1.88
₹ 9.36
₹ 17.62
₹ 25.97
₹ 33.60
₹ 39.75
₹ 133.84

WTH)
Pr. Value

₹ 5.81
₹ 6.37
₹ 6.98
₹ 7.65
₹ 8.38
₹ 9.18
₹ 10.06
₹ 11.03
 ₹ 12.09
₹ 32.83
₹ 110.37
 INVES

COMPANY NAME
Particulars
Multibagger List Net Profit (Rs Crore)
Net Profit Margin
Income Statement (Yearly) Return on Equity

Income Statement Calculations

(Quarterly) Estimated CAGR in Net Profit over next 10 years
Balance Sheet Estimated Net Profit after 10 years (Rs Cr)
Current P/E (x)
Cash Flow Statement Exit P/E in the 10th year from now (x, Estimated)
Esti. Market Cap (10th year from now; Rs Cr)
Ratio Analysis
Cost of Capital/Discount Rate
Discounted Value (Rs Cr)
Info-graphics & Charts
Current Market Cap (Rs Cr)
DCF Valuation
If you invest 1 lakh today, in 10 yrs it will grow into
Investment Return from this stock in the next 10 years
Investment Decission
Speculative Return from this stock in the next 10 years
Stock Watchlist Capital Gains
Dividend Return
Total Return = Investment Return + Speculative Return
INVESTMENT DECISSION

D P WIRES LTD
Mar/13 Mar/14 Mar/15 Mar/16 Mar/17 Mar/18 Mar/19 Mar/20
1 2 2 5 10 17 17 24
1% 1% 1% 3% 5% 5% 6% 5%
8% 10% 20% 21% 24% 18% 22% 21%

20.00%
YOU CAN INVEST C
194
21.7
20.0
DON'T INVEST D
3,886 Investment Signal

C
10%
1,678
968

401,791
20.49%
-5.09%
14.91%
0.49% Volatility ANALYSIS
15.41% LAST 3 MONTHS
 VERSION 7.001

Mar/21 Mar/22 CAGR (9-Yr) CAGR (5-Yr)

29 41 47% 33%
5% 3%
24% 0%
COMPANY NAME D P WIRES LTD
LATEST VERSION 2.10
CURRENT VERSION 2.10
PLEASE DO NOT
META
Number of shares 1.55
Face Value 10
Current Price 622.8
Market Capitalization 967.79

PROFIT & LOSS

Report Date Mar-14 Mar-15 Mar-16 Mar-17
Sales 92.66 137.95 159.42 195.38
Raw Material Cost 77.03 117.22 123.54 156.01
Change in Inventory 1.23 1.09 -1.98 2.24
Power and Fuel 4.21 4.92 6.55 8.67
Other Mfr. Exp 3.83 5.96 10.99 8.4
Employee Cost 0.63 1.04 1.32 4.19
Selling and admin 3.85 5.95 8.95 10.59
Other Expenses 0.29 0.1 0.19 0.4
Other Income 0.99 1.18 0.64 1.7
Depreciation 0.98 1.02 1.26 1.26
Interest 2.37 1.9 2.41 2.76
Profit before tax 1.69 2.11 2.87 7.04
Tax 0.44 0.43 0.68 2.01
Net profit 1.25 1.67 2.19 5.02
Dividend Amount

Quarters
Report Date Jun-21 Sep-21 Dec-21 Mar-22
Sales 142.35 132.22 160.34 178.33
Expenses 131.54 123.61 148.43 168.99
Other Income 0.3 0.57 0.61 1.26
Depreciation 0.53 0.57 0.64 0.74
Interest 0.2 0.76 0.73 0.44
Profit before tax 10.38 7.85 11.15 9.42
Tax 2.72 1.88 2.72 2.44
Net profit 7.66 5.97 8.43 6.99
Operating Profit 10.81 8.61 11.91 9.34
BALANCE SHEET
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Equity Share Capital 2.5 2.5 2.5 2.5
Reserves 16.49 18.16 20.34 25.39
Borrowings 7.25 7.79 23.8 30.47
Other Liabilities 4.49 21.82 21.85 23
Total 30.73 50.27 68.49 81.36
Net Block 5.16 5.72 8.27 8.18
Capital Work in Progress
Investments
Other Assets 25.57 44.55 60.22 73.18
Total 30.73 50.27 68.49 81.36
Receivables 11.93 24.15 26.79 30.8
Inventory 6.58 10.5 16.06 25.9
Cash & Bank 0.99 2.49 3.51 1.65
No. of Equity Shares 2496000 2496000 2496000 2496000
New Bonus Shares
Face value 10 10 10 10

CASH FLOW:
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Cash from Operating Activity 5.96 0.9 -1.64 1.73
Cash from Investing Activity 0.9 -0.79 -3.46 0.31
Cash from Financing Activity -6.44 1.39 6.12 -2.08
Net Cash Flow 0.43 1.5 1.02 -0.04

PRICE:

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

OVERVIEW

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

207.19 331.62 283.87 466.72 613.24 1215.31
156.64 252.3 219.9 367.83 494.36 1076.44
-0.1 3.12 -2.62 0.01 0.36
9.32 10.88 11.79 13.74 18.4 19.85
4.32 22.39 10.66 22.87 28.78 25.28
5.73 5.72 5.78 5.3 7.57 7.88
13.18 13.49 13.95 20.15 22.49 27.54
1.61 1.04 1.61 1.01 0.98 3.88
1.03 2.5 2.27 2.53 2.74 6
1.18 1.58 1.96 2.22 2.47 3.47
1.31 2.33 1.35 1.1 2.13 2.01
14.93 24.29 22.26 32.41 38.81 55.32
5.11 6.87 5.58 8.33 9.76 14.31
9.83 17.42 16.69 24.08 29.05 41.01
1.36 1.63

Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23

200.42 283.96 344.29 386.64 265.93 273.14
189.5 271.96 332.23 366.81 250.26 262.69
0.55 1.11 1.77 2.56 1.47 3.35
0.77 0.78 0.89 1.02 0.96 1.01
0.56 0.28 0.56 0.61 1.33 0.63
10.14 12.05 12.38 20.76 14.85 12.16
2.52 3.02 3.08 5.69 3.74 3.1
7.61 9.03 9.31 15.06 11.11 9.06
10.92 12 12.06 19.83 15.67 10.45
Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
13.57 13.57 13.57 13.57 13.57 13.57
51.03 68.45 85.05 109.09 138.22 177.9
6.23 22.63 3.05 7.96 13.18 2.14
25.57 17.02 23.52 23.08 31.06 57.86
96.4 121.67 125.19 153.7 196.03 251.47
7.99 15.74 22.98 22.93 27.98 31.41
3.38

88.41 102.55 102.21 130.77 168.05 220.06

96.4 121.67 125.19 153.7 196.03 251.47
26.14 45.78 46.37 62.39 87.81 86.99
25.1 29.95 24.68 25.35 47.1 49.65
2.76 1.75 12.86 5.27 8.29 33.27
13568000 13568000 13568000 13568000 13568000 13568000

10 10 10 10 10 10

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

-12.18 -5.08 38.24 -12.18 4.48 45.54
-2.88 -8.9 -17.38 11.64 -4.8 -6.08
15 13.9 -20.52 3.66 2.93 -14.75
-0.06 -0.08 0.34 3.11 2.62 24.71

64 63 45 94 286 318

2 2 2 2 2 2
How to use it?
OVERVIEW
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: https://www.screener.in/excel/

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: screener.feedback@dalal-street.in
… do ANYTHING.

dalal-street.in
 Hybrid Investing Excel Analysis - Version 7.001
HOW TO USE THIS SPREADSHEET
Step 1 - This spreadsheet works only on Screener.in. The first step is to create a free account here -
https://www.screener.in/register/
Step 2 - After creating your account, while you are logged in to Screener.in website, visit this page -
https://www.screener.in/excel/ - and upload this excel file.
Step 3 - Visit the home page of Screener.in and choose a company of your choice. Once you do that, you will see details of y
chosen company. Scroll down and come to the first financial statement table called "Quarterly Results" and click on "View
Consolidated". Now, all data you see for this company will be consolidated.

Step 4 - Scroll back to the top of the page, and you will see a button "Export to Excel" on the right side. Click the button and
company's financial data will be exported in an excel file in the exact format as "Investors Delight Stock Valuation Excel Ver
Now onwards, any excel you export for any company on Screener.in will be downloaded in this very format.
Step 5 - Email me your love and testimonial for helping you with this excel. :-)

READ THESE INSTRUCTIONS BEFORE YOU START

1. DON’T change anything on "Data Sheet" tab - this is dynamic template based on which company
need is being pulled through Screener.in upload
2. If you see data is not flowing when you download excel from Screener.in, just click on "Enable Ed
on the top of your excel workbook

Data Sheet underlying data is from Screener.in

IMPORTANT INSTRUCTIONS
1. Ensure that the company whose data you are downloading has numbers at least starting from FY08 (March 2008). This is
if, for instance, the company has financials starting from, say, FY10, you will see incorrect data for FY08 and FY09 (which w
Ambuja Cement on whose financials I have created this Analysis sheet format)
2. All financial data of your chosen company will be automatically updated in the sheet you download, except "Cash and Ba
(Balance Sheet sheet) and Capex (Cash Flow sheet) figures, which you must update manually from the company's annual re
Don’t forget to make these changes as these numbers are key inputs in a few Intrinsic Value calculations.

3. You may update the sheet and add your own analysis, formulae etc. and then upload again to Screener.in site using the S
mentioned above. But DON'T touch the sheet titled "Data Sheet" because this will cause errors in your future downloads.
4. DON’T touch any cell except the black ones, where you are required to update the numbers manually from Annual Repo
Cash and Capex numbers) or where you may change the growth assumptions etc.
4. I have added Comments and Instructions wherever necessary so as to explain the concepts. Read those carefully before w
on the sheet.
5. This sheet is not a replacement of the work required to read annual reports as part of the analysis process. So please do th
with working on this sheet. You may sometime find some discrepancy in numbers (though rare), but you will know this on
you read annual reports.
6. I could not find a bug/errors in this spreadsheet, but if you notice some, please email me at - connectl@investorsdelight.in
will try to fix the same and update the sheet
7. I will keep on updating the sheet from time to time and will update the same on the website. I invite you to share your fee
and thoughts on the sheet so that we can make it better together.
8. This excel won't work for banking and financial services companies.
 Warren B

1. What is BUSINESS POSITIONING and scope?

2. What is the NETWORK EFFECT of the company?

3. What is the LEVERAGE POSITION of the company?

4. What is the OWNERSHIP STRUCTURE of promoters?

5. How is the management achieving the ECONOMIC OF SCA

6. How superior is the TECHNOLGY being offered by the com

7. Does the company have a HABIT FORMING ecosystem?

8. Is the company has COST LEADERSHIP?

9. What is the PLEDGE CAPITAL position of the company?

10. How much BRAND VISIBILITY does the Company produ

11. Does the management of the company is honest and compe

 Warren Buffett Economic Moat
D P WIRES LTD

G and scope? Monopolistic Competiti

f the company? Moderate Network
N of the company? Low Leverage
TURE of promoters? Sudden Decrease
he ECONOMIC OF SCALE? Decreasing DC & OP
being offered by the company? Decreasing R&D
ORMING ecosystem? Strong
RSHIP? Price Setter
sition of the company? Less than 15%
does the Company product have? Strong
any is honest and competent? Strongly Agree
 AVERA
D GE GO
B A OD
R
WO

B ES
ST

L
T
ECONOMIC MOAT
INDICATOR
 Monopoly 0.9 Increasing
Oligopoly 0.7 Gradually Decreasing
Perfect Competition 0.2 Stable
Monopolistic Competition 0.6 Sudden Decrease
Monopsony 0.8
Oligopsony 0.6 Decreasing DC
Natural Monopoly 1.0 Decreasing OP
Decreasing DC & OP
Increasing DC
Narrow Network 0.3 Increasing OP
Wide Network 1.0 Increasing DC & OP
Moderate Network 0.6
Increasing R&D
Highly Leverage -1.0 Decreasing R&D
Low Leverage 1.0 Stable R&D
Moderately Leverage 0.7
No Leverage 0.8 Price Setter
Price Follower
Strong 1 Average
Moderate 0.7
Insignificant 0.4 Grater than 15%
Less than 15%

0% Worst 10% L
30% Bad 30% L
50% Average 50% K
75% Good 70% J
90% Best 90% J

Bad
30% 1% 169.00%
 1 Strong 1 1 0.6
0.6 Moderate 0.7 2 0.6
0.8 Insignificant 0.4 3 1
-4 4 -4
5 1
0.7 Strongly Agree 1 6 0.4
0.8 Agree 0.6 7 1
1 Disgree -4 8 1
0.6 9 1
0.5 10 1
0.2 11 1
Score 4.6
1
0.4 42%
0.6

1
0.2
0.6

0.3
1

L
 benjamin graham Formu
D P WIRES LTD

Year Ended Mar/22

Avg 5-Yr Net Profit (Rs Crore) 25.6

PE Ratio at 0% Growth 10.0x
Long-Term Growth Rate 9.3%

Ben Graham Value (Rs Crore) 261

Current Market Cap (Rs Crore) 968

Ben Graham'sFormula: Value = EPS x (8.5 + 2G)

Here, EPS is the trailing 12-month EPS, 10x is the P/E ratio of a stock with a growth rate (g%) is the
aham Formula
RES LTD

Year Ended Mar/22

Avg 5-Yr Net Profit (Rs Crore) 25.6

PE Ratio at 0% Growth 10.0x
Long-Term Growth Rate 18.7%

Ben Graham Value (Rs Crore) 266

Current Market Cap (Rs Crore) 968

G)

ock with a growth rate (g%) is the growth rate for the next 7-10 years
*In case of
companies
earning
negative
FCF, where
this model
will not
Dhandho Intrinsic Value
work, you D P WIRES LTD
must use a
normalized
positive Dhandho - Lower Range
FCF as the Year FCF (Rs Cr) PV of FCF (Rs Cr)
starting
number. 0 Excess Cash (Latest) 33
This number 1 FY23 18 16
is your
2 FY24 21 17
assumption
of FCF the 3 FY25 24 17
business will 4 FY26 27 17
earn in a
normal year, 5 FY27 29 17
without 6 FY28 32 16
capex.
Check the 7 FY29 34 15
history of 8 FY30 36 14
this business
while 9 FY31 37 13
arriving at 10 FY32 39 13
your
10 392 126
assumption,
and use your Intrinsic Value 315
judgment Current Mkt. Cap. 968
wisely
without Premium/(Discount) to IV 207%
twisting the
model to fit
your version
of reality.
o Intrinsic Value Calculation
D P WIRES LTD

Dhandho - Higher Range

Assumed FCF Growth Year FCF (Rs Cr) PV of FCF (Rs Cr)
Year 1-3 15% 0 Excess Cash (Latest) 33
Year 4-6 10% 1 FY23 19 17
Year 7-10 5% 2 FY24 22 18
Discount Rate 12% 3 FY25 25 18
4 FY26 28 18
Assumed FCF Growth 5 FY27 31 17
Year 1-3 20% 6 FY28 34 17
Year 4-6 15% 7 FY29 35 16
Year 7-10 10% 8 FY30 37 15
Discount Rate 12% 9 FY31 39 14
10 FY32 41 13
Last 5-Years' CAGR 10 410 132
Sales 30% Intrinsic Value 328
PBT 18% Current Mkt. Cap. 968
FCF -217% Premium/(Discount) to IV 195%
 Piotroski F-Score Calc
D P WIRES LTD

Parameters (in INR,Crs) Mar-21 Mar-22

Revenue 613 1,215
F-Score
100% 9
Cost of Goods Sold 2 3
90%
Gross Margin 0.40% 0.29%
80%
Net Income 29 41
70% 7
Year End Current Assets 143 170
60%
Year End Current Liabilities 31 58
50%
Year Beginning Total Assets 154 196
40%
Year End Total Assets 196 251
30% 4
Long-term Debt 13 2
20%
Operating Cash Flow 4 46
10%
Diluted Shares Outstanding 13,568,000 13,568,000 0
0%
33
%
negative
FCF,
where this
model will
not work,
you must
use a
normalized
positive
FCF as the
starting
number.
This
number is
your
assumption
of FCF the
business
will earn
in a
normal
year,
without
capex.
Check the
history of
this
business
while
arriving at
your
assumption
, and use
your
judgment
wisely
without
twisting
the model
to fit your
version of
reality.
F-Score Calculator
D P WIRES LTD
>> F-Score
<<
Piotroski F Score Breakdown F-Score
Profitability
ROA 1
CFO 1

3
∆ ROA 1
ACCRUAL 1
Leverage, Liquidity, Source of Funds
∆ LEVERAGE 1
∆ LIQUID 0
EQ_OFFER 0

😓
Operating Efficiency
∆ MARGIN 0
∆ TURN 1
Total Score 6
Fscore 67% 33%
 Other Current
Assets
Mar-22 Mar-23
41 71
72.46% FIXED Assets
+ Mar-22
58
Mar-23
74
INVENTORY 27.86%
Mar-22
12
Mar-23
15
+
25.93%

+
Current Assets
Mar-22 Mar-23
90 113
Accounts
Receivable 25.12%
Mar-22 Mar-23
25 18
-28.70%

+ Operating Income
Cash & Mar-22 Mar-23
Equivalents 58 74
Mar-22 Mar-23
27.86%
12
-24.45%
9
-
Non-Operating
Expenses
Mar-22 Mar-23
14 16
12.61%
 Du-Point Analysis
D P WIRES LTD

D Assets Sales
Mar-23 Mar-22 Mar-23

74 115 149
29.71%

÷
7.86%

nt Assets Total Assets Assets Turnov

Mar-23 Mar-22 Mar-23
Mar-22
113 123 166
93.76%
5.12% 35.78% -419 bps

Net Profit
ng Income Net Profit Margin
Mar-22
Mar-23 Mar-22 Mar-23
37.98%
74 44 58
93 bps
7.86% 32.90%

÷
Operating Sales
penses
Mar-23 Mar-22 Mar-23

16 115 149

2.61% 29.71%
Assets Turnover
Mar-22 Mar-23
93.76% 89.56%
-419 bps RETURN ON

X INVESTMENT
Mar-22
35.61%
Mar-23
34.85%
Net Profit -76 bps
Margin
Mar-22 Mar-23
37.98% 38.91%
93 bps
 25 50
101.81%

47 50
5.41%

88 87
-0.93%

8 33
301.33%

196 251 -
28.28%

168 220
30.95%

41 55
34.74%

613 1,215
98.18%

29 41
41.17%

312.83% 483.28%
17045 bps

4.74% 3.37%
-136 bps

14.82% 16.31%
149 bps

12 14
18.67%