Wind Ultimate Model + Portfolio Manager — From Single Project to Full Pipeline in One Purchase

Description
This bundle combines two complementary tools that most renewable energy professionals end up needing together. The Wind Ultimate Model handles the project-level analysis — a fully calibrated 20-year DCF for onshore wind across 8 countries and 3 scenarios, with turbine degradation, four configurable revenue streams and optional co-located BESS. The Portfolio Manager handles the portfolio-level view — aggregating up to 50 projects across all technologies into a single dashboard with weighted IRR, total NPV, LCOE, DSCR and a technology breakdown.
Used separately, each tool solves half the problem. Used together, they cover the full workflow from individual project evaluation to portfolio reporting.


How they work together
You run your wind deal in the Wind Ultimate Model. Once you have your Project IRR, Equity IRR, NPV, Revenue, OPEX and Debt ratio, you transfer those outputs directly into a row in the Portfolio Manager. The portfolio KPIs update immediately. No reformatting, no manual aggregation, no formula rebuilding — the output structure of the project model maps directly to the input structure of the portfolio tracker.
As you add more projects — Solar PV, BESS, Agrivoltaic, or additional wind — the Portfolio Manager accumulates them all, keeping the portfolio view current without any extra work.


What makes the Wind model different from a generic DCF template
The assumptions are already calibrated for your market. 8 countries — Italy, Spain, UK, Germany, USA, France, Australia, Nordic — each with Conservative, Base and Aggressive scenarios built from BNEF H2 2025, WindEurope 2025, Aurora Energy Research and national regulatory sources including CfD AR6, EEG 2023 and IRA PTC. You are not guessing at capacity factors or debt terms. You are starting from a credible, sourced baseline and adjusting from there.
The revenue engine reflects how wind projects actually get financed. PPA, Merchant, CfD/FiT and Balancing streams are each configurable independently, with country-specific benchmark allocations pre-loaded — because the role of CfD in the UK is not the same as in Italy, and the model reflects that. A 5% revenue haircut is applied automatically to gross revenues. Turbine degradation at 0.5% per year follows IEA Wind Task 26 methodology.
Two producibility modes are available. If you have a P50 wind resource assessment, feed it in directly in MWh/MW. If you are at screening stage, the CF-based mode gives you a calibrated estimate immediately, with typical P50 ranges documented by country in the README.
The optional BESS module evaluates co-located battery storage with a single toggle, loading CAPEX, OPEX, arbitrage and ancillary revenues automatically by country and scenario, and sizing debt on the combined Wind+BESS CAPEX at wind financing terms.


Who this is for
Developers managing a mixed pipeline who need both rigorous project-level analysis and a clean consolidated view for investment committees or partners. Financial advisors who evaluate individual wind deals and then need to show how each asset fits into a client portfolio. Anyone who is tired of maintaining a separate summary spreadsheet that goes stale every time a project assumption changes.


Workbook Wind: CONTROL_PANEL · WIND_INPUTS · BESS_INPUTS · WIND_CONFIGURATION · REVENUE_ENGINE · BESS_ENGINE · FINANCIAL_MODEL · DASHBOARD.


Workbook Portfolio Manager: Istruzioni · INPUT PROGETTI · Dashboard · Analisi Tecnologia.


For custom versions or specific requests, contact us at [email protected]