Question
From the information given below, calculate ABC Inc.s free cash flow (FCF) for the year 2020: Date 12/31/2019 1/31/2020 Current Assets $360 $372 millions Current
From the information given below, calculate ABC Inc.s free cash flow (FCF) for the year 2020:
Date | 12/31/2019 | 1/31/2020 |
|
Current Assets | $360 | $372 | millions |
Current Liabilities | $201 | $247 | |
Fixed Assets | $250 | $300 | |
EBITDA |
| $180 | millions |
Depreciation | $30 | ||
EBIT | $150 | ||
Interest Expenses | $30 | ||
Income after Taxes | $90 | ||
Dividend Paid |
| $40 | |
Tax Rate |
| 25% |
b) An experienced analyst believes that the growth rate of the FCF for the next 5 years will be 20% per year, and that after 5 years the growth rate will slow down to 4% per year forever. ABCs cost of capital is 12%. The company has a debt of $950 million, and 40 million common shares outstanding. Calculate the value of the company, the value of its equity, and the value of its stock per share.
Please show formulas in excel. Here are some outlines to reference:
(a) Free Cash Flow (FCF): Profit After Tax Depreciation After tax interest payments Increase in FA Increase in CA Increase in CL FCF 2020 2020 0 2021 1 2022 2 2023 3 2024 4 2025 5 2026 6 2027 7 Calendar year Time (year) FCF growth rate Expected FCF ($) Horizon value (at the end of year 5) millions PV of high growth period FCFS PV of horizon value Value of firm's operation today Value of non-operating assets Value of the enterprise (company) Value of debt Value of equity |# of shares outstanding Value per share (a) Free Cash Flow (FCF): Profit After Tax Depreciation After tax interest payments Increase in FA Increase in CA Increase in CL FCF 2020 2020 0 2021 1 2022 2 2023 3 2024 4 2025 5 2026 6 2027 7 Calendar year Time (year) FCF growth rate Expected FCF ($) Horizon value (at the end of year 5) millions PV of high growth period FCFS PV of horizon value Value of firm's operation today Value of non-operating assets Value of the enterprise (company) Value of debt Value of equity |# of shares outstanding Value per shareStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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