Assumptions & Inputs
Single source of truth — all yellow fields are editable. Changes propagate instantly to all projections.
Derived / Calculated Outputs (auto-updated)
Design Annual Capacity
30,000 Tonnes
5 × 20h × 300 days
Total Variable Cost / Tonne
₹4,500
RM + Power + Labour + Maint + Pack + Other
Total Fixed Cost (Base)
₹0.69 Cr
Lease + Salaries + Insurance
Total Project Cost
₹6.25 Cr
CAPEX + Working Capital
Depreciation Base
₹4.40 Cr
Machinery + Civil + Electrical
Annual Depreciation
₹0.44 Cr
SLM over 10 years
Annual Debt Service
₹88,64,121
PMT(11.0%, 6 yrs, ₹3,75,00,000)
Project IRR
108.9%
10-year unlevered
Equity IRR
231.9%
10-year levered
NPV @ WACC
₹39.1 Cr
Discount rate 14.0%
Rated throughput of the pellet line — scaled from 2 TPH baseline
Continuous operation — 2 shifts typically; 20 hrs allows maintenance window
Standard for continuous biomass plants; allows 65 days for maintenance/seasonal
Calculated: TPH × Hours/day × Days/year
Ramp-up year — conservative 75% accounts for commissioning, market development
Steady state after ramp — 95% is achievable with secured offtake
Year 1 Production: 22,500 T · Year 2+ Production: 28,500 T
Market rate for biomass pellets in Western UP — NTPC/TPP offtake 2026
Applied from Year 2 onwards — CPI-linked assumption
Excluded from Base Case — treated as Upside only (potential ₹3–5 Cr/year at scale)
Year 1 Revenue
₹18.0 Cr
Year 2 Revenue
₹23.5 Cr
Year 5 Revenue
₹25.7 Cr
Year 10 Revenue
₹29.7 Cr
Biomass feedstock delivered to gate — parali, bagasse, agri-residue mix — Western UP 2026
~0.14 kWh/kg × ₹8/unit grid tariff; higher without solar integration
Slightly lower per tonne at 5 TPH scale vs 2 TPH — scale economies on direct operators
Dies, rollers, wear parts — economies of scale at 5 TPH
HDPE/PP bags for pellet packing
Internal logistics, water, consumables — scale benefit vs 2 TPH
Calculated: SUM of all 6 variable cost lines above
Contribution Margin / Tonne: ₹3,500 · Gross Margin (Yr2): 45.4%
Model Limitations & Disclaimer
- •10-year explicit forecast only — no terminal value in NPV/IRR
- •Debt amortisation is simplified (not full EMI schedule with exact bank terms)
- •No monthly cash-flow seasonality for feedstock
- •Carbon credits and MNRE subsidies excluded from Base Case
- •Working capital modelled as initial lump sum only — ongoing WC changes not modelled monthly
- •Power remains full grid; solar can be added as sensitivity / Phase-2