Syamantak Valuation Engine

Load the financials

Upload the client Excel, or enter the figures yourself — choose a route below.

Pick the option that matches how your figures are supplied — most users: “One complete file”. Which should I use?

Most common

📄

One complete file

P&L and balance sheet in the same workbook (or a CMA). You confirm each mapped line.

📂 Choose file

No file

⌨️

Paste your statements

Copy your P&L and balance sheet from Excel and paste them — any format, including Tally.

Projections

📈

P&L / projections only

A forecast P&L (new company). If it has projected balance-sheet lines, we build the cash flow & balance sheet from them.

📂 Choose P&L file

Two files

🗂️

Separate files

Projections in one file, the balance sheet in another. Pick both here — they merge into one model.

📈 Projections file 🗂️ Balance sheet

Pick both files — they merge automatically.

🔒 Your data stays on this computer. The tool runs entirely on your laptop — the client’s figures and the report are never uploaded to any server or cloud. You control the files.

Company details

Identification, purpose & valuation basis.

Company Identification

Company Name *

CIN

PAN

Date of Incorporation

Sector * (Damodaran list)

Sub-Sector / Business Description

No. of Equity Shares *

Face Value per Share (₹)

No. of Preference Shares

Constitution / Type of Entity

Registered Address

Nature of Business / Principal Activity (prints in the report; also sets the sector)

Directors / Partners (each in its own row — Name, Designation, DIN/PAN — prints as a table in the report)

Purpose of Valuation

Choose the Act, then the transaction, then the section — each list narrows the next, and the tool writes the formal purpose statement for you below. The statement is fully editable: expand it, or add anything specific to this engagement. If your matter isn’t in the lists, set the Act to “General fair-value opinion” and simply type your own purpose.

1. Applicable Act / Regulation

2. Nature of transaction

3. Section / Rule

＋ Cite an additional section / rule (optional)

Instrument(s) being valued / issued / transferred (tick all that apply — the purpose statement cites them, e.g. CCPS)

Salient terms of the CCPS / convertible instrument (prints as Annexure I — edit or paste the actual terms from the term sheet)

One term per line as “Label: value”. This appears as Annexure I — Salient terms of the CCPS in the report, and the Sources of Information already refers to it.

Purpose statement (auto-written from the Act, transaction & instruments — fully editable)

Report regime (bifurcate FEMA ↔ Companies-Act content — generate one of each)

Combined (both) FEMA report Companies-Act report

Combined — both FEMA and Companies-Act clauses included.

Annexures / additional documents forming part of the report (e.g. the CCPS Subscription / Shareholders Agreement, term sheet, board resolution)

List any document that is to be annexed to and form part of the report. The report prints an Annexures index and a note that the listed documents are enclosed. Attach the actual document(s) to the signed report (upload an image of a page to embed it, if you wish).

🖼 Attach page images

Valuation basis

Valuation Date * pick from the calendar

Financial Year End (for stub period computation)

🗓️

Valuation basis

Defines the starting point for every number

Balance sheet at the valuation date is

Currency

Default INR → INR. Set another currency + rate to convert all figures; the rate & date print in the report.

Input currency (financials)

Output / report currency

Exchange rate

Rate date (for the report)

Financial Data

From your figures

Show figures in:

The figures read from your file — every cell is editable, and totals re-tally as you type.

Valuation Methods

Pick the approaches — the advisor recommends from your data.

Select the approach(es) to apply

✓ The methods already ticked are Syamantak’s advisor’s suggestion, chosen from your financials (leverage, debt schedule, sector) and marked ★ Rec. You can change them — tick or untick any approach; the final choice is yours. The reasoning is shown below the cards.

FCFF Firm cash flow · WACC · income approach FCFE Equity cash flow · Ke · income approach NAV Net asset value · cost approach CCMM Listed comparables · market approach

What ticking does: a ticked method is computed and shown in the report. By default the income method (FCFF/FCFE) carries the conclusion, and NAV / CCMM are shown as a cross-check — not blended into the weighted average. To actually weight a method into the concluded value, switch it to “Weight into conclusion” below (or set its weight on the Valuation screen). Unticking a method leaves it out of the report, except for a one-line note that it was considered and not adopted.

Discount Rate

CAPM-based cost of equity · WACC build-up · Damodaran sector beta

Money in the future is worth less than money today, and a riskier business is discounted harder. This screen builds the rate that brings the projected cash flows back to the present — the cost of equity (Ke) from the CAPM, and, where the company has debt, the blended cost of capital (WACC). Work through the parts in order.

Market data — Sensex · Rf · Tax

BSE Sensex opening: 3,568.27 (10 May 2001) · BSE MidCap opening: 1,677.24 (11 Apr 2005, common base) · Enter current closing levels below

BSE Sensex — Level on Valuation Date ↗ BSE Historical Data

BSE MidCap — Level on Valuation Date ↗ Look it up on BSE Historical Data

Risk-Free Rate — Rf (10-yr G-Sec yield %) ↗ Investing.com

