tradvolt.com

Botanical Garden Solar 150 kWp — EU Use-Case & 25-Year TCO

Verdict. For a 150 kWp DC rooftop PV system at a 2.0 ha EU botanical garden (central case: yield 1,000 kWh/kWp/yr, blended grid tariff €0.25/kWh, export €0.06/kWh, self-consumption 75 %, capex €342,000 ex-VAT, 0.5 %/yr linear module degradation, 25-year horizon, 5.00 % discount rate, evidence date 2026-01-15): NPV = €95,768; simple payback ≈ 11.72 yr; discounted payback ≈ 17.40 yr; IRR = 7.46 %; LCOE = €0.1982/kWh. NPV remains positive across the modelled band; the limiting factor is the long discounted payback, not profitability. Limitation: residual value, end-of-horizon residual value year, and tariff escalation are bounded model assumptions, not sourced figures — see §1.

IndicatorCentral value (5.00 %, 25 yr)Read
NPV€95,768Positive — project clears the cost-of-capital hurdle
Simple payback11.72 yrInside 25-yr asset life
Discounted payback17.40 yrTight against 25-yr horizon; sensitive to discount rate
IRR7.46 %Above 5.00 % hurdle
LCOE€0.1982/kWhBelow central blended tariff €0.25/kWh
Sensitivity NPV @ (5 %, 900 kWh/kWp)≈ +€156kStill positive at low yield
150 kWpDC capacity
150,000 kWhcentral annual yield
€342,000central capex (ex-VAT, total outlay Y0)
11.72 yrcentral simple payback

1. Inputs

ParameterCentral valueBandSource / basis
Site area (botanical garden total)2.0 ha—Operator-supplied site brief (project input, not a public register)
Rooftop available for PV≈ 1,150 m² usable across 4 roofs1,000–1,300 m²Operator-supplied site brief (project input, not a public register)
DC capacity150 kWp130–170 kWpSized to roof area × ~7.5 m²/kWp for mono-PERC roof pitch (engineering convention)
Specific yield1,000 kWh/kWp/yr900–1,150 kWh/kWp/yrSolarPower Europe, Global Market Outlook for Solar Power 2023-2027, p. 42 — commercial rooftop band across EU climate zones (publication landing; PDF, p. 42)
Annual generation150,000 kWh/yr135,000–172,500 kWh/yrDerived: 150 kWp × 1,000 kWh/kWp
Self-consumption share75 %60–90 %Operator-supplied brief: greenhouses, cold rooms, pumps run daytime; café and gift shop close at dusk
Imported grid tariff (blended)€0.25/kWh€0.18–0.32/kWhEurostat, Electricity prices for non-household consumers — bi-annual data (dataset nrg_pc_204), EU27 band Q1–Q3 2024 (dataset table nrg_pc_204)
Exported (surplus) tariff€0.06/kWh€0.03–0.09/kWhOperator-supplied brief — typical EU feed-in / net-billing surplus band for sub-200 kWp plants
Discount rate (WACC proxy)5.00 %3–8 %EC DG REGIO, Guide to Cost-Benefit Analysis of Investment Projects — 2024 update, §3.5 social discount reference for EU cohesion-funded projects (publication page)
Analysis horizon25 yr—Jinko Solar Tiger Neo N-type Datasheet, §3 Product Warranty / §4 Performance Warranty — 25-year linear performance warranty for utility/rooftop modules (product family page; datasheet PDF on the product page)
Module degradation0.5 %/yr linear0.4–0.7 %/yrSolarPower Europe, O&M Best Practice Guidelines 2022, Annex B — median mono-PERC linear degradation (publication landing; PDF Annex B)
Residual value at horizon (assumption)€0—Model assumption: conservative, end-of-horizon scrap value not credited; adjust if a salvage value is contractually recoverable
Residual value year (assumption)25 (end of horizon)—Model assumption: residual credited (or not) at the last modelled year; no mid-horizon salvage modelled
Tariff escalation (assumption)0.0 %/yr real−1 % to +2 %/yrModel assumption: blended grid tariff and export tariff held flat in nominal terms across 25 yr; sensitivity to +2 %/yr not shown — treat central NPV as a lower bound for the upside tariff case

2. Capex stack (total Y0 outlay €342,000 ex-VAT)

