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,514 -345 -3,969
Change - 12.23% -7.97% -37.24% -13.01% -56.44% -113.72% -1,050.43%
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 2,815
Change - 60.19% 0.38% 34.16% -21.46% -8.02% -0.73% -20.72%
Free Cash Flow (FCF) 1 10,511 1,978 2,228 -224 3,484 1,932 2,665 4,941
Change - -81.18% 12.64% -110.06% 1,655.31% -44.53% 37.92% 85.39%
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% 7.85% 8.36% 8.91%
EBIT Margin (%) 5.99% 3.48% -0.41% 1.02% -0.89% 0.61% 1.66% 2.49%
EBT Margin (%) 2.85% 1.37% -2.47% 2.36% 0.06% 0.63% 1.54% 2.42%
Net margin (%) 3.12% 1.5% -1.43% 2.45% 1.09% 0.72% 1.42% 1.54%
FCF margin (%) 19.13% 3.23% 3.09% -0.3% 4.77% 2.48% 3.31% 5.86%
FCF / Net Income (%) 613.83% 215.51% -215.79% -12.37% 435.87% 346.95% 233.8% 380.54%

Profitability

        
ROA - - - - - - - -
ROE 14.76% 7.16% -8.16% 14% 5.58% 3.7% 7.2% 9.9%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 4.18% 6% 5.12% 6.7% 5.32% 4.6% 4.41% 3.34%
CAPEX / EBITDA (%) 36.91% 70.28% 102.29% 101.27% 92.96% 58.6% 52.78% 37.47%
CAPEX / FCF (%) 21.84% 185.92% 165.69% -2,210.62% 111.62% 185.1% 133.23% 56.98%

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.25 33.15 35.3
Change - 6.56% -8.79% 15.13% 6.39% 9.83% 2.79% 6.49%
EPS 1 3.4 1.82 -2.05 3.6 1.59 - 0.9 2.15
Change - -46.47% -212.64% 275.61% -55.83% - - 138.89%
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 - 150x
PBR 4.18x 4.06x
EV / Sales 0.9x 0.84x
Yield - -

EPS & Dividend

Y-o-Y evolution of P/E

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
3
Last Close Price
134.70INR
Average target price
140.50INR
Spread / Average Target
+4.31%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. PRSMJOHNSN Stock
  4. Financials Prism Johnson Limited