Back to Blog
solar roi12 min read

Solar NPV Calculation: Formula and 5 MW Example

Learn the solar NPV calculation with a reproducible 5 MW example, corrected cash-flow sensitivities and checks for discount rates and tax assumptions.

Akash Hirpara

Written by

Akash Hirpara

Co-Founder · SurgePV

Rainer Neumann

Edited by

Rainer Neumann

Editorial contributor · SurgePV

Published ·Updated

Answer

Solar NPV calculation discounts future net cash flows and subtracts the initial investment. The deciding inputs are cash-flow timing and a discount rate consistent with risk, currency and inflation. In the illustrative 5 MW example here, a 6% rate produces $2.18 million NPV before taxes, debt and other excluded costs.

Last updated: November 2026

A solar project only looks cheap until you discount its future cash flows properly. Every installer, EPC, and finance team eventually faces the same question: is this project worth building today? Solar NPV calculation answers that question by translating 25 years of energy production, tariffs, costs, and taxes into a single number in today’s dollars. Unlike a simple payback calculation, NPV counts every dollar earned after payback and weights earlier cash flows more heavily than later ones.

A low levelized cost of energy is not the same as a positive NPV. The price paid for electricity, the timing of costs and the investor’s required return all matter. The NLR System Advisor Model financial documentation describes this link between modeled electrical output and annual project cash flows.

This guide covers the formula, revenue and cost assumptions, discount rates and a reproducible 5 MW example. The example is illustrative, not a project quotation or evidence of a typical investment return.

SurgePV publishes this post and sells solar design software.

Connect the energy estimate with the financial case

Explore SurgePV financial modeling alongside your project layout and yield assumptions.

Book a Demo

Checking cost first? See the SurgePV pricing page.

What Is Solar NPV and Why It Drives Project Finance

NPV is the difference between the present value of future cash inflows and the initial cash outflow. In solar, that means adding up every year of electricity revenue, incentives, and residual value, subtracting OPEX and taxes, discounting each amount back to today, and comparing the total to the upfront CAPEX.

If NPV is positive, the project earns more than the discount rate. If it is negative, the money would be better deployed elsewhere at that same rate. For capital-intensive assets with 25-year lives, NPV is more reliable than simple payback because it values time and risk explicitly.

NPV makes the timing of investment explicit. A construction payment leaves the project before operating revenue arrives. A later equipment replacement may occur after a favorable simple-payback date. Include those dated cash flows rather than comparing upfront cost with undiscounted lifetime revenue. The size of the discount-rate effect must be calculated from the actual cash-flow schedule.

The Solar NPV Formula, Step by Step

The standard NPV formula is:

NPV = Σ (CFt / (1 + r)^t) − C0

Where:

  • CFt = net cash flow in year t
  • r = discount rate
  • t = year, from 1 to n
  • C0 = initial CAPEX at year 0
  • n = project life in years

In practice, build the model year by year. For each year:

  1. Start with energy yield, adjusted for degradation.
  2. Multiply by the applicable tariff or avoided cost.
  3. Add incentives, grants, or tax credits that arrive that year.
  4. Subtract cash operating costs, insurance, land lease and actual maintenance expenditure. Track reserve funding separately so withdrawals and replacement costs are not counted twice.
  5. Calculate cash taxes using the applicable deductions. Depreciation is a noncash deduction, not an additional cash receipt.
  6. The result is CFt.

Then discount each CFt by (1 + r)^t, sum the present values, and subtract C0.

Microsoft’s NPV documentation assumes equally spaced, end-of-period cash flows. In Excel, use NPV(rate, year1:yearN) minus the initial investment when that investment occurs at time zero. Including the time-zero cost inside that range discounts it by an extra period.

Use nominal cash flows with nominal discount rates, or real cash flows with real rates. Do not mix the two. A fixed nominal contract price remains nominal even when it does not escalate. A real model expresses every cash flow in constant purchasing-power terms; it is not simply a model with flat prices.

Building the Revenue Side: Yield, Tariffs, and Incentives

Revenue streams depend on the market structure and the offtaker.

Self-consumption savings