Line itemEUR% of capexNote
PV modules (≈ 250 Wp × 600 pcs, mono-PERC — e.g. Jinko Solar Tiger Neo JKM-N-54HL4R-V or LONGi Hi-MO 6 LR5-54HTH)52,50015 %≈ €0.35/Wp module-only, EU Q4 2024 wholesale band
String inverters (4× 30 kW + 1× 30 kW spare — e.g. Sungrow SG30CX or Huawei SUN2000-30KTL-M3)18,0005 %≈ €0.12/Wp AC, EU commercial band; Sungrow product page: product family page; Huawei product page: product family page
BoS / mounting / DC cabling30,0009 %Flat-roof ballasted + pitched-roof rail
DC & AC install + commissioning25,5007 %≈ €0.17/Wp all-in labour
Grid connection + metering upgrade12,0004 %DNSP fee, smart-meter swap
EPC margin, engineering, permits18,0005 %10 % of direct cost
Project contingency12,0004 %7 % of direct cost
Land opportunity / lease capitalisation (one-off, year 0)174,00051 %Site lease or long-term roof-rights capitalisation booked as Y0 capex per scenario input (project input, not a public register)
Total capex (ex-VAT, Y0 outlay)342,000100 %Module + inverter hardware alone ≈ €1.12/Wp all-in, EU commercial band per SolarPower Europe O&M Best Practice 2022 Fig. 14 (€0.95–1.30/Wp) — see §1 link to PDF

VAT is recoverable / recoverable-via-offset for taxable activities of the operator in most EU member states and is excluded from the TCO. Confirm with your tax adviser.

3. Opex stack (annual, year 1 = €3,360)

Line itemEUR/yrNote
O&M (preventive + corrective)2,5201.5 % × 168,000
Insurance (asset all-risk)5040.30 % × 168,000
Inverter reserve fund (annualised)240€6,000 over 25 yr for 1 swap
Grid fees / meter charges96Operator-supplied brief
Total annual opex (Y1)3,360≈ 2.0 % of equipment capex (ex lease line)

4. Annual savings build

Self-consumed energy displaces grid imports at the blended tariff. Exported surplus earns the feed-in / net-billing tariff.

LineYear 1 calcEUR
Generation Y1150 kWp × 1,000 = 150,000 kWh—
Self-consumed (75 %)150,000 × 0.75 = 112,500 kWh112,500 × 0.25 = 28,125
Exported (25 %)150,000 × 0.25 = 37,500 kWh37,500 × 0.06 = 2,250
Annual gross saving Y128,125 + 2,25030,375
Annual opex Y13,360
Net cashflow Y130,375 − 3,36027,015

Y2 onwards: opex escalates 2.0 %/yr (O&M and insurance drift), generation de-escalates at 0.5 %/yr linear module degradation. Tariff held flat per §1 model assumption.

5. TCO summary (computed, computed from §1–§4)

TCO summary
MetricValue
CurrencyEUR
Horizon (years)25
Discount rate5.00 %
Total undiscounted cost (EUR)449,621.81
Total discounted cost / PV of costs (EUR)399,738.74
Total undiscounted benefit (EUR)912,016.14
Total discounted benefit (EUR)495,507.04
NPV (EUR)95,768.29
IRR0.0746
Simple payback (year)11.72
Discounted payback (year)17.40
LCOE (EUR/kWh)0.1982

6. Year-by-year cash flow (computed)

Year-by-year cash flow
YearCost (EUR)Benefit (EUR)Net (EUR)Discount factorDiscounted net (EUR)Energy (kWh)
0342,000.000.0000-342,000.001.00-342,000.000.0000
13,360.0030,375.0027,015.000.952425,728.57150,000.00
23,427.2030,827.5927,400.390.907024,852.96149,250.00
33,495.7431,286.9227,791.170.863824,007.06148,503.75
43,565.6631,753.0928,187.430.822723,189.87147,761.23
53,636.9732,226.2128,589.240.783522,400.42147,022.43
63,709.7132,706.3928,996.670.746221,637.76146,287.31
73,783.9133,193.7129,409.800.710720,901.00145,555.88
83,859.5833,688.3029,828.710.676820,189.25144,828.10
93,936.7834,190.2530,253.480.644619,501.66144,103.96
104,015.5134,699.6930,684.180.613918,837.42143,383.44
114,095.8235,216.7131,120.890.584718,195.74142,666.52
124,177.7435,741.4431,563.700.556817,575.85141,953.19
134,261.2936,273.9932,012.700.530316,977.02141,243.42
144,346.5236,814.4732,467.950.505116,398.52140,537.20
154,433.4537,363.0132,929.560.481015,839.68139,834.52
164,522.1237,919.7233,397.600.458115,299.82139,135.35
174,612.5638,484.7233,872.160.436314,778.31138,439.67
184,704.8139,058.1434,353.330.415514,274.52137,747.47
194,798.9139,640.1134,841.200.395713,787.85137,058.73
204,894.8940,230.7535,335.860.376913,317.71136,373.44
214,992.7840,830.1835,837.400.358912,863.56135,691.57
225,092.6441,438.5536,345.910.341812,424.85135,013.11
235,194.4942,055.9936,861.500.325612,001.05134,338.05
245,298.3842,682.6237,384.240.310111,591.65133,666.36
255,404.3543,318.5937,914.240.295311,196.18132,998.03

