Free Templates · US Tax & Construction
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.
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| Worksheet | Scope & Live Formulas |
|---|---|
| PCM_and_LookBack | 3-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_Small | IRC § 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_OBBBA | 80% 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_Cap | 6-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_Recon | Consolidated 4-year book-tax reconciliation, Schedule M-1/M-3 adjustments, and ASC 740 DTL rollforward closing to $0. |
| Controls | 12 dynamic accounting identity checks with automated FAIL counter (0 errors). |
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