- Home
- Skills
- Finance & Accounting
- India DCF Valuation (FCFF + FCFE, Ind AS 116 aware)
More screenshots
Works with the AI Agents you already use
India DCF Valuation (FCFF + FCFE, Ind AS 116 aware)
Board-ready DCF for Indian companies: INR CAPM, consistent Ind AS 116 lease basis, 115BAA tax, mid-year discounting, FCFE cross-check, fully diluted bridge and a live Excel model.
$5
India DCF Valuation (FCFF + FCFE, Ind AS 116 aware)
Example session with this skill installed
Build a DCF for an unlisted Indian QSR chain: 4 years financials and lease note attached, 115BAA tax, valuation date 31 March 2026, Series B investor round.
- Read your context and instructions
- Compiled the india dcf valuation
Valuation summary (EV, equity, diluted per-share, range), WACC build, lease basis reconciliation, FCFF/FCFE schedules, bridge, sensitivity grids and a live-formula Excel model.
Connects securely to your tools. The creator never sees your data.
About this skill
Generic DCF skills get Indian companies wrong in three places: they use US risk premia, they double-count leases after Ind AS 116, and they ignore India-specific tax. This skill fixes all three and produces a board-ready, audit-traceable model.
-
3–5 years audited financials (P&L, balance sheet, cash flow) and management projections if any
-
Lease note: lease liabilities, ROU assets, depreciation on ROU, interest on leases, actual rent cash outflow
-
Tax regime (section 115BAA at 25.17% effective incl. surcharge & cess, or the old regime with MAT credit; 115BAB for eligible new manufacturing)
-
Capital structure: debt, cash, investments, CCPS/CCDs/warrants, ESOP pool
-
Valuation date and purpose (investor, internal, regulatory). For regulatory valuations (Rule 11UA, FEMA pricing, SEBI ICDR preferential issue) state that a registered valuer or merchant banker must sign off.
-
Valuation summary first: EV, equity value, per-share value (basic and diluted), range from sensitivity, method weights if blended with comps.
-
Excel model with tabs: Cover, Inputs, Historicals, Drivers, Lease (both bases), WACC, FCFF, FCFE, TV, Bridge, Sensitivity (WACC × g, WACC × exit multiple), Audit checks. All formulas live; no hard-coded outputs.
-
Management summaries in ₹ crore; detail tabs in absolute ₹.
-
Key assumptions and limitations note (suitable for a valuation report annexure).
-
Use
scripts/dcf.pyto verify the headline numbers.
python3 scripts/dcf.py input.json — fields: fcff (list), wacc, g, cash, debt, lease_liabilities, lease_basis ("A" or "B"), diluted_shares, mid_year (bool). Prints EV, equity value and per-share value.
Not a registered valuer's report; regulatory valuations need a registered valuer or merchant banker. User supplies data.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 23 days ago
Permissions
Runs a local Python calculator on user-supplied JSON. No network access.