Engagement setup
Company, valuation date, horizon and tax. Amber cells everywhere are inputs; white cells are computed live. All figures in ₹ Millions.
Engagement details flows into report
Forecast horizon & capital
Tax India default
Historical financials
Type the actuals, or upload audited statements / Tally exports and let AI extraction fill the grid. One click then derives growth, margins and working-capital assumptions from the history.
Profit & loss — actuals (₹ Mn)
Balance sheet as on valuation date (₹ Mn)
Net fixed assets seed the opening WDV; current items set opening working capital; debt, cash and investments drive the equity bridge.
Revenue build-up
Project revenue by segment: first-year revenue, then year-on-year growth — the Revenue Driver sheet of the Excel model.
Segment drivers
Projected revenue (₹ Mn)
Operating costs & projected P&L
Cost lines as % of revenue, set year by year. The projected P&L recomputes to EBIT on every keystroke.
Cost assumptions — % of revenue
Projected profit & loss (₹ Mn)
Capex, depreciation & equity infusion
Written-down-value method: depreciation = rate × (opening WDV + additions).
Assumptions
Capex & depreciation schedule (₹ Mn)
Equity infusion plan (₹ Mn) optional
Fresh equity is added to free cash flow in the year received and its present value is deducted from enterprise value — matching the Excel treatment.
Working capital
Balances projected from holding periods (months of the relevant driver); the change in non-cash NWC flows into FCF.
Holding period assumptions (months)
Working capital projections (₹ Mn)
Cost of capital
CAPM build-up for cost of equity, blended with post-tax cost of debt at the target structure.
Cost of equity (Ke)
Cost of debt & capital structure
Build-up
DCF valuation — FCFF
Mid-period discounting from the valuation date, terminal value by Gordon growth and/or exit multiple, and the equity value bridge with implied-multiple cross-checks.
Terminal value method
Free cash flow build-up (₹ Mn)
Equity value bridge (₹ Mn)
Implied multiples — cross-check
Compare against listed comparables / transaction multiples to sanity-check the DCF conclusion.
Risk & sensitivity
Two-way sensitivity grids, a Monte Carlo simulation across the key value drivers, and the valuation football field.
Enterprise value (₹ Mn) — WACC × terminal growth
Equity value (₹ Mn) — WACC × terminal growth
Monte Carlo simulation 5,000 trials
Valuation football field — equity value (₹ Mn)
Scenario manager
Base, Bull and Bear hold independent assumption sets. Switch with the chips in the top bar — every sheet edits the active scenario. Reset Bull/Bear to regenerate them from Base with standard spreads.
Scenario comparison
Default spreads: Bull = growth +5 pts each year, indirect costs −2 pts, terminal growth +0.5 pt. Bear = the reverse. After regenerating, fine-tune each scenario on its own sheets.
Equity value by scenario
Dashboard
Free cash flow vs discounted cash flow
Revenue & EBITDA margin
Equity value bridge
Valuation report
A complete, paginated report generated from the live model — cover, certificate of value, methodology, assumptions, WACC and DCF annexures, sensitivity and signature block. Review the preview, then print to PDF.