A free Section 754 & 743(b) Basis Adjustment Calculator in Excel
Previously Taxed Capital (Reg. 1.743-1(d)), Section 755 Ordinary vs. Capital allocation, 5-year cost recovery with post-OBBBA 100% bonus toggle, and both $250,000 Section 743(d) tests.
Pre-loaded with Alderbrook Industrial Partners, LP ($1,500,000 cash purchase plus $750,000 debt share for a 25% interest), the workbook derives $450,000 of Previously Taxed Capital, a +$1,050,000 Section 743(b) step-up (+$225,000 Ordinary, +$825,000 Capital), and $251,074.50 of Year 1 Schedule K-1 Box 13 Code V deductions ($92,897.57 federal tax shield at 37%). Replace the blue cells with your own deal figures.
Get the Excel calculator
One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.
The book behind this calculator
The Section 754 Handbook works through Alderbrook Industrial Partners, LP (Section 743(b), Section 704(c) layers, Section 1060 residual premium, and Year 3 asset sale reconciliation), Crestview Real Estate Partners, LP (Section 734(b) liquidating distributions), and Pinehurst Office Partners, LP (mandatory $250,000 step-downs under Sections 743(d) and 734(d)).
743b & 755 Allocation: Transferee outside basis, hypothetical liquidation cash and gain, Previously Taxed Capital, optional Section 704(c) layer input, and Ordinary vs. Capital class reconciliation.
Cost Recovery & K-1: 5-year depreciation and amortization schedule (AR, Inventory, 5-year MACRS / 100% bonus Equipment toggle, 39-year Building, 15-year Section 197 Goodwill) outputting annual Box 13 Code V deductions and Box 20 Code U remaining basis.
743d Mandatory Test: Evaluates both the Aggregate Asset Test (IRC 743(d)(1)(A)) and the post-TCJA Transferee Allocation Test (IRC 743(d)(1)(B)) against the $250,000 threshold, plus annual Box 11 Code F income addback.
Checks: Ten automated formula assertions reconciling every output against The Section 754 Handbook.