Pre-loaded with the 10-year Meridian Logistics Trust and Cascade Distribution Corp. warehouse lease ($18,000,000.00 aggregate rent, 4.50% Long-Term AFR, 4.95% at 110% AFR). Overwrite the blue input cells on the Inputs_Overview tab with your own rent allocation and cash schedules to see live Proportional Rental Accrual (fraction 0.961426), Constant Rental Accrual ($1,678,218.22/yr), Year 6 Section 467(c) recapture ($1,522,256.35), and Schedule M-1 / M-3 deferred taxes.
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 467 Rental Agreements Handbook walks through the full Meridian Logistics Trust and Cascade Distribution Corp. lease: Reg. Section 1.467-1 through 1.467-9 triggers, Proportional and Constant Rental Accrual, Section 467 Loans and Section 163(j), 85/115 and 90/110 safe harbors, Section 467(c) recapture, substantial modifications, and ASC 842 / ASC 740 tax provision.
Inputs_Overview: Editable blue cells for AFR, tax rate, WACC, disposition assumptions, and 10-year allocated vs. cash rent schedules, plus live Reg. Section 1.467-1(c)(3) deferred-rent trigger diagnostics and executive summary.
Proportional_467_Loan: Live Regime 2 engine computing PV(Cash) and PV(Allocated) at 110% AFR, the proportional fraction f, annual Proportional Rent, Section 467 Interest, and a self-liquidating loan balance ending at $0.00.
Constant_Rental_Accrual: Live Regime 3 engine computing the 10-year annuity factor, Constant Annual Rent, Section 467 Loan amortization, and three-regime cash-tax NPV comparison at 110% AFR and WACC.
Safe_Harbors_Recapture: Live 85/115 real estate and 90/110 equipment uneven rent safe harbor tester alongside a Year 6 Section 467(c) ordinary income recapture calculator.
ASC842_Book_Tax: 10-year Schedule M-1 / M-3 book-tax difference reconciliation and ASC 740 DTA (lessee) / DTL (lessor) rollforward for both Regime 2 and Regime 3.
Controls: Twelve 100% dynamic accounting identity checks verifying self-liquidation, cumulative rent-plus-interest equality to cash, recapture reconciliation, and zero residual deferred tax at lease end.