formualizer

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.

Summary ResultsB6:D45

Saved workbook valuesOutput

RowBCD
6Outputs SummaryunitsCurrent Model Run
7Net Year-One Cost of Energy (COE)¢/kWh32.05
8Annual Escalation of Year-One COE%0.0%
9Percentage of Tariff Escalated%0.0%
14Net Nominal Levelized Cost of Energy¢/kWh32.05
20Production, Yr 1kWh3,101,354
25Net Installed Cost (Total Installed Cost less Grants)$$7,389,914
31Target 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 / descriptionType / constraints / default
system_size_kw

Generator Nameplate Capacity

Type: number

Constraints: min: 0.001

Default: 2000

capacity_factor_mode

Net Capacity Factor: Select "State Average" or "Custom" →

Type: string

Default: "State Average"

capacity_factor

Net 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_detail

Select Cost Level of Detail

Type: string

Default: "Intermediate"

installed_cost_per_watt

Total Installed Cost Active only when capital_cost_detail is Simple.

Type: number

Default: 3.6

om_cost_detail

Select Cost Level of Detail

Type: string

Default: "Intermediate"

fixed_om_per_kw_year

Fixed 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_rate

Interest Rate on Term Debt; decimal fraction (0.30 = 30%).

Type: number

Default: 0.07

federal_incentive_type

Select Form of Federal Incentive

Type: string

Default: "Neither"

federal_cost_incentive_form

Investment Tax Credit (ITC) or Cash Grant?

Type: string

Default: "Cash Grant"

itc_fraction

ITC 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 / descriptionType / constraints / default
year_one_coe_cents_per_kwh

Year one coe cents per kwh.

Type: number

nominal_lcoe_cents_per_kwh

Nominal lcoe cents per kwh.

Type: number

year_one_energy_kwh

Year one energy kwh.

Type: number

net_installed_cost

Net installed cost.

Type: number

after_tax_equity_irr_year25

Actual 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/mcp

Slug: 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.