Free Templates · US Tax & Construction

Section 460 PCM & Form 8697 Look-Back Calculator (.xlsx)

Six-tab live Excel workbook for Percentage-of-Completion Method (PCM), Form 8697 split-rate daily-compounded look-back interest, 10% deferral, P.L. 119-21 residential CCM, Section 263A(f) avoided-cost interest, and ASC 606 M-1/M-3 reconciliation.

Built as the companion workbook to The Section 460 Long-Term Contracts Handbook, this formula-driven Excel model contains zero macros, zero hardcoded outputs, and twelve automated accounting identity checks on the Controls tab.

Direct download (no macros, 100% live formulas)

Pre-loaded with the four-year Redwood Civil & Industrial Corp. (2024 to 2027) portfolio. Change any blue input cell to model your own contracts.

Download Section_460_PCM_Lookback_Calculator.xlsx

What is inside the six tabs

WorksheetScope & Live Formulas
PCM_and_LookBack3-year PCM cost-to-cost schedule, change orders, cost re-estimation, 10% de minimis variance test, and Form 8697 corporate split-rate daily-compounded interest ($8,733.77 net interest due in base case).
Deferral_10pct_and_SmallIRC § 460(b)(5) 10% deferral schedule ($40,320 cash tax deferred in Year 1) plus § 448(c) 3-year average gross receipts test ($32,000,000 2026 threshold).
Residential_CCM_OBBBA80% dwelling-unit test and Post-P.L. 119-21 (OBBBA) Completed Contract Method vs. ASC 606 vs. repealed 70/30 hybrid comparison ($264,600 2026 cash tax saved).
Sec263Af_Interest_Cap6-quarter Accumulated Production Expenditures (APE) schedule, traced debt + avoided-cost general debt interest ($385,455 total), and § 460(f)(2) PCM integration.
ASC606_M1_M3_ReconConsolidated 4-year book-tax reconciliation, Schedule M-1/M-3 adjustments, and ASC 740 DTL rollforward closing to $0.
Controls12 dynamic accounting identity checks with automated FAIL counter (0 errors).

Need the full statutory and regulatory walkthrough?

Read The Section 460 Long-Term Contracts Handbook for the complete 15-chapter analysis covering severing/aggregating, simplified cost-to-cost, pass-through SMIM, M&A step-in-the-shoes rules, Form 3115 cut-off transitions, and IRS audit defense.

View the handbook