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

Description
This bundle combines two complementary tools that professionals working on agrivoltaic pipelines end up needing together. The Agrivoltaic Ultimate Model handles the project-level analysis — a fully calibrated 20-year DCF for elevated agrivoltaic projects across 8 countries and 3 scenarios, with three agricultural revenue modes, a GCR-based shading engine 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 that includes Agri-PV and Agri-PV+BESS as distinct categories.
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 agrivoltaic deal in the Agrivoltaic 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 — selecting Agri-PV or Agri-PV+BESS as the project type. 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, Wind, BESS, Offshore Wind — the Portfolio Manager accumulates them all, keeping the portfolio view current without any extra work.


What makes the Agrivoltaic model different from a standard solar DCF
The agricultural module is the core differentiator, because elevated agrivoltaic projects have a revenue structure that no standard PV model handles correctly. Three modes cover every configuration a developer actually encounters. Zero transfers land use entirely to the farmer — the agricultural value is reported as an ESG metric without affecting project IRR, which is the right approach when the farming activity is managed independently and the developer has no contractual claim on it. Land Lease gives the developer a fixed rent per hectare per year, inflation-linked, with country-specific benchmarks pre-loaded from CREA, Wood Mackenzie and Aurora data — ranging from €300/ha/year in Australia to over €1,000/ha/year in Germany and Nordic markets. Direct Revenue models the developer managing the farming activity directly, drawing from a crop database of ten species — wheat, durum wheat, sunflower, soybean, tomato, lettuce, lavender, grass, vineyard and blueberry — each with calibrated yield, price and PAC subsidy assumptions.
The producibility engine handles the structural specifics of elevated configurations. GCR-based mode uses a shading factor lookup table built from Fraunhofer ISE and EU AgriPV research, interpolating across Ground Coverage Ratio from 0.20 to 0.50 and structure heights from 2 to 6 metres — because a 35% GCR at 4 metres clearance produces a different generation profile than the same GCR at 2 metres, and the model reflects that. CF-based mode uses country-calibrated capacity factors for rapid screening. P50 direct input accepts site-specific yield studies when available.
CAPEX is pre-loaded with an elevated structure premium over standard fixed-tilt solar — 20% in the Aggressive scenario, 25% in Base, 30% in Conservative — reflecting the additional cost of raised mounting systems that allow agricultural machinery to pass underneath. This premium is applied on top of the country-specific solar CAPEX baseline, so the all-in agrivoltaic cost is always correctly positioned relative to a standard PV reference.


Who this is for
Developers evaluating elevated agrivoltaic projects at early-stage feasibility across European and international markets, where both the PV and agricultural revenue streams need to be modelled explicitly. Financial advisors preparing lender presentations for agrivoltaic deals where the revenue stack — PPA, merchant, land lease or direct crop revenue — needs to be structured and defended. M&A teams running valuations on agrivoltaic assets where the agricultural component is a material part of the value proposition. Anyone managing a mixed renewable pipeline that includes agrivoltaic alongside conventional solar, wind or storage.


Workbook Agrivoltaic: CONTROL_PANEL · AGV_INPUTS · BESS_INPUTS · AGV_CONFIGURATION · PRODUCIBILITY_ENG · 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]