Free templates · US Corporate Tax
Constant yield OID schedules, Section 1273(c)(2) investment units, Section 163(e)(5) AHYDO disallowance and catch-up payment design, market discount, bond premium, CPDI, and Treas. Reg. 1.1001-3 modification testing.
This free, unlocked Excel workbook (Section_1272_OID_AHYDO_Calculator.xlsx, 32 KB) models every calculation from The Section 1272 OID and Debt Tax Handbook using 100% live native Excel formulas (RATE(), NPV(), SUM()), zero macros, and 19 automated accounting-identity checks.
Pre-loaded with Caldwell Industrial Holdings, Inc. (CIH) and verified with zero formula errors.
| Worksheet | Statutory Scope & Key Calculations |
|---|---|
| Summary | Executive dashboard aggregating all six CIH modules and overall control status. |
| Controls | 19 dynamic accounting-identity verification checks (0 hardcoded constants, mutation-safe). |
| Tranche_A_DeMinimis | Section 1273(a)(3) 7-year vs. 5-year de minimis test and 14-period issuer constant yield schedule. |
| Tranche_B_OID_AHYDO | Section 1273(c)(2) warrant allocation ($4,000,000.00), 10.7514% YTM, $29,629,486.24 OID, and Section 163(e)(5) disqualified portion ($1,519,626.41). |
| Tranche_B_CatchUp | Mandatory Period 11 to 13 catch-up payments ($19,871,197.70) generating $786,853.87 NPV tax shield gain. |
| Secondary_Market | Section 1276 market discount (ratable vs. constant yield), Section 171 bond premium, and Section 1272(a)(7) acquisition premium. |
| Tranche_C_CPDI | 5-year Reg. 1.1275-4(b) Noncontingent Bond Method with positive adjustment and Tier 1/Tier 2 negative adjustment waterfall. |
| Restructuring_1001_3 | Reg. 1.1001-3(e)(2) yield change test (38.91 bp limit), Section 108(e)(10) COD income ($17,046,507.52), and post-workout AHYDO re-test. |
Companion handbook: Every formula, regulation, and credit-agreement drafting guardrail is explained step by step in The Section 1272 OID and Debt Tax Handbook.
Related guides: Constant Yield OID Worked Example · Section 163(e)(5) AHYDO Catch-Up Design · Reg. 1.1001-3 Significant Modification Tests