Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 9 1 pts Using the FCF worksheet in the fsa_assignment.xlsx file on canvas, compute the firm's average free cash flow for the period 2016

image text in transcribedimage text in transcribed

Question 9 1 pts Using the FCF worksheet in the fsa_assignment.xlsx" file on canvas, compute the firm's average free cash flow for the period 2016 to 2019. Round your final answer to two decimals. Financial Statements (Q1 to Q8) FCF Projection Assumptions Corporate tax rate 21% Year 2015 2016 2017 2018 2019 164 179 280 Income statement information EBITDA Depreciation expense EBIT 171 44 127 46 118 246 47 199 33 146 45 235 Balance sheet information Current assets Cash Accounts receivable Inventory Total current assets 43 35 20 38 49 69 66 26 161 32 59 30 48 26 104 25 28 119 98 112 Current liabilities Accounts payable Current portion of long-term debt Short-term debt Total current liabilities 23 44 17 15 39 71 26 29 26 31 19 29 17 31 15 63 11 78 81 79 Cash flow statement information Capital expenditures 39 31 48 40 32 Step 1: Compute the NWC Adj. current assets Less: Adj. current liabilities NWC DNWC Step 2: Compute the FCF EBIT(1-tc) Plus: Depreciation expense Less: DNWC Less: Capital expenditures FCF

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

Q4 Should you take documents from coworkers' desktops?

Answered: 1 week ago