Free Templates · UK Corporate Tax
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.
File: UK_CIR_Disallowance_Calculator.xlsx (20 KB, 5 linked tabs, verified with 0 formula errors).
| Tab Name | Scope & Live Formulas |
|---|---|
| CIR_3Year_Model | 4 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_Sch7A | FY2025 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_Comparison | Side-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_Cases | Three standalone statutory edge cases: De Minimis non-carry-forward trap (SmallCo), Fixed Ratio Debt Cap binding (LowDebt), and 100% Group Ratio ceiling (HighLeverage). |
| Controls | 10 dynamic accounting and statutory identity checks (zero hardcoded constants) with automatic PASS/FAIL status and error counter. |
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.
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