"""Illustrative valuation, 20 October 2026. USD billions unless specified.
Not management guidance. Expansion values are incremental, not enterprise values.
Assumes full announced project cost still to be funded: conservative proxy, not
a verified remaining-capex schedule. No project cash earnings before year three.
"""
import csv
from pathlib import Path
OUT = Path(__file__).parent
FX = 1364
SHARES = 120128915901 + 4100000000
OFFER = 525
EQUITY = SHARES * OFFER / FX / 1e9
NET_PROCEEDS = 2111007217311.09 / FX / 1e9
NET_CASH = 0.6508 + NET_PROCEEDS
EV = EQUITY - NET_CASH
rows=[]
for name,u,margin,multiple,discount in [('Bear',.80,.12,6,.18),('Base',.90,.18,8,.15),('Bull',.95,.24,10,.12)]:
    revenue=.7*365*u*100/1000
    ebitda=revenue*margin
    project_npv=ebitda*multiple/(1+discount)**3-sum(14.269/3/(1+discount)**t for t in (1,2,3))
    equity=ebitda*multiple+NET_CASH+project_npv
    rows.append(dict(case=name,utilisation=u,revenue=revenue,ebitda_margin=margin,ebitda=ebitda,multiple=multiple,discount_rate=discount,expansion_npv=project_npv,equity=equity,ngn_per_share=equity/EQUITY*OFFER,return_vs_offer=equity/EQUITY-1))
if __name__=='__main__':
    with open(OUT/'valuation-scenarios.csv','w') as f:
        w=csv.DictWriter(f,fieldnames=rows[0].keys());w.writeheader();w.writerows(rows)
    print({'equity':EQUITY,'net_cash_pro_forma':NET_CASH,'EV':EV,'scenarios':rows})
