When Solar Financial Models Look Good on Paper — But Still Need Discipline

In renewable energy, especially rooftop solar for commercial and industrial customers, financial models often become the final decision gate.

A project may look attractive because the spreadsheet shows a positive IRR, a reasonable payback period, and strong customer savings. But after reviewing many solar project structures, I have learned one important lesson:

A financial model is not only about whether the numbers work. It is about whether the assumptions can survive reality.

For solar developers, investors, and C&I customers, this distinction matters.

Because in many projects, the difference between a feasible project and a fragile one is not always visible from the headline IRR.

It is hidden inside the assumptions.

The Problem with “Good Enough” IRR

In solar project development, IRR is often treated as the ultimate answer.

If the project IRR passes the hurdle rate, the project moves forward. If it does not, the project is revised, renegotiated, or rejected.

That logic is understandable.

But it can also be dangerous.

A project with an IRR slightly above the required threshold may not actually be strong. It may only be surviving because the model assumes several optimistic conditions at the same time:

• CAPEX stays low.
• Performance ratio remains high.
• Irradiance is achieved as expected.
• The customer absorbs all solar generation.
• There is no major curtailment.
• O&M cost stays controlled.
• The contract runs for the full tenor.
• No major equipment replacement is required.
• Currency assumptions remain stable.

When too many positive assumptions are stacked together, the model may still produce an acceptable IRR — but the project becomes fragile.

In other words:

A project can pass the spreadsheet and still fail the real-world stress test.

IRR Is Not Enough Without Margin of Safety

One of the biggest mistakes in project assessment is treating an IRR barely above the hurdle rate as a “green light.”

For example, if the hurdle rate is 9%, and the project IRR is 9.2%, technically the project passes.

But commercially, that is not a comfortable margin.

A small increase in CAPEX, a slight reduction in generation, a lower-than-expected performance ratio, or a larger customer discount can quickly push the project below the threshold.

This is why I believe renewable energy projects should not only ask:

“Does the IRR pass?”

They should also ask:

“How easily can this IRR break?”

That second question is often more important.

The Hidden Sensitivities Behind Solar Projects

A rooftop solar project may look simple, but its financial performance depends on several sensitive drivers.

1. CAPEX per Wp

CAPEX is one of the strongest determinants of project feasibility.

A small difference in cost per Wp can materially change the IRR, especially for mid-sized C&I rooftop projects.

The challenge is that early-stage CAPEX assumptions often look cleaner than reality.

Real project costs may include:

• structural strengthening,
• roof treatment,
• additional walkways or lifelines,
• cable routing complexity,
• zero-export devices,
• metering system,
• logistics,
• permitting,
• safety requirements,
• client-specific standards,
• contingency,
• and replacement provisions.

If these items are underestimated, the model may look profitable at proposal stage but become tight during execution.

This is why CAPEX should never be treated as a single number. It should be treated as a risk profile.

2. Performance Ratio

Performance ratio is another critical assumption.

A high PR makes the project look better because it increases expected energy generation. But PR is not just a technical input. It is a commercial risk.

It depends on:

• module quality,
• inverter performance,
• temperature loss,
• soiling,
• shading,
• cable loss,
• mismatch loss,
• availability,
• clipping,
• degradation,
• and maintenance quality.

For C&I rooftop solar, PR should be validated carefully because rooftops are rarely perfect.

There may be shading from nearby buildings, dust from industrial activities, roof orientation issues, equipment downtime, or access limitations for maintenance.

A 1–2% drop in PR may look small technically, but financially it can be meaningful.

3. Irradiance

Solar financial models often rely on irradiation data from simulation tools or satellite-based datasets.

That is necessary, but it should not be treated as absolute truth.

The model should clarify:

• source of irradiation data,
• whether the value is GHI or POA,
• simulation assumptions,
• tilt and azimuth,
• shading analysis,
• soiling assumptions,
• and weather variability.

If the project’s IRR is already thin, even a small irradiation deviation can affect project viability.

4. Customer Discount

The commercial discount to the customer is often the most visible negotiation point.

