Cash Flow
Open full model inputs →Cumulative Cash Position & Net Cash per Quarter
Closing cumulative position: (JOD 3,146,511). Peak funding requirement of (JOD 4,645,265) occurs at Q4'27.
Absorption Profile — Units Sold per Quarter
Drives the receipt timing. Total scheduled: 40 of 40 units.
Quarterly Breakdown
| Quarter | Units Sold | Receipts | Outflows | Net Cash | Cumulative |
|---|---|---|---|---|---|
| Q4'26 | 0 | 0 | 3,212,491 | -3,212,491 | -3,212,491 |
| Q1'27 | 4 | 808,550 | 1,438,968 | -630,418 | -3,842,908 |
| Q2'27 | 6 | 1,212,826 | 1,136,092 | 76,733 | -3,766,175 |
| Q3'27 | 6 | 1,212,826 | 1,469,292 | -256,467 | -4,022,642 |
| Q4'27▼ PEAK | 4 | 808,550 | 1,431,173 | -622,623 | -4,645,265 |
| Q1'28 | 5 | 1,010,688 | 921,236 | 89,452 | -4,555,813 |
| Q2'28 | 5 | 1,010,688 | 336,596 | 674,092 | -3,881,722 |
| Q3'28 | 5 | 1,010,688 | 502,026 | 508,662 | -3,373,060 |
| Q4'28 | 5 | 1,010,688 | 345,790 | 664,898 | -2,708,162 |
| Q1'29 | 0 | 0 | 136,338 | -136,338 | -2,844,500 |
| Q2'29 | 0 | 0 | 122,687 | -122,687 | -2,967,187 |
| Q3'29 | 0 | 0 | 122,687 | -122,687 | -3,089,874 |
| Q4'29 | 0 | 0 | 56,638 | -56,638 | -3,146,511 |
| TOTAL | 40 | 8,085,504 | 11,232,015 | -3,146,511 |
Outflows by Cost Category
| Category | Q4'26 | Q1'27 | Q2'27 | Q3'27 | Q4'27 | Q1'28 | Q2'28 | Q3'28 | Q4'28 | Q1'29 | Q2'29 | Q3'29 | Q4'29 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Land & Acquisition | 2,280,000 | — | — | — | — | — | — | — | — | — | — | — | — | 2,280,000 |
| Substructure | 486,000 | 324,000 | — | — | — | — | — | — | — | — | — | — | — | 810,000 |
| Superstructure | — | 584,640 | 584,640 | 584,640 | 584,640 | 584,640 | — | — | — | — | — | — | — | 2,923,200 |
| MEP | — | — | 212,224 | 212,224 | 218,655 | — | — | — | — | — | — | — | — | 643,104 |
| Fitout / Specialist | — | — | — | 134,400 | 134,400 | — | — | — | — | — | — | — | — | 268,800 |
| Parking | 191,100 | 191,100 | — | — | — | — | — | — | — | — | — | — | — | 382,200 |
| Common / External | — | — | — | 198,800 | 198,800 | — | — | — | — | — | — | — | — | 397,600 |
| Preliminaries | 67,136 | 67,136 | 67,136 | 67,136 | 67,136 | 67,136 | 67,136 | 67,136 | — | — | — | — | — | 537,090 |
| Soft Costs | 133,650 | 133,650 | 133,650 | 133,650 | 89,100 | 89,100 | 89,100 | 89,100 | — | — | — | — | — | 891,000 |
| S&M and CX | 54,605 | 54,605 | 54,605 | 54,605 | 54,605 | 54,605 | 54,605 | 54,605 | 54,605 | 27,302 | 13,651 | 13,651 | — | 546,046 |
| Finance Costs | — | 83,837 | 83,837 | 83,837 | 83,837 | 125,756 | 125,756 | 125,756 | 125,756 | 52,398 | 52,398 | 52,398 | — | 1,047,963 |
| Handover | — | — | — | — | — | — | — | 165,430 | 165,430 | — | — | — | — | 330,860 |
| Year 1 Ops | — | — | — | — | — | — | — | — | — | 56,638 | 56,638 | 56,638 | 56,638 | 226,550 |
| TOTAL OUTFLOWS | 3,212,491 | 1,438,968 | 1,136,092 | 1,469,292 | 1,431,173 | 921,236 | 336,596 | 502,026 | 345,790 | 136,338 | 122,687 | 122,687 | 56,638 | 11,232,015 |
Funding Structure
All fields editable — finance cost and the funding gap recalculate.
Islamic Bank Facility
%
%
%
Investor Tranche
%
Owner Equity
Facility requiredJOD 9,136,450
Arrangement feeJOD 137,047
Bank finance costJOD 730,916
Investor returnJOD 180,000
Total finance costJOD 1,047,963
Peak Funding Gap: (JOD 4,645,265) — committed funding JOD 1,237,047 — coverage 26.6%
⚠ FUNDING SHORTFALL — project cannot proceed without additional funding
Coverage follows the V1 workbook convention, which counts the arrangement fee rather than the drawn facility as available funding. Flagged for correction in V2.
GDV
JOD 8.33M
— at baseTDC
JOD 11.28M
— at baseNet Dev Profit
(JOD 3.20M)
— at basePeak Funding Gap
(JOD 4.65M)
— at baseReturn on Cost
-28.3%
Target ≥ 15%Verdict
NOT VIABLE