CBG Plant Breakeven Calculator
Size a compressed biogas plant from 0.5 to 20 TPD on any feedstock. Every quantity, rate, cost and the project financing is editable, and breakeven, unit economics and returns recompute instantly.
- CBG output
- 5 TPD
- Feedstock
- 104.17 TPD
- Manure (FOM)
- 16.67 TPD
- Plant capex
- ₹27.50 Cr
Project returns
Full project finance over a 15-year horizon at the current inputs. Construction 15.00 months, 2-year principal moratorium, 8-year repayment. Edit every financing assumption in the configuration panel.
| Year | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Plant usage | 60% | 80% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% |
| Revenue | ₹8,24,04,864 | ₹11,31,69,347 | ₹14,57,05,534 | ₹15,00,76,700 | ₹15,45,79,001 | ₹15,92,16,371 | ₹16,39,92,862 | ₹16,89,12,648 | ₹17,39,80,027 | ₹17,91,99,428 |
| Operating cost | ₹9,16,28,026 | ₹10,19,72,651 | ₹11,31,39,544 | ₹11,82,11,296 | ₹12,35,24,931 | ₹12,90,92,310 | ₹13,49,25,880 | ₹14,10,38,708 | ₹14,74,44,507 | ₹15,41,57,674 |
| EBITDA | −₹92,23,162 | ₹1,11,96,696 | ₹3,25,65,990 | ₹3,18,65,404 | ₹3,10,54,069 | ₹3,01,24,061 | ₹2,90,66,982 | ₹2,78,73,940 | ₹2,65,35,520 | ₹2,50,41,754 |
| Depreciation | ₹0 | ₹0 | ₹0 | ₹0 | ₹0 | ₹0 | ₹0 | ₹0 | ₹0 | ₹0 |
| Interest | ₹1,68,64,583 | ₹1,68,64,583 | ₹1,68,64,583 | ₹1,54,55,459 | ₹1,39,05,423 | ₹1,22,00,383 | ₹1,03,24,839 | ₹82,61,741 | ₹59,92,333 | ₹34,95,984 |
| Profit before tax | −₹2,60,87,745 | −₹56,67,888 | ₹1,57,01,406 | ₹1,64,09,944 | ₹1,71,48,646 | ₹1,79,23,678 | ₹1,87,42,143 | ₹1,96,12,199 | ₹2,05,43,187 | ₹2,15,45,770 |
| Tax | ₹0 | ₹0 | ₹39,25,352 | ₹41,02,486 | ₹42,87,162 | ₹44,80,919 | ₹46,85,536 | ₹49,03,050 | ₹51,35,797 | ₹53,86,442 |
| Profit after tax | −₹2,60,87,745 | −₹56,67,888 | ₹1,17,76,055 | ₹1,23,07,458 | ₹1,28,61,485 | ₹1,34,42,758 | ₹1,40,56,607 | ₹1,47,09,149 | ₹1,54,07,390 | ₹1,61,59,327 |
| Debt repaid (principal) | ₹0 | ₹0 | ₹1,40,91,239 | ₹1,55,00,363 | ₹1,70,50,399 | ₹1,87,55,439 | ₹2,06,30,983 | ₹2,26,94,081 | ₹2,49,63,490 | ₹2,74,59,839 |
| Closing debt | ₹16,11,45,833 | ₹16,11,45,833 | ₹14,70,54,594 | ₹13,15,54,231 | ₹11,45,03,832 | ₹9,57,48,393 | ₹7,51,17,410 | ₹5,24,23,328 | ₹2,74,59,839 | ₹0 |
| DSCR | -0.62× | 0.65× | 0.92× | 0.89× | 0.86× | 0.82× | 0.78× | 0.74× | 0.68× | 0.63× |
| Cumulative equity cash | −₹2,60,87,745 | −₹3,17,55,633 | −₹3,40,70,817 | −₹3,72,63,722 | −₹4,14,52,637 | −₹4,67,65,318 | −₹5,33,39,694 | −₹6,13,24,626 | −₹7,08,80,725 | −₹8,21,81,237 |
EBITDA excludes interest and depreciation; interest here includes working-capital interest. The equity cash line turns positive at payback. Depreciation is straight-line on the gross block (capex + IDC); the subsidy is treated as a capital reserve. Figures are indicative — a bank will re-appraise.
Breakeven analysis
Revenue and cost as capacity utilisation moves from cold plant to 120% of nameplate. Fixed cost is incurred whatever the plant produces; variable cost scales with throughput.
Revenue against cost stack
The crossing of the revenue line and the top of the cost stack is the breakeven point.
Breakeven metrics
Computed at the current utilisation and input set.
- Contribution margin per month
- ₹89,34,912revenue less variable cost
- Contribution margin ratio
- 78.1%each ₹100 of sales leaves ₹78.07 to cover fixed cost
- Fixed cost to be absorbed
- ₹81,96,330unchanged at any output
- Break-even point (capacity)
- 91.7%of 5 TPD nameplate
- Breakeven revenue per month
- ₹1,04,99,038₹12,59,88,456 per year
- Breakeven CBG volume
- 1,37,601 kg4.59 TPD against 5 TPD
- Breakeven CBG price
- ₹68.58 / kgagainst ₹72.00 assumed
- Margin of safety
- 8.3%₹9,46,082 of revenue above breakeven
- Profit sensitivity
- 12.10×a 1% change in output moves profit 12.10% (operating leverage)
How far can each lever move before the plant breaks even?
One variable at a time, everything else held at the current input set. The arrow shows how far that single assumption must move to wipe out the surplus; the bar is capped at a 100% move, so a short bar is a tight lever.
| Lever | Current input | Breakeven value | Move to breakeven | Headroom | Reading |
|---|---|---|---|---|---|
| CBG selling price | ₹72.00 / kg | ₹68.58 / kg | ↓ 4.8% | Price can fall 4.8% — to ₹68.58 — before breakeven | |
| Manure (FOM) price | ₹1,200 / T | below zero | no limit | the manure could be given away free and the plant would still break even | |
| Plant usage | 100% | 91.7% | ↓ 8.3% | Output can drop 8.3% from today's level | |
| Feedstock rate | ₹500.00 / T | ₹736.35 / T | ↑ 47.3% | Feedstock rate can rise 47.3% before the surplus is gone | |
| Electricity tariff | ₹9.00 / unit | ₹11.74 / unit | ↑ 30.4% | Tariff can rise 30.4% before the surplus is gone | |
| Total monthly cost | ₹1,07,06,538 | ₹1,14,45,120 | ↑ 6.9% | Total cost can overrun 6.9% before breakeven |
Where the money goes
Monthly cost at the current utilisation, largest first. Hover any bar for its share and basis.
Cost line items
Total ₹1,07,06,538 per month at 100% utilisation · ₹12,84,78,456 per year
Fixed and variable split
Classification follows the Category column of the input sheet unless switched to the economic basis.
- Fixed cost per month
- ₹81,96,33011 of 14 line items
- Variable cost per month
- ₹25,10,2083 line items, scaling with output
- Variable cost per kg of CBG
- ₹16.73marginal cash cost of a kilogram
- Fixed cost per kg of CBG
- ₹54.64falls as the plant loads up
- Largest single cost
- Electricity₹24,30,000 · 23% of cost
- Feedstock and inbound logistics
- ₹21,87,50020% of total cost
- Debt service and finance cost
- ₹20,66,78619% of total cost
Revenue to surplus bridge
At the current utilisation. Surplus is cash surplus after the full EMI — the cost block already carries debt service, working-capital interest and partner salary.
Monthly bridge
Unit economics per kg of CBG
Every rupee expressed against the CBG actually sold in the month.
- CBG sold in the month
- 1,50,000 kg5.00 TPD across a 30-day month
- CBG selling price per kg
- ₹72.00ex-plant, before any bagging or manure logistics
- FOM credit per kg of CBG
- ₹2.80₹4,20,120 of FOM revenue spread over CBG
- Total realisation per kg
- ₹76.30CBG plus FOM
- Total cost per kg of CBG
- ₹71.38every cost line, including EMI
- Cost per kg net of FOM credit
- ₹68.58the number to compare with the CBG price
- Surplus per kg of CBG
- ₹4.92cash left after everything
- CBG yield on feedstock
- 4.80% by weight48.00 kg of CBG per tonne of feedstock
Five-year horizon
Annual figures, with every cost rising each year from its Year 1 base. Feedstock rises at its own rate; everything else moves on the general rate; the CBG price rises with CNG. Any single line can be given its own yearly rise in the input sheet below.
Revenue against cost, Year 1 to Year 5
Feedstock at 2.00% p.a., other costs at 5.00% p.a., CBG at 3.00% p.a.
What the escalation does
Read against Year 1 at the same utilisation.
- Year 1 cash surplus
- ₹88,62,9846.5% margin at 100% utilisation
- Year 5 cash surplus
- ₹62,52,6374.0% margin at 100% utilisation
- Five-year cash surplus
- ₹3,83,06,027sum of the five years
- Cost growth, Year 1 to 5
- 3.66% p.a.blended across every line
- Revenue growth, Year 1 to 5
- 3.00% p.a.3.00% realisation escalation
- Margin movement
- −2.4% ptsYear 5 margin against Year 1
- Break-even point drift
- 91.7% → 94.7%the plant has to run harder each year to stand still
- First year of cash shortfall
- none in five yearsat the utilisation set for each year
| Annual | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 5-year total |
|---|---|---|---|---|---|---|
| Plant usage % | — | |||||
| Revenue | ₹13,73,41,440 | ₹14,14,61,683 | ₹14,57,05,534 | ₹15,00,76,700 | ₹15,45,79,001 | ₹72,91,64,357 |
| Variable cost | ₹3,01,22,496 | ₹3,16,28,621 | ₹3,32,10,052 | ₹3,48,70,554 | ₹3,66,14,082 | ₹16,64,45,805 |
| Fixed cost | ₹9,83,55,960 | ₹10,14,71,186 | ₹10,47,30,924 | ₹10,81,42,174 | ₹11,17,12,281 | ₹52,44,12,526 |
| Total cost | ₹12,84,78,456 | ₹13,30,99,807 | ₹13,79,40,976 | ₹14,30,12,728 | ₹14,83,26,363 | ₹69,08,58,331 |
| Cash surplus | ₹88,62,984 | ₹83,61,876 | ₹77,64,558 | ₹70,63,972 | ₹62,52,637 | ₹3,83,06,027 |
| Surplus margin | 6.5% | 5.9% | 5.3% | 4.7% | 4.0% | 5.3% |
| Breakeven utilisation | 91.7% | 92.4% | 93.1% | 93.9% | 94.7% | — |
| Cumulative surplus | ₹88,62,984 | ₹1,72,24,860 | ₹2,49,89,418 | ₹3,20,53,389 | ₹3,83,06,027 | — |
Input sheet — fully editable
Derived from your 5 TPD capacity, press mud (filter cake) feedstock and the project financing above. Edit any cell, add lines, set a per-line escalation, and remove any line with the ×. Edited cells are highlighted; every chart re-reads them. Reset rebuilds the derived lines at the current configuration.
| Particulars | Costed as | Input per month | Unit | Rate (₹) | Cost per month (₹) | Category | Escalation % p.a. | Basis of input | Remove |
|---|---|---|---|---|---|---|---|---|---|
| ₹15,62,500 | |||||||||
| ₹6,25,000 | |||||||||
| ₹10,00,000 | |||||||||
| — | — | ||||||||
| ₹24,30,000 | |||||||||
| — | — | ||||||||
| ₹59,375 | |||||||||
| — | — | ||||||||
| — | — | ||||||||
| — | — | ||||||||
| — | — | ||||||||
| — | — | ||||||||
| — | — | ||||||||
| — | — | ||||||||
| Total cost — at 100% capacity | ₹1,07,06,538 | ₹81,96,330 fixed · ₹25,10,208 variable · ₹12,84,78,456 per year · 14 line items | |||||||
Assumptions to revisit, quotes pending. Saved with the model. | |||||||||
| Particulars | Per day | Days | Input per month | Unit | Rate (₹) | Revenue per month (₹) | Escalation % p.a. | Basis of input | Remove |
|---|---|---|---|---|---|---|---|---|---|
| 1,50,000 | ₹1,08,00,000 | ||||||||
| 350 | ₹4,20,120 | ||||||||
| 150 | ₹2,25,000 | ||||||||
| Total revenue — at 100% capacity | ₹1,14,45,120 | ||||||||
Off-take terms, price discovery, FOM sales plan. Saved with the model. | |||||||||