Resilience ROI & Funding Case for CFO
N.B. Upload a time-series dataset with unique Period keys; declare whether values are actuals or include estimates. Confirm if leap periods or 53-week years exist and whether to normalize them.
📄 Prompt Template
Build a quantified investment case for resilience initiatives totaling [InvestmentAmount]. Model expected loss reduction ([RiskReductionPct]), service uplift, working capital effects, and EBIT sensitivity; ensure payback meets [PaybackThreshold]. Present base/optimistic/conservative cases and an options portfolio with staged releases, aligned to a board review on [BoardDate].
Output format: (1) “Financial_Model” markdown table with columns: Initiative; Capex; Opex; VaR Reduction ($/€); OTIF Gain (%pts); WC Δ; EBIT Δ; Payback (months); IRR. (2) Scenario analysis table (Base/Up/Down) with NPV and break-even volumes. (3) Executive one-pager bullets: decision asks, risks, and next steps.