First page of the UK Capital Allowances CalculatorExcel workbook preview

UK tax (HMRC)

UK Capital Allowances Calculator

Capital allowances calculator in Excel: full expensing, AIA, 40%, 50% and 100% first-year allowances, main and special rate pools and the 14% hybrid rate.

Excel workbook · 18 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

Capital allowances give tax relief on plant and machinery a business buys. Companies can claim full expensing on new main rate assets and a 50% first-year allowance on new special rate assets, businesses have a GBP 1 million Annual Investment Allowance, and from 1 January 2026 a new 40% first-year allowance applies. From April 2026 the main pool writing down allowance falls from 18% to 14%, so many accounting periods need a hybrid rate.

This calculator lists each addition with its category and chosen claim, checks the claim against the business type and the date, and sends the rest to the main or special rate pool. It handles disposals, small pools and the hybrid rate, then totals the allowances for the tax computation. Rates and rules come from the gov.uk capital allowances guides and the Autumn Budget 2025 policy paper.

Who it is for

The financial controller or tax accountant who has to work out a company's capital allowances claim for the Corporation Tax computation after the 2026 changes.

What is inside

  • Additions sheet with 12 worked assets and 20 blank rows, 7 asset categories and 6 claim types
  • Eligibility check by formula for each claim: business type, category and date, with ineligible claims flagged red
  • Main and special rate pools with disposals, balancing charges and the GBP 1,000 small pools allowance
  • Hybrid main pool rate by formula for a period spanning the 18% to 14% change on 1 April 2026
  • AIA scaled for short periods and checked against the limit
  • Summary of allowances by type, giving the net claim for the tax computation
  • Inputs sheet with every rate, limit and start date as a sourced input cell

How to use it

Enter the accounting period and business type on the Inputs sheet and check each rate against gov.uk, then list the additions with the claim you want.

Files

  • XLSXuk-capital-allowances-calculator.xlsx18 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What is the main rate writing down allowance from April 2026?

The gov.uk policy paper from the Autumn Budget 2025 reduces the main pool writing down allowance from 18% to 14%, from 1 April 2026 for Corporation Tax and 6 April 2026 for Income Tax. A period that includes the change date uses a hybrid rate based on the share of the period before and after the change.

What is the new 40% first-year allowance?

The policy paper introduces a 40% first-year allowance for main rate expenditure incurred from 1 January 2026. It is available to all businesses, including leasing, but excludes cars, second-hand assets and assets for overseas leasing. The remaining 60% of the cost goes into the main pool.

Can I claim full expensing on a second-hand asset?

No. gov.uk says only companies can claim full expensing, and only on plant and machinery that is new and unused and not a car. A second-hand asset can still qualify for the Annual Investment Allowance. The calculator flags a full expensing claim on a second-hand item in red.