Free Excel Template · US Corporate Tax

Section 305 Deemed Dividend & Preferred Stock Calculator in Excel

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.

Download Section_305_Deemed_Dividend_Calculator.xlsx

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.

Download Excel Workbook (.xlsx) →

What Is Inside the Six Linked Tabs

Tab NameScope & Live Formulas
Redemption_Premium_305c0.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_30710.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_305b2Dual-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_WHTIndenture 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).
ControlsNine dynamic accounting identity checks verifying exact AIP closure, E&P conservation, basis conservation, ownership sum, CRA identity, and dry withholding balance.

Go Deeper: The Section 305 Stock Dividends and Preferred Stock Handbook

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.

Explore the handbook →

Related Technical Guides

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