Active Pipeline
12
2 New this month
Portfolio Value (CAPEX)
$4.2B
Across 3 Regions
Avg. Viability (IRR)
14.5%
0.5% vs Target
Critical Alerts
2
Requires Attention
Recent Projects
Pending Review
Islamabad Surface Water
Submission Progress
90% (Ready)
Construction Phase
Lagos Desalination Plant
EPC Progress
Delayed (-2 weeks)
Bid Stage
Cairo Wastewater Exp.
Due Diligence
On Track
New Project
Launch Configurator Wizard
Project Portfolio
Strategic Roadmap & Execution
All Projects
Africa 4
Mid-East 2
Critical
Show Risk Heatmap
Project / Details
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
TODAY
Islamabad Surface Water
Pakistan • $142M
Lagos Desalination
Nigeria • $1.2B
Cairo Wastewater Exp.
Egypt • $850M
Riyadh Potable Water
Saudi Arabia • $2.1B
Approve EPC Assumptions
Engineering team has updated the steel cost projections. Requires sign-off.
Review Legal Framework
Legal team uploaded the draft concession agreement for review.
O&M Schedule Check
Verify the maintenance downtime schedule for Year 5-10.
Approve EPC Assumptions
Assigned by Eng. Okafor • 2 hours ago
High Priority
The engineering team has revised the Civil Works CAPEX based on the latest inflation data from Lagos. Please review the highlighted changes below and approve for the Financial Model.
MetitAI Insight: The 8.2% increase in steel aligns with the global commodity index for Q3. This change will impact Project IRR by approx -0.15%.
| Variable Name | Current Value | Source | Last Updated | Trend (6M) |
|---|---|---|---|---|
| Lagos Cement Price (50kg) Material Cost • Construction |
$ 13.50 | Market Index | Today, 9:00 AM | |
| Global Steel Rebar Material Cost • Imported |
$ 850 / ton | Supplier Quote | Oct 20, 2023 | |
| Nigeria Inflation (CPI) Macro • Economic |
18.4 % | Central Bank | Yesterday |
Variable Details
Lagos Desalination
High Sensitivity
Kano Water
Low Sensitivity
Oct 24, 2023
Updated via Bloomberg API
Oct 01, 2023
Manual entry by Treasury
Report Templates
IFRIC 12 Disclosure
Standard monthly disclosure for Service Concession Arrangements. Includes Asset Roll-forward.
Compliance Monthly
Board Financial Pack
High-level P&L, Cash Flow, and KPI summary for the Board of Directors.
Executive PPT / PDF
Audit Trail Log
Detailed log of all assumption changes, user logins, and approval stamps.
Governance Security
Feasibility Study
Full financial model export including sensitivity analysis and macro assumptions.
Bid Stage Excel
Recently Generated
| Report Name | Project Context | Generated By | Date | Status | Action |
|---|---|---|---|---|---|
| Oct_2023_IFRIC12_Disclosure.pdf | Lagos Desalination | JD John Doe |
Oct 24, 2023 | Ready | |
| Q3_Financial_Model_v4.xlsx | Cairo Wastewater | SE Sarah E. |
Oct 22, 2023 | Ready |
Islamabad Surface Water Treatment (Phase II)
Capital Development Authority (CDA) • BOT Concession
Setup
2
Technical
3
Commercial
4
Sign-off
TK
Engineering & Technical Assumptions
Include SCADA Automation Suite?
Commercial & Procurement Strategy
Vendor Escalation Linked to CPI?
Force Majeure includes Political Events?
Pre-Flight Validation
Review final assumptions before generating the IFRIC 12 Model.
Key Assumptions Summary
| Total CAPEX Estimate | $142.5 M |
| Debt/Equity Ratio | 75 : 25 |
| Concession Term | 25 Years |
| Construction Period | 36 Months |
| Risk Profile (Seismic) | High (Zone 2B) |
Governance Alert: KIBOR rate assumption (22.5%) is 200bps above the 5-year average. This will severely impact DSCR in Year 1-3.
Islamabad Financial Model
Draft Scenario AIFRIC 12 Service Concession • 25 Year Term • Currency: PKR
Project IRR (Nominal vs Real)
18.2%
Real Return: 0.2% (Inflation Adj.)
Min DSCR (Bank Covenant)
1.05x
BREACH RISK
Equity NPV
($450M)
Non-Viable at current Tariff
IFRIC 12 Asset Profile (Financial vs Intangible)
The "Cash Trap" Analysis (Profit vs. Liquidity)
Stress Test Simulator
AI Recommendation:
Current structure is Non-Viable due to high KIBOR. Recommended Action: Restructure debt to 60:40 and request Tariff Indexation.
Project Architect
Form Elements
Text Input
Data Grid (Yr 1-30)
Currency Field
File Upload
Logic
Approval Gate
Team Assignment
-- Drag and Drop elements here to build the EPC Workflow --
Financial Asset (Receivable) Profile
Profit vs. Cash Flow (The "Cash Trap")
Scenario Sandbox
Calculated IRR
14.2%
Status: Viable