Projected (partial) cash flow Statement | ||||||
Year | 0 | 1 | 2 | 3 | 4 | Perpetuity |
Sales | 27,273 | 30,000 | 33,000 | 36,300 | 39,930 | 39,930 |
Sales growth | 10% | |||||
Operating profit margin | 16% | |||||
Operating income | 4,364 | 4,800 | 5,280 | 5,808 | 6,389 | 6,389 |
Tax rate | 30% | |||||
Tax liability | 1,309 | 1,440 | 1,584 | 1,742 | 1,917 | 1,917 |
NOPAT | 3,055 | 3,360 | 3,696 | 4,066 | 4,472 | 4,472 |
Working capital rate | 13% | |||||
Investment in WC (Incremental) | 3,545 | 355 | 390 | 429 | 472 | 472 |
Fixed asset rate | 18% | |||||
Fixed investment rate | 4,909 | 491 | 540 | 594 | 653 | 653 |
Total investments | 8,455 | 845 | 930 | 1,023 | 1,125 | 1,125 |
FCFF | (5,400) | 2,515 | 2,766 | 3,043 | 3,347 | 3,347 |
Cost of capital | 12% | |||||
PV of FCFF | (5,400) | 2,245 | 2,205 | 2,166 | 2,127 | 15,826 |
terminal value in year 4 | 27,891 |
PV of terminal value | 15,826 |
NPV of FCFF | 19,169 |
Firm value= | 19,169 |
Invested capital | 9,818 |
MVA | 9,350 |
Debt | 4,000 |
Shareholders value added | 5,350 |
no of shares | 2,000 |
Value added per share | 2.68 |
Note-
Working capital need not be infused every year as it is the cash
in business. Only additional WC as a % of sales needs to be
infused
Fixed investments depreciate and hence, need to be maintained as a
fixed % of sales. FA also needs to infused as % of additional sales
every year
Cost of debt, interest payment etc. are not provided. Hence, these
factors are ommited from calculation. Ideally, interest payment
impact (net of tax) and capital repayment impact should be
accounted.
1 question (70%) The Bergeson Corporation sold its shares to the general public in 2019. The...
1. Question (70%) The Bergman Corporation sold its shares to the general public in 2018. The firm's estimated free cash flow for the next four year is as follows: Sales growth for years 1-3 Operating profit margin Net working capital to sales ratio Current assets to sales ratio Property, plant, and equipment to sales ratio Beginning sales Cash tax rate Total liabilities Cost of capital Number of shares 10.0% 16.0% 13.0% 18.0% 18.0% $27,272.73 30.0% S 4,000.00 12.0% 2,000.00 The...
Quantitative Problem 1: Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1 – T)] will be $440 million and its 2020 depreciation expense will be $70 million. Barrington's 2020 gross capital expenditures are expected to be $100 million and the change in its net operating working capital for 2020 will be $25 million. The firm's free cash flow is expected to grow at a constant rate of 6% annually. Assume that its free...
Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1 – T)] will be $430 million and its 2020 depreciation expense will be $65 million. Barrington's 2020 gross capital expenditures are expected to be $100 million and the change in its net operating working capital for 2020 will be $20 million. The firm's free cash flow is expected to grow at a constant rate of 5.5% annually. Assume that its free cash flow occurs...
Compute the Coca-Cola's free cash flow in 2019 using the Coca-Cola's cash flow statement in 2019. Assume that only "Investments in property, plant and equipment" item in the investing activities section is operating-related. (Submit the number in million dollars E G H J K L M N o Р Q R A B с D 1 COCA-COLA BALANCE SHEET 2019 IN MILLION DOLLARS 2 Cash, Cash Equivalents & Short Term Investments 11,175 Current Liabilities 26,973 3 Receivables 3,971 Total Non...
Quantitative Problem 1: Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income (EBIT(1 - 1)] will be $420 million and its 2020 depreciation expense will be $65 million. Barrington's 2020 gross capital expenditures are expected to be $110 million and the change in its net operating working capital for 2020 will be $30 million. The firm's free cash flow is expected to grow at a constant rate of 5.5% annually. Assume that its free...
Quantitative Problem 1: Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1 – T)] will be $450 million and its 2020 depreciation expense will be $60 million. Barrington's 2020 gross capital expenditures are expected to be $120 million and the change in its net operating working capital for 2020 will be $30 million. The firm's free cash flow is expected to grow at a constant rate of 6% annually. Assume that its free...
Williams Company is a manufacturer of auto parts having the following financial statements for 2018-2019. Balance Sheet December 31 2019 Cash $ 264,800 Accounts receivable 154,800 Inventory 389, eee Total current assets $ 827,899 Long-lived assets 1,680, eee Total assets $2,487,eee Current liabilities 248, eee Long-term debt 990.ea3 Shareholders' equity 1,339, eee Total debt and equity $2,487,000 2018 $ 139.ee 229,000 179,800 $ 547,899 1,540,888 $2,887,899 215,800 8 40. 1,832, 800 $2,887,899 Income Statement For the years ended December 31...
castew w ant wat in weather Lhota has renament holder with were years. W e MVA A) SS2.000.000 3) SI300.000 S12.000.000 ng atine nome r Nation has $220.000 and a e the firm has S 0 00, long term debt of $116,000, and common equity of 5435.00. What is its retro A) 1798 B) 18.62 1987% Question 31 Shives Publishing recently reported $13,000 of sales, 55,500 of operating costs other than and $1.250 of depreciation. The company had $3,500 of...
Biblio... Saved Williams Company is a manufacturer of auto parts having the following financial statements for 2018-2019 Balance Sheet December 31 2819 2018 Cash $ 270,000 145,000 160,866 395,000 Accounts receivable 235,008 185,006 Inventory Total current assets $ 825,000 565,000 1,748,901,600,e89 $2,565,0e0 $2,165,0e0 Long-lived assets Total assets Current liabilities 275,000 900,000 990,00 320,000 900,000 1,345,009 Long-term debt Shareholders' equity $2,565,000 $2,165,000 Total debt and equity Income Statement For the years ended December 31 2019 2018 $3,600,000 $3,700,000 2,700,000 2,800,000 900,000...
2. Consider the following year-end 2017 financial data for Texas Roadhouse. Figures in millions. Sales Revenue 1,219.5 Operating Income 186.2 Interest Expense 2.0 Tax Expense 43.0 Net Income 141.2 Total Assets 1,330.6 Cash 150.9 Conventional Debt 52.0 Operating Lease Debt 596.7 Total Debt 648.7 Shareholder Equity 851.4 Depreciation 93.5 CAPEX 161.6 Change in NWC Operating Lease Expense 41.6 Shares Outstanding 71.17 Stock Price per Share 52.68 a. Calculate the following: the effective tax rate, after-tax EBIT, operating profit margin, net...