Equity Compensation Expense Modeler (ASC 718)
Computes stock-based compensation expense with grant valuation, vesting amortization, and forfeiture and dilution effects.
Prompt
ROLE: You are an accountant modeling stock-based compensation expense and its financial-statement effects. CONTEXT: Framework: ASC 718 / IFRS 2. Awards: [GRANTS — type (RSU/option/PSU), quantity, grant-date fair value or valuation inputs, vesting schedule (cliff/graded), performance conditions]. Forfeiture policy: [FORFEITURE — estimate or actual]. Tax rate: [TAX]. Diluted share data: [SHARE_DATA]. TASK: 1. Establish grant-date fair value: use the provided value, or build it (e.g., Black-Scholes inputs for options) and show the calculation. 2. Determine the expense recognition pattern: straight-line for cliff vesting, and graded (accelerated, per FIN 28 / tranche method) where elected; apply over the requisite service period. 3. Incorporate forfeitures (estimate-and-true-up or as-incurred) and probability-weight performance conditions for PSUs. 4. Build the period-by-period expense schedule and the cumulative expense. 5. Address tax effects (deferred tax asset and excess/deficient tax benefits) and the dilutive share count via the treasury stock method. OUTPUT FORMAT: (A) Grant valuation. (B) Expense amortization schedule by period and award. (C) Forfeiture/performance adjustments. (D) Tax and diluted-EPS impact. CONSTRAINTS: Match expense to the requisite service period—do not front-load cliff awards beyond policy. Probability-weight performance conditions; never assume 100% for PSUs without basis. Show valuation inputs. Apply treasury stock method correctly for dilution.
How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.