Pre-loaded with Oakridge Industrial Partners, LP (Building A $5,000,000 FMV vs. $710,000 tax basis, $4,290,000 built-in gain, $2,000,000 nonrecourse mortgage, $1,600,000 recourse loan, Year 4 Reverse 704(c) book-up of $3,340,000, and Year 5 $650,000 Minimum Gain Chargeback). Overwrite any blue input cell and all six tabs recalculate automatically with 21 live integrity checks.
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 704(b) and 704(c) Handbook walks through every formula, regulation, and LPA clause on Oakridge Industrial Partners, LP from Day-1 formation to Year 5 Schedule K-1 Item L reporting.
Inputs_Assumptions: All property FMVs, tax bases, MACRS recovery lives, recourse and nonrecourse debt terms, annual NOI, refinancing, book-up FMVs, and NPV tax parameters in blue editable cells.
Capital_Accounts_704b: Complete five-year partnership balance sheet, Section 704(b) Book Capital, Schedule K-1 Item L Tax Basis Capital, and Outside Tax Basis rollforwards for Partners A, B, and C.
Sec704c_Methods_Compare: Side-by-side Traditional, Curative, and Remedial Section 704(c) engines showing the ceiling rule shortfall ($179,000/yr in Years 1-3), curative reallocations, bifurcated 39-year remedial depreciation, and five-year NPV tax impact.
Sec752_Debt_PMG: Live Partnership Minimum Gain, Nonrecourse Deductions, Year 5 Minimum Gain Chargeback ($650,000), and three-tier Section 752 nonrecourse plus recourse EROL debt waterfall.
AntiMixingBowl_QIO: Interactive calculators for Year 2 QIO stress ($260,000.00), Year 5 Section 704(c)(1)(B) ($2,145,000.00), Year 5 Section 737 with vs. without recourse debt ($0.00 vs. $1,586,875.00), and Section 707(a)(2)(B) disguised sales ($514,800.00 cash-only / $858,000.00 full OIP with 1.707-5(a)(5) qualified-liability taint).
Controls: 21 live Subchapter K accounting identity checks (Inside Basis equals Outside Basis every year, Book Capital equals Net Book Assets, Tier 1 PMG parity across all years, and identical total taxable income across all three 704(c) methods).