Free Excel templates

A free Section 467 Rental Accrual Calculator in Excel

Proportional and Constant Rental Accrual, self-liquidating Section 467 Loans at 110% AFR, 85/115 and 90/110 uneven rent safe harbors, Section 467(c) recapture, and ASC 842 / ASC 740 book-tax schedules.

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.

Section_467_Rental_Accrual_Calculator.xlsx (26 KB)

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.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is inside the 6 tabs

Related reading