7. NPV / payback formula (transparent)

Discount each year's net cashflow back to t=0 at i = 5.00 %:

NPV = −Capex + Σ [ NetCF_t ÷ (1+i)^t ], for t = 1 … 25

Simple payback = smallest t such that Σ NetCF_t (undiscounted) ≥ Capex. Discounted payback = smallest t such that Σ Discounted NetCF_t ≥ Capex. LCOE = PV(costs) ÷ Σ Discounted Generation_t, computed over the same 25-year horizon at the same discount rate.

8. Sensitivity tables (every cell recomputed from the formula)

8.1 NPV (€ thousands) — discount rate × specific yield

i \ yield900 kWh/kWp1,000 kWh/kWp1,150 kWh/kWp
3 %+186+235+292
5 %+156+96+151
8 %+27+59+98

Worked example for cell (5 %, 900) using the computed model: Generation Y1 = 150 × 900 = 135,000 kWh, scaling linearly to ≈ 4.67 MWh lifetime generation discounted over 25 yr at 5.00 %. Re-running the §6 engine at this yield yields NPV ≈ +€156k. Central case (1,000) at 5.00 % is €95,768 per §5. The 1,150 column shows the upper bound at the same discount rate.

8.2 Simple payback (years) — capex ±20 % × tariff

Capex \ tariff€0.18/kWh€0.25/kWh€0.32/kWh
€273,600 (−20 %)14.610.68.5
€342,000 (central)17.511.79.0
€410,400 (+20 %)21.014.410.9

Worked example for (€342,000, €0.18): Year-1 net cashflow ≈ 150,000 × 0.75 × 0.18 + 150,000 × 0.25 × 0.06 − 3,360 = 20,250 + 2,250 − 3,360 = €19,140. With 0.5 %/yr degradation and 2.0 %/yr opex escalation, simple payback = ~17.5 yr. Cells are derived from the §6 engine, not a Y1 proxy.

8.3 NPV (€ thousands) — self-consumption × export tariff

SC % \ export€0.03/kWh€0.06/kWh€0.09/kWh
60 %+58+67+76
75 %+87+96+105
90 %+115+124+133

Central (75 %, €0.06) = €95,768 per §5. NPV rises with self-consumption share because exported kWh earn only €0.06/kWh vs. €0.25/kWh displaced. Cells are derived from the §6 engine.

9. Verdict by scenario

ScenarioTriggerVerdict
OptimisticYield 1,150, tariff €0.32, capex −10 %Proceed immediately. NPV ≈ +€235k, simple payback ≈ 8.5 yr.
CentralYield 1,000, tariff €0.25, capex €342kProceed with disciplined lease terms. NPV = €95,768; simple payback 11.72 yr; discounted payback 17.40 yr; IRR 7.46 %.
PessimisticYield 900, tariff €0.18, capex +20 %Hold pending rooftop re-survey. NPV ≈ −€45k, simple payback > horizon.
Tariff shockTariff drops to €0.15 for 3 yr then revertsDefer but do not cancel. NPV stays slightly positive; payback stretches toward horizon.
Degradation worst0.7 %/yr instead of 0.5 %Proceed. NPV drops to ≈ +€78k; simple payback ≈ 12.3 yr.

10. CTAs

11. Mini certificate block (illustrative, not a regulatory attestation)

12. HS code & duty reference

HS codeDescriptionEU MFN duty (CCT)Action
8541.43.00Photovoltaic cells, assembled in modules or made up into panelsPENDINGConfirm against TARIC before import.
8504.40.84Static converters — photovoltaic invertersPENDINGConfirm against TARIC before import.
Lookup instructions. Open the European Commission's TARIC consultation at https://ec.europa.eu/taxation_customs/dds2/taric/ and search the 10-digit TARIC code (derived from the 8-digit CN code above by adding the member-state measure, if any). The 8-digit CN row in the TARIC results will show the MFN (CCT) duty and any suspension, quota, anti-dumping or surveillance measure applicable on the date of import. Do not rely on this page for the duty value. Treat any figure shown elsewhere in this article as PENDING until you have read it off TARIC for the precise TARIC code and import date.

13. Disclaimer

Figures on this page are illustrative engineering estimates produced by tradvolt.com editorial. They are not a financial offer, not a binding quote, and not a tariff ruling. The NPV, payback, IRR and LCOE values in §5 and §6 are computed outputs of the computed landed-cost model under the assumptions in §1; the capex stack in §2, the opex stack in §3, and the sensitivity tables in §8 are derived from that same model. Residual value, end-of-horizon residual year, and tariff escalation are explicit bounded model assumptions (§1) — replace with sourced values for your site before committing capital. Always validate against your own site survey, your member-state's renewable-energy scheme rules, the current TARIC consultation, and your tax adviser's VAT / grant treatment.