Assumptions blue workbook inputs
Revenue ModelIncome StatementBalance SheetCash FlowScenariosDCF InputsDCF-DDMSensitivityCompsValuation Summary editable input estimate years Expand
Dubai Islamic Bank — Earning Assets & Revenue Build — AED millions · Historicals from audited FS FY2021-2025 · Base case projections 2026E-2030E · Blue = input/assumption · Black = actual/formula · Green = link
| FY2021A | FY2022A | FY2023A | FY2024A | FY2025A | FY2026E | FY2027E | FY2028E | FY2029E | FY2030E | |
|---|---|---|---|---|---|---|---|---|---|---|
| A. EARNING ASSETS (end of period) | ||||||||||
| Net Islamic financing and investing assets | 186,691 | 186,043 | 199,453 | 212,427 | 262,055 | 288,261 | 314,204 | 339,340 | 364,791 | 390,326 |
| YoY growth % | -0.35% | 7.21% | 6.5% | 23.36% | 10% | 9% | 8% | 7.5% | 7% | |
| Investments in sukuk | 41,794 | 52,228 | 68,172 | 82,161 | 90,589 | 90,589 | 96,024 | 101,785 | 107,892 | 114,366 |
| YoY growth % | 24.97% | 30.53% | 20.52% | 10.26% | 0% | 6% | 6% | 6% | 6% | |
| Total earning assets (EOP) | 228,485 | 238,271 | 267,626 | 294,587 | 352,644 | 378,849 | 410,228 | 441,126 | 472,683 | 504,692 |
| Average earning assets | 233,378 | 252,948 | 281,106 | 323,616 | 365,746 | 394,539 | 425,677 | 456,905 | 488,688 | |
| B. FUNDED INCOME | ||||||||||
| Gross yield on average earning assets % | 5.03% | 6.81% | 6.92% | 6.04% | 5.65% | 5.3% | 5.1% | 5.1% | 5.1% | |
| Income from Islamic financing and investing transactions | 9,013 | 11,739 | 17,227 | 19,454 | 19,548 | 20,665 | 20,911 | 21,710 | 23,302 | 24,923 |
| C. FUNDING BASE (end of period) | ||||||||||
| Customers' deposits | 205,845 | 198,637 | 222,054 | 248,546 | 320,184 | 339,395 | 368,244 | 397,704 | 427,531 | 457,459 |
| YoY growth % | -3.5% | 11.79% | 11.93% | 28.82% | 6% | 8.5% | 8% | 7.5% | 7% | |
| CASA share of deposits (memo) | 38.1% | 34.3% | ||||||||
| Due to banks and financial institutions | 2,584 | 12,810 | 12,967 | 5,854 | 1,966 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 |
| Sukuk issued (senior) | 20,563 | 22,340 | 20,481 | 24,154 | 25,071 | 20,000 | 22,000 | 24,000 | 26,000 | 28,000 |
| Total funding base (EOP) | 228,992 | 233,786 | 255,502 | 278,555 | 347,222 | 365,395 | 396,244 | 427,704 | 459,531 | 491,459 |
| Average funding base | 231,389 | 244,644 | 267,028 | 312,888 | 356,308 | 380,820 | 411,974 | 443,617 | 475,495 | |
| Cost of funds on average funding % | 1.57% | 3.47% | 3.93% | 3.38% | 3.2% | 2.95% | 2.85% | 2.85% | 2.85% | |
| Depositors' and sukuk-holders' share of profit | -2,373 | -3,634 | -8,477 | -10,505 | -10,576 | -11,402 | -11,234 | -11,741 | -12,643 | -13,552 |
| NET FUNDED INCOME | 6,639 | 8,104 | 8,749 | 8,949 | 8,972 | 9,263 | 9,676 | 9,968 | 10,659 | 11,371 |
| Net profit margin (NFI / avg earning assets) % | 3.47% | 3.46% | 3.18% | 2.77% | 2.53% | 2.45% | 2.34% | 2.33% | 2.33% | |
| D. NON-FUNDED INCOME | ||||||||||
| Commissions, fees and FX income | 1,655 | 1,601 | 1,795 | 1,748 | 1,874 | 1,986 | 2,106 | 2,232 | 2,366 | 2,508 |
| YoY growth % | -3.26% | 12.11% | -2.58% | 7.18% | 6% | 6% | 6% | 6% | 6% | |
| Income from properties held for development and sale | 82.50 | 137.80 | 237.20 | 341.50 | 487.50 | 450 | 425 | 400 | 400 | 400 |
| Income from investment properties | 224.60 | 230.10 | 343.80 | 738.90 | 504.70 | 300 | 300 | 300 | 300 | 300 |
| Income from other investments at FV, net | 20.60 | 56.10 | 30.90 | 17.10 | 28.20 | 25 | 25 | 25 | 25 | 25 |
| Share of profit of associates and JVs | 115.90 | 128.30 | 214.90 | 485.30 | 381.40 | 400 | 420 | 440 | 460 | 480 |
| Other income | 683.90 | 209.30 | 294.20 | 556.10 | 1,004 | 1,000 | 800 | 800 | 850 | 900 |
| TOTAL NON-FUNDED INCOME | 2,782 | 2,362 | 2,916 | 3,887 | 4,279 | 4,161 | 4,076 | 4,197 | 4,401 | 4,613 |
| NET OPERATING REVENUE | 9,422 | 10,467 | 11,665 | 12,836 | 13,251 | 13,424 | 13,752 | 14,165 | 15,060 | 15,984 |
| YoY growth % | 11.1% | 11.44% | 10.04% | 3.23% | 1.31% | 2.44% | 3% | 6.32% | 6.14% |