Ebit/Ebitda Worksheet

Ebit/Ebitda Worksheet


EBIT/ EBITDA Worksheet
Company NameCurrent Year periodPrevious YearForecast for Next Year
A worksheet to determine the real earnings and value of the company.
Fiscal year end
Sales
Pretax Earnings from Inc.Statement.
Normalizing adjustments:
Interest paid (+)
Principal’s salary (+)
Principal’s perks, pension (+)
Principal’s profit sharing (+)
Principal’s insurance (+)
Related party salary/div/bonus (+)
Other – non-business related exp. (+)
Rent adjustment (if +/- norm)
Nonrecurring extraord. loss (+)
Replacement manager(s) salary (-)
Total of adjustments
EBIT normalized
EBIT as % of sales
+Depreciation & Amortization
Cash flow (EBITDA)
Notes:
EBIT: Earnings Before Interest & Tax
EBITDA: Earnings Before Interest & Tax, Amortization & Depreciation
Multiple of EBITDA – Value