Answer: Solar IRR (internal rate of return) is the yearly rate at which a project’s NPV, or net present value, is zero. If you invest 10,000 and receive 3,000 a year for five years, the IRR is 15.24%. Build the cash flows for the right owner and timing. Then compare the IRR with the return you need, and check NPV.
0 = CF0 + CF1/(1+r) + CF2/(1+r)^2 + ... + CFn/(1+r)^n
CF means cash flow: the money in or out in one year. CF0 is the first payment, at time zero. The letter r is the IRR. You can find it with a spreadsheet, as shown below.
Treat the result as a model, not just a percentage in a proposal. A homeowner, an asset owner and an equity investor can get different cash flows from the same solar system. Say whose cash flow you are using before you calculate.
SurgePV publishes this guide and sells solar software. The examples are made-up calculations. They are not market benchmarks, customer projects or investment advice. For a wider look at payback, NPV and IRR, read the NPV, IRR and payback guide. This page shows how to do the calculation.
How to set up the cash flows
IRR is the value of r in the formula above. NPV (net present value) is today’s value of all the cash flows, after you apply a discount rate. The discount rate is the return you ask for. At the IRR, NPV is exactly zero.
CF0 is usually the negative investment. The later terms are net receipts or payments at the end of each year. You choose how many years to model. Twenty-five years is common, but it is not a rule.
Microsoft’s IRR documentation explains how Excel handles equal periods, cash-flow order and the repeated trial-and-error search. Monthly inputs give a monthly rate. Do not call it annual just because the sheet shows a percentage. For a steady monthly rate, the annual equivalent is (1 + monthly rate)^12 − 1.
IRR assumes you reinvest each payout at the IRR itself. If that is not realistic, use MIRR (modified IRR, explained below). Two assets can have the same IRR and still differ in risk, cash access and value.
Which inputs to include
| Input | What to check |
|---|---|
| Investment | Full installed scope, payment dates, tax treatment, commissioning |
| Production | Project energy model, delivery point, losses, aging, uncertainty |
| Electricity value | Tariff, interval load, export rights, contract schedule |
| Operating costs | Maintenance, insurance, admin, land, fees |
| Replacements | Equipment, downtime, installation, timing |
| Tax and incentives | Eligible owner, actual rules, tax capacity, receipt dates |
| Exit | Sale, residual value, removal, site restoration, transaction costs |
| Financing | Loan draws, interest, principal, fees, reserves, payouts |
Use interval electricity and load data when the tariff needs it. Yearly generation times a retail rate does not give the avoided bill. Exports, fixed charges, demand charges and timing all change the result.
Count each incentive once, on the date you receive it. Depreciation is a tax deduction. It is not a cash payment equal to the amount depreciated. A grant, a recoverable tax, a credit and a tax saving each need their own treatment. Check eligibility with the authority and the owner’s adviser first.
Note whether the model uses nominal or real money, the tax basis and the period. Inflation, price growth and the discount rate must match. The PPA pricing guide explains billed energy and contract price growth. A PPA is a power purchase agreement, where a customer pays for the energy the system produces.
A residential solar IRR example
Take a made-up home system with these inputs:
- Net cost after incentives: 12,000 currency units.
- First-year bill savings: 1,400.
- Savings grow 2.5% a year with the tariff and fall 0.5% a year as the modules age.
- An inverter replacement costs 1,500 in year 12.
- The model runs for 25 years, with no loan, tax or maintenance cost.
Savings in year t are 1,400 × 1.025^(t−1) × 0.995^(t−1). The year-12 cash flow is the year-12 savings of 1,738.38 minus the 1,500 replacement.
| Year | Net cash flow | Cumulative |
|---|---|---|
| 0 | −12,000.00 | −12,000.00 |
| 1 | 1,400.00 | −10,600.00 |
| 2 | 1,427.82 | −9,172.17 |
| 3 | 1,456.20 | −7,715.97 |
| 4 | 1,485.15 | −6,230.83 |
| 5 | 1,514.66 | −4,716.16 |
| 7 | 1,575.47 | −1,595.93 |
| 8 | 1,606.78 | 10.85 |
| 12 | 238.38 | 5,263.73 |
| 25 | 2,245.20 | 31,270.91 |
The annual IRR is 12.28%. At a 6% discount rate, NPV is 8,848.93 currency units. The running total turns positive in year 8, so simple payback is about 8.0 years (7.99). Without the inverter replacement, the IRR would be 12.69%.
If the cost, first-year savings, price growth or aging rate change, all three results change. Recalculate the cash flows for each case. Do not subtract a standard number of percentage points.
A five-year example
Assume you invest 10,000 currency units. You then receive 3,000 at the end of each of five years. These are declared net cash flows. They have no tax, replacement, loan or end value. They are not a typical project forecast.
| Year | Net cash flow |
|---|---|
| 0 | −10,000 |
| 1 | 3,000 |
| 2 | 3,000 |
| 3 | 3,000 |
| 4 | 3,000 |
| 5 | 3,000 |
The annual IRR is 15.2382%. At an annual discount rate of 8%, NPV is 1,978.13 currency units. NPV at the IRR is zero.
What is a good solar IRR?
There is no single good number. A solar IRR is good when it beats the return the investor needs for that level of risk. Use the same currency and tax basis for both. Two published benchmarks show how wide those needed returns are:
- Lazard, LCOE+ July 2026 (version 19.0). Lazard’s US utility-scale analysis assumes 60% debt at 8% interest and 40% equity at a 12% cost. Lazard says this implies an after-tax IRR/WACC of 7.7%. WACC means weighted average cost of capital, the blended cost of debt and equity. Lazard’s cost-of-capital test runs from 4.2% (6% cost of equity, 5% cost of debt) to 10.0% (16% and 10%) on the same 60/40 split. Lazard sets each project’s price so that the levered IRR equals the assumed cost of equity (Lazard LCOE+ 2026).
- IRENA, Renewable Power Generation Costs in 2024. IRENA’s WACC assumptions ranged from 3.8% in Europe to 12% in Africa. It says this reflects country risk and the economy in 2023 (IRENA, July 2025). The 2025 edition’s executive summary says solar PV installed costs fell about 6% in 2025. Solar LCOE (levelized cost of energy, the lifetime cost per unit of energy) stayed the same. A higher cost of capital and slightly lower capacity factors offset the cheaper equipment.
These numbers are the returns investors require to price projects. They are not the IRRs that built projects achieved. Compare your IRR with your own hurdle rate, the minimum return you accept. In the residential example, the 12.28% IRR is above the 6% discount rate, so NPV is positive. An equity IRR below your cost of equity loses value, even when it is a positive number. For a finance-team view of hurdle rates and payback, see the commercial solar CFO pitch.
How to calculate IRR in a spreadsheet
Microsoft’s cash-flow function guide explains the difference between equal-period and dated calculations. Put year zero to year five of the five-year example in cells B2:B7:
=IRR(B2:B7)
=NPV(8%,B3:B7)+B2
Excel’s NPV function treats the first value as year one. So add the starting outflow, which happens at time zero, outside the function. Keep a zero for empty years. A blank cell may be skipped.
For cash flows on exact dates, keep matching value and date lists and use the date-based functions:
=XIRR(cash_flow_range,date_range)
=XNPV(discount_rate,cash_flow_range,date_range)
A dated model is only as good as its dates. A tax refund you expect is not a known date. If you move the investment later, or merge building payments into one date, the return looks better on paper only.
Project IRR and equity IRR
Project cash flows leave out loan payments. Equity cash flows show what owners put in and take out after the loan. Show both where useful, and say which is which.
Model loan draws and repayments on the real schedule. Include fees, interest, reserve accounts, refinancing and balloon payments. Do not count the full capital cost (CAPEX) as an equity payment and also leave out the loan that paid for part of it. Do not count borrowed money as an operating benefit.
A higher equity IRR does not make the asset more productive. Loans and payout timing change the owner’s result, and the loan payments still count in a bad year. An IRR above the loan rate does not by itself prove a higher equity IRR.
The SAM financial-model overview shows how ownership changes the cash flow. SAM (System Advisor Model) separates residential and commercial projects that buy and sell electricity at retail rates. It treats PPA projects separately: they sell at a wholesale rate to meet internal rate of return requirements. Pick the model that fits the deal.
Why IRR and NPV can rank offers differently
This simple comparison uses 25 yearly inflows. Both options cost 120,000 at time zero and have no other cash flows. The discount rate is 7%. The growth is an assumed cash-flow pattern, not an electricity price forecast.
| Metric | Alternative A | Alternative B |
|---|---|---|
| First annual net inflow | 24,000 | 18,000 |
| Annual net-inflow growth | 0% | 4% |
| Number of annual inflows | 25 | 25 |
| Calculated IRR | 19.7805% | 18.4156% |
| NPV at 7% | 159,686.00 | 185,293.11 |
| Initial investment / first annual inflow | 5.00 | 6.67 |
A has the higher IRR. B has the higher NPV at 7%. If 7% is the return you require, B adds more value. The last row is a simple ratio, not a payback calculation for the growing stream. IRR is a percentage. NPV is a money value at the discount rate you choose. Do not compare a project IRR with an equity benchmark. Do not rank projects in different currencies or with different risks as if everything else matched.
Advanced: more than one IRR, or none
A solver can return one answer without proving it is the only one. Take cash flows of −100, +230, −132 in years zero, one and two. Both 10% and 20% make NPV zero. A late cost, such as a replacement or site restoration, can create this kind of pattern in a solar model. Check for it before you show one rate.
Two flows, −1,000 and then +900 one year later, give an IRR of −10%. If every cash flow is negative, no rate above −100% gives zero NPV. The usual search needs the cash flows to change sign. A sign change does not guarantee one useful answer.
Check NPV across a range of rates. Try different solver starting points. Record any case with several answers or none. A spreadsheet error means the cash flows need a closer look. It does not mean you can swap in a market benchmark.
Advanced: MIRR and reinvestment
MIRR uses an explicit financing rate and an explicit reinvestment rate. It shows those assumptions openly. It is not always the lower number.
For the five-year example, take a 6% financing rate and a 4% reinvestment rate. The only negative flow is at time zero, so the financing rate does not change it. Grow the five inflows to year five at 4%: 3,000 × (1.04^4 + 1.04^3 + 1.04^2 + 1.04 + 1) = 16,248.97. Then (16,248.97 / 10,000)^(1/5) − 1 gives a 10.1958% MIRR. The IRR was 15.2382%.
=MIRR(B2:B7,6%,4%)
The result depends on the rates you pick. IRR here assumes reinvestment at 15.24%, which is why MIRR is lower.
Sensitivity and lender checks
Recalculate generation, when power is used, export pay, CAPEX, replacements, O&M, tax timing and loan terms. O&M means operations and maintenance. Use scenarios backed by evidence. Keep links between inputs visible. A battery changes both the cash flows and the investment, so it is not a fixed IRR boost. The backup power and battery design guide covers the design side.
A P90 energy case is a yield estimate the system should reach or beat in 9 years out of 10. It needs a probability method behind it. Do not call an arbitrary ten percent cut in production a P90. Show the scenario assumptions and the cash-flow result.
If there is a loan, use the lender’s own definitions. These cover cash available for debt service, debt service, coverage ratios, reserve accounts and payout conditions. Test the modeled periods against the real covenant. Each lender sets its own DSCR (debt service coverage ratio) and reserve terms, so model against the term sheet.
Keep the technical and financial versions in sync
The layout, production, tariff, financing and proposal should all use the same project scenario. Check inputs and outputs again after equipment or load changes. Keep the cash-flow export and note who reviewed each financial assumption.
SurgePV’s generation and financial tool is for financial modeling from the project inputs you set. Its page lists IRR, NPV and payback among the results, and the results can go into the proposal. The financial modeling hub explains the ROI, NPV, IRR and payback calculations. You still need to check tax eligibility, lender acceptance and each financing structure for your own case.
Run IRR, NPV and payback on your own project inputs
Bring a quote and a load profile to a guided demo. See the cash flows behind each result.
Book a Free DemoGuided demo · No credit card required
Frequently Asked Questions
What is solar IRR calculation?
Solar IRR is the rate that makes the NPV of a solar project’s cash flows zero. NPV is net present value, the value today of all the cash flows. State who owns the project, the period, the currency, the loan and the tax basis. If you invest 10,000 and receive 3,000 a year for five years, the IRR is 15.24%. It is a model result, not a guaranteed return.
What does IRR mean in solar?
IRR means internal rate of return. It is the yearly percentage return that a solar system’s cash flows imply. The cash flows run from the cost at time zero to the savings or revenue over the system’s life. In this page’s residential example, 12,000 spent and 25 years of bill savings give an IRR of 12.28%.
How do you calculate IRR for a solar project?
List the cash flows year by year. Enter the investment at time zero as a negative number. In Excel, use =IRR(range) for equal periods. Use =XIRR(values,dates) for dated flows. Then check that NPV at the returned rate is zero, and check the signs of the cash flows.
What is a good solar IRR in 2026?
A good solar IRR is one above the return the investor needs for that risk. Lazard’s July 2026 analysis uses a 12% cost of equity and 8% interest. That implies a 7.7% after-tax IRR/WACC for US utility-scale solar. IRENA’s 2024 WACC assumptions run from 3.8% in Europe to 12% in Africa. WACC is the blended cost of debt and equity. Compare your IRR with your own hurdle rate, and check NPV.
What is the difference between project IRR and equity IRR?
Project IRR uses the project’s cash flows before loan payments, under a stated tax method. Equity IRR uses what owners put in and take out after the loan. Do not use the full project cost as the equity payment. Compare each return with a benchmark on the same basis.
Should I use IRR or NPV for solar investment decisions?
Use both, with the same assumptions. IRR is a rate. NPV is a money value at the discount rate you choose. Different project sizes, timing or unusual cash flows can rank projects differently. A positive IRR does not by itself mean a positive NPV at the return you need.
What are common solar IRR mistakes?
Common errors are: missing the time-zero investment, mixing up periods or signs, and treating a tax deduction as cash. Others are counting incentives twice, mixing project and equity flows, and ignoring replacements or exit costs. Also check the solver result against NPV and look for other answers.
How does debt financing affect solar IRR?
A loan changes the owner’s cash flows through draws, interest, principal, fees, reserves and payout limits. It can raise or lower the equity return, and it adds risk. An IRR above the loan rate does not guarantee that equity IRR rises.
How do tax incentives change solar IRR?
Enter each incentive once, on the date it arrives, for the right owner and eligible costs. A deduction is not a tax saving of the same size. A credit may arrive after year zero. Compare cases with and without the incentive. Do not assume a fixed gain in percentage points.
What is MIRR and when should it be used?
MIRR is a modified IRR. It uses a set financing rate and a set reinvestment rate. In the five-year example with 6% and 4%, MIRR is 10.20% and IRR is 15.24%. Use MIRR when the IRR’s assumption of reinvesting cash at the IRR is not realistic.
Can solar IRR be negative?
Yes. If you pay 1,000 and receive 900 exactly one year later, the IRR is minus ten percent. Other cash-flow patterns can have several IRRs or none that is useful. Check the result against NPV and the stated point of view.
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.


