# NREL CREST Solar Cash-Flow Model Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/nrel-crest-solar) - [Subject guide (text)](https://formualizer.com/catalog/subjects/energy/llms.txt) - [Subject guide (JSON)](https://formualizer.com/catalog/subjects/energy/llms.json) - [Publisher page](https://www.nlr.gov/analysis/crest) - [Ports (text)](https://formualizer.com/catalog/agents/nrel-crest-solar/v1.4/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/nrel-crest-solar/v1.4/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "nrel-crest-solar/v1.4", "title": "NREL CREST Solar Cash-Flow Model", "summary": "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.", "edition": "v1.4", "html": "https://formualizer.com/catalog/nrel-crest-solar", "parent": { "text": "https://formualizer.com/catalog/subjects/energy/llms.txt", "json": "https://formualizer.com/catalog/subjects/energy/llms.json" }, "publisher": "National Renewable Energy Laboratory (NREL / DOE)", "publisherPageUrl": "https://www.nlr.gov/analysis/crest", "verificationLevel": "scenario-engine-regression", "verificationExplanation": "Scenarios match the engine’s own earlier results, not an independent check.", "rightsExplanation": "This is an academic source; this catalog class does not establish a redistribution licence.", "limitations": [ "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." ], "releaseBlockers": [], "licenseClass": "open-academic", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_solar_lcoe_check", "title": "Quick solar LCOE check", "description": "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.", "inputPorts": [ "system_size_kw", "capacity_factor_mode", "capacity_factor", "capital_cost_detail", "installed_cost_per_watt", "om_cost_detail", "fixed_om_per_kw_year", "debt_fraction", "debt_interest_rate", "federal_incentive_type", "federal_cost_incentive_form", "itc_fraction" ], "outputPorts": [ "nominal_lcoe_cents_per_kwh", "year_one_coe_cents_per_kwh", "year_one_energy_kwh", "net_installed_cost", "after_tax_equity_irr_year25" ] }, { "id": "full_project_finance_model", "title": "Full project finance model", "description": "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 scenario-engine-regression evidence.", "inputPorts": [ "technology", "system_size_kw", "capacity_factor_mode", "state", "capacity_factor", "annual_degradation", "project_life_years", "capital_cost_detail", "installed_cost_per_watt", "generation_equipment_cost", "balance_of_plant_cost", "interconnection_cost", "development_cost", "om_cost_detail", "fixed_om_per_kw_year", "variable_om_cents_per_kwh", "om_inflation_initial", "om_initial_period_years", "om_inflation_later", "insurance_fraction", "project_management_annual", "property_tax_annual", "property_tax_adjustment", "land_lease_annual", "royalties_fraction", "construction_months", "construction_interest_rate", "debt_fraction", "debt_term_years", "debt_interest_rate", "lender_fee_fraction", "minimum_dscr_required", "average_dscr_required", "target_after_tax_equity_irr", "other_closing_costs", "taxable_owner", "federal_tax_rate", "federal_tax_benefit_timing", "state_tax_rate", "state_tax_benefit_timing", "tariff_duration_years", "tariff_escalated_fraction", "tariff_escalation_rate", "market_value_mode", "market_value_cents_per_kwh", "market_value_escalation", "federal_incentive_type", "federal_cost_incentive_form", "itc_fraction", "itc_utilization", "federal_pbi_form", "federal_pbi_cents_per_kwh", "federal_pbi_utilization", "federal_pbi_years", "federal_pbi_escalation", "federal_grants", "federal_grants_taxable", "state_incentive_type", "state_itc_fraction", "state_itc_utilization", "state_itc_years", "state_pbi_form", "state_pbi_annual_cap", "state_pbi_taxable", "state_pbi_cents_per_kwh", "state_pbi_utilization", "state_pbi_years", "state_pbi_escalation", "state_grants_per_watt", "state_grants_cap", "state_grants_taxable", "first_inverter_replacement_year", "first_inverter_replacement_per_watt", "second_inverter_replacement_year", "second_inverter_replacement_per_watt", "decommissioning_funding", "decommissioning_reserve", "debt_reserve_months", "om_reserve_months", "reserve_interest_rate", "bonus_depreciation_enabled", "bonus_depreciation_fraction", "depreciation_simple_total_macrs5", "depreciation_simple_total_macrs7", "depreciation_simple_total_macrs15", "depreciation_simple_total_macrs20", "depreciation_simple_total_sl5", "depreciation_simple_total_sl15", "depreciation_simple_total_sl20", "depreciation_simple_total_sl39", "depreciation_simple_total_nondepreciable", "depreciation_generation_macrs5", "depreciation_generation_macrs7", "depreciation_generation_macrs15", "depreciation_generation_macrs20", "depreciation_generation_sl5", "depreciation_generation_sl15", "depreciation_generation_sl20", "depreciation_generation_sl39", "depreciation_generation_nondepreciable", "depreciation_balance_of_plant_macrs5", "depreciation_balance_of_plant_macrs7", "depreciation_balance_of_plant_macrs15", "depreciation_balance_of_plant_macrs20", "depreciation_balance_of_plant_sl5", "depreciation_balance_of_plant_sl15", "depreciation_balance_of_plant_sl20", "depreciation_balance_of_plant_sl39", "depreciation_balance_of_plant_nondepreciable", "depreciation_interconnection_macrs5", "depreciation_interconnection_macrs7", "depreciation_interconnection_macrs15", "depreciation_interconnection_macrs20", "depreciation_interconnection_sl5", "depreciation_interconnection_sl15", "depreciation_interconnection_sl20", "depreciation_interconnection_sl39", "depreciation_interconnection_nondepreciable", "depreciation_development_macrs5", "depreciation_development_macrs7", "depreciation_development_macrs15", "depreciation_development_macrs20", "depreciation_development_sl5", "depreciation_development_sl15", "depreciation_development_sl20", "depreciation_development_sl39", "depreciation_development_nondepreciable", "depreciation_soft_costs_macrs5", "depreciation_soft_costs_macrs7", "depreciation_soft_costs_macrs15", "depreciation_soft_costs_macrs20", "depreciation_soft_costs_sl5", "depreciation_soft_costs_sl15", "depreciation_soft_costs_sl20", "depreciation_soft_costs_sl39", "depreciation_soft_costs_nondepreciable" ], "outputPorts": [ "year_one_coe_cents_per_kwh", "nominal_lcoe_cents_per_kwh", "year_one_energy_kwh", "effective_capacity_factor", "net_installed_cost", "net_installed_cost_per_watt", "minimum_dscr_met", "average_dscr_met", "target_equity_irr", "after_tax_equity_irr_year25", "year_one_revenue", "year_one_operating_expenses", "year_one_after_tax_cash_flow", "initial_equity_cash_flow", "installed_cost_total", "minimum_dscr", "average_dscr" ] } ], "example": { "id": "utility_scale_100mw_itc30", "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 }, "expectedOutputs": { "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 }, "inputsJson": "{\"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}", "expectedOutputsJson": "{\"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}" }, "ports": { "text": "https://formualizer.com/catalog/agents/nrel-crest-solar/v1.4/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/nrel-crest-solar/v1.4/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/openapi.json", "types": "https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/nrel-crest-solar/v1.4/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```