Free Excel Templates · Partnership Taxation
Live 5-tab workbook modeling hot assets, look-through rates, split holding periods, installment sales, and Section 1446(f) withholding.
100% live Excel formulas, no macros, no locked sheets, pre-loaded with the reconciled Redwood Crest Partners, LP case study across all four seller scenarios.
Download Excel calculator (.xlsx) Explore the companion handbook →
| Tab Name | Scope and Key Live Outputs |
|---|---|
| Asset_Schedule | 100% partnership asset schedule ($12,000,000 FMV, $7,000,000 basis), Section 751(a) ordinary vs. Section 741 capital split, inventory 120% threshold check (114.29% yet 100% hot), and Section 752 liabilities ($4,000,000). |
| Sec741_751a_Calc | Scenario A (split holding period 20.00%/80.00%, 25% unrecaptured Section 1250 $240,000, 28% collectibles $80,000, active vs. passive NIIT) and Scenario B (high-basis capital loss trap: $620,000 ordinary + -$220,000 capital loss). |
| Installment_453 | Scenario C installment sale: Year-1 acceleration of Section 1245 recapture ($450,000) and inventory/A/R ($170,000), Gross Profit Ratio (42.57%), and 5-year gain recognition schedule. |
| Foreign_1446f | Scenario D foreign corporate transferor: Section 864(c)(8) ECI ($1,200,000), default 10% withholding ($300,000), and Maximum Tax Liability modification ($252,000, saving $48,000). |
| Controls | Seven dynamic accounting-identity checks verifying 0.00 variance across all tabs under any blue-cell input change. |
Section 751(a) Hot Assets Hypothetical Sale Calculation
Unrecaptured Section 1250 and Collectibles Look-Through Rates
Section 1446(f) Withholding and Form 8308 Reporting Rules
See also: The Section 754 Handbook · The Section 704(b) and 704(c) Handbook · The Section 731 and 732 Handbook