Quality of Earnings (QoE) Adjusted & Pro-Forma EBITDA Formula

Scrutinize M&A EBITDA add-backs before multiplying one-time noise by a 9x deal multiple!

In middle-market private equity and corporate M&A diligence, transaction advisors prepare a Quality of Earnings (QoE) bridge to strip accounting distortions out of Reported GAAP EBITDA and isolate sustainable, cash-generating operating earnings! QoE Normalized EBITDA = Reported_EBITDA + NonRecurring_OneTime_Expenses (litigation settlements, ERP migration) - NonOperating_Windfall_Gains (PPP forgiveness, asset-sale gains, out-of-period reserve releases) + Above_Market_Owner_Compensation_&_Perks! Layering verified full-year Pro-Forma Run-Rate Adjustments (e.g., annualizing a mid-year price increase or signed contract) yields Marketing Pro-Forma EBITDA—yet lenders cap "add-back reliance" ((ProForma_EBITDA - Reported_EBITDA) / ProForma_EBITDA) at <= 20%–25% so debt leverage is not underwritten on air!

Build a Deal-Team QoE Bridge—Reported_GAAP_EBITDA = $18.00M (B2), Verified_OneTime_AddBacks = $2.50M (B3), NonOperating_Gains_Deducted = $1.20M (B4), Excess_Founder_Comp_AddBack = $0.70M (B5), ProForma_RunRate_Adjustment = $1.50M (B6), and Valuation_Multiple = 9.0x (B7): QoE Normalized EBITDA is 18.00 + 2.50 - 1.20 + 0.70 = $20.00M (E2); Pro-Forma Run-Rate EBITDA reaches 20.00 + 1.50 = $21.50M (E3); Implied Enterprise Value is 21.50 * 9.0 = $193.50M (E4); and Net Add-Back Share of Pro-Forma EBITDA is (21.50 - 18.00) / 21.50 = 0.1628 (16.28% in E5)! If an analyst asks the in-app Pro Assistant for a hint ("Show me which sign flips if a one-time insurance gain in B4 is accidentally added instead of subtracted, without editing my cells"), they immediately spot a 2 * $1.20M * 9x = $21.60M valuation error!

QoE Pro-Forma Run-Rate EBITDA & Enterprise Value Formula

Validate non-negative add-backs and deductions, positive Deal_Multiple, and strictly positive Normalized and Pro-Forma EBITDA!

=LET(eb_r, B2, ad_1, B3, dd_g, B4, ow_c, B5, pf_r, B6, ml_x, B7, eb_n, eb_r + ad_1 - dd_g + ow_c, eb_p, eb_n + pf_r, IF(OR(ad_1 < 0, dd_g < 0, ow_c < 0, ml_x <= 0, eb_n <= 0, eb_p <= 0), "Invalid QoE EBITDA Bridge", ROUND(eb_p * ml_x, 2)))

Buy-Side Diligence Deduction Sensitivity Check (Set Non-Operating Deduction = $3.20M)

In a shared Arte Sheets QoE workbook, test a buy-side advisor’s cell suggestion raising NonOperating_Deductions B4 from $1.20M to $3.20M (+$2.00M out-of-period rebate reversal): Pro-Forma EBITDA E3 drops to $19.50M and Implied EV E4 falls by $18.00M to $175.50M!

=IF(ISTEXT(E2), E2, ROUND((E3 - B2) / E3, 4))

Further reading

• Arte Sheets Lesson — M&A EV-to-Equity Bridge, Working Capital Peg & Wire
• Arte Sheets Lesson — M&A Contingent Earnout Sliding-Scale vs Binary Cliff