Free Excel Template · US Corporate Tax
Six linked tabs covering the 0.25% de minimis cliff test, constant yield accrual (Section 1272(a)), E&P allocation, corporate Section 243 DRD, Section 307 basis rules, convertible note CRAs, and Sections 1441/1442 dry withholding.
Pre-loaded with the complete five-year Meridian Precision Systems, Inc. (MPS) case study. 100% live formulas, editable blue input cells, zero macros, and nine automated accounting identity checks.
| Tab Name | Scope & Live Formulas |
|---|---|
| Redemption_Premium_305c | 0.25% de minimis test (Series A FAIL vs. Series B PASS), constant yield via Excel RATE (7.7302%), 5-year AIP accrual ($15,000,000.00 total), Year 1 E&P split, and 25% corporate holder Section 243 DRD tracker. |
| Stock_Div_305a_307 | 10.00% pro-rata stock dividend basis allocation ($22.7273/share) and Section 307(b) 15% stock rights threshold test (with and without the Section 307(b)(2) election). |
| Cash_Stock_305b1 | $22.00M optional cash-or-stock dividend with 20.00% cash cap, Rev. Proc. 2017-45 check, proration factors (33.3333% cash), and cash vs. stock elector outcomes. |
| Disproportionate_305b2 | Dual-class common test (Class A cash vs. Class B 5.00% stock), +79.21 bps shift, automatic Section 305(b)(2) verdict, and 5% fractional-share safe harbor. |
| Convertible_CRA_WHT | Indenture anti-dilution CRA formula (20.0000 to 20.877193), $50.00/note deemed dividend ($7.50M total), and 30% statutory vs. 15% treaty dry withholding coupon offsets ($637,500.00). |
| Controls | Nine dynamic accounting identity checks verifying exact AIP closure, E&P conservation, basis conservation, ownership sum, CRA identity, and dry withholding balance. |
Every formula, statutory citation, Form 8937 line item, and ASC 480 / ASC 740 book-tax reconciliation behind this workbook is explained step by step in the companion handbook.
IRC Section 305(b) Five Taxable Stock Dividend Exceptions
Section 305(c) Preferred Stock Redemption Premiums and Constant Yield Accrual
Section 305(c) Conversion Ratio Adjustments, Form 8937, and Dry Withholding