Value self-consumed energy at the bill charges it actually avoids. Use the customer’s tariff and interval demand where timing affects the result. Fixed charges may remain payable, and demand-charge savings need a separate assessment of peak demand rather than multiplying annual kWh by an average bill rate.

Export income

Value exported electricity under the applicable utility or offtake arrangement. Check payment rates, time periods, caps and settlement rules. Do not count the same kWh as both avoided retail purchases and exported energy.

Power purchase agreements

A power purchase agreement, or PPA, defines the price and terms for electricity sales. Enter its price escalation, curtailment treatment, payment timing and contract duration. For years beyond the contract, label the merchant-price assumption separately and show the effect of changing it.

Incentives and tax credits

Include an incentive only after eligibility, amount and timing have been reviewed for the actual project. The IRS Clean Electricity Investment Credit overview describes a base credit and conditional increases; it is not a promise that every solar project receives the headline rate.

For a 2026 US decision, also consult the IRS’s updated tax-law guidance. Construction and service dates, ownership, labor conditions and applicable restrictions can affect eligibility. Obtain a project-specific tax assessment before including credits, depreciation benefits or transfer proceeds in the financeable case. This article’s worked example excludes them.

Energy yield and degradation

Use a documented energy-yield case and degradation assumption. P50 denotes a median estimate under the stated uncertainty model; it is not a guarantee. The following table uses an illustrative 0.5% annual degradation rate, with year 1 as the undegraded reference. It is arithmetic, not a measured fleet benchmark.

Year Output vs year 1, 0.5% degradation
1 100.0%
5 98.0%
10 95.6%
15 93.2%
20 90.9%
25 88.7%

Each value equals 100 × 0.995 raised to the power of year minus one. Keep any first-year loss separate so it is not applied twice.

Building the Cost Side: CAPEX, OPEX, and Taxes

CAPEX

Capital expenditure, or CAPEX, includes the costs needed to deliver the defined project. Use quotations and a dated scope rather than applying a generic percentage split to every location.

Cost category Evidence to collect
PV modules and inverters Equipment quote, delivery terms and warranty scope
Mounting and balance of system Layout, quantities, structural requirements and electrical scope
Grid connection Utility studies, connection scope and payment schedule
Construction Labor, access, civil works, commissioning and contingency
Development and soft costs Engineering, permits, legal work and project management

Model spending when it occurs. A single time-zero investment is a useful simplification for the example below, but an actual construction schedule may require several payments and financing costs before revenue starts.

OPEX

Operating expenditure, or OPEX, includes the recurring costs of keeping the project available. Review maintenance, insurance, land lease, monitoring, taxes where applicable and replacement work. Match the scope to the contracts, not to a benchmark with an unknown boundary.

Avoid counting a funded replacement reserve and the same replacement payment as two permanent expenses. Track when cash enters a restricted reserve and how it is later released. For a simple unlevered operating model, directly scheduling the replacement expenditure may be clearer.

Document escalation separately for each material cost. A fixed-price maintenance contract, an inflation-linked lease and an uncertain future inverter replacement need not share the same growth assumption. Include any decommissioning cost and defensible terminal value at the end of the analysis.

Taxes and depreciation

Taxable income and cash flow are different. Depreciation can reduce taxable income without being a cash operating expense. If the model starts from net income, adding back noncash depreciation can be appropriate; if it starts from cash receipts and expenses, adding depreciation again would overstate cash flow.

Ask the tax adviser to specify eligible basis, depreciation timing, credit interactions, loss utilization and any restrictions. A reduction in depreciable basis is not itself an equal-dollar reduction in tax benefits: the cash effect depends on the tax rate and when the deduction can be used.

For cross-border projects, also document currency conversion, withholding and repatriation treatment. Keep the tax calculation visible year by year so the investor can distinguish an available deduction from a cash benefit it can actually realize.

Discount Rate and WACC in Solar Projects

The discount rate is the investor’s required return. For an unlevered project cash-flow valuation, an appropriately estimated weighted average cost of capital, or WACC, may be used. Discount equity cash flows after debt service at the equity investor’s required return instead:

