←
Dubai Islamic Bank
DFM: DIB · Initiation of coverage · strict model
Rating
Equal-Weight
Fair value
AED 7.98
Analyst
S. Rahman
Status
published
Model reviewer
DIB_Financial_Model_2026-08-28.xlsx · 213 editable inputs · recalculated 2026-08-28 10:27:50
Assumptions blue workbook inputs
YoY growth % - FY2026EG8
YoY growth % - FY2027EH8
YoY growth % - FY2028EI8
YoY growth % - FY2029EJ8
YoY growth % - FY2030EK8
YoY growth % - FY2026EG10
YoY growth % - FY2027EH10
YoY growth % - FY2028EI10
YoY growth % - FY2029EJ10
YoY growth % - FY2030EK10
Gross yield on average earning assets % - FY2026EG15
Gross yield on average earning assets % - FY2027EH15
Gross yield on average earning assets % - FY2028EI15
Gross yield on average earning assets % - FY2029EJ15
Gross yield on average earning assets % - FY2030EK15
YoY growth % - FY2026EG20
YoY growth % - FY2027EH20
YoY growth % - FY2028EI20
YoY growth % - FY2029EJ20
YoY growth % - FY2030EK20
Due to banks and financial institutions - FY2026EG22
Due to banks and financial institutions - FY2027EH22
Due to banks and financial institutions - FY2028EI22
Due to banks and financial institutions - FY2029EJ22
Due to banks and financial institutions - FY2030EK22
Sukuk issued (senior) - FY2026EG23
Sukuk issued (senior) - FY2027EH23
Sukuk issued (senior) - FY2028EI23
Sukuk issued (senior) - FY2029EJ23
Sukuk issued (senior) - FY2030EK23
Cost of funds on average funding % - FY2026EG26
Cost of funds on average funding % - FY2027EH26
Cost of funds on average funding % - FY2028EI26
Cost of funds on average funding % - FY2029EJ26
Cost of funds on average funding % - FY2030EK26
YoY growth % - FY2026EG34
YoY growth % - FY2027EH34
YoY growth % - FY2028EI34
YoY growth % - FY2029EJ34
YoY growth % - FY2030EK34
Income from properties held for development and sale - FY2026EG35
Income from properties held for development and sale - FY2027EH35
Income from properties held for development and sale - FY2028EI35
Income from properties held for development and sale - FY2029EJ35
Income from properties held for development and sale - FY2030EK35
Income from investment properties - FY2026EG36
Income from investment properties - FY2027EH36
Income from investment properties - FY2028EI36
Income from investment properties - FY2029EJ36
Income from investment properties - FY2030EK36
Income from other investments at FV, net - FY2026EG37
Income from other investments at FV, net - FY2027EH37
Income from other investments at FV, net - FY2028EI37
Income from other investments at FV, net - FY2029EJ37
Income from other investments at FV, net - FY2030EK37
Share of profit of associates and JVs - FY2026EG38
Share of profit of associates and JVs - FY2027EH38
Share of profit of associates and JVs - FY2028EI38
Share of profit of associates and JVs - FY2029EJ38
Share of profit of associates and JVs - FY2030EK38
Other income - FY2026EG39
Other income - FY2027EH39
Other income - FY2028EI39
Other income - FY2029EJ39
Other income - FY2030EK39
Depreciation of investment properties - FY2026EG23
Depreciation of investment properties - FY2027EH23
Depreciation of investment properties - FY2028EI23
Depreciation of investment properties - FY2029EJ23
Depreciation of investment properties - FY2030EK23
Depreciation of property and equipment - FY2026EG24
Depreciation of property and equipment - FY2027EH24
Depreciation of property and equipment - FY2028EI24
Depreciation of property and equipment - FY2029EJ24
Depreciation of property and equipment - FY2030EK24
Cost of risk (bps on avg net financing) - FY2026EG30
Cost of risk (bps on avg net financing) - FY2027EH30
Cost of risk (bps on avg net financing) - FY2028EI30
Cost of risk (bps on avg net financing) - FY2029EJ30
Cost of risk (bps on avg net financing) - FY2030EK30
Effective tax rate % - FY2026EG34
Effective tax rate % - FY2027EH34
Effective tax rate % - FY2028EI34
Effective tax rate % - FY2029EJ34
Effective tax rate % - FY2030EK34
NCI share of net profit % - FY2026EG38
NCI share of net profit % - FY2027EH38
NCI share of net profit % - FY2028EI38
NCI share of net profit % - FY2029EJ38
NCI share of net profit % - FY2030EK38
Tier 1 sukuk coupons (equity appropriation, memo) - FY2026EG41
Tier 1 sukuk coupons (equity appropriation, memo) - FY2027EH41
Tier 1 sukuk coupons (equity appropriation, memo) - FY2028EI41
Tier 1 sukuk coupons (equity appropriation, memo) - FY2029EJ41
Tier 1 sukuk coupons (equity appropriation, memo) - FY2030EK41
DPS declared for the year (fils) - FY2026EG43
DPS declared for the year (fils) - FY2027EH43
DPS declared for the year (fils) - FY2028EI43
DPS declared for the year (fils) - FY2029EJ43
DPS declared for the year (fils) - FY2030EK43
Due from banks and financial institutions - FY2026EG8
Due from banks and financial institutions - FY2027EH8
Due from banks and financial institutions - FY2028EI8
Due from banks and financial institutions - FY2029EJ8
Due from banks and financial institutions - FY2030EK8
Other investments at fair value - FY2026EG11
Other investments at fair value - FY2027EH11
Other investments at fair value - FY2028EI11
Other investments at fair value - FY2029EJ11
Other investments at fair value - FY2030EK11
Investments in associates and joint ventures - FY2026EG12
Investments in associates and joint ventures - FY2027EH12
Investments in associates and joint ventures - FY2028EI12
Investments in associates and joint ventures - FY2029EJ12
Investments in associates and joint ventures - FY2030EK12
Properties held for development and sale - FY2026EG13
Properties held for development and sale - FY2027EH13
Properties held for development and sale - FY2028EI13
Properties held for development and sale - FY2029EJ13
Properties held for development and sale - FY2030EK13
Investment properties - FY2026EG14
Investment properties - FY2027EH14
Investment properties - FY2028EI14
Investment properties - FY2029EJ14
Investment properties - FY2030EK14
Receivables and other assets - FY2026EG15
Receivables and other assets - FY2027EH15
Receivables and other assets - FY2028EI15
Receivables and other assets - FY2029EJ15
Receivables and other assets - FY2030EK15
Property and equipment - FY2026EG16
Property and equipment - FY2027EH16
Property and equipment - FY2028EI16
Property and equipment - FY2029EJ16
Property and equipment - FY2030EK16
Payables and other liabilities - FY2026EG24
Payables and other liabilities - FY2027EH24
Payables and other liabilities - FY2028EI24
Payables and other liabilities - FY2029EJ24
Payables and other liabilities - FY2030EK24
Zakat payable - FY2026EG25
Zakat payable - FY2027EH25
Zakat payable - FY2028EI25
Zakat payable - FY2029EJ25
Zakat payable - FY2030EK25
Share capital - FY2026EG29
Share capital - FY2027EH29
Share capital - FY2028EI29
Share capital - FY2029EJ29
Share capital - FY2030EK29
Tier 1 sukuk - FY2026EG30
Tier 1 sukuk - FY2027EH30
Tier 1 sukuk - FY2028EI30
Tier 1 sukuk - FY2029EJ30
Tier 1 sukuk - FY2030EK30
Other reserves and treasury shares - FY2026EG31
Other reserves and treasury shares - FY2027EH31
Other reserves and treasury shares - FY2028EI31
Other reserves and treasury shares - FY2029EJ31
Other reserves and treasury shares - FY2030EK31
Investments fair value reserve - FY2026EG32
Investments fair value reserve - FY2027EH32
Investments fair value reserve - FY2028EI32
Investments fair value reserve - FY2029EJ32
Investments fair value reserve - FY2030EK32
Exchange translation reserve - FY2026EG33
Exchange translation reserve - FY2027EH33
Exchange translation reserve - FY2028EI33
Exchange translation reserve - FY2029EJ33
Exchange translation reserve - FY2030EK33
Earning asset growth, CAGR % - BullB7
Earning asset growth, CAGR % - BaseC7
Earning asset growth, CAGR % - BearD7
Net profit margin (NFI / avg earning assets) % - BullB8
Net profit margin (NFI / avg earning assets) % - BaseC8
Net profit margin (NFI / avg earning assets) % - BearD8
Non-funded income growth p.a. % - BullB9
Non-funded income growth p.a. % - BaseC9
Non-funded income growth p.a. % - BearD9
Cost-to-income ratio % - BullB10
Cost-to-income ratio % - BaseC10
Cost-to-income ratio % - BearD10
Cost of risk (bps on avg financing) - BullB11
Cost of risk (bps on avg financing) - BaseC11
Cost of risk (bps on avg financing) - BearD11
Effective tax rate % - BullB12
Effective tax rate % - BaseC12
Effective tax rate % - BearD12
Risk-free rate (10Y UST) % - FY2021AB23
Equity risk premium % - FY2021AB24
Beta - FY2021AB25
Country/size adjustment % - FY2021AB26
Terminal growth % - FY2021AB28
Share price (AED) - FY2021AB31
Shares outstanding (m) - FY2021AB32
Terminal payout ratio (normalized) - 2026EB15
Sustainable ROTE % - 2026EB22
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A6
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A7
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A8
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A9
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A10
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A14
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A15
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A16
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A17
input - GRID 1: JUSTIFIED P/TBV VALUE — Sustainable ROTE (cols) x Cost of equity (rows)A18
Target P/E (x) applied to 2026E EPS - CountryB17
Target P/TBV (x) applied to 2026E TBVPS - CountryB18
Justified P/TBV (Gordon growth on ROTE) - WeightC5
Dividend discount model - WeightC6
Trading comparables - WeightC7
Historical multiples (10y P/E 9.4x; P/TBV 1.40x) - WeightC8
Edits write to the Excel master; every dependent figure, table and chart input recalculates.
Revenue ModelIncome StatementBalance SheetCash FlowScenariosDCF InputsDCF-DDMSensitivityCompsValuation Summary editable input estimate years Expand
Dubai Islamic Bank — Cash Flow Statement — AED millions · FY2021-2025: audited summary lines · 2026E-2030E: derived from model balance sheet movements · Blue = input/assumption · Black = actual/formula · Green = link
FY2021AFY2022AFY2023AFY2024AFY2025AFY2026EFY2027EFY2028EFY2029EFY2030E
OPERATING ACTIVITIES
Profit before income tax8,6688,4368,3958,9799,583
Add back: impairment charges, net825.471,2051,4701,5841,699
Add back: depreciation260270280290300
(Increase) in net financing assets (incl. charge-offs)-27,031-27,148-26,607-27,035-27,234
(Increase) in receivables and other assets-712.20-800-800-800-900
Increase in customers' deposits19,21128,84929,46029,82829,927
Increase/(decrease) in due to banks4,0340000
Increase in other liabilities and zakat1,2591,3701,4701,5701,670
Income tax paid-1,214-1,265-1,259-1,347-1,437
NET CASH FROM OPERATING ACTIVITIES5,9297,40920,15615,26012,9835,30010,91612,40913,06913,607
INVESTING ACTIVITIES
(Increase) in sukuk investments0-5,435-5,761-6,107-6,474
(Increase)/decrease in other investment assets, net-114.90-155-160-170-180
Purchase of property and equipment, net-250.40-255-265-275-285
NET CASH FROM INVESTING ACTIVITIES-5,700-10,203-16,005-12,688-7,777-365.30-5,845-6,186-6,552-6,939
FINANCING ACTIVITIES
Sukuk issued/(redeemed), net-5,0712,0002,0002,0002,000
Dividends paid to owners-1,445-1,807-2,168-3,348-3,373-2,534-2,751-2,896-3,041-3,258
Tier 1 sukuk coupons and NCI dividends-520-520-520-520-520
NET CASH FROM FINANCING ACTIVITIES-3,841-374.60-4,4091,262-6,206-8,125-1,271-1,416-1,561-1,778
NET CHANGE IN CASH-3,612-3,169-258.203,834-999.20-3,1903,7994,8064,9564,890
Other/balancing vs balance sheet cash (reconciliation)-154.60-155.00-155.00-155.00-155.00
Cash and balances with central banks, EOP (per BS)28,08026,48924,02026,70036,87031,91235,25639,60744,10848,543