Commercial Equipment Finance, Fleet Leasing & IRC Section 7701(h) TRAC Leases
Commercial Fleet TRAC Lease Terminal Adjustment Formula
Calculate Commercial Truck & Tractor IRC Section 7701(h) TRAC Lease Guaranteed Residual Value ($), Terminal Rental Adjustment Deficiency or Rebate ($), Lessee All-In Net Cash Lease Cost ($), and All-In Cost-to-Capex Ratio.
Model two-way TRAC lease residual true-ups on over-the-road tractor and trailer fleets!
Qualified commercial motor-vehicle Terminal Rental Adjustment Clause (TRAC) leases under IRC Section 7701(h) lower monthly fleet payments by setting a high contractual TRAC Residual Percentage (e.g., 20%–35% of Original Equipment Cost) while preserving tax-lease treatment! At lease expiration, the lessor sells or auctions the truck for Net_Terminal_Sale_Proceeds and settles the Terminal Rental Adjustment = Guaranteed_TRAC_Residual - Net_Sale_Proceeds: if used-truck auction prices fall short, the lessee pays the positive deficiency; in a full open-end TRAC, if auction proceeds exceed the TRAC residual, the lessee receives the negative adjustment back as a rental rebate!
Verify on a Class-8 Sleeper Tractor TRAC Lease—Original_Equipment_Cost = $150,000 (B2), TRAC_Residual_Guarantee = 0.30 (30.0%, B3 -> Guaranteed TRAC Residual = $45,000 in E2), Cumulative_Base_Rentals_Paid = $122,000 (B4), and Net_Auction_Sale_Proceeds = $38,000 (B5): Terminal Rental Adjustment Owed by Lessee is 45,000 - 38,000 = +$7,000 deficiency (E3), bringing All-In Lessee Cash Cost to 122,000 + 7,000 = $129,000 (E4), or 0.8600 (86.00% of original capex in E5)!
| TRAC Fleet Lease Metric ($150k Cost, 30% TRAC Residual, $122k Rentals, $38k Sale) | Formula | Verified Output |
|---|---|---|
| Guaranteed TRAC Residual ($) | Original_Cost * TRAC_Residual_Pct | $45,000 |
| Terminal Adjustment Owed / (Rebate) | Guaranteed_Residual - Net_Sale_Proceeds | +$7,000 (-$6,000 @ $51k Sale) |
| All-In Lessee Cash Cost ($) | Cumulative_Rentals + Terminal_Adjustment | $129,000 ($116,000 @ $51k Sale) |
| All-In Cost / Original Capex | AllIn_Cash_Cost / Original_Cost | 0.8600 (0.7733 @ $51k Sale) |
TRAC Lease Terminal Adjustment & All-In Lessee Cash Cost Formula
Validate Original_Cost > 0, TRAC_Residual_Pct in (0, 1), Cumulative_Rentals > 0, and Net_Sale_Proceeds >= 0!
=LET(eq_c, B2, tr_p, B3, rn_c, B4, sl_p, B5, IF(OR(eq_c <= 0, tr_p <= 0, tr_p >= 1, rn_c <= 0, sl_p < 0), "Invalid TRAC Lease Input", LET(rs_g, eq_c * tr_p, ad_t, rs_g - sl_p, ROUND(rn_c + ad_t, 2))))Strong Used-Truck Resale Rebate Check (Set Auction Proceeds = $51,000)
Test a tight secondary truck market where Net_Auction_Sale_Proceeds B5 = $51,000: Terminal Adjustment E3 flips to -$6,000 (a $6,000 lessee rental rebate!), lowering All-In Cash Cost E4 to $116,000 (0.7733 of capex in E5)!
=IF(ISTEXT(E4), E4, ROUND(E4 / B2, 4))Try the example
Use the original values or change them to test your understanding.