Free Templates · US Corporate Tax
Six linked worksheets covering SSCM, SPM vs. MSPM (T.D. 9843), LIFO, Simplified Resale Method (SRM), 3-year HAR, Form 3115 Section 481(a), and Section 263A(f) avoided-cost interest.
Pre-loaded with the complete 2024 to 2026 Meridian Precision Manufacturing & Distribution, Inc. (MPMD) case study from The Section 263A UNICAP Handbook. Every blue/yellow cell is editable and propagates dynamically to the Controls audit dashboard.
| Worksheet | Scope & Live Formulas |
|---|---|
| Controls | 9 dynamic reconciliation checks (ALL PASS verdict) plus consolidated 2024 to 2026 executive summary. |
| SSCM_Mixed_Services | 6 HQ mixed service departments, Labor-Based (58.00%) vs. Production-Cost (66.00%) SSCM ratios, and annual savings ($476,400 in 2026). |
| PMD_SPM_vs_MSPM | 3-year SPM vs. T.D. 9843 MSPM comparison, structural vs. negative-cost savings decomposition ($796,552 in 2026), and parallel LIFO layer schedule. |
| ISDD_SRM_Reseller | Dual-function warehouse split (85% off-site / 15% on-site), reseller mixed service ratio, Storage & Handling + Purchasing combined absorption ratio (8.13%). |
| HAR_and_Form3115 | 3-year Historic Absorption Ratios (2024 to 2026), 2026 Form 3115 DCN 23 Section 481(a) adjustment (-$736,290), and ASC 740 DTA rollforward ($336,231). |
| Sec263Af_Interest | 6-quarter (18-month) Line 4 CNC assembly line avoided-cost interest model ($335,566 capitalized interest on $6,400,000 spend) and 2026 MACRS recovery. |
Read the complete 15-chapter practitioner guide, regulatory citations, and IRS exam defense playbook in The Section 263A UNICAP Handbook.