More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    ESOP Valuation & Expense (Ind AS 102 / IFRS 2)

    1

    Values ESOPs with Black-Scholes per tranche and builds a live-formula Excel Ind AS 102 / IFRS 2 expense schedule with graded vesting, attrition, journal entries and disclosures.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    ESOP Valuation & Expense (Ind AS 102 / IFRS 2)

    ESOP Valuation & Expense (Ind AS 102 / IFRS 2)

    Example session with this skill installed

    Grant on 1 Jun 2025: 1,00,000 options, exercise Rs 10, fair value per share Rs 120, volatility 45%, risk-free 6.8%, 10% annual attrition, vesting 25% a year over 4 years. FY April-March.

    • Read your context and instructions
    • Compiled the esop valuation

    Fair value per option Rs 112.12 to Rs 112.90 by tranche. 77,378 options are expected to vest after attrition, for a total cost of Rs 87.04 lakh. Expense: FY2026 Rs 39.91 lakh, FY2027 Rs 27.13 lakh, FY2028 Rs 13.43 lakh, FY2029 Rs 5.79 lakh, FY2030 Rs 0.79 lakh. The check is 0, and the journal entries and disclosure inputs are included.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Built by a CFO and former valuation professional who has valued options for listed and unlisted companies and defended the workings to auditors.

    Share your ESOP plan and grant register. The skill sets defensible inputs:

    • Share price at grant, including unlisted valuations
    • Peer-based volatility
    • A risk-free rate matched to the expected life
    • Expected life by the simplified method

    It then builds an Excel model with every cell a live formula:

    • Black-Scholes fair value per tranche, with d1 and d2 visible
    • Expected options vesting after attrition
    • Graded-vesting attribution, so each tranche is expensed over its own vesting period
    • Cumulative catch-up by financial year, plus a check that total expense equals total cost
    • Journal entries for grant, exercise and lapse

    It also covers the judgement areas auditors probe: performance and market conditions, IPO-linked vesting, modifications, cancellations, forfeiture true-ups, group plans and SARs. You get a disclosure note draft and a sensitivity table.

    Includes a tested Python engine.

    Equity-settled plans with service and non-market conditions. Market-condition awards need Monte Carlo and cash-settled SARs need remeasurement; both are flagged. Not tax advice.

    How to use

    1. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Requires

    Python 3
    openpyxl

    Permissions

    File Scopes

    grants.json
    and
    the
    generated
    .xlsx
    in
    working
    folder

    No network access.

    Listed23 days ago

    What's inside

    Frequently Asked Questions

    Ind AS 102 / IFRS 2 require graded-vesting attribution: each tranche is a separate award, which front-loads expense compared with one straight line.

    It uses the median volatility of 3-5 listed peers over the expected life, and shows the peers so your auditor can review them.

    Yes. An annual attrition estimate reduces expected options vesting, and you true it up to actual leavers through the cumulative catch-up.

    New in Finance & Accounting