Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started