WACC = (E/V × re) + (D/V × rd × (1 − Tc))

Where:

  • E/V = equity share of total capital
  • D/V = debt share of total capital
  • re = cost of equity
  • rd = cost of debt
  • Tc = corporate tax rate

Use project-specific financing evidence for the cost of debt, cost of equity and capital weights. The simplified formula assumes the interest tax shield is available at the stated tax rate. Structures with tax equity, changing leverage or tax losses may need a more detailed method.

Modeling choice Matching discount-rate basis
Cash flow before financing Project discount rate appropriate to the valuation method
Cash flow to equity after debt service Cost of equity or equity hurdle rate
Nominal currency cash flows Nominal rate for that currency and risk
Constant-purchasing-power cash flows Consistent real rate

Do not copy a country-average WACC into a project without checking the underlying year, currency, contractual risk and financing structure. A historic survey can provide context but is not a financing offer.

Nominal versus real rates trip up even experienced modelers. A real rate removes expected inflation; a nominal rate includes it. If your PPA escalates at 2% per year and your OPEX escalates at 2.5% per year, your cash flows are nominal. Discount them with a nominal WACC. If you instead strip inflation out of every cash flow, use a real WACC. Mixing a nominal discount rate with real cash flows will understate value; mixing a real discount rate with nominal cash flows will overstate it.

NPV vs IRR vs LCOE: Which Metric Answers Which Question

NPV, IRR, and LCOE are not competitors. They answer different questions for different audiences.

Metric What it answers Best audience Main limitation
NPV How many dollars of value does this create at our discount rate? CFO, board, equity investor Sensitive to discount rate
IRR What percentage return does the project earn? Investors comparing projects Can rank mutually exclusive projects differently; nonconventional cash flows can have multiple IRRs
LCOE What is the lifetime cost per kWh? Auction planners, technology comparison Does not by itself show revenue or equity value
Simple payback How quickly do I get my money back? Homeowner, small business Ignores time value and cash flows after payback

Use NPV and IRR together. For a conventional cash-flow pattern, compare IRR with the matching discount rate and check that NPV is positive. For mutually exclusive projects, NPV is the better decision rule because it measures absolute value.

LCOE is useful for comparing technologies or bidding into auctions. It is not enough for an investment decision because it ignores who buys the power and at what price.

Common Mistakes That Destroy Solar NPV Models

Most NPV errors are not math errors. They are assumption errors.

Ignoring degradation. Apply the project’s supported degradation assumption. In the example below, output in year 25 is 0.995 to the power of 24 times year-one output. The effect on NPV also depends on revenue timing and the discount rate.

Mixing nominal and real rates. Discount nominal cash flows with a nominal WACC. Discount real cash flows with a real WACC. Mixing them overstates or understates value.

Forgetting OPEX escalation. Check the actual contract terms and the nominal or real basis. Flat nominal costs require justification; flat real costs may already represent inflation-adjusted expenditure.

Using P50 as a guarantee. Use the yield cases required by the investor and lender. P50 and P90 describe probabilities under a specified uncertainty model and time horizon, not contractual delivery guarantees.

Double-counting incentives. Record each eligible benefit once at its expected realization date, with its associated basis adjustment and costs. Do not both reduce initial investment and add the same credit as a later cash receipt.

Overstating merchant prices. For projects without a long-term PPA, use conservative price forecasts or forward curves, not the current spot price.

Ignoring construction and completion risk. A project with positive operating NPV can still fail if construction is delayed and liquidated damages apply.

Worked Example: 5 MW Solar NPV Calculation in 2026

This is an illustrative, pre-tax, unlevered example for a 5 MW DC solar project. All prices, growth rates, energy output and costs below are chosen assumptions, not market benchmarks or a real project. Cash flows occur at year end and initial investment occurs at time zero.

The calculation excludes tax credits, depreciation, debt, replacements, residual value and decommissioning. Those exclusions make the arithmetic reproducible but mean the result is not an investment recommendation. A project model should add the relevant items with evidence for their amounts and dates.

Inputs

