Free Templates · UK Corporate Tax

UK CIR Disallowance Calculator in Excel

TIOPA 2010 Part 10 & Schedule 7A: Fixed Ratio vs. Group Ratio Method, QNGIE, PIE Election, and Disallowance Allocations

Download the unlocked, macro-free Excel workbook pre-loaded with the three-year Thamesbridge Infrastructure & Industrial Group plc case study (£9.00m to £16.50m ANTIE across four UK subsidiaries). Substitute your own group's entity figures in the blue cells to compute FRM vs. GRM disallowances, Schedule 7A non-consenting pro-rata caps, PIE election savings, and multi-period reactivations.

Direct Download (No Macros, 100% Live Formulas)

File: UK_CIR_Disallowance_Calculator.xlsx (20 KB, 5 linked tabs, verified with 0 formula errors).

Download Excel Calculator (.xlsx)

What is inside the 5 tabs

Tab NameScope & Live Formulas
CIR_3Year_Model4 UK entities + IFRS worldwide inputs across FY2024 to FY2026; 0/1 FRM vs. GRM election toggle; 30% cap + ANGIE debt cap; QNGIE/Group-EBITDA (100% cap) + QNGIE debt cap; £2.00m de minimis floor; 5-year unused allowance & indefinite disallowed carry-forward; 25% UK CT cash tax impact.
Allocation_Sch7AFY2025 Schedule 7A disallowance allocation across consenting and non-consenting companies; automatic paras 22-23 (para 23(4)) pro-rata cap (£0.70m on OpCo 2); net-interest-income protection; FY2026 company-level reactivation tracker.
PIE_ComparisonSide-by-side FY2025 comparison with and without the Public Infrastructure Exemption (ss. 432-449) on InfraCo (£3.50m vs. £2.85m disallowance; £0.65m deduction saving).
Sensitivity_CasesThree standalone statutory edge cases: De Minimis non-carry-forward trap (SmallCo), Fixed Ratio Debt Cap binding (LowDebt), and 100% Group Ratio ceiling (HighLeverage).
Controls10 dynamic accounting and statutory identity checks (zero hardcoded constants) with automatic PASS/FAIL status and error counter.

Go deeper with the full handbook

Every formula, statutory citation (TIOPA 2010 ss. 372-498, Schedule 7A, Finance Act 2026 reforms), and accounting entry in this calculator is documented line by line in The UK Corporate Interest Restriction Handbook.

Explore The UK Corporate Interest Restriction Handbook →

Related technical guides

UK CIR Fixed Ratio vs. Group Ratio Method: Complete Worked Example Under TIOPA 2010

UK CIR Public Infrastructure Exemption (PIE): Eligibility, Trade-Offs, and Worked Calculation

UK CIR Unused Interest Allowance Carry-Forward and Reactivation Rules Explained