Excel workbook · Catalog edition v1.4
NREL CREST Solar Cash-Flow Model
National Renewable Energy Laboratory (NREL / DOE)
Calculate NREL CREST solar cost of energy, project debt coverage and after-tax equity returns using Formualizer’s solver for Excel What-If tables.
- Inputs
- 136
- Outputs
- 17
- File size
- 212 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 | 32.05 |
| 8 | Annual Escalation of Year-One COE | % | 0.0% |
| 9 | Percentage of Tariff Escalated | % | 0.0% |
| 14 | Net Nominal Levelized Cost of Energy | ¢/kWh | 32.05 |
| 20 | Production, Yr 1 | kWh | 3,101,354 |
| 25 | Net Installed Cost (Total Installed Cost less Grants) | $ | $7,389,914 |
| 31 | Target After-Tax Equity IRR | % | 12.00% |
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.
NREL/DOE Cost of Renewable Energy Spreadsheet Tool (CREST v1.4) for solar PV cost of energy (COE/LCOE), project finance debt sizing, MACRS/ITC tax credits, and 25-year after-tax equity IRR.
- Historical tax and incentive defaults are model assumptions, not current-law guidance. LCOE is nominal cents/kWh. Edition differences were not independently established.
- Uses a JavaScript 33-trial What-If data-table solver with the Formualizer WASM engine. Baseline outputs match source Excel caches; changed-input expectations are engine-generated regression vectors, not independent Excel recalculations.
What it computes
Ports for the compact flow: quick_solar_lcoe_check. The full port contract includes all 153 ports.
Inputs (12)
| Port / description | Type / constraints / default |
|---|---|
system_size_kwGenerator Nameplate Capacity | Type: number Constraints: min: 0.001 Default: 2000 |
capacity_factor_modeNet Capacity Factor: Select "State Average" or "Custom" → | Type: string Default: "State Average" |
capacity_factorNet C.F.: If "Custom" method, then enter Net C.F. →; decimal fraction (0.30 = 30%). Active only when capacity_factor_mode is Custom. | Type: number Constraints: min: 0; max: 1 Default: 0.15 |
capital_cost_detailSelect Cost Level of Detail | Type: string Default: "Intermediate" |
installed_cost_per_wattTotal Installed Cost Active only when capital_cost_detail is Simple. | Type: number Default: 3.6 |
om_cost_detailSelect Cost Level of Detail | Type: string Default: "Intermediate" |
fixed_om_per_kw_yearFixed O&M Expense, Yr 1 | Type: number Default: 6.5 |
debt_fraction% Debt (% of hard costs) (mortgage-style amort.); decimal fraction (0.30 = 30%). | Type: number Constraints: min: 0; max: 1 Default: 0.45 |
debt_interest_rateInterest Rate on Term Debt; decimal fraction (0.30 = 30%). | Type: number Default: 0.07 |
federal_incentive_typeSelect Form of Federal Incentive | Type: string Default: "Neither" |
federal_cost_incentive_formInvestment Tax Credit (ITC) or Cash Grant? | Type: string Default: "Cash Grant" |
itc_fractionITC or Cash Grant Amount ; decimal fraction (0.30 = 30%). Select federal_incentive_type Cost-Based and federal_cost_incentive_form ITC to activate tax credit. | Type: number Constraints: min: 0; max: 1 Default: 0.3 |
Outputs (5)
| Port / description | Type / constraints / default |
|---|---|
year_one_coe_cents_per_kwhYear one coe cents per kwh. | Type: number |
nominal_lcoe_cents_per_kwhNominal lcoe cents per kwh. | Type: number |
year_one_energy_kwhYear one energy kwh. | Type: number |
net_installed_costNet installed cost. | Type: number |
after_tax_equity_irr_year25Actual cumulative after-tax equity IRR at fixed year 25; use selectCells for other project lives. | Type: number |
Questions this workbook answers
- Calculate solar levelized cost of energy with NREL CREST
- Model solar project debt and after-tax equity returns
- Compare utility-scale and commercial rooftop solar economics
Questions and answers
Does CREST calculate LCOE or a required tariff?
CREST solves a year-one cost-based tariff against a target equity return, then reports nominal levelized cost of energy. This is not an unlevered engineering-only LCOE.
Is the target equity IRR the achieved return?
No. Inputs!G62 and Summary Results!D31 contain the target. Annual Cash Flows & Returns!O31 reports the actual cumulative after-tax equity IRR at year 25.
Can I change capacity factor, capex and ITC directly?
Select Custom capacity factor, Simple capex, and Cost-Based federal incentive with ITC form for those scalar assumptions to become active. Percentages use decimal fractions.
Is this pilot ready for finance decisions?
Use professional review for finance decisions. A JavaScript 33-trial What-If solver supports finance calculations. Baseline results match source Excel caches; changed-input expectations come from the engine and do not establish independent Excel scenario parity.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: nrel-crest-solar · 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-solar",
"edition": "v1.4",
"flow": "quick_solar_lcoe_check",
"inputs": {
"system_size_kw": 100000,
"capacity_factor_mode": "Custom",
"capacity_factor": 0.28,
"capital_cost_detail": "Simple",
"installed_cost_per_watt": 1.1,
"om_cost_detail": "Simple",
"fixed_om_per_kw_year": 15,
"debt_fraction": 0.6,
"debt_interest_rate": 0.05,
"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_solar_lcoe_check
Quick solar LCOE check
Curated solar sizing, capex/O&M, debt, and ITC sensitivity returning Year-1 COE, Nominal LCOE, Year-1 generation, Net Installed Cost, and Year-25 After-Tax Equity IRR.
12 input ports · 5 output ports. Full membership in the port contract.
full_project_finance_model
Full project finance model
All mapped Inputs assumptions including financing, taxes, incentive modes, reserves and depreciation. Complex Inputs year-by-year tables require cellOverrides. Finance results use the JavaScript What-If solver and engine regression check evidence.
136 input ports · 17 output ports. Full membership in the port contract.
REST example
Bundle scenario: utility_scale_100mw_itc30 · Flow: quick_solar_lcoe_check
curl 'https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/evaluate?flow=quick_solar_lcoe_check' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"system_size_kw":100000,"capacity_factor_mode":"Custom","capacity_factor":0.28,"capital_cost_detail":"Simple","installed_cost_per_watt":1.1,"om_cost_detail":"Simple","fixed_om_per_kw_year":15,"debt_fraction":0.6,"debt_interest_rate":0.05,"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.65,
"nominal_lcoe_cents_per_kwh": 3.65,
"year_one_energy_kwh": 245280000,
"net_installed_cost": 110000000,
"after_tax_equity_irr_year25": 0.1120284096031227
}
}Looking for another spreadsheet? Request a workbook.