Free Excel Templates · Partnership Taxation

Section 741 & 751(a) Partnership Sale Calculator in Excel

Live 5-tab workbook modeling hot assets, look-through rates, split holding periods, installment sales, and Section 1446(f) withholding.

Download Section_741_751a_Sale_Calculator.xlsx (20 KB, .xlsx)

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 →

What the five tabs calculate

Tab NameScope and Key Live Outputs
Asset_Schedule100% 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_CalcScenario 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_453Scenario 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_1446fScenario 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).
ControlsSeven dynamic accounting-identity checks verifying 0.00 variance across all tabs under any blue-cell input change.

Related reading

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