energy data expert logo book cover

Advanced Mini-Hydro (Run-of-River) Project Finance Model (ver. 3)


Mini-Hydro (Run-of-River) is a renewable energy and power generation technology that diverts a portion of the river flow to a thrash rack, diversion canal or tunnel (headrace), settling basin or forebay, surge tank, pressurized penstock, water turbine generator, and tail water to re-join the river flow. This project finance model will determine its economic viability by calculating the feed-in-tariff (or first year tariff), equity and project returns (IRR, NPV, PAYBACK), debt service coverage ratio (DSCR – min, ave, max), levelized cost of energy (LCOE) also known as long run marginal cost (LRMC) and short run marginal cost (SRMC).

ADV Mini-Hydro Model3 – demo5a – (download free demo model)

This deterministic model costs USD 700 and uses static (fixed) data to calculate the above economic viability parameters. However, if the user needs to assess project risks, then it is highly recommended that the stochastic or probabilistic model using Monte Carlo Simulation (MCS) be purchased as an option via email. The user simply remits an additional USD 700 to my PayPal account ( and once received, the author will email back the user the MCS version and a link to download from internet the Monte Carlo add-in program (MonteCarlito_v1_10) to do the random simulation.

Product Description

A macro-enabled (xlsm) Excel File for Mini-Hydro (Run-of-River) project finance modeling. Determines equity (e.g. 30% equity, 70% debt) and project (100% equity, 0% debt) returns such as internal rate of return (IRR), net present value (NPV), payback period (PAYBACK), debt service cover ratio (DSCR – min, ave, max), benefits-to-cost (B/C) ratio and other financial ratios needed to establish the technical, economic and financial feasibility of the Mini-Hydro power plant project. Contains the following worksheets: Cover Sheet, Inputs & Assumptions, Tariff Breakdown, Sensitivity Analysis, Construction Period, Operating Period, Financials and Asset Base FIT. The model can handle up to 60 months (5 years) construction period and 30 years of commercial operation. If you need more periods, you can request for a longer-period model from the Energy Data Expert via email ( The user can run sensitivity cases and save (copy paste value) the results in column format in the space provided in the Sensitivity Analysis worksheet.


There are no reviews yet.

Be the first to review “Advanced Mini-Hydro (Run-of-River) Project Finance Model (ver. 3)”

Your email address will not be published. Required fields are marked *