Free Templates · Julian R. Sterling

Section 1060 & Form 8594 PPA Calculator (Excel)

Six-tab live Excel model for US M&A asset acquisitions: seven-class residual waterfall, 180-month Section 197 ledger, buyer vs. seller Joint Tax Surplus, anti-churning, earn-outs, and ASC 740 goodwill DTL.

Download the working companion spreadsheet for The Section 1060 and 197 Asset Acquisition Tax Handbook. Every cell is unlocked, macro-free, and pre-loaded with the $80,000,000 Kestrel-Apex worked acquisition so you can test your own deal terms immediately.

Download Section_1060_Form_8594_PPA_Calculator.xlsx

462 live Excel formulas across 6 structured tabs. Compatible with Microsoft Excel, LibreOffice Calc, and Google Sheets.

Download Excel Workbook (.xlsx)

What the 6 tabs compute

Tab NameScope & Live Outputs
ControlsAll editable deal inputs (closing cash, assumed liabilities, AFR, tax rates, WACC, allocation shifts) and live executive KPI dashboard.
Form8594_WaterfallSeven-class residual allocation under Treas. Reg. Section 1.338-6 for both the $80,000,000 Base Case (Class VII = $16,000,000) and the $38,000,000 Bargain Purchase (76.92% Class V pro-rata ratio).
Sec197_Amortization15-year (180-month) straight-line amortization ($2,400,000/yr base), Year 2 earn-out 13-year layer ($837,257.98/yr), and Year 4 Section 197(f)(1) partial disposition reallocation ($2,000,000 disallowed loss).
Buyer_vs_SellerAllocation A vs. B Buyer NPV tax shields ($8,474,539.29 vs. $8,729,070.81), Seller S-Corp vs. C-Corp tax, Section 453(i) recapture, and Joint Tax Surplus (-$765,468.48 S-Corp vs. $254,531.52 C-Corp).
AntiChurning_EarnOutSection 197(f)(9) >20% related-party screen ($18,500,000 pre-1993 intangibles), Section 197(f)(9)(B) gain-recognition election breakeven, and Section 483 imputed interest ($1,115,646.26) / Form 8594 Part III.
Book_Tax_ASC740ASC 805 Book vs. Section 1060 Tax opening balance sheet, capitalized transaction costs ($1,800,000), and 15-year goodwill DTL naked credit rollforward ($4,450,000).

Related guides & handbooks