How to Build a Bankable Onshore Wind Financial Model
Updated: Aug 31
An onshore wind project can look attractive when expected annual generation is multiplied by an electricity price, yet that simple calculation says very little about whether the project can repay debt or deliver the required investor return. The real challenge is that wind generation, grid availability, construction costs, electricity revenues and financing terms all affect one another. A bankable onshore wind financial model solves this by converting supported technical and commercial assumptions into net generation, project revenue, lifecycle costs, Cash Flow Available for Debt Service (CFADS), debt capacity and investor returns. The model should also show how those results change under credible downside scenarios, allowing developers, lenders and investors to judge whether the project remains financeable when assumptions weaken.
For Irish onshore wind developers, this connection between technical evidence and cash flow is particularly important. Grid constraints, RESS support, Corporate PPAs, merchant electricity prices and financing costs can materially affect the investment case. A financial model therefore needs to reflect the actual project rather than a generic wind-farm template.
What Makes an Onshore Wind Financial Model Bankable?
A financial model becomes useful for project finance when a lender or investor can trace the main assumptions back to credible evidence, understand how each assumption affects cash flow and test the project under alternative cases. Bankability is therefore less about the number of worksheets and more about the quality of the assumptions, financial logic, contract links and downside analysis.
Start With Traceable Project Assumptions
Every material model input should have a defensible source. The wind-resource assumptions should come from the project's technical assessment; turbine and construction costs should reflect supplier, engineering or procurement information; revenue should follow the applicable PPA, RESS rules or market assumptions; and debt terms should match the lender term sheet.
A useful assumptions register might look like this:
Model input | Supporting source |
P50 and P90 energy yield | Independent energy-yield assessment |
Turbine price | Turbine supply proposal or contract |
Balance of Plant cost | EPC / engineering estimate |
Grid cost and timing | Connection documentation |
PPA revenue | PPA or commercial Heads of Terms |
RESS revenue | Applicable RESS Terms and Conditions |
O&M costs | LTSA / O&M agreement |
Land payments | Lease agreement |
Debt assumptions | Financing term sheet |
Tax assumptions | Project-specific tax advice |
The current IEC 61400-15-1:2025 standard places clear emphasis on assessing, documenting, and tracing site conditions for wind-power plants, including long-term meteorological conditions and their relationship with turbine and balance-of-plant characteristics. That technical discipline should carry into the financial model: material numbers should have an identifiable basis.
Keep the Model Structure Clear
A large spreadsheet is not automatically bankable. A reviewer should be able to move logically from inputs to calculations and then to decision outputs. A practical structure might include separate sections for assumptions, project timeline, energy production, revenue, costs, construction, tax, financing, debt, financial statements, cash waterfall, returns, sensitivities and model checks.
The principle is simple:
Inputs → calculations → cash flow → financing metrics → investment outputs
The research supporting this article identifies the same financial chain: site and wind-resource data feed P50/P90 generation, which then drives revenue, costs, CFADS, debt sizing, coverage ratios, and investor returns. Hard-coded outputs should be kept to a minimum. If changing the Commercial Operation Date requires manual amendments across several worksheets, or changing P90 generation does not automatically flow into revenue and debt ratios, the model becomes difficult to review and easier to break.
Build the Bankable Energy-Yield Case
For an onshore wind project, generation is the foundation of almost every major financial output. Overstating annual energy production increases revenue, CFADS, debt capacity and IRR at the same time. The energy section of the model therefore needs to reflect the independently assessed production case rather than a simple installed-capacity calculation.
Start With the Wind Resource and Energy-Yield Assessment
The financial modeller does not need to recreate the wind engineer's work. Instead, the model should translate the output of the technical assessment into a financial production schedule.
Model P50 and P90 Without Treating Them as Fixed Lender Rules
Probability-based energy cases help show uncertainty in expected wind-farm production.
In simple terms:
P50 represents a central or median energy-yield case.
P90 represents a more conservative generation case with a higher probability of being exceeded.
Other cases such as P75 may also be used depending on the project and financing analysis.
A common modelling mistake is to state that P50 is always the equity case and P90 is always the lender case. The actual approach depends on the financing structure, lender methodology, revenue profile and technical assessment.
What matters financially is the relationship:
Lower energy yield → lower electricity revenue → lower CFADS → weaker debt coverage
Your model should therefore allow the selected generation case to flow through the entire project automatically. The underlying research similarly links P90 with lower output, lower CFADS and reduced debt capacity rather than treating P90 as an isolated technical statistic.
Convert Gross Energy Into Net Exported Generation
Lenders care about the energy that can actually generate project revenue. The model should therefore include a transparent gross-to-net energy bridge.
A typical structure is:
Gross Annual Energy Production
minus:
wake losses;
turbine availability losses;
electrical losses;
environmental or operational losses;
curtailment;
applicable grid constraints;
other supported losses;
equals:
Net Annual Energy Production
The financial model can then apply the relevant revenue assumptions to the net MWh.
This is stronger than starting with:
Installed MW × 8,760 hours × assumed capacity factor
because a single capacity-factor assumption can hide the individual technical losses that determine the final revenue-producing output.
Capacity factor remains a useful output check:
Capacity Factor = Annual Energy Production ÷ (Installed Capacity × 8,760)
but it should generally be the result of a supported production case rather than a substitute for the underlying energy assessment.
Treat Curtailment and Grid Constraints Separately
For an Irish onshore wind project, grid-related output reductions deserve explicit modelling. EirGrid publishes renewable dispatch-down data and distinguishes constraint and curtailment information within its system reporting. Its Constraint Forecast Studies also estimate possible dispatch-down across different future network and generation scenarios so developers can assess potential constraint exposure.
The model should therefore avoid using one unexplained percentage labelled simply “grid loss.”
Where the information supports it, separate:
curtailment;
local network constraints;
technical availability;
electrical losses;
compensated lost generation;
uncompensated lost generation.
This distinction becomes particularly important when the revenue contract or support scheme treats different forms of unavailable generation differently.
Build Revenue From the Actual Route to Market
Once net generation has been established, the next question is what each MWh earns. A bankable model should reproduce the project's actual revenue structure rather than applying one fixed tariff across the operating life.
Model Contracted Revenue According to the Contract
An Irish wind project may have revenue supported by RESS, a Corporate PPA or another offtake arrangement.
If the project participates in RESS, the model should reflect the applicable competition and payment mechanics rather than inserting a generic €/MWh support value. EirGrid currently operates RESS auctions, including qualification, and publishes the documentation for current competitions such as RESS 6.
Depending on the applicable RESS terms, relevant modelling inputs may include:
Offer or Strike Price;
market-reference assumptions;
indexation;
support period;
payment mechanics;
applicable treatment of unavailable generation.
There is no reason to reproduce the entire RESS framework inside the model documentation. The key requirement is that the revenue calculation matches the scheme applying to that project.
For a Corporate PPA, model the actual contract terms, including price, volume structure, indexation, tenor, balancing allocation and route-to-market costs. The headline PPA price alone is not enough.
Use Wind Capture Prices for Merchant Revenue
Merchant revenue needs particular care because wind farms do not necessarily receive the average wholesale electricity price. Wind generation is concentrated in certain hours. If market prices are lower during periods of high wind production, the project's realised capture price can sit below the baseload or average wholesale price.
The model should therefore distinguish:
Wholesale baseload price ≠ wind capture price
Where merchant exposure is material, use an appropriate power-price curve and technology-specific capture-price assumptions rather than applying one annual market price to every MWh. The same principle matters for a project with partial contracted revenue. Contracted output may earn a PPA or support price while residual production remains exposed to market prices.
Model the Merchant Tail Separately
A project's operating life may extend beyond its PPA or support period. If a wind farm has a 30-year operating case but only 15 years of contracted revenue, the remaining period requires a separate price assumption. That period is commonly referred to as the merchant tail. The model should therefore switch revenue regimes automatically:
contracted/support period → merchant period
rather than continuing the contracted tariff beyond its actual expiry.
Merchant-tail assumptions can materially affect NPV and Equity IRR, especially where a large proportion of project value sits beyond the contracted period. Use a separate downside power-price case rather than assuming the base merchant curve is certain.
Model the Full Lifecycle Cost and Construction Case
A bankable model needs more than turbine CAPEX and annual O&M. Development expenditure, construction timing, financing costs, ongoing operating expenditure and end-of-life obligations all affect the cash required from investors and lenders.
The complete cost chain is better viewed as:
DEVEX + CAPEX + OPEX + ABEX → lifecycle project cost
Your competitor research identifies the same relationship and shows why development and abandonment costs should sit alongside the more commonly modelled CAPEX and OPEX.
Build Development and Construction Costs From Real Cost Categories
Development expenditure can include land, planning, environmental work, wind measurements, technical studies, grid studies, legal costs, advisory costs and project management.
Construction CAPEX may include:
wind turbine supply;
transport and installation;
foundations;
civil works and roads;
electrical Balance of Plant;
cabling;
substation works;
grid connection;
owner's costs;
construction management;
contingency.
Breaking CAPEX into meaningful categories improves sensitivity analysis. If turbine prices increase by 8%, for example, the model should not require the modeller to increase unrelated grid and civil costs by the same percentage.
Model the Construction S-Curve and Funding Timing
Construction spending does not occur on one date. Turbine deposits may be paid before delivery, civil works may begin months before erection, and grid payments can follow a separate schedule.
A good model links:
Construction milestone → CAPEX payment → funding drawdown → interest during construction
This matters because the timing of expenditure changes both the peak funding requirement and interest during construction, or IDC. A project with €100 million of total CAPEX does not have the same financing requirement if most expenditure occurs early rather than late. The underlying competitor research also identifies construction drawdown and the S-curve as direct drivers of debt/equity funding and IDC.
Include Operating and End-of-Life Costs
OPEX may include turbine O&M, land rent, insurance, asset management, market costs, administration and other recurring project charges. Separate fixed and variable costs where the contract supports that distinction. Apply the relevant escalation mechanism rather than automatically increasing every OPEX line by one generic inflation rate. The model should also consider end-of-life obligations where material, including decommissioning, site restoration and any required reserve. Salvage value should be included only where there is a supportable basis for it.
Convert Project Cash Flow Into Debt Capacity
This is where an ordinary investment model becomes a project-finance model. The question is no longer simply whether the project produces positive cash flow; it is how much debt that cash flow can sustainably service while meeting lender requirements.
Start With Sources and Uses
The financing schedule should reconcile the total amount the project needs with the funds available.
Uses can include:
development expenditure;
construction CAPEX;
contingency;
financing fees;
IDC;
reserve-account funding;
working-capital requirements where relevant.
Sources may include:
senior debt;
sponsor equity;
shareholder or subordinated funding;
other project-specific funding.
The first financing check is simple:
Total Sources = Total Uses
Debt and equity drawdowns should then follow the project construction schedule rather than being assumed to arrive entirely at financial close.
Calculate CFADS Clearly
Cash Flow Available for Debt Service (CFADS) is one of the central outputs in project finance because scheduled principal and interest are paid from project cash rather than accounting profit.
A simplified bridge is:
Revenue
− operating cash costs− cash taxes± working-capital adjustments− other financing-defined adjustments
= CFADS
The exact CFADS definition should follow the financing documents.
Accounting EBITDA and CFADS should not be treated as interchangeable. Non-cash accounting items, tax payments, working capital and other financing adjustments can cause the two to differ. The uploaded research similarly links revenue and operating costs to CFADS, then connects CFADS directly to debt capacity and the repayment profile.
Size and Sculpt Debt Using Cash Flow
Project debt may be constrained by several factors:
maximum gearing;
available CFADS;
required DSCR;
loan tenor;
lender downside case;
contracted-revenue period;
project life;
financing policy.
Avoid inserting a universal “bankable” gearing or DSCR assumption. The acceptable level depends on the key project's risk profile and lender requirements. Where the financing uses debt sculpting, scheduled debt service can be shaped around CFADS.
A simplified relationship is:
Permitted Debt Service ≈ CFADS ÷ Target DSCR
Then:
Principal Repayment = Debt Service − Interest
The result is a debt schedule that follows the project's capacity to pay rather than forcing equal annual principal repayments.
Understand DSCR, LLCR and Reserve Accounts
Debt Service Coverage Ratio (DSCR) measures periodic debt-service capacity:
DSCR = CFADS ÷ scheduled debt service
where scheduled debt service generally includes principal and interest under the relevant financing definition. Loan Life Coverage Ratio (LLCR) provides a longer-term view by comparing the present value of CFADS available during the remaining loan life with outstanding debt.
The distinction matters:
DSCR focuses on individual debt-service periods.
LLCR considers debt coverage over the remaining loan term.
Your supplied entity research makes the same distinction, defining DSCR against principal and interest while LLCR uses the present value of loan-life CFADS relative to outstanding debt. The model may also include a Debt Service Reserve Account (DSRA), maintenance reserve, decommissioning reserve, and distribution lock-up provisions where required by financing terms.
These should feed into a clear cash waterfall:
Revenue → operating costs → taxes → debt service → required reserves → permitted distributions
Integrate the Model and Measure Investor Returns
Once generation, revenue, costs, and debt are connected, the model can calculate the outputs used by shareholders and investment committees. Debt metrics and investor returns should remain conceptually separate because they answer different questions.
Link the Three Financial Statements
A full project-finance model will often integrate:
Income Statement: Revenue, OPEX, depreciation, interest, tax and net income.
Balance Sheet: Project assets, debt, cash, reserves, working capital and equity.
Cash Flow Statement: Operating, investing and financing cash movements.
The statements should reconcile automatically. Your supplied research also stresses that the Income Statement, Balance Sheet and Cash Flow Statement should be fully linked rather than independent forecasts.
Separate Project IRR From Equity IRR
Project IRR generally measures the return generated by the underlying project before the effect of shareholder financing, based on the chosen model convention.
Equity IRR measures the return earned on shareholder cash invested and distributions received.
The two should not be used interchangeably.
Debt can increase Equity IRR where project returns exceed financing costs, but additional leverage also increases fixed debt obligations and reduces the cash-flow cushion available when project performance weakens.
NPV can provide another useful valuation measure, while LCOE can help compare the lifetime cost of different project or design cases. IRENA's current cost work continues to show that onshore-wind economics are sensitive to installed costs, capacity factor, O&M and financing conditions. LCOE remains useful for comparison, but it does not tell a lender whether annual CFADS can meet scheduled debt service. Renewable energy regulation in Ireland is a connected system rather than a single permit.
Stress-Test the Model Before Calling the Project Bankable
The base case tells investors what happens if the central assumptions occur. Bankability requires understanding what happens when they do not. A useful sensitivity framework should test both individual variables and combined downside cases.
Test the Main Project Risks
Core wind-finance sensitivities can include:
P50 versus more conservative energy cases;
lower availability;
higher curtailment or constraints;
lower capture prices;
lower merchant-tail prices;
CAPEX overrun;
construction delay;
higher OPEX;
higher interest rates;
reduced gearing;
shorter debt tenor.
Each sensitivity should affect the outputs that matter.
For example:
Lower generation → lower revenue → lower CFADS → lower DSCR → lower Equity IRR
and:
CAPEX overrun → larger funding requirement → higher debt/equity need → potentially higher IDC → lower returns
The competitor research highlights these same links, including the effect of CAPEX overruns, higher rates and lower power prices on debt capacity, DSCR and IRR.
Avoid Double-Counting Downside Assumptions
This is especially important with probability-based energy cases. If a P90 case already incorporates defined technical uncertainties, do not automatically add the same uncertainty again as an extra percentage reduction. A downside case should be internally consistent rather than simply stacking every negative assumption available. The model should clearly state which risks are already embedded in each technical yield case.
Use Combined Downside Cases
Real projects can experience several weaker assumptions together.
A useful structure is:
Case | Example purpose |
Base Case | Central technical and commercial assumptions |
Moderate Downside | Lower generation + modest CAPEX increase + higher rate |
Severe but Plausible | Combined lender-focused downside assumptions |
The aim is not to manufacture the worst possible result. It is to understand whether the project remains financeable under credible stress.
Calculate Break-Even Points
Break-even outputs often provide more decision value than large sensitivity tables.
Useful questions include:
At what net generation does minimum DSCR fall below the required level?
How much CAPEX overrun can the project absorb?
At what merchant price does NPV reach zero?
How much additional constraint reduces debt capacity materially?
What debt amount can the project support under the downside case?
These outputs help developers understand the margin of safety within the investment case.
Make the Model Ready for Lender and Investment Review
A bankable model should end with reconciliation and review, not simply an attractive dashboard. Each significant technical, contractual and financing assumption should be compared back to the project documents before the model is relied on for investment or Financial Close.
Reconcile Contracts and Technical Reports to the Model
The model should allow a reviewer to follow relationships such as:
Energy-yield report → P50/P90 generation
PPA / RESS terms → revenue formulas
Turbine contract → turbine CAPEX
Construction programme → CAPEX timing
O&M agreement → operating expenditure
Lender term sheet → debt tenor, interest and repayment
Grid information → connection cost, timing and constraint assumptions
A technically correct contract sitting beside a spreadsheet that does not reproduce its commercial terms is still a modelling problem.
Automatic checks should also cover:
sources equal uses;
balance sheet balances;
debt opening balance + drawdowns − repayments = closing debt;
cash reconciles;
debt is repaid by maturity;
distributions stop where financing restrictions apply;
revenue periods switch correctly;
dates remain consistent across the model.
Avoid Common Onshore Wind Modelling Errors
Some of the most damaging errors are conceptually simple:
using gross rather than net generation;
mixing P50 and P90 assumptions;
double-counting losses;
ignoring wind capture price;
hiding constraints inside an unsupported percentage;
modelling all CAPEX on one date;
omitting IDC;
hard-coding principal repayments;
treating EBITDA as CFADS;
continuing a PPA price beyond contract expiry;
ignoring the merchant tail;
using unsupported salvage value;
focusing on IRR without checking downside DSCR.
The purpose of model review is to catch these issues before they become investment or financing decisions. For Irish developers, this is also where external financial-model support can add practical value. Stakelum Consultancy provides Initial Project Evaluation, Financial Modelling and Financial Close among its renewable-energy services, and our project experience includes financial modelling for onshore wind.
Final Takeaway
A bankable onshore wind financial model is the financial translation of the project itself. The strongest model starts with supported wind-resource and technical assumptions, converts them into net exported generation, applies the actual revenue structure, captures full lifecycle costs and then determines how much cash is available to support debt and equity.
The core relationship is:
Wind Resource → P50/P90 Net Generation → Revenue → Lifecycle Costs → CFADS → Debt Capacity → DSCR/LLCR → Equity Cash Flow → Project and Equity Returns → Downside Resilience
If one part of that chain is weak, later outputs can appear precise while still being unreliable. For developers preparing an Irish onshore wind project for investment or financing, Stakelum Consultancy provides Initial Project Evaluation, Financial Modelling and Financial Close support, alongside transaction and commercial advisory services. A well-structured model can help project teams test generation, revenue, costs, debt capacity and downside performance before those assumptions become investment or financing commitments.
References
Current IEC 61400-15-1:2025
Eirgrid Forecast
Onshore wind LCOE
