wing

ficw

History

Bookmarks

Window

Help

$$

Case Study $-$ Financial Statements & Fut...

Page $7$ of $8$

exams.corporatefinanceinstitute.com

Exams $|$ Introduction to $3-$Statement Modeling

$12$ out of $15$

Review Later

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

Download

Forecasting Working Capital and PP&E

Changes in working capital may be either a source of cash or a use of cash. It's important to know how to calculate the cash impact from working capital.

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

What is the cash impact from working capital in Year $2?$

$-68,026$

$45,754$

$125,766$

$-45,754$

Previous

$$

Visw

History

Bookmarks

Window

Help

$$

Case Study $-$ Financial Statements & Fut...

Page $7$ of $8$

exams.corporatefinanceinstitute.com

$01$

Loading the content...

$9$ out of $15$

Review Later

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

$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$

$\backslash$table$[[$Edit$,$Insert,Table,Organize,Format,Arrange,View,Window,Help,,$],[0,,,,,,,3-$Stateme,nt Model,ig Qua,fied As$],[$D$,125\%vv,,,$:$,,,,,,(9)],[$View$,$Zoom,,,Add Category,Pivot Table,,,Insert,Table,Chart$],[+,$Gross,rofit $($B$,$ank$),$EBIT $($Blar$,$nk$),$AR I,Days $($Blank$),,$Inven,y $($Blan$]]$

Corporate

Finance Institu

EBITDA and EBIT

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

EBITDA

EBIT

$9$ out of $15$

Review Later

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

$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 Institu

EBITDA and EBIT

Interest Expense

Income Tax

$1,240$

Cost of Goods Sold

Administration

Revenues

Depreciation

Research & Development

EBITDA

EBIT