Name Date
EBITDA worksheet
Grades 6–7
Calcapedia Solve each problem and show your work. Round answers to 2 decimal places where needed.
- 1.
Problem 1. - Start from: Operating income (EBIT)
- Operating income (EBIT): $350,000
- Depreciation: $85,000
- Amortization: $24,000
- Revenue (optional, for margins): $1,550,000
Find: EBITDA
Answer
- 2.
Problem 2. - Start from: Net income
- Net income: $250,000
- Interest expense: $35,000
- Income tax expense: $52,500
- Depreciation: $85,000
- Amortization: $25,000
- Revenue (optional, for margins): $1,600,000
Find: EBITDA
Answer
- 3.
Problem 3. - Start from: Net income
- Net income: $240,000
- Interest expense: $40,000
- Income tax expense: $75,000
- Depreciation: $110,000
- Amortization: $29,000
- Revenue (optional, for margins): $1,800,000
Find: EBITDA
Answer
- 4.
Problem 4. - Start from: Operating income (EBIT)
- Operating income (EBIT): $400,000
- Depreciation: $97,500
- Amortization: $16,000
- Revenue (optional, for margins): $2,200,000
Find: EBITDA
Answer
- 5.
Problem 5. - Start from: Operating income (EBIT)
- Operating income (EBIT): $320,000
- Depreciation: $75,000
- Amortization: $16,500
- Revenue (optional, for margins): $1,600,000
Find: EBITDA
Answer
- 6.
Problem 6. - Start from: Net income
- Net income: $225,000
- Interest expense: $50,000
- Income tax expense: $35,000
- Depreciation: $92,500
- Amortization: $22,500
- Revenue (optional, for margins): $1,300,000
Find: EBITDA
Answer
- 7.
Problem 7. - Start from: Operating income (EBIT)
- Operating income (EBIT): $350,000
- Depreciation: $100,000
- Amortization: $16,000
- Revenue (optional, for margins): $2,400,000
Find: EBITDA
Answer
- 8.
Problem 8. - Start from: Net income
- Net income: $230,000
- Interest expense: $37,500
- Income tax expense: $62,500
- Depreciation: $80,000
- Amortization: $16,000
- Revenue (optional, for margins): $1,500,000
Find: EBITDA
Answer
- 9.
Problem 9. - Start from: Operating income (EBIT)
- Operating income (EBIT): $330,000
- Depreciation: $100,000
- Amortization: $16,500
- Revenue (optional, for margins): $2,200,000
Find: EBITDA
Answer
- 10.
Problem 10. - Start from: Operating income (EBIT)
- Operating income (EBIT): $300,000
- Depreciation: $72,500
- Amortization: $18,000
- Revenue (optional, for margins): $2,300,000
Find: EBITDA
Answer
Answer key: EBITDA worksheet
Calcapedia 1. EBITDA: $459,000.00
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
2. EBITDA: $447,500.00
Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
3. EBITDA: $494,000.00
Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
4. EBITDA: $513,500.00
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
5. EBITDA: $411,500.00
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
6. EBITDA: $425,000.00
Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
7. EBITDA: $466,000.00
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
8. EBITDA: $426,000.00
Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
9. EBITDA: $446,500.00
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin
10. EBITDA: $390,500.00
Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA
Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin
Do the same with EBIT (operating income) to get the EBIT margin