Free Cash Flow and Corporate Valuation: You have taken a jo…
Free Cash Flow and Corporate Valuation: You have taken a job with BlueComm, a telecommunications company, as a financial analyst in their corporate finance department. As your first assignment, your boss has asked you to complete a free cash flow and corporate valuation of BlueComm. You have been provided with the following projected financial statements for BlueComm for the fiscal years ending July 31 ($ in 000’s): Projected Earnings 2021 2022 2023 Sales $ 735.0 $ 825.0 $ 897.0 Operating expenses (568.0) (594.0) (647.0) Operating income (EBIT) 167.0 231.0 250.0 Interest expense (46.8) (64.7) (70.0) Earnings before taxes (EBT) 120.2 166.3 180.0 Depreciation (included in op expense) 50.0 55.0 59.0 Current assets 347.0 381.0 419.0 Current liabilities 204.0 218.0 231.0 Capital expenditures 72.0 90.0 65.0 In addition, your boss provided you with the following assumptions ($ in 000’s): BlueComm’s tax rate is 28% BlueComm’s 2020 Net Working Capital was $128.0 BlueComm expects its 2020 free cash flow to grow at 3.7% in perpetuity; and BlueComm’s WACC is 9.8% Based upon the above information: Prepare a Free Cash Flow for each projected year (2021 thru 2023) (34 points) Calculate the business value of the company (10 points) Complete in Excel and upload at the end of the exam.
Read Details