Nûr Retreats · Villa Dija — Investment Monitor · printed ·
Investment monitorreconciles to the sheets
6-suite luxury wellness retreat at Bahia Golf Beach Resort. Every figure below is recomputed from the bank log (snapshot of 4 Sep 2026) and the approved budget; the analyst commentary is the only hand-written text.
Headline
Budget vs spent, by section — are we on budget?
Bar = spent to date · tick = approved budget · shaded band = 90 % to 110 % of budget. Red bar and "+x % over" = overrun. The IMPREVUS bar shows the overruns of the other sections against the contingency.
Cumulative construction spend against a straight-line plan (Dhs million, excl. Foncier)
Analyst commentary
Phase status & next steps
Committed not yet paid (Dhs): · Planned completion:
Approved budget treemap — tile size = budget, colour = share consumed
Sand = little spent yet · deep terracotta = fully consumed · red outline = overrun. Click a tile to filter the table below.
Budget vs actual detail
To classify
Where the money came from and where it went (Dhs million)
Left: net funding drawn (CCA associés and loans, incl. the 2022 off-bank KEF INVEST loan that settled the land). Right: uses by budget section, other assets, lines still to classify and operating charges. The balancing item closes sources to uses.
Monthly inflows and outflows (Dhs million)
Top counterparties by net inflow — who funded the project
Net = inflows received − repayments made to the same counterparty, all bank lines (financing and other credits). Only net providers of funds are listed; the 2022 off-bank KEF INVEST loan that settled the land is included.
Top counterparties by outflow — where the money went
Gross payments, capex and other-asset lines only (bank commissions and financing repayments excluded).
Spend heatmap — quarter × section (Dhs thousand)
Small multiples — monthly spend per section, shared scale
Phase markers
Transactions
Basis. Construction budget from vBahia_STRAT_BP › TDB_Synthèse; actuals from vDija_DAF_CdG_Trésorerie › Transactions, mapped by OPERATION CATEGORY 3. Foncier is part of the approved budget (settled off-bank); financing flows and bank charges are reported outside the budget variance.
Data. Without an endpoint this file runs on the embedded snapshot of the Transactions sheet taken on 4 September 2026 (622 lines, Jan 2022 → 14 Aug 2026: individual lines from January 2026, monthly aggregates per category before that) and the TDB_Synthèse budget of the same day. Paste the Apps Script endpoint (see README) to switch to live data with a 5-minute refresh. Snapshot-mode editor password:
Limitations. Management information built from the bank log and the budget sheet as maintained by KEF; not audited accounts. Amounts in MAD, VAT as booked.
Data. Without an endpoint this file runs on the embedded snapshot of the Transactions sheet taken on 4 September 2026 (622 lines, Jan 2022 → 14 Aug 2026: individual lines from January 2026, monthly aggregates per category before that) and the TDB_Synthèse budget of the same day. Paste the Apps Script endpoint (see README) to switch to live data with a 5-minute refresh. Snapshot-mode editor password:
vdija2026 — change it before sharing (README §3).Limitations. Management information built from the bank log and the budget sheet as maintained by KEF; not audited accounts. Amounts in MAD, VAT as booked.