SmartHelping / Renewable Energy / Excel
Hydropower Financial Model
Build a 20-year, monthly and annual financial forecast for a hydropower dam using bottom-up generation assumptions, construction financing, operating costs, fixed assets, valuation, and investor returns. Connect flow rate, net head, uptime, efficiency, and kWh pricing directly to a fully integrated 3-statement model.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
See how construction, water flow, power generation, and debt connect.
Watch the walkthrough, then open the screenshots to review the project timing, bottom-up energy assumptions, construction loan, operating forecast, financial statements, DCF, return analysis, fixed assets, and KPI visuals.
What the model includes
An integrated infrastructure model from construction through exit.
Translate physical dam and water assumptions into electricity revenue, operating cash flow, financing requirements, financial statements, valuation, and investor returns.
Model a long-lived energy asset
Run the detailed project forecast for up to 20 years and use terminal value to represent economics beyond the explicit forecast.
Connect monthly and annual financials
Integrate the income statement, balance sheet, and cash flow statement across both monthly and annual views.
Build revenue from physical operating drivers
Calculate energy and revenue from flow rate, net head, uptime hours, efficiency, and expected kWh pricing.
Change assumptions in every forecast year
Test reduced flow, declining efficiency, expansion, changing uptime, and other year-specific operating scenarios.
Finance the build through interest-only draws
Link monthly loan draws to construction costs, choose how interest is handled, and convert the balance to amortizing debt.
Track depreciation, book value, and disposition
Calculate depreciation and net book value, then estimate the net tax effect when the project is sold at exit.
Evaluate IRR, DCF value, and terminal economics
Measure project value and returns and support joint-venture cash-flow waterfalls using IRR hurdles.
Model expenses, staffing, CAPEX, and KPIs
Use fixed and variable expense slots, staffing assumptions, three transmission-cost inputs, additional CAPEX, and detailed visualizations.
Bottom-up hydropower assumptions
Connect the physical dam to MWh production and energy revenue.
The model denominates its physical calculations in meters and lets the core generation variables change by year across the 20-year forecast.
Flow rate
Define the volume of water moving through the generation system and adjust it over time for changing operating conditions.
Net head
Use the effective vertical drop created by the dam's size and height to drive the energy available from gravity.
Efficiency
Apply conversion efficiency to the available hydraulic energy and test degradation, improvement, or equipment changes by year.
Uptime hours
Define the operating time available for generation and use it to translate capacity into annual MWh production.
Electricity pricing
Apply expected revenue per kWh and change pricing assumptions throughout the life of the project.
Expansion scenarios
Adjust physical and commercial assumptions annually to evaluate capacity expansion or other operating changes.
Construction financing
Model loan draws during construction and amortization after completion.
The construction loan follows the monthly build schedule, offers flexible treatment of interest, and transitions into regular principal-and-interest repayment.
Set the construction phase duration
Define the number of interest-only months while the project is being built and before regular amortization begins.
Fund a percentage of monthly construction spending
Use the defined financing percentage and construction costs to calculate the loan amount drawn in each month.
Accrue interest or pay it currently
Select whether construction-period interest compounds into the loan balance or is paid in cash each month.
Transition to regular amortization
Define the terms for principal-and-interest repayment after the interest-only construction period ends.
Clear the debt when terminal value is realized
When terminal value is displayed, repay the remaining loan balance in the selected project exit month.
Track depreciable costs outside the financed build
Use the additional CAPEX schedule for one-time depreciable spending that does not belong in the construction schedule or loan draws.
Decision-ready outputs
Follow the project from construction through operations and exit.
Physical and financial assumptions flow into connected statements, valuation, return analysis, fixed-asset schedules, and operating KPIs.
Monthly and annual statements
Review the integrated income statement, balance sheet, and cash flow statement at both monthly and annual levels.
DCF and terminal value
Value the explicit forecast cash flows and include an optional terminal value to represent the project's longer economic life.
IRR and joint-venture capability
Measure investor returns and use the modeled cash flows in an IRR-hurdle joint-venture waterfall structure.
Fixed assets and exit tax effect
Calculate cost basis, accumulated depreciation, net book value, and the net tax effect based on terminal value less net book value.
Financial and operating visuals
Review high-level financial charts plus KPIs such as uptime, efficiency over time, and MWh generated.
How to use it
Move from construction timing to long-term project value.
Set the project calendar and construction costs
Use month numbers for all timing assumptions, then layer the desired dates onto the selected model start month.
Build the hydropower production forecast
Enter flow rate, net head, uptime, efficiency, and kWh pricing for each year of the operating period.
Add financing, expenses, staffing, and CAPEX
Configure the construction loan, operating cost categories, three transmission-cost inputs, staffing, and additional depreciable assets.
Review statements, value, and scenarios
Use the financial statements, DCF, IRR, terminal value, fixed-asset analysis, and KPI visuals to test downside, degradation, and expansion cases.
Who gets value from it
Built for teams evaluating long-lived hydropower infrastructure.
Hydropower developers and operators
Plan construction, generation, energy revenue, operating costs, staffing, CAPEX, and long-term performance.
Infrastructure investors
Evaluate project cash flow, terminal value, IRR, downside cases, and the economics available to equity.
Lenders and project-finance teams
Review construction draws, interest treatment, conversion to amortization, and repayment at exit.
Advisors and financial modelers
Use a detailed bottom-up framework for feasibility analysis, fundraising, client work, and scenario planning.
Also available in these bundles
Need a broader spreadsheet library?
The Hydropower Financial Model is also included in the Industry-Specific, Renewable Energy, and Super Smart bundles.
Industry-Specific Models
Use a broader library of bottom-up operating and financial models built around specific business types.
View Industry-Specific ModelsRenewable Energy Models
Explore solar, wind, hydro, storage, charging, recycling, and other energy-business forecasts.
View Renewable Energy ModelsSuper Smart Bundle
Get the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.
View Super Smart BundleMore renewable-energy business case models
Extend the energy, infrastructure, and operating analysis.
Use these complementary SmartHelping models for other renewable-energy, charging, recycling, and distributed-generation opportunities.
Battery Recycling Plant
Forecast feedstock, processing capacity, recovered materials, pricing, costs, financing, and returns.
Explore the battery recycling modelSolar Farm
Model utility-scale solar production, revenue, operating costs, financing, valuation, and investor returns.
Explore the solar farm modelWind Farm
Forecast turbine deployment, power production, energy pricing, operating costs, debt, and returns.
Explore the wind farm modelEV Charging
Build a deployment-based forecast for charging stations, utilization, energy sales, costs, and returns.
Explore the EV charging modelBiogas
Evaluate biomethane production, revenue streams, operating costs, financing, and project economics.
Explore the biogas modelGeneral Recycling
Model material intake, processing, recovered outputs, pricing, direct costs, operating performance, and valuation.
Explore the recycling modelSolar Panel Installer
Forecast a Solar-as-a-Service business with deployment tranches, kWh revenue, grid sales, financing, and returns.
Explore the solar installer modelCustom Financial Model Work
Request modifications to this hydropower model or a custom infrastructure forecast built for a specific project.
Contact SmartHelpingQuestions before you buy
A few useful details.
How long is the model forecast?
The explicit forecast runs for up to 20 years, with an optional terminal value to account for the project's remaining economic life in the DCF analysis.
How is hydropower generation calculated?
The bottom-up calculation uses water flow rate, net head, uptime hours, efficiency, and kWh pricing. Physical calculations are denominated in meters.
How does the construction loan work?
A selected percentage of monthly construction costs drives loan draws during an interest-only period. Interest can be accrued or paid, and the loan can convert to regular principal-and-interest amortization.
How are fixed assets and exit handled?
The model calculates depreciation, accumulated depreciation, and net book value. At exit, the estimated net tax effect can be based on terminal value less net book value, and the remaining loan can be repaid.
Can it model costs outside the financed construction budget?
Yes. An additional CAPEX schedule handles depreciable one-time costs that are outside the main construction schedule and not subject to construction financing.
Is it included in any bundles?
Yes. It is included in the Industry-Specific, Renewable Energy, and Super Smart bundles.
Model the full hydropower project lifecycle
Turn water flow and construction spending into cash flow, value, and returns.
Build a 20-year, monthly and annual 3-statement forecast with bottom-up generation, construction debt, fixed assets, DCF, terminal value, IRR, and operating KPIs. One-time purchase for $75.
