Skip to main content

5-Year P&L Projections

Profit and loss forecasts across conservative, realistic, and optimistic scenarios.

Key Parameters

ParameterValue
Annual Revenue Growth Rate15%
Fixed Cost Annual Increase5%
Variable Costs45% of Revenue

Revenue Projections (₹ Cr)

ScenarioYear 1Year 2Year 3Year 4Year 5
Conservative8.339.5811.0212.6714.58
Realistic10.8312.4614.3316.4818.95
Optimistic15.9118.3021.0424.2027.83

Fixed Costs (₹ Cr)

ItemYear 1Year 2Year 3Year 4Year 5
Fixed Costs6.546.877.217.577.95

Fixed costs increase at 5% annually

Variable Costs (₹ Cr)

45% of Revenue

ScenarioYear 1Year 2Year 3Year 4Year 5
Conservative3.754.314.965.706.56
Realistic4.885.616.457.418.53
Optimistic7.168.239.4710.8912.52

EBITDA (₹ Cr)

Revenue - Fixed Costs - Variable Costs

ScenarioYear 1Year 2Year 3Year 4Year 5
Conservative-1.95-1.59-1.15-0.600.07
Realistic-0.58-0.010.671.492.47
Optimistic2.213.204.375.747.36

EBITDA Margin (%)

ScenarioYear 1Year 2Year 3Year 4Year 5
Conservative-23.5%-16.6%-10.4%-4.7%0.5%
Realistic-5.3%-0.1%4.7%9.1%13.1%
Optimistic13.9%17.5%20.7%23.7%26.4%

Realistic Scenario - Detailed P&L

Line ItemYear 1Year 2Year 3Year 4Year 5
Revenue10.8312.4614.3316.4818.95
Variable Costs (45%)(4.88)(5.61)(6.45)(7.41)(8.53)
Gross Profit5.956.857.889.0710.42
Fixed Costs(6.54)(6.87)(7.21)(7.57)(7.95)
EBITDA(0.58)(0.01)0.671.492.47
Depreciation(2.31)(2.31)(2.31)(2.31)(2.31)
EBIT(2.89)(2.32)(1.64)(0.82)0.16

5-Year Cumulative Performance

ScenarioTotal RevenueTotal EBITDAAvg Margin
Conservative₹56.18 Cr-₹5.22 Cr-9.3%
Realistic₹73.05 Cr₹4.04 Cr5.5%
Optimistic₹107.28 Cr₹22.88 Cr21.3%

Key Insights

  1. Conservative Scenario: Breaks even only in Year 5
  2. Realistic Scenario: EBITDA positive from Year 3, strong margins by Year 5
  3. Optimistic Scenario: Profitable from Year 1 with healthy 26% margins by Year 5