ROI Calculator

What it does

A project-level investment model for a lighting or facility upgrade. It builds a year-by-year, after-tax cash flow and reports payback, 10-year NPV, IRR and debt-service coverage. Revenue comes from the added yield over a base yield, and the model states it is not investment advice.

When to use it

Use it to prepare an investment case for lenders, investors or advisory teams, including cash-versus-loan and sensitivity scenarios.

How it calculates

• Added revenue = (enhanced − base yield) × growing area × crop price (flat or seasonal)
• One year-indexed, after-tax, levered cash flow that includes yield ramp, price and opex escalation, LED degradation, and MACRS depreciation
• NPV is discounted at the WACC you enter. IRR, simple and discounted payback, and minimum DSCR come from the same cash flow and the loan amortization
• The sensitivity snapshot shifts yield uplift and crop price by ±10%. The lender pack adds a tornado chart and a Monte Carlo NPV distribution

What you enter

Crop Type

Growing Area(m²)

Photoperiod(hr/day)

Base and Enhanced Yield(kg/m²/year)

Power Density (W/m²), Efficacy (µmol/J) and Equipment Cost ($/m²)

Crop price($/kg, average or winter/summer)

Electricity Cost ($/kWh) and Gas Cost ($/m³)

Capital Structure(cash or term loan: rate and term)

Discount Rate — WACC (%) and Marginal Tax Rate (%)

Facility type, target DLI and optional detailed operating costs

What you get

Annual revenue ($) and added production (kg/year)

Operating Cost ($) and electricity (kWh/year)

Payback(years, after-tax)

10-Year NPV ($), IRR and discounted payback

Debt Service Coverage Ratio

CapEx/m², Revenue/m² and EBITDA margin(%)

10-year cumulative cash flow

HTML/PDF lender pack and CSV workbook

Related calculators

• Carbon Credits Estimator
• Demand Response Optimization
• Electrical Estimator
• Energy Cost