Sector (Damodaran — for Beta)

Tax Rate (%)

USD/INR, EUR/INR, GBP/INR — useful when the report currency isn’t INR.

Beta (β) — market sensitivity

Unlevered Beta (βU) — Damodaran sector ↓ Damodaran βu table ↗ source

Debt / Equity Ratio (from BS)

Beta Levered (βL) — Hamada formula

Manual Override Beta (enter to override the Hamada βL above)

Reason for the adopted beta (required — this prints in the report whenever the beta differs from the software's sector suggestion)

Bottom-up check against your actual comparables (add them on the Market/CCMM tab first).

Company-specific risk premium (CSRP) ★ Most reviewed by IBBI

CSRP Total 0.00%

Or enter CSRP % directly % (spreads across the factors above)

CAPM Cost of Equity Build-up

Market Returns — BSE Sensex CAGR

—

↳ Override market return (optional — to tie to your own working)

Risk-Free Rate (Rf)

—

Equity Risk Premium (ERP = Market Returns − Rf)

—

↳ Override ERP

Beta Levered (βL)

—

β × ERP

—

Company Specific Risk Premium (CSRP)

—

Open to add a Country Risk Premium (CRP) — usually 0% 0.00% ▾

India already sits inside the Sensex-based ERP, so leave this at 0% for an INR valuation. Add a CRP only if you are benchmarking against a foreign (e.g. US) market return.

Damodaran India CRP — 1.41% (indicative - update to the latest).

Open to apply a Size Premium — small/mid-caps earn more — Apply ▾

A smaller company is riskier than the large-caps in the Sensex, so investors demand a little extra. We measure it as the gap between BSE MidCap and Sensex long-run returns (common base 11 Apr 2005).

Sensex CAGR (from 6397.52): — · MidCap CAGR (from 1677.24): —

Cost of Equity (Ke) = Rf + βL × ERP + CSRP + Size Premium

—

↳ Override Cost of Equity (flows into WACC too)

Cost of Debt & WACC Critical output

Cost of Equity (Ke) — equity-only

Used to discount FCFE — the cash to equity.

→

WACC — whole company

Blends Ke with the after-tax cost of debt. Used to discount FCFF (cash to all capital); usually lower than Ke.

Cost of Debt — Pre-tax Kd (%) see debt schedule

Cost of Debt — Post-tax (auto)

Particulars	Amount (₹)	Cost (%)	WACC	Weight %

Terminal growth (TGR) & DLOM TV driver

Terminal Growth Rate — TGR (%) Must be ≤ WACC − 2%

DLOM — Discount for Lack of Marketability (%)

Discount rate — result

WACC

—

TGR

—

DLOM

—

↳ Override WACC directly %

Review — before you value

A last check that every input is set and confirmed — whichever method you use.

FCFF — Free Cash Flow to Firm

EBIT(1−t) + Depreciation − ΔWC − Net CapEx · Discounted at WACC

FCFE — Free Cash Flow to Equity

Net Income + Depreciation − ΔWC − Net CapEx + Net Borrowing · Discounted at Ke

NAV — Net Asset Value

Adjusted book value · Land & Building market value override supported

CCMM — Comparable Companies Multiples

BSE/NSE listed peers · FY2025 annual data · P/E · P/B · EV/EBITDA · EV/Sales · All multiples editable

Sector for peer selection:

Override sector if peers don't match

Weighted Average & Conclusion

Select methods · Assign weights · Weights must total 100%

Sanity Check

A last look before concluding — does the valuation hold together?

Sensitivity Analysis

Per-share value matrix across WACC and TGR ranges

Valuation & Conclusion

Your concluded value — finalise and lock it; work out pre-money / post-money only if raising investment.

Checklist & Notes

Engagement workpaper — information checklist, fee note, discussion points and your record notes. Saved with the session.

Valuation Report

Professional report — format per Sunil Abhyankar & Associates standard

Before generating

Figures in the report

Sets the unit for the whole report, consistently — independent of the “Figures in” display you work in on screen. (Per-share values are always in ₹.)

UDIN Include the UDIN in the report

Off by default — tick only for the final signed report (UDIN is generated after signing).

Date of signing

📝 Management Representation Letter — ready to issue

Syamantak prepares a tailor-made MRL from this engagement — the company, the purpose, the projection years relied upon, the methods applied, and any beta / normalisation adjustments are already written in. Download it as Word and send it to the client to print on their letterhead and sign.

Include industry analysis (draft review only — leave OFF for the signed report)

Show the CCMM comparison in the report (cross-check only) — shown only if you select CCMM on Methods and fill that screen; it is a cross-check, not weighted.

Complete the panels, then Generate Report — a draft Word document in IBBI format with all disclosures.

Valuer Profile

Registered Valuer credentials · auto-applied to every report & UDIN declaration

Industry Analysis — Positioning

Peer multiples vs sector benchmarks · Syamantak commentary

Projected Ratios

ROE · ROIC · margins · leverage trajectory · computed reasonableness check

📄 Map Project Report → DCF