Projected Income Statement: Prism Johnson Limited

Forecast Balance Sheet: Prism Johnson Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 10,234 11,486 10,570 6,634 5,771 2,633 -2,157 -7,175
Change - 12.23% -7.97% -37.24% -13.01% -54.37% -181.92% -232.64%
Announcement Date 19/05/21 11/05/22 10/05/23 16/05/24 15/05/25 - - -
1INR in Million
Estimates

Cash Flow Forecast: Prism Johnson Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 2,295 3,677 3,691 4,952 3,889 3,577 3,551 1,800
Change - 60.19% 0.38% 34.16% -21.46% -8.02% -0.73% -49.31%
Free Cash Flow (FCF) 1 10,511 1,978 2,228 -224 3,484 3,371 3,118 6,537
Change - -81.18% 12.64% -110.06% 1,655.31% -3.24% -7.5% 109.63%
Announcement Date 19/05/21 11/05/22 10/05/23 16/05/24 15/05/25 - - -
1INR in Million
Estimates

Forecast Financial Ratios: Prism Johnson Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 11.32% 8.54% 5% 6.61% 5.72% 8% 9.03% 9.53%
EBIT Margin (%) 5.99% 3.48% -0.41% 1.02% -0.89% 2.36% 4.68% 4.85%
EBT Margin (%) 2.85% 1.37% -2.47% 2.36% 0.06% 0.65% 2.6% 3.67%
Net margin (%) 3.12% 1.5% -1.43% 2.45% 1.09% 0.22% 1.56% 1.07%
FCF margin (%) 19.13% 3.23% 3.09% -0.3% 4.77% 4.35% 3.85% 7.85%
FCF / Net Income (%) 613.83% 215.51% -215.79% -12.37% 435.87% 2,000.59% 247.09% 734.49%

Profitability

        
ROA - - - - - - - -
ROE 14.76% 7.16% -8.16% 14% 5.58% 3.8% 9.45% 11%

Financial Health

        
Leverage (Debt/EBITDA) 1.65x 2.2x 2.93x 1.36x 1.38x 0.42x - -
Debt / Free cash flow 0.97x 5.81x 4.75x -29.62x 1.66x 0.78x - -

Capital Intensity

        
CAPEX / Current Assets (%) 4.18% 6% 5.12% 6.7% 5.32% 4.62% 4.38% 2.16%
CAPEX / EBITDA (%) 36.91% 70.28% 102.29% 101.27% 92.96% 57.68% 48.53% 22.66%
CAPEX / FCF (%) 21.84% 185.92% 165.69% -2,210.62% 111.62% 106.11% 113.87% 27.54%

Items per share

        
Cash flow per share 1 - - - - - - - -
Change - - - - - - - -
Dividend per Share 1 - - - - - - - -
Change - - - - - - - -
Book Value Per Share 1 24.66 26.28 23.97 27.6 29.36 32.65 35.6 41.9
Change - 6.56% -8.79% 15.13% 6.39% 11.19% 9.04% 17.7%
EPS 1 3.4 1.82 -2.05 3.6 1.59 1.1 3.05 4.2
Change - -46.47% -212.64% 275.61% -55.83% -30.82% 177.27% 37.7%
Nbr of stocks (in thousands) 5,03,357 5,03,357 5,03,357 5,03,357 5,03,357 5,03,357 5,03,357 5,03,357
Announcement Date 19/05/21 11/05/22 10/05/23 16/05/24 15/05/25 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 111x 39.9x
PBR 3.73x 3.42x
EV / Sales 0.82x 0.73x
Yield - -
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Trader
Investor
Global
-
Quality
-
ESG MSCI
-
More Ratings
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
4
Last Close Price
121.70INR
Average target price
154.00INR
Spread / Average Target
+26.54%
Consensus

Quarterly revenue - Rate of surprise