0.5% CREST SDRT vs. £5-rounded Stock Transfer Forms, earn-out contingency engine, Section 42 75% group relief tests, Sections 75/77/77A reliefs, FA 2019/2020 market value rules, and FA 2024 1.5% ADR calculations.
Pre-loaded with Alderbrook Industrial Group plc's £768,148,283.00 (£768.15m) corporate program (£5,081,744.75 gross exposure reduced to £410,740.00 actual tax, saving £4,671,004.75). Overwrite any blue input cell or toggle statutory flags on the Controls tab to model your own UK share acquisition, reorganization, or ADR offering.
Get the Excel calculator
One Excel workbook, 6 linked tabs, 165 live formulas, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
UK_Stamp_Duty_SDRT_Calculator.xlsx (21 KB)
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 UK Stamp Duty and SDRT Handbook reconciles every formula on Alderbrook Industrial Group plc: Stamp Act 1891 vs. Finance Act 1986 Part IV, earn-out contingency structuring, Section 42 and Section 27(3) group relief, Sections 75-77A reconstructions, FA 2019/2020 market value traps, and FA 2024 depositary receipts.
Controls: Editable statutory rates (0.5%, 1.5%, £5 rounding, £1,000 de minimis, 75% group threshold, 7.25% late interest, FA 2024 ADR toggle) plus automated master balance checks and module summary.
Core_05_and_Rounding: Compares CREST SDRT exact-penny calculations against paper Stock Transfer Form £5 ceiling rounding, £1,000 Certificate 1 de minimis, and the AIM Recognised Growth Market exemption.
EarnOut_Contingency: Models initial cash plus assumed vendor debt (s. 57) across capped, uncapped (with Section 92 SDRT cancellation), minimum-only floor, and unstamped SDRT earn-out structures.
Group_and_Reorg: Live pass/fail engine for Section 42 FA 1930 (75% ordinary shares, CTA 2010 profits and assets tests) and Section 27(3) disqualifying arrangements, plus Sections 75, 77, and 77A reconstructions.
Connected_MV_and_ADR: Calculates FA 2019 s. 47 listed connected-company market value charges, FA 2020 s. 77 unlisted share-issue transfers vs. cash, and post-FA 2024 primary (0%) vs. secondary (1.5%) ADR and Section 97A clearance transfers.
Late_Filing_and_Ledger: Computes Stamp Act 1891 ss. 15A-15B late stamping interest and tiered penalties (180 vs. 400 days) and consolidates the complete 9-deal executed program ledger.