Input Value
Capacity 5 MW DC / 4.2 MW AC
CAPEX $1.00/W DC = $5,000,000
Capacity factor 26%, explicitly on a DC-nameplate basis
Year 1 generation 11,388 MWh
PPA price $55/MWh, escalating 2% per year
Annual OPEX $125,000, escalating 2.5% per year
Degradation 0.5% per year
Project life 25 years
Discount rate Assumed 6% nominal project rate

Year 1 generation = 5,000 kW × 8,760 hours × 26% = 11,388 MWh.

Year 1 revenue = 11,388 MWh × $55/MWh = $626,340.

Year 1 net cash flow = $626,340 − $125,000 = $501,340.

Selected year cash flows

Year Generation (MWh) Revenue OPEX Net cash flow Present value
1 11,388 $626,340 $125,000 $501,340 $472,962
2 11,331 $635,672 $128,125 $507,547 $451,715
5 11,162 $664,513 $137,977 $526,536 $393,458
10 10,886 $715,516 $156,108 $559,408 $312,371
15 10,616 $770,434 $176,622 $593,813 $247,777
20 10,353 $829,568 $199,831 $629,737 $196,355
25 10,097 $893,240 $226,091 $667,149 $155,445

Results

  • Present value of all future cash flows: $7,175,638
  • Initial CAPEX: $5,000,000
  • NPV at 6%: $2,175,638
  • IRR: approximately 10.0%
  • LCOE: $50.50/MWh

Under these assumptions, the present value of modeled net cash flows exceeds the initial investment by $2,175,638. The approximate 9.99% IRR is the rate that sets this example’s NPV to zero. Its discounted-cost LCOE of $50.50/MWh divides discounted CAPEX and OPEX by discounted generation; it is not a wholesale-price forecast.

The discount-rate and price sensitivities below use exactly the same cash-flow formulas. At 8%, NPV is about $930,348, not $1.35 million. At an initial PPA price of $45/MWh and a 6% discount rate, NPV remains positive at about $502,123.

Illustrative scenario NPV, rounded USD
4% discount rate, initial $55/MWh PPA $3,867,548
6% discount rate, initial $55/MWh PPA $2,175,638
8% discount rate, initial $55/MWh PPA $930,348
6% discount rate, initial $45/MWh PPA $502,123
Illustrative 5 MW NPV sensitivity (USD; same $55/MWh starting PPA)
  • 4% rate$3,867,548
  • 6% rate$2,175,638
  • 8% rate$930,348

Source: Illustrative example, not market data; calculated from the stated 25-year cash flows, checked November 2026.

Key Takeaway

The example stays positive in the $45/MWh sensitivity. Recalculate the full schedule when an input changes; a plausible-sounding summary can contradict the underlying arithmetic.

Reproduce the calculation

For year t, generation equals 11,388 × 0.995^(t - 1) MWh. Revenue equals that generation multiplied by $55 × 1.02^(t - 1). OPEX equals $125,000 × 1.025^(t - 1). Discount the difference at 1.06^t, sum years 1 through 25, then subtract $5 million.

Keep full precision in intermediate calculations and round only displayed values. Using the rounded selected years as though they represented every year will not reproduce the result. To check IRR, substitute the calculated rate into the NPV formula and verify that the result is approximately zero.

Review the assumptions before the return

Bring your yield, tariff and cost inputs to a demonstration of SurgePV financial modeling.

Book a Demo

Checking cost first? See the SurgePV pricing page.

How to Present NPV in a Solar Proposal

A strong NPV slide does three things: it shows the answer, defends the assumptions, and exposes the sensitivity.

State assumptions clearly. List the discount rate, project life, degradation rate, tariff escalation, OPEX growth, and tax treatment. If the model is nominal or real, say so.

Show base, upside, and downside cases. At minimum, run a low-price case, a base case, and a high-price or high-yield case. Decision-makers want to know the range, not a single point.

Include a sensitivity table. A two-way sensitivity grid of discount rate and PPA price is one of the most useful visuals in project finance. It lets the reader find the outcome that matches their own view.

Pair NPV with IRR and payback. NPV tells the CFO how much value is created. IRR tells the investor whether the return beats alternatives. Payback tells the operations team how fast capital is recovered.

