Pre-loaded with the full four-year Nordcrest Technologies SE case (EUR 20,659,600 consolidated IFRS 2 expense across Plans A through E). Overwrite any blue input cell (share prices, tax rate, grant units, retention rates, or fair values) and all six tabs and ten dynamic audit controls update immediately.
Get the Excel calculator
One Excel workbook, 282 live formulas, zero macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.
The book behind this calculator
The IFRS 2 Share-Based Payment Handbook walks through every line item, journal entry, valuation input, group recharge entry, and audit disclosure in the Nordcrest Technologies SE case.
Inputs_Summary: Editable market share prices (FY1-FY4), corporate tax rate (25%), withholding rate, consolidated 4-year P&L (EUR 20,659,600) and balance-sheet summary, plus the FY1 IAS 33 Diluted EPS module (EUR 2.09).
Graded_Vesting_IFRS2_ASC718: Plan A (300,000 RSUs across 3 tranches) comparing mandatory IFRS 2.IG11 front-loaded attribution (EUR 6,986,000 in FY1) against ASC 718 straight-line with the vested-portion floor (EUR 3,990,000 in FY1).
PSUs_EBITDA_TSR: Plan B1 (non-market EBITDA cumulative true-up) alongside Plan B2 (Relative TSR market condition at EUR 36.50 Monte Carlo FV showing zero P&L reversal when TSR fails in FY3).
Cash_SARs_and_Modif: Plan C cash-settled SARs over four years (including FY3 P&L credit of -EUR 1,495,800), Plan D1 repricing incremental fair value (EUR 4.01), Plan D2 cancellation acceleration and buyout split, Plan E1 net tax withholding (40% cap vs 45% excess test), and Plan E2 compound choice instrument.
Deferred_Tax_IAS12: Full IAS 12.68A-68C intrinsic-value remeasurement across FY1 (EUR 54.00), FY2 (EUR 62.00), and FY3 (EUR 36.00 shortfall), splitting P&L (EUR 2,697,000) vs Equity (EUR 730,000), compared side by side with ASC 718 (ASU 2016-09).
Controls: Ten 100% dynamic audit reconciliation checks verifying zero-variance identities across every tab.