IRS releases new look-back interest calculator for long-term contracts

What is the new IRS calculator?

The IRS released a free Excel tool to help businesses with large, multi-year construction or manufacturing projects figure interest tied to those contracts. It is called the Percentage-of-Completion Method (PCM) Look-Back Interest Calculator.

The tool supports calculations needed for Form 8697, Interest Computation Under the Look-Back Method for Completed Long-Term Contracts.

You can download it here: IRS PCM Look-Back Interest Calculator (Excel).

Who may find it useful?

Tax professionals who work with long-term contracts may find the calculator helpful, including:

• Certified public accountants (CPAs)
• Enrolled agents (EAs)
• Other tax preparers handling construction or manufacturing contracts

If your client builds projects or manufactures goods over more than one year, look-back interest rules may apply when the contract is completed.

What is look-back interest?

In plain terms, look-back interest adjusts for the fact that income from a long-term contract was estimated over several years. When the job is done, actual revenues and costs are known. The look-back method rechecks earlier years and figures interest if tax was underpaid or overpaid based on those estimates.

The three steps

Look-back interest is figured in three steps:

1. Reallocate income — Hypothetically move income to prior years using actual revenues and costs.
2. Compare the tax — Compute the hypothetical overpayment or underpayment of tax for those years.
3. Figure the interest — Calculate interest on any underpayment or overpayment.

The new calculator is built to help with step 3 — the interest computation — by giving a structured worksheet to run the numbers.

Important limits

Using the calculator does not guarantee compliance. It does not cover every fact pattern or complexity. Practitioners should:

• Review the output carefully
• Consider each taxpayer’s specific situation
• Confirm results against the law and regulations

Key authorities include I.R.C. Section 460 and Treasury Regulations Section 1.460-6. For full filing guidance, see the Form 8697 instructions on IRS.gov.

Bottom line

If you prepare returns for multi-year construction or manufacturing contracts, this free IRS Excel calculator can make the interest piece of Form 8697 easier. Treat it as a helper, not a substitute for professional judgment or official guidance. When in doubt, work with a qualified tax professional.