SmartHelping / Renewable Energy / Excel
Solar Farm Financial Model
Evaluate the development and operation of a utility-scale solar project over as many as 20 years. Connect panel and MW capacity assumptions to power generation, four revenue streams, construction and operating costs, financing, financial statements and investor returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
See the updated project structure and return logic.
Walk through the latest sources-and-uses summary, equity inputs, generation assumptions, financing, statements and hurdle-based joint venture waterfall.
Original model walkthrough
Review the underlying solar-farm framework.
This original walkthrough provides additional context for the project's sizing, revenue, operating and financing logic.
What the model includes
A connected development, operating and investor-return framework.
Size the facility from the bottom up, forecast energy output and multiple revenue sources, build the capital and operating plan, and evaluate the project through monthly, annual and investor-level results.
Model as many as 240 months
Build a long-range solar-farm forecast with connected monthly and annual Income Statements, Balance Sheets and Cash Flow Statements.
Size production from MW and panel assumptions
Use bottom-up capacity, panel-count and efficiency inputs to estimate maximum MWh production and the expected final energy output.
Allocate generated power between two sales channels
Define the share of energy bound to a power purchase agreement versus direct-to-grid sales, including pricing changes over the forecast.
Add renewable credits and other support
Forecast renewable energy credit pricing per MWh over time and layer in other subsidy revenue alongside electricity sales.
Build startup and construction costs from operating scale
Use costs per MW and panel-count assumptions to create a more transparent capital requirement for the planned solar deployment.
Combine construction and working-capital debt
Configure a construction loan plus two working-capital loans or other term loans and follow the balances through the project statements.
Forecast fixed, variable, staffing and overhead costs
Use dynamic direct-cost schedules alongside FTE and other overhead assumptions to reflect the ongoing cost of operating the farm.
Connect sources, uses and investor funding
Use the sources-and-uses summary, streamlined equity injections and dynamic IRR hurdle-based joint venture waterfall to evaluate partner economics.
Model project sale proceeds at the end of the forecast
Turn on a terminal sale and evaluate project value through discounted cash flow, IRR, NPV and equity multiple calculations.
Review monthly detail and an annual summary
Use the annual executive summary and detailed pro formas to assess operating performance, cash flow, capital needs and returns in a fully editable workbook.
Generation and revenue architecture
Translate technical output into four revenue streams.
The model connects available capacity and expected generation with the pricing and allocation assumptions that determine project revenue over the full forecast.
Power purchase agreement
Set the percentage of generated energy committed to a PPA and define how the contracted pricing changes over time.
Direct-to-grid sales
Forecast merchant power sales with monthly seasonality and independent grid-pricing assumptions.
Renewable energy credits
Enter REC pricing per MWh and its expected movement throughout the 20-year forecast.
Other subsidies
Add another project-support revenue stream so the operating case can reflect the incentive structure available to the development.
How to use it
Move from facility sizing to a financeable project case.
-
Size the farm and expected generation
Enter project capacity, panel counts, production limits, efficiency factors and the assumptions that determine expected MWh output.
-
Define the revenue mix and pricing
Allocate generation between PPA and direct-to-grid sales, then add seasonality, REC pricing and other subsidies.
-
Build the cost and capital structure
Set startup and construction costs, ongoing operating expenses, FTEs, debt facilities, equity injections and JV waterfall terms.
-
Evaluate performance and investor returns
Review the monthly and annual pro formas, three statements, executive summary, DCF, IRR, NPV, equity multiple and potential exit proceeds.
Who gets value from it
Built for teams evaluating utility-scale solar economics.
Solar developers and operators
Translate technical sizing and production assumptions into a connected construction, operating and exit forecast.
Renewable-energy investors
Evaluate project cash flow, funding needs, valuation and investor outcomes under a configurable hurdle-based waterfall.
Project-finance lenders
Review construction debt, working-capital or term loans and the project's ability to support its financing structure.
Analysts, advisors and consultants
Use a fully editable framework to test capacity, pricing, cost, financing and sale assumptions over a long-range forecast.
Also available in these bundles
Need a broader modeling library?
The Solar Farm Financial Model is also included in the Industry-Specific, Capacity-Constrained, Renewable Energy and Super Smart bundles.
Industry-Specific Bundle
Access detailed operating and investment models designed around the economics of specific sectors.
View Industry-Specific BundleCapacity-Constrained Models
Explore models where physical capacity, utilization and production limits drive revenue and capital needs.
View Capacity ModelsRenewable Energy Bundle
Compare solar, wind, hydropower, hydrogen, biogas and other renewable-energy project models.
View Renewable Energy BundleSuper Smart Bundle
Get the complete SmartHelping template collection for forecasting, valuation, accounting, financing, real estate and more.
View Super Smart BundleRelated financial models
Explore other renewable-energy and project-development models.
Battery Recycling Plant
Model feedstock intake, processing capacity, recovered material, operating costs and plant returns.
Explore the battery-recycling modelHydropower
Evaluate power generation, project costs, financing and returns for a hydropower facility.
Explore the hydropower modelSolar Panel Installer
Forecast installation volume, pricing, crews, equipment, operating costs and business cash flow.
Explore the solar-installer modelEV Charging
Plan charging-station deployment, utilization, revenue, capex, financing and network expansion.
Explore the EV-charging modelBiogas
Model feedstock, biomethane production, revenue, plant costs and investment performance.
Explore the biogas modelWind Farm
Connect turbine capacity and power generation with project costs, financing and returns.
Explore the wind-farm modelHydrogen Production Plant
Build a 20-year view of plant capacity, hydrogen output, pricing, costs and investor returns.
Explore the hydrogen modelLand and Lot Development
Evaluate land-development timing, infrastructure costs, lot sales and project cash flow.
Explore the lot-development modelConstruction Business
Forecast project volume, labor, materials, overhead, equipment and contractor profitability.
Explore the construction modelCleaning Service
Plan labor, service volume, pricing and operating costs for a cleaning business.
Explore the cleaning-service modelQuestions before you buy
A few useful details.
How long is the forecast?
The model supports as many as 240 months, or 20 years, with both monthly and annual pro forma detail and fully connected financial statements.
Which revenue streams are included?
The model includes PPA revenue, direct-to-grid electricity sales, renewable energy credits and other subsidies. You can allocate generated power between the PPA and grid channels and adjust pricing over time.
How is solar generation modeled?
Bottom-up assumptions use project MW sizing, panel counts, efficiency and capacity inputs to estimate maximum MWh production and expected output.
Which financing options are available?
You can model a construction loan plus two working-capital loans or other term loans, with the debt balances flowing through the project statements.
Are investor funding and joint venture returns included?
Yes. The updated model includes easier equity-injection inputs, a sources-and-uses summary, a dynamic IRR hurdle-based cash-flow waterfall and DCF, IRR, NPV and equity-multiple outputs.
Is the model editable and included in bundles?
Yes. The spreadsheet is fully unlocked and editable with user-friendly formatting and tab descriptions. It is included in the Industry-Specific, Capacity-Constrained, Renewable Energy and Super Smart bundles.
Turn technical solar assumptions into an investment case
Evaluate the full project from construction through exit.
Connect generation, four revenue streams, project costs, financing, financial statements and investor returns in one editable 20-year Excel model. One-time purchase for $65.
