Excel workbook · Catalog edition v1.4
NREL CREST Wind Cash-Flow Model
National Renewable Energy Laboratory (NREL / DOE)
NREL CREST v1.4 wind cost-of-energy and project-finance model with tax incentives, debt service and after-tax equity returns.
- Inputs
- 137
- Outputs
- 16
- File size
- 211 KB
- Verification
- Engine regression check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesOutput
| Row | B | C | D |
|---|---|---|---|
| 6 | Outputs Summary | units | Current Model Run |
| 7 | Net Year-One Cost of Energy (COE) | ¢/kWh | 10.05 |
| 8 | Annual Escalation of Year-One COE | % | 0.0% |
| 9 | Percentage of Tariff Escalated | % | 0.0% |
| 10 | Does modeled project meet minimum DSCR requirements? | No, see Inputs Worksheet | |
| 14 | Net Nominal Levelized Cost of Energy | ¢/kWh | 10.05 |
| 20 | Production, Yr 1 | kWh | 28,032,000 |
| 25 | Net Installed Cost (Total Installed Cost less Grants) | $ | $25,000,000 |
What was checked
Scenarios match the engine’s own earlier results, not an independent check.
Scope and limitations
Catalog calculations, not certification.
Try it uses Formualizer’s own tariff solver in place of Excel’s What-If tables.
- Historical CREST v1.4 assumptions retain the source tax and incentive defaults; they are not current policy advice.
- Changed-input scenarios are engine regression checks; only baseline values have an independent original Excel cache comparison. Cash flows with multiple sign changes may have multiple IRR roots.
- Cascaded one-variable tariff tables are evaluated at each trial point; the final tariff uses the source 0.1-cent bracket midpoint, so target-return NPV need not be exactly zero.
What it computes
Ports for the compact flow: quick_wind_lcoe_check. The full port contract includes all 153 ports.
Inputs (12)
| Port / description | Type / constraints / default |
|---|---|
system_size_kwGenerator Nameplate Capacity; units: kW. Numeric costs are positive unless stated otherwise. | Type: number Constraints: min: 0.001 Default: 10000 |
capacity_factorNet Capacity Factor, Yr 1; units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise. Directly active; this edition has no capacity-factor mode switch. | Type: number Constraints: min: 0; max: 1 Default: 0.32 |
capital_cost_detailSelect Cost Level of Detail; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. Allowed values: Simple, Intermediate, Complex. | Type: string Constraints: one of: Simple, Intermediate, Complex Default: "Simple" |
installed_cost_per_kwTotal Installed Cost; units: USD/kW. Numeric costs are positive unless stated otherwise. Active only when capital_cost_detail = Simple. | Type: number Constraints: min: 0.001 Default: 2500 |
federal_incentive_typeSelect Form of Federal Incentives; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. Allowed values: Cost-Based, Performance-Based, Neither. | Type: string Constraints: one of: Cost-Based, Performance-Based, Neither Default: "Cost-Based" |
federal_cost_incentive_formInvestment Tax Credit (ITC) or Cash Grant?; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. Allowed values: ITC, Cash Grant. | Type: string Constraints: one of: ITC, Cash Grant Default: "Cash Grant" |
itc_fractionITC or Cash Grant Amount ; units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise. Active when federal_incentive_type = Cost-Based; federal_cost_incentive_form selects ITC or Cash Grant. | Type: number Constraints: min: 0; max: 1 Default: 0.3 |
om_cost_detailSelect Cost Level of Detail; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. Allowed values: Simple, Intermediate. | Type: string Constraints: one of: Simple, Intermediate Default: "Intermediate" |
fixed_om_per_kw_yearFixed O&M Expense, Yr 1; units: USD/kW/year. Numeric costs are positive unless stated otherwise. Active only when om_cost_detail = Simple. | Type: number Default: 0 |
variable_om_cents_per_kwhVariable O&M Expense, Yr 1; units: ¢/kWh . Numeric costs are positive unless stated otherwise. Active only when om_cost_detail = Simple. | Type: number Default: 2.5 |
debt_fraction% Debt (% of hard costs) (mortgage-style amort.); units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise. | Type: number Constraints: min: 0; max: 1 Default: 0.5 |
debt_interest_rateInterest Rate on Term Debt; units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise. | Type: number Default: 0.07 |
Outputs (5)
| Port / description | Type / constraints / default |
|---|---|
year_one_coe_cents_per_kwhcents/kWh; year-one tariff, rounded to the midpoint of the 0.1-cent CREST bracket | Type: number |
nominal_lcoe_cents_per_kwhcents/kWh; nominal levelized cost of energy | Type: number |
year_one_energy_kwhkWh/year; positive generation | Type: number |
net_installed_costUSD; positive net capital cost | Type: number |
after_tax_equity_irr_year20decimal fraction; cumulative equity IRR through year 20 | Type: number |
Questions this workbook answers
- Calculate wind LCOE with NREL CREST
- Compare wind project financing and tax incentives
- Estimate wind project after-tax equity returns
Questions and answers
What units are required?
Capacity is kW, capex USD/kW, capacity factor and rates decimal fractions, and tariff cents/kWh.
Are the perturbed scenarios checked in Excel?
The baseline is compared against source Excel caches. Perturbed cases are deterministic WASM regression vectors, not independently recalculated Excel oracles.
Does the reported IRR always equal the target return?
No. CREST solves a tariff bracket against target-return NPV. Its separate IRR formula can select a different root when cash flows change sign repeatedly. The 100 MW wind preset exhibits this behavior. Inspect full-flow NPV, DSCR, cash flows and achieved IRR together.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: nrel-crest-wind · Edition: v1.4
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "nrel-crest-wind",
"edition": "v1.4",
"flow": "quick_wind_lcoe_check",
"inputs": {
"system_size_kw": 100000,
"capacity_factor": 0.42,
"capital_cost_detail": "Simple",
"installed_cost_per_kw": 1600,
"om_cost_detail": "Simple",
"fixed_om_per_kw_year": 40,
"variable_om_cents_per_kwh": 0.5,
"debt_fraction": 0.6,
"debt_interest_rate": 0.055,
"federal_incentive_type": "Cost-Based",
"federal_cost_incentive_form": "ITC",
"itc_fraction": 0.3
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_wind_lcoe_check
Quick wind LCOE check
Capacity, costs, O&M, debt and federal incentive sensitivity. Capacity factor is directly active in this edition. Simple cost modes activate the quick cost inputs; omitted inputs retain source defaults.
12 input ports · 5 output ports. Full membership in the port contract.
full_wind_project_finance
Full wind project finance
All mapped Inputs assumptions and depreciation allocations, plus cash-flow and DSCR diagnostics. Complex Inputs schedules can be supplied through cellOverrides. Expenses and initial equity are negative USD; ratios and rates use decimal fractions.
137 input ports · 16 output ports. Full membership in the port contract.
REST example
Bundle scenario: utility_100mw · Flow: quick_wind_lcoe_check
curl 'https://catalog.formualizer.com/v1/models/nrel-crest-wind/v1.4/evaluate?flow=quick_wind_lcoe_check' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"system_size_kw":100000,"capacity_factor":0.42,"capital_cost_detail":"Simple","installed_cost_per_kw":1600,"om_cost_detail":"Simple","fixed_om_per_kw_year":40,"variable_om_cents_per_kwh":0.5,"debt_fraction":0.6,"debt_interest_rate":0.055,"federal_incentive_type":"Cost-Based","federal_cost_incentive_form":"ITC","itc_fraction":0.3}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"year_one_coe_cents_per_kwh": 3.8500000000000005,
"nominal_lcoe_cents_per_kwh": 3.8500000000000023,
"year_one_energy_kwh": 367920000,
"net_installed_cost": 160000000,
"after_tax_equity_irr_year20": -0.027785477140071943
}
}Looking for another spreadsheet? Request a workbook.