Skip to content
Calcapedia
Number of problems

In the print window, choose “Save as PDF” as the printer (or print it on paper). Seed 1 rebuilds this exact sheet.

Showing 10 problems, seed 1.

EBITDA worksheet

Grades 6–7

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

  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

  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

  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

  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

  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

  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

  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

  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

  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 key: EBITDA worksheet

  1. 1. EBITDA: $459,000.00

    1. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $350,000.00+$85,000.00+$24,000.00=$459,000.00
    2. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $459,000.00$1,550,000.00×100=29.6129%
    3. Do the same with EBIT (operating income) to get the EBIT margin

      $350,000.00$1,550,000.00×100=22.5806%
  2. 2. EBITDA: $447,500.00

    1. Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)

      $250,000.00+$35,000.00+$52,500.00=$337,500.00
    2. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $337,500.00+$85,000.00+$25,000.00=$447,500.00
    3. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $447,500.00$1,600,000.00×100=27.9687%
    4. Do the same with EBIT (operating income) to get the EBIT margin

      $337,500.00$1,600,000.00×100=21.0938%
  3. 3. EBITDA: $494,000.00

    1. Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)

      $240,000.00+$40,000.00+$75,000.00=$355,000.00
    2. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $355,000.00+$110,000.00+$29,000.00=$494,000.00
    3. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $494,000.00$1,800,000.00×100=27.4444%
    4. Do the same with EBIT (operating income) to get the EBIT margin

      $355,000.00$1,800,000.00×100=19.7222%
  4. 4. EBITDA: $513,500.00

    1. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $400,000.00+$97,500.00+$16,000.00=$513,500.00
    2. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $513,500.00$2,200,000.00×100=23.3409%
    3. Do the same with EBIT (operating income) to get the EBIT margin

      $400,000.00$2,200,000.00×100=18.1818%
  5. 5. EBITDA: $411,500.00

    1. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $320,000.00+$75,000.00+$16,500.00=$411,500.00
    2. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $411,500.00$1,600,000.00×100=25.7188%
    3. Do the same with EBIT (operating income) to get the EBIT margin

      $320,000.00$1,600,000.00×100=20%
  6. 6. EBITDA: $425,000.00

    1. Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)

      $225,000.00+$50,000.00+$35,000.00=$310,000.00
    2. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $310,000.00+$92,500.00+$22,500.00=$425,000.00
    3. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $425,000.00$1,300,000.00×100=32.6923%
    4. Do the same with EBIT (operating income) to get the EBIT margin

      $310,000.00$1,300,000.00×100=23.8462%
  7. 7. EBITDA: $466,000.00

    1. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $350,000.00+$100,000.00+$16,000.00=$466,000.00
    2. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $466,000.00$2,400,000.00×100=19.4167%
    3. Do the same with EBIT (operating income) to get the EBIT margin

      $350,000.00$2,400,000.00×100=14.5833%
  8. 8. EBITDA: $426,000.00

    1. Add interest and income tax back to net income, so loans and taxes no longer count. This gives EBIT (operating earnings)

      $230,000.00+$37,500.00+$62,500.00=$330,000.00
    2. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $330,000.00+$80,000.00+$16,000.00=$426,000.00
    3. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $426,000.00$1,500,000.00×100=28.4%
    4. Do the same with EBIT (operating income) to get the EBIT margin

      $330,000.00$1,500,000.00×100=22%
  9. 9. EBITDA: $446,500.00

    1. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $330,000.00+$100,000.00+$16,500.00=$446,500.00
    2. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $446,500.00$2,200,000.00×100=20.2955%
    3. Do the same with EBIT (operating income) to get the EBIT margin

      $330,000.00$2,200,000.00×100=15%
  10. 10. EBITDA: $390,500.00

    1. Add depreciation and amortization back to EBIT, since they are paper charges, not cash. This gives EBITDA

      $300,000.00+$72,500.00+$18,000.00=$390,500.00
    2. Divide EBITDA by revenue to see how much of each sales dollar it is. That is the EBITDA margin

      $390,500.00$2,300,000.00×100=16.9783%
    3. Do the same with EBIT (operating income) to get the EBIT margin

      $300,000.00$2,300,000.00×100=13.0435%