Add a model appendix. Include the yield source, weather dataset, degradation assumption, tariff escalation, OPEX scope, tax rate, and financing assumptions. An appendix builds trust and makes it easy for a lender or independent engineer to reproduce the numbers.

Use the right tool. SurgePV supports energy-yield modeling, financial modeling and proposal generation. Review the financial workflow against your required inputs and outputs; its scope does not replace a tax opinion, lender review or independent engineering assessment.

Pro Tip

Keep a separate assumptions sheet with each input’s source, date, units and responsible reviewer. Before sharing the proposal, reconcile the year-one revenue and cash flow by hand and verify that the sensitivity table uses the same model.

Conclusion

Solar NPV is useful when the cash-flow schedule and discount rate describe the same investment perspective. Its precision does not make an unsupported tariff, tax benefit or yield assumption reliable.

  • Build a year-by-year cash-flow model rather than a single average-year estimate.
  • Match the discount rate to project risk, currency, financing treatment and inflation basis.
  • Present the base case and meaningful sensitivities, with evidence for each assumption.

Use a SurgePV financial-modeling walkthrough to discuss how the design’s energy estimate can support your customer proposal. Have the responsible finance and tax reviewers approve the assumptions that determine the investment decision.

Frequently Asked Questions

What is solar NPV and why does it matter?

Solar net present value is the present value of modeled net cash flows minus the initial investment. A positive result means the modeled investment exceeds the selected hurdle rate on that cash-flow basis. It is a valuation result, not a guarantee of actual returns.

How do you calculate NPV for a solar project?

Forecast the net cash flow for each period, discount it by the matching rate and subtract the time-zero investment. In Excel, the NPV function assumes end-of-period cash flows. Keep the initial payment outside the function when it occurs at time zero.

What discount rate should I use for solar NPV?

Use a rate consistent with the cash-flow perspective, risk, currency and inflation treatment. Unlevered project cash flows and equity cash flows after debt service need different rate choices. A generic country or sector range is not a substitute for project financing evidence.

What cash flows belong in a solar NPV model?

Include the relevant dated cash receipts and payments for the selected investor or project perspective. Model energy revenue, operating costs, replacements, tax payments and eligible benefits without double-counting them. Depreciation affects taxable income but is not itself a cash receipt.

Should I use P50 or P90 energy yield?

Use the energy cases required by the decision-maker and show the uncertainty basis. P50 is a median estimate and P90 an exceedance estimate under a specified model and time horizon. Neither is a production guarantee or a fixed percentage discount.

What is the difference between NPV and IRR?

NPV measures value at a selected discount rate, while IRR is a rate that makes NPV zero. Their rankings can differ for projects of different sizes or timing. Nonconventional cash flows can also produce multiple IRRs, so inspect the cash-flow pattern.

Can positive solar NPV still fail a financing review?

Yes, a positive NPV does not guarantee financeability. Lenders also assess debt coverage, contractual risk, construction readiness and the quality of the supporting evidence. The investor must still approve the assumptions and required return.

Where this fits

This article is part of SurgePV's Solar Business & Operations hub, which works through the topic from first principles to the decisions a project team actually has to make.

About the Contributors

Author
Akash Hirpara
Akash Hirpara

Co-Founder · SurgePV

Akash Hirpara is identified by SurgePV as a company co-founder. His SurgePV author page lists only role information that can be tied to the public profile below; education, certifications, project totals, financial results, speaking engagements, and media appearances are not asserted without retained evidence.

Editor
Rainer Neumann
Rainer Neumann

Editorial contributor · SurgePV

Rainer Neumann is credited as an editorial contributor on SurgePV content. This profile does not assert engineering credentials, project totals, software-testing experience, education, speaking engagements, or media citations because independent verification evidence is not retained in the publication record.

Get Solar Design Tips in Your Inbox

Join 2,000+ solar professionals. One email per week - no spam.

No spam · Unsubscribe anytime

Book Free Demo

Choose which optional technologies SurgePV may use. Essential storage remains active for security and requested features.