AFUR Mini‑Grid Tariff Tool – Unified Model

Revenue requirement = O&M + Depreciation + Pre‑tax Return on RAB (WACC pre‑tax). Includes battery/inverter replacement reserve, demand growth, component‑wise depreciation, asset valuation, customer cost allocation, tax toggle, grant/unsubsidized view.

📡 Plant & Performance

Capacity (kWp)

Capacity factor (%)

Availability (%)

Technical losses (%)

PV degradation (%/year)

Load growth (%/year)

Economic life (years)

Currency symbol

💰 CAPEX – Asset Groups (₦)

Solar PV + racks

Inverters & controllers

Batteries + BOS

Civil & powerhouse

Distribution network

Metering & termination

Other (land, logistics)

Capital grant / subsidy

Customer contribution

🔍 Show unsubsidized tariff (remove grant)

🔧 O&M, Escalation & Reserve

Fixed O&M (₦/year)

Variable O&M (₦/year)

Regulatory/admin (₦/year)

Escalable proportion (%)

Inflation (escalation %)

Initial working capital (₦)

Reserve contribution start year

Reserve fund smooths replacement: annual contrib from start year to year 12, withdrawal at year 13.

🏦 Financing, WACC & Tax

Debt proportion (%)

Cost of debt (APR %)

Cost of equity (%)

Debt tenor (years)

Corporate tax rate (%)

Construction (months)

🏛️ Taxable entity (apply corporate tax)

Depreciation method

Tariff structure

Return on RAB = pre‑tax WACC: debt_ratio*cost_debt + equity_ratio*(cost_eq/(1-tax_rate)). Tax allowance handled via cash tax.

👥 Customer categories & cost allocation

Households (#)

HH monthly kWh

HH cost alloc (%)

Small business (#)

Bus monthly kWh

Bus cost alloc (%)

Anchor/Institution (#)

Anchor monthly kWh

Anchor cost alloc (%)

Lifeline (#)

Lifeline monthly kWh

Lifeline cost alloc (%)

Cost allocation normalized to 100%. Demand grows with load growth.

📊 Sensitivity (multipliers)

CAPEX multiplier: 1.00

O&M multiplier: 1.00

Demand multiplier: 1.00

⚡ AFUR Mini-Grid Tariff Tool Unified Model – Reserve Fund | Demand Growth | Pre‑tax Return | Component Depreciation | DSCR Smoothing