Business question
Project investment decisions need more than a headline return: assumptions, build costs, funding, operating performance and valuation must remain traceable through one model.
← Back to selected work
FP&A model portfolio
Financial Planning, Scenario Modelling & Management Reporting
A portfolio of integrated project models connecting assumptions, cost phasing, funding, financial statements, valuation and return sensitivities.
The brief
From business question to decision-ready view.
The approach
- Created controlled scenario and assumption inputs.
- Connected cost phasing and operating drivers to financial statements, cash flow and funding.
- Calculated FCFF, DCF, NPV, IRR, payback and sensitivity views.
- Presented the model outputs in executive dashboards while retaining auditable supporting schedules.
What the sample data shows
Figures below describe the displayed portfolio dataset, not a client outcome.
- One displayed project scenario shows SAR 45.0M investment, SAR 41.22M NPV, a seven-year payback and a 20% project return.
- A second displayed model shows SAR 153.73M revenue, SAR 62.27M project profit, SAR 19.94M NPV and a 3.75-year payback.
- The valuation example compares DCF and market-comparable techniques before presenting a blended illustrative equity value.
Decisions this supports
- Whether project returns remain acceptable under downside assumptions
- How construction timing and funding choices affect cash availability
- Which valuation, payback or sensitivity signal should guide the investment decision
Analysis walkthrough
A model story, not just a dashboard.
Each layer is connected so decision-makers can trace an executive result back to the operating and financial assumptions that produced it.
Set the drivers
Choose business, pricing, cost, capacity and funding assumptions in a controlled input layer.
Build the forecast
Phase project costs and connect operating assumptions to the income statement, working capital and cash flow.
Value the project
Calculate FCFF, discount cash flows and compare DCF with market-based valuation techniques.
Test the downside
Review payback, IRR and valuation sensitivity under alternative price, CAPEX and cost scenarios.
Support the decision
Summarize investment, funding, return and break-even signals in an executive project view.
Model walkthrough
Follow the model from assumptions to returns.
The views below show the model mechanics as well as the executive output: inputs, calculations, cash and funding, valuation, payback and sensitivity.
FP&A model view
Project returns overview
Executive view of investment, NPV, discounted cash flow, payback, IRR and the effect of price and CAPEX changes.
Start a conversation
Have a similar reporting or modelling question?
Share the decision you need to support and the data or report you already have.