$3-$Statement Modeling Qualified Assessment Support $($Blank$).$xlsx

$0\mathrm{.}05$ Mb

Forecasting Revenues down to EBITDA

EBIT and EBITDA are key metrics that analysts often focus on$.$

Open the attached Excel file called $3-$Statement Modeling Qualified Assessment Support $($Blank$).$ Go to the worksheet labeled: EBIT $($Blank$)$

Calculate EBITDA and EBIT, respectively, given the information in the Excel file.

$3,631$;$1,356$

$86$;$116$

$116$;$86$

$1,356$;$3,631$

Finance Instity

EBITDA and EBIT

$\backslash$table$[[$Interest Expense,$1,240],[$Income Tax,$30],[$Cost of Goods Sold,$6,529],[$Administration$,1,500],[$Revenues$,12,771],[$Depreciation$,2,275],[$Research & Development,$1,111]]$

EBITDA

EBIT