Stop re-typing the same formulas in a new sheet for every company.
StockTracker has the projection grid and valuation framework built in. Enter the drivers — revenue growth, margins, target multiples — and the buy price, margin of safety, and IRRs compute themselves. Bull, base, and bare on one page; recomputed every time results come in.
- Target buy
- ₹3,400
- Margin of safety
- -5.9%
- Base-case IRR (3y)
- 5.3%
Numbers frozen the day it was printed. Is it still a buy today? You can't tell.
Your model, out of the spreadsheet
The rigour of a financial model — without rebuilding it from a blank sheet every time.
No more re-typing the same formulas
Every new Excel sheet starts with the same skeleton: revenue growth, EBITDA margin, PAT, EPS. StockTracker has that skeleton built in — you enter the drivers, it computes the rest, for every company you research.
Bull, base, and bare on the same page
Set optimistic, realistic, and pessimistic multiples for the same set of projections. The three target prices, margins of safety, and IRRs are side by side — so you know the downside before you decide, not after.
The buy price recomputes when results come in
After each quarterly result you revise the projections. The target price, margin of safety, and buy price all update immediately — in the same model you built originally, not in a copy that forked six months ago.
Projections grid · PE / Earnings
Switch to EV/EBITDA| Metric | FY23A | FY24A | FY25A | FY26E | FY27E | FY28E |
|---|---|---|---|---|---|---|
| Revenue (₹ Cr) | 3,240 | 3,890 | 4,620 | 5,430 | 6,370 | 7,430 |
| EBITDA (₹ Cr) | 487 | 604 | 740 | 896 | 1,083 | 1,300 |
| EBITDA % | 15.0% | 15.5% | 16.0% | 16.5% | 17.0% | 17.5% |
| PAT (₹ Cr) | 298 | 374 | 468 | 572 | 702 | 862 |
| EPS (₹) | 14.2 | 17.8 | 22.3 | 27.2 | 33.4 | 41.0 |
| EPS Growth % | — | 25.3% | 25.3% | 22.0% | 22.7% | 22.7% |
| Scenario | PE Multiple | Target EPS | Target Price | MoS % | IRR |
|---|---|---|---|---|---|
| Bull | 35× | ₹41.0 | ₹4,345 | +35% | 28.4% |
| Base | 28× | ₹41.0 | ₹3,476 | +18% | 18.4% |
| Bare | 20× | ₹41.0 | ₹2,481 | -13% | 4.1% |
CMP ₹2,841.5 · Target buy ₹2,272 · Buy price back-solved from 18% required return on base case
A real valuation model in StockTracker — names masked for privacy. Numbers illustrative.
How to do this in StockTracker
From a blank projection grid to a live buy price with three scenarios — in one session.
Open a company and go to Projections & Valuations
Every company in StockTracker has a Projections & Valuations tab. It starts with a blank grid ready for your assumptions.
Pick PE/Earnings or EV/EBITDA
Choose the framework that fits the business — PE for most listed companies, EV/EBITDA for capital-intensive or loss-making businesses where EBITDA is the more meaningful driver.
Enter the drivers
Fill in revenue growth, EBITDA (or PAT) margin, and any other assumptions for each year. The app computes PAT, EPS, EBITDA, and growth rates — you focus on the assumptions, not the formulas.
Set target multiples for bull, base, and bare
Assign a PE (or EV/EBITDA) multiple to each scenario. StockTracker computes the implied target price, margin of safety, and IRR for each case automatically.
Read your buy price and IRRs — they update after every result
Your base-case buy price back-solves from your required return and lives on the dashboard as your watchlist target. After each quarterly result, revise the projections and the numbers update in place — the same model, not a new copy.
Explore more
Frequently asked questions
- Which valuation frameworks does StockTracker support?
- Two: PE/Earnings (you set the target PE and the forward EPS; the app computes target price, margin of safety, and IRR) and EV/EBITDA (same structure, with EBITDA as the driver and an EV-to-equity bridge). You pick one per model, but you can create multiple models per company — for example a PE model and an EV/EBITDA model side by side.
- What is the 'back-solved buy price'?
- Instead of asking 'what is this stock worth at today's CMP?', back-solving asks 'given my base-case target price and my required return of X% per year, what is the maximum price I should pay today?' The app solves for that entry price automatically — it's the same number as your target buy price on the watchlist and dashboard.
- What is the forward PEG check?
- PEG (PE divided by earnings growth rate) is a sanity check on whether the multiple you're paying is reasonable given the growth you're projecting. StockTracker computes it from your model's projected EPS growth and the base-case target PE so you can spot a stretched valuation before you finalise your price.
- Can I model multiple scenarios per company?
- Yes. Every company has a default model (the one whose buy price drives the dashboard BUY signal), but you can save additional models under the same company. Bull/base/bare is built into every model as three columns of the same projection — they share the same growth assumptions but differ only in the target multiple you assign each case.