Projected Income Statement: Qatar National Bank

Forecast Balance Sheet: Qatar National Bank

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt - - - - - - - -
Change - - - - - - - -
Announcement Date 1/13/21 1/11/22 1/12/23 1/14/24 1/13/25 - - -
Estimates

Cash Flow Forecast: Qatar National Bank

Fiscal Period: December 2019 2020 2021 2022 2023 2024
CAPEX 1 613.2 402.9 728.4 514.5 475.8 570.4
Change - -34.3% 80.8% -29.36% -7.52% 19.87%
Free Cash Flow (FCF) 1 - - - - - -
Change - - - - - -
Announcement Date 1/15/20 1/13/21 1/11/22 1/12/23 1/14/24 1/13/25
1EGP in Million
Estimates

Forecast Financial Ratios: Qatar National Bank

Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

         
EBITDA Margin (%) - - - - - - - - -
EBIT Margin (%) - 76.13% 74.65% - 85.85% 69.49% 81.02% 80.97% 80.94%
EBT Margin (%) - 62.76% 62.37% 69.11% 69.93% 82.32% 72.27% 72.37% 71.99%
Net margin (%) - 44.49% 42.72% 46.17% 45.54% 54.83% 50.95% 49.53% 49.8%
FCF margin (%) - - - - - - - - -
FCF / Net Income (%) - - - - - - - - -

Profitability

         
ROA - 2.7% 2.3% 2.46% 2.92% 3.64% 3.1% 2.99% 2.88%
ROE - 20% 17.7% 20.6% 26.88% 33.49% 27.7% 24.47% 22.77%

Financial Health

         
Leverage (Debt/EBITDA) - - - - - - - - -
Debt / Free cash flow - - - - - - - - -

Capital Intensity

         
CAPEX / Current Assets (%) - - - - - - - - -
CAPEX / EBITDA (%) - - - - - - - - -
CAPEX / FCF (%) - - - - - - - - -

Items per share

         
Cash flow per share 1 - - - - - - - - -
Change - - - - - - - - -
Dividend per Share 1 - - 0.75 - - - 2.5 2.39 2.747
Change - - - - - - - -4.4% 14.92%
Book Value Per Share 1 - 18.39 21.52 25.11 30.92 42.24 49.3 61.41 74.01
Change - - 17% 16.65% 23.18% 36.6% 16.71% 24.56% 20.52%
EPS 1 - 3.08 3.1 4.2 6.57 10.76 12.54 13.98 15.75
Change - - 0.65% 35.48% 56.43% 63.77% 16.51% 11.54% 12.61%
Nbr of stocks (in thousands) - 2,154,823 2,154,823 2,154,823 2,154,823 2,154,823 2,154,823 2,154,823 2,154,823
Announcement Date - 1/13/21 1/11/22 1/12/23 1/14/24 1/13/25 - - -
1EGP
Estimates
2025 *2026 *
P/E ratio 3.68x 3.3x
PBR 0.94x 0.75x
EV / Sales 1.72x 1.53x
Yield 5.42% 5.18%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
3
Last Close Price
46.14EGP
Average target price
64.73EGP
Spread / Average Target
+40.30%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. QNBE Stock
  4. Financials Qatar National Bank