Free templates · US Corporate Tax

Section 1272 OID & AHYDO Calculator in Excel

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.

Direct download (no registration required)

Pre-loaded with Caldwell Industrial Holdings, Inc. (CIH) and verified with zero formula errors.

Download Section_1272_OID_AHYDO_Calculator.xlsx (32 KB)

What is inside the 8 worksheets

WorksheetStatutory Scope & Key Calculations
SummaryExecutive dashboard aggregating all six CIH modules and overall control status.
Controls19 dynamic accounting-identity verification checks (0 hardcoded constants, mutation-safe).
Tranche_A_DeMinimisSection 1273(a)(3) 7-year vs. 5-year de minimis test and 14-period issuer constant yield schedule.
Tranche_B_OID_AHYDOSection 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_CatchUpMandatory Period 11 to 13 catch-up payments ($19,871,197.70) generating $786,853.87 NPV tax shield gain.
Secondary_MarketSection 1276 market discount (ratable vs. constant yield), Section 171 bond premium, and Section 1272(a)(7) acquisition premium.
Tranche_C_CPDI5-year Reg. 1.1275-4(b) Noncontingent Bond Method with positive adjustment and Tier 1/Tier 2 negative adjustment waterfall.
Restructuring_1001_3Reg. 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