Models
SP CAPITAL FINANCING LTD.BSE 530289Commercial Services & Supplies
₹481per share · Base Model Note
Revenue growth, the horizon and scenarios are yours to change. Every other input is part of the Trader plan; saving, sharing a saved link and the live-formula workbook are part of the Institutional plan.
Scenario
Value per share, your model₹481implied FY26 P/E 51.1× · EV/EBITDA 30.7×
Against CMP ₹51.54+833.4%close of 9 Oct 2026
Growth the CMP implies—%no growth rate between −20% and 45% a year brings the value to the CMP on your other inputs
Value after FY3182%share of enterprise value in the terminal
This figure is the arithmetic of your inputs and nothing else. MarketPing publishes no fair value, target or rating; the model is yours.

Where the methods land · ₹ per share · the dashed line is the CMP

DCF, rate ±1 · growth ±1your model across the sensitivity grid
₹366₹712
52-week rangetraded range, a fact not a value
₹48₹72

From enterprise to equity · ₹ crore

PV of FY27–FY31 free cash flow53
PV of terminal value235
Enterprise value288
less net debt1
less non-controlling interest0
add non-operating investments0
Equity value289
÷ 0.60 crore shares₹481
82% of the value sits after FY31. Usual when return on capital sits near the cost of capital; the 5 explicit years carry little of it.

Free cash flow, filed and modelled · ₹ '000 crore

0000000FY21: ₹(3) croreFY21FY22: ₹2 croreFY22FY23: ₹10 croreFY23FY24: ₹1 croreFY24FY25: ₹1 croreFY25FY26: ₹5 croreFY26FY27: ₹8 croreFY27FY28: ₹10 croreFY28FY29: ₹13 croreFY29FY30: ₹17 croreFY30FY31: ₹23 croreFY31
Filed, cash from operations − capexModelled free cash flow to firm

Sensitivity · ₹ per share

Down Across
WACC ↓terminal growth →4.0%4.5%5.0%5.5%6.0%
10.00%498537583641712
10.50%457489528573630
11.00%422449481519564
11.50%392415442473510
12.00%366385408435465
The outlined cell is your model. Green figures sit above the CMP of ₹51.54; n/a marks a terminal growth at or above the discount rate. Steps: WACC and terminal growth ±0.5 point, growth ±2, margin ±1.

Distribution of outcomes · 4,000 draws · growth, margin and the discount rate vary together

P10 ₹348P50 ₹479P90 ₹648
10th · 50th · 90th percentile, ₹ per share348 · 479 · 648
Draws below the CMP0%
Rank correlation with revenue growth+0.85
Rank correlation with discount rate−0.40
Rank correlation with ebitda margin+0.28
Each driver is drawn from a PERT distribution between the lowest and highest value across your scenarios (or ±50% growth, ±20% margin when there is one scenario), with the discount rate ±1.5 points. Seeded, so the same inputs give the same picture.

Projected cash flow to the firm · ₹ crore

History Forward
₹ croreFY23FY24FY25FY26FY27FY28FY29FY30FY31
Revenue235111418233039
growth %85.962.8115.191.830.030.030.030.030.0
EBITDA12491216212735
margin %59.068.778.789.289.289.289.289.289.2
less depreciation000000000
EBIT12491216212735
less tax on EBIT(3)(4)(6)(7)(9)(12)
NOPAT6810131723
add depreciation000000000
less capex000000000
less working-capital build—00000
Free cash flow to firm1011—810131723
Discount factor0.9490.8550.7700.6940.625
Present value89101214
History columns are the filed years (free cash flow there is cash from operations − capex, as filed); the base year and everything to its right come from the engine. Forward is the explicit horizon of the model itself: 3, 5 or 10 years, then flat.

The three statements, projected · ₹ crore · debt held at 0, dividends at 0% of profit

₹ croreFY26FY27FY28FY29FY30FY31
Income statement
EBIT91216212735
Interest at 8% on debt00000
Profit before tax1216212735
Profit after tax0810131723
Dividends(2)00000
Balance sheet, year end
Cash1919325072
Working capital000000
Net block and other assets151151151151151151
Debt000000
Equity273545587699
Balance check000000
Cash flow
From operations810131723
Investing (capex)00000
Financing (dividends)00000
Net change in cash810131723
Free cash flow to equity810131723
Other liabilities are held at their FY26 level, so the check tests only what the model moves: cash, working capital, net block and other assets, debt and equity. A non-zero check would mean the three statements no longer tie.

Scenarios side by side · ₹ per share

ScenarioTemplateGrowthMarginRateTerminal₹ / sharevs CMP
Base · editingDCF30%89.2%11.00%5%₹481833.4%
A scenario is a full set of inputs under a name. Keep Base as the filed history carried forward; add Bull and Bear by saving the current inputs under those names and moving the two or three assumptions you actually hold a view on. The distribution above draws each driver between the lowest and highest value across your scenarios, so three scenarios give it a real range; with one scenario it falls back to fixed bands.