Grand Master Report
Master Report & Client Engagement Suite
App walkthrough · data dictionary · optimizer methodology · results audit · client engagement protocol
Section 1
App Walkthrough & User Explainer
A guided tour of every page in the order an executive would navigate — what each shows and how to use it.
1
Executive Dashboard · Dashboard
Portfolio-level financial overview: CAPEX waterfall, EBITDA uplift, payback, and energy use intensity. Adjust portfolio levers (solar, BESS, DC, fleet) and watch all metrics recalculate instantly.
2
Scenario Comparison · Compare
Save the active scenario and compare it side-by-side with alternatives. Every metric shows the delta between configurations.
3
Assumptions Catalog · Assumptions
Every CAPEX, OPEX, revenue, and tariff assumption with its source basis. Verified IEC bill inputs are flagged with a verification badge.
4
Cash Flow Projections · Cash Flow
Quarterly and annual cash flow over 10 years, with optional degradation modeling (solar fade + battery augmentation) and lifecycle projections.
5
Bill of Materials · Bill of Materials
Itemized procurement list — modules, inverters, battery racks, DC containers, V2G chargers, gas turbines — with quantities and unit costs scaled to the active scenario.
6
Sensitivity & Monte Carlo · Sensitivity
Scenario matrix heatmap across parameter combinations, plus probabilistic Monte Carlo simulation (P10/P50/P90) with payback probability distributions.
7
Load Profiles · Load Profiles
Hourly supply-versus-load charts for each season. Toggle between synthetic benchmark and real measured Kiryat Gat data (8,760 hours).
8
Sites & Engineering · Sites & Engineering
Interactive Israel map with all 10 facilities, per-site engineering specs (solar, BESS, DC, CCGT), architectural drawings, and grid connection details.
9
Project Gantt · Gantt
14-workstream implementation schedule over 80 weeks with milestones: Financial Close, First Site Energized, Full VPP Operational, Portfolio Complete.
10
Development Phases · Development
Phase tracker from feasibility through handover, with deliverables, owners, and status for each development stage.
11
Partners & Compliance · Partners & Compliance
Regulatory and partner checklists — IEC grid connection, NOGA MSP integration, TAOZ registration, environmental permits.
12
Report Library · Report Library
Save and retrieve any scenario variation as a named report with auto-applied naming convention.
13
Investment KPIs · Investment KPIs
Capital structure levers (D/E, WACC), levered IRR, NPV, MOIC, ROE, and LCOE/LCOSE benchmarking against Lazard, IRENA, and Israeli market rates.
14
Constraints · Constraints
Physical and regulatory constraint envelope — rooftop area, grid capacity, V2G participation limits, gas pipeline availability.
15
Portfolio Optimizer · Optimizer
Multivariate optimization maximizing a weighted composite of IRR, ROE, MOIC, payback, and scale. Client-side Latin-hypercube + coordinate ascent, or high-fidelity backend solver.
16
Sources · Sources
Index of all 15+ data source files and the V2 data-request questionnaire tracker for real Flying Cargo site data.
17
Master Report (this page) · Master Report
The grand-master deliverable: app walkthrough, data dictionary, optimizer methodology, results audit, and client engagement protocol.
Section 2
Data Point Dictionary
Every model output indexed by page and workflow order, with its live formula and input sources.
Dashboard — Portfolio Capacity
Total Solar CapacitytotalSolarMWp
solarMWpPerSite × activeSites = 2 × 10 = 20 MWp
Total BESS CapacitytotalBatteryMWh
batteryMWhPerSite × activeSites = 4 × 10 = 40 MWh
Total Modular DC LoadtotalDCKW
dataCenterKWPerSite × activeSites = 500 × 10 = 5,000 kW
Dashboard — Fleet & V2G
V2G-Capable Vehiclesv2gVehicles
totalVehicles × v2gParticipation = 360 × 65% = 234
V2G Daily Discharge Poolv2gTotalMWh
(v2gVehicles × avgUsableKWh × v2gHoursDischarge) / 1000 = (234 × 61 kWh × 3.5h) / 1000 = 50.5 MWh
Dashboard — CAPEX Breakdown
Solar PV CAPEXcapexSolar
totalSolarMWp × capexPerSolarMWp = 20 × ₪3.2M = ₪64.0M
BESS CAPEXcapexBattery
totalBatteryMWh × capexPerBatteryMWh = 40 × ₪1.4M = ₪58.0M
Modular DC CAPEXcapexDC
totalDCKW × capexPerDCkW = 5,000 × ₪10K = ₪47.5M
V2G Fleet CAPEXcapexV2G
v2gVehicles × capexPerV2GVehicle = 234 × ₪38K = ₪8.9M
CCGT Gas Turbine CAPEXcapexCCGT
ccgtTotalMW × ccgtCapexPerMW = 20.0 × ₪4.5M = ₪90.0M
Total CAPEXcapexTotal
Solar + BESS + DC + V2G + CCGT = ₪64.0M + ₪58.0M + ₪47.5M + ₪8.9M + ₪90.0M = ₪270.7M
Dashboard — OPEX
Annual OPEX (non-gas assets)opexAnnual
(capexTotal − capexCCGT) × opexRate = ₪180.7M × 1.8% = ₪3.2M
CCGT Gas Fuel + Fixed O&MccgtGasOpex
(ccgtGenMWh × 1000 × heatRate × gasPrice) + (ccgtTotalMW × fixedOM) = ₪73.6M + ₪3.6M = ₪77.2M
Dashboard — Generation
Annual Solar GenerationsolarGenMWh
(totalSolarMWp × 1000 × solarYield) / 1000 = (20 × 1000 × 1750) / 1000 = 35000 MWh
Solar Self-ConsumptionsolarSelfMWh
solarGenMWh × 70% = 35000 × 0.70 = 24500 MWh
Solar ExportsolarExportMWh
solarGenMWh × 30% = 35000 × 0.30 = 10500 MWh
Dashboard — Tariff
Blended Import PriceblendedImport
peak×0.35 + shoulder×0.30 + offPeak×0.35 = 1.51×0.35 + 0.84×0.30 + 0.42×0.35 = 0.927
Dashboard — Savings & Revenue
Solar Self-Consumption SavingssolarSavings
solarSelfMWh × 1000 × blendedImport = 24500 × 1000 × 0.927 = ₪22.7M
Arbitrage EnergyarbitrageMWh
— see model —
Arbitrage SavingsarbitrageSavings
arbitrageMWh × 1000 × (peak − offPeak) = 28799 × 1000 × 1.090 = ₪31.4M
Solar Export RevenueexportRevenue
solarExportMWh × 1000 × offPeak × 0.80 = 10500 × 1000 × 0.42 × 0.80 = ₪3.5M
CCGT Self-Generation SavingsccgtSavings
ccgtSelfMWh × 1000 × blendedImport = 73584 × 1000 × 0.927 = ₪68.2M
CCGT Export RevenueccgtExportRevenue
ccgtExportMWh × 1000 × offPeak × 0.80 = 31536 × 1000 × 0.42 × 0.80 = ₪10.6M
CCGT Net ContributionccgtNetContribution
ccgtSavings + ccgtExportRevenue − ccgtOpex = ₪68.2M + ₪10.6M − ₪77.2M = ₪1.7M
DC Reseller RevenuedcResellerRevenue
dcEnergyMWh × 1000 × dcResellerMargin = 37230 × 1000 × 0.42 = ₪15.6M
Dashboard — Benefit
Gross Annual BenefitgrossBenefit
solarSavings + arbitrageSavings + exportRevenue + dcResellerRevenue + ccgtSavings + ccgtExportRevenue = ₪22.7M + ₪31.4M + ₪3.5M + ₪15.6M + ₪68.2M + ₪10.6M = ₪152.1M
Net Annual BenefitnetBenefit
grossBenefit − opexAnnual − ccgtOpex = ₪152.1M − ₪3.2M − ₪77.2M = ₪71.7M
Dashboard — Financial Impact
Facility RevenuefacilityRevenue
totalSqm × facilityRevenuePerSqm = 272,000 × ₪2K = ₪503.2M
Baseline EBITDAbaselineEbitda
facilityRevenue × 16.5% = ₪503.2M × 0.165 = ₪83.0M
EBITDA UpliftebitdaUplift
= netBenefit = ₪71.7M
New EBITDAnewEbitda
baselineEbitda + ebitdaUplift = ₪83.0M + ₪71.7M = ₪154.8M
EBITDA MarginebitdaMargin
(newEbitda / facilityRevenue) × 100 = (₪154.8M / ₪503.2M) × 100 = 30.8%
Net Profit UpliftnetProfitUplift
(newEbitda − baselineEbitda) × 0.62 = ₪71.7M × 0.62 = ₪44.5M
Net Profit % UpliftnetProfitPctUplift
(netProfitUplift / baselineNetProfit) × 100 = (₪44.5M / ₪51.5M) × 100 = 86.4%
Dashboard — Efficiency
Energy Use Intensityeui
(totalLoadMWh × 1000) / totalSqm = NaN / 272,000 = 255
Payback PeriodpaybackYears
capexTotal / netBenefit = ₪270.7M / ₪71.7M = 3.8 yrs
Cost of Energy / RevenuecoePctRevenue
(newCoE / facilityRevenue) × 100 = (₪0 / ₪503.2M) × 100 = 0.0%
Investing — Capital Structure & Levered Returns
Weighted Avg Cost of Capitalwacc
E/V·Re + D/V·Rd·(1−tax) = 71.4%×10.0% + 28.6%×6.0%×0.77 = 8.46%
Debt FundingdebtAmount
capexTotal × D/(D+E) = ₪270.7M × 28.6% = ₪76.7M
Equity FundingequityAmount
capexTotal × E/(D+E) = ₪270.7M × 71.4% = ₪206.9M
Levered IRR (Equity)irr
IRR of levered FCFE series (Yr0 = −equity, Yr1..10 = netBenefit − after-tax interest − principal + 5% salvage) = 27.2%
Levered NPV (at WACC)npv
Σ FCFEₜ / (1+WACC)ᵗ = ₪205.7M
MOIC (Equity Multiple)moic
total distributions / equity invested = ₪634.7M / ₪206.9M = 3.07×
Return on Equityroe
(netBenefit − annualInterest) × (1−tax) / equity = (₪71.7M − ₪4.6M) × 0.77 / ₪206.9M = 25.0%
Investing — LCOE / LCOSE
Levelized Cost of Energylcoe
(capexTotal + totalOpex×15yr) / (deliveredMWh×15yr) = ₪1.48B / 1471260 = 1004 ₪/MWh
Levelized Cost of Storagelcose
(capexBattery + opexBattery×15 + augment) / (dischargedMWh×15) = ₪82.4M / 431979 = 191 ₪/MWh
Section 3
Optimizer Methodology
How the optimizer arrives at the optimal result, and what can be improved to meet the client's needs.
Decision Variables
Solar MWp / site0.5–4.0 MWp
BESS MWh / site1–10 MWh
V2G participation20–90%
CCGT MW / gas site0–10 MW
Debt-to-Equity0–1.0
Arbitrage hours2–8h/day
Algorithm Steps
1.
Latin-Hypercube Sampling
Stratified sampling across decision-variable bounds ensures full search-space coverage with fewer evaluations than random sampling.
2.
Coordinate Ascent
From each start, probe ±one step on each lever; move to the best feasible improvement. Repeat until no lever improves the score.
3.
Multi-Start (6–16 starts)
Independent LHS starts + a climb from the current config — the optimizer never returns something worse than the existing setup.
4.
Constraint Enforcement
Every candidate is checked against the physical/regulatory envelope (rooftop, grid, gas pipeline). Infeasible candidates are discarded.
5.
Composite Scoring
Weighted: IRR + ROE + MOIC + 1/Payback + Scale. The scale weight prevents portfolio shrinkage.
Improvement Levers
- Raise IRR/ROE: Increase D/E ratio (leverage amplifies equity returns), expand solar capacity, or switch to dynamic MSP tariff.
- Reduce Payback: Lower BESS capacity (biggest CAPEX lever), add CCGT for self-generation, or reduce DC modular capacity.
- Increase NPV: Extend arbitrage hours, increase V2G participation, or scale to more sites.
- Improve MOIC: Scale the portfolio (more sites = more total distributions), or optimize capital structure.
- High-Fidelity Solver: Backend multi-start LHS + coordinate ascent with 8 passes per start — more thorough than client-side preview.
Section 4
Results Audit — High / Baseline / Low
The audit classifies the current scenario against client-stated financial targets. Set thresholds below to recalculate.
Audit Verdict
High
Clears all client target thresholds
5/5
Thresholds Met
Client Target Thresholds
KPI Traffic-Light Matrix
| KPI | Value | Target | Gap | Status |
|---|---|---|---|---|
| Levered IRR | 27.2% | 15.0% | +12.2% | |
| Return on Equity | 25.0% | 20.0% | +5.0% | |
| MOIC (Equity Multiple) | 3.07× | 1.50× | +1.57 | |
| Payback Period | 3.8 yrs | 5 yrs | +1.23 | |
| Levered NPV | ₪205.7M | ₪5.0M | +₪200.7M |
Section 5
Client Engagement Protocol
Secured sharing, client training, feedback collection, and report upgrade — the train-review-upgrade loop.
1
Share
Password-protected link OR branded email
2
Train
Client reads the walkthrough & audit
3
Feedback
Client submits per-section comments
4
Review
Builder triages feedback in the inbox
5
Upgrade
Apply feedback, re-run audit, regenerate
Share Report with Stakeholders
Feedback Inbox (0)
No client feedback yet. Share the report to collect feedback.