The customer wants cheaper electricity. The developer needs enough margin to recover CAPEX, O&M, financing cost, tax, risk, and return.

This is where many solar projects become difficult.

If the PLN/grid tariff is already low, the room for solar discount becomes limited.

A higher discount may make the proposal more attractive to the customer, but it reduces project revenue directly.

That means the discount cannot be viewed only as a sales tool. It is a financial lever.

The key question is:

What is the maximum discount the project can offer without destroying its own economics?

5. Contract Period

A longer contract period generally improves project economics because the asset has more time to generate cash flow.

But from the customer side, long-term contracts can create hesitation.

A 20–25 year contract may help the model, but customers may worry about:

• operational changes,
• site relocation,
• roof replacement,
• future tariff movement,
• business continuity,
• technology obsolescence,
• and flexibility.

This creates a structural tension.

The developer wants longer certainty. The customer wants shorter commitment.

A good solar proposal should not only present the price. It should explain why the contract period makes sense for both parties.

The NPV Problem: When Discount Rate Is Missing

Another issue I often notice in project models is how NPV is presented.

NPV should reflect the present value of future cash flows using an appropriate discount rate.

But if the discount rate or WACC is set at 0%, the NPV becomes misleading.

It is no longer a true economic NPV. It becomes closer to cumulative undiscounted cash flow.

This may still be useful as a reference, but it should not be used as a serious investment decision metric.

For proper project evaluation, the model should clearly define:

• WACC,
• cost of equity,
• cost of debt,
• debt-equity structure,
• tax assumptions,
• inflation,
• and risk premium.

Without that, NPV can look attractive while failing to reflect the true cost of capital.

LCOE Must Also Make Sense

LCOE is another metric that should be handled carefully.

In principle, LCOE represents the cost of producing electricity over the asset lifetime.

So when a model produces an unusually low or even negative LCOE, that should trigger a review.

It may be caused by:

• sign convention error,
• incorrect cash flow treatment,
• missing cost components,
• incorrect discounting,
• or improper inclusion of revenue items.

LCOE should help compare energy cost, not confuse the decision.

If the LCOE output does not make intuitive sense, the formula should be reviewed before the number is shown to management, investors, or customers.

Why Sensitivity Analysis Is Non-Negotiable

A solar project should never be approved based only on a base case.

The base case is only one version of the future.

A better model should show how the project behaves under stress.

At minimum, I believe every C&I solar model should test sensitivity against:

A project with a strong base case but weak downside case should be treated carefully.

The goal is not to make the project look bad.

The goal is to understand where it can break.

The Real Question: Is the Project Bankable?

For me, the most important question is not simply:

“Is the project profitable?”

The better question is:

“Is the project bankable, executable, and resilient?”

A bankable solar project should have:

• realistic CAPEX,
• defensible generation assumptions,
• clear risk allocation,
• proper contract structure,
• reasonable customer savings,
• adequate developer return,
• transparent O&M assumptions,
• and protection against downside scenarios.

If any of these are weak, the project may still work — but it needs stronger governance.

My Personal Take

I believe the renewable energy industry needs more financial discipline.

Not because solar is unattractive.

Quite the opposite.

Solar is one of the most practical and scalable energy solutions for commercial and industrial users.

But precisely because solar is growing, the market needs better conversations around project quality.

We should not oversell projects by hiding behind optimistic assumptions.

We should not rely only on headline IRR.

We should not ignore WACC, curtailment, O&M, contract risk, or technical uncertainty.

And we should not present models as if they are certain, when they are actually built on assumptions that must be tested.

A good financial model should not only persuade.

It should also protect.

It protects the developer from underpriced risk. It protects the customer from unrealistic promises. It protects the project from failing after contract signing.

Closing Thought

In solar project development, optimism is important.

But discipline is what makes projects sustainable.

A strong project is not the one that looks best in the base case.

A strong project is the one that still makes sense after the assumptions are challenged.

Because at the end of the day:

The quality of a renewable energy project is not measured only by its IRR, but by the realism behind that IRR.