
Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following
Year | 0 | 1 | 2 | 3 | ||||
....... | ....... | ....... | ....... | ....... | ....... | ....... | ....... | |
FCF ($ millions) | ....... | ....... | ....... | ....... | ....... | ....... | ....... | ...... |
- $25 | $24 | $57 |
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
-
What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55.
$ fill in the blank 2 million
-
What is the firm's value today? Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not round your intermediate calculations.
$ fill in the blank 3 million
-
Suppose Dantzler has $72 million of debt and 6 million shares of stock outstanding. What is your estimate of the current price per share? Round your answer to two decimal places. Write out your answer completely. For example, 0.00025 million should be entered as 250.
$ fill in the blank 4

Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images

- WorldTrans Industries is planning its operations for next year. The CEO, wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions. Last year's sales = S0 $350 Last yr's accounts payable $40 Sales growth rate = g 30% Last yr's notes payable $50 Last year's total assets = A0* $460 Last yr's accruals $30 Last year's prof margin = PM 5% Target payout ratio 60% Group of answer choices $87.4 $120.8 $90.6 $124.1 $107.9arrow_forwardWant the Correct answerarrow_forwardA firm's current profits are $450,000. These profits are expected to grow indefinitely at a constant annual rate of 3 percent. If the firm's opportunity cost of funds is 6 percent, determine the value of the firm: Instructions: Round your responses to 2 decimal places. a. The instant before it pays out current profits as dividends. $ million b. The instant after it pays out current profits as dividends. $ millionarrow_forward
- Want the Correct answer fromarrow_forwardThe HUT is evaluating a 5 year investment projected to yield the following relevant cash flows over its 5 year life: Given that the firm employs a 12% discount rate, what is the value of each of the three criteria: NPV? Profitability Index? Payback Period? round each to the nearest hundredth, as in "123.45".arrow_forward6arrow_forward
- HappyTunes Inc. forecasts the free cash flows (in millions) shown below. The weighted average cost of capital is 11.75%, the cost of equity is 19.25%, and the FCFs are expected to continue growing at a 5.25% rate after Year 5. Assuming that the ROIC is expected to remain constant in Year 5 and beyond, what is the Year O value of operations? Year: 1 2 3 4 5 Free cash flow: -$995 $15 $55 $80 $125 O-$310.32 million O $387.53 million O $139.31 million $445.46 million O-$176.72 milliarrow_forwardXYZ plans to open a new store with the following forecasted free cash flows. If the interest rate is 8% and cash flows are expected to grow by 2% a year starting year 4, calculate project’s NPV 0 1 2 3 CF, mil. -50 35 55 85 -$1.5 million $1,386.9 million $1,589.1 million $1,244.1 millionarrow_forwardThe table below gives the expected cash inflows of a firm for a period of 9 years. Time 3 6 9 Cash inflow (£) 45000 90000 120000 Assume the present value of the cash outflows is £87000, and the applicable cost of capital is 13%. Calculate the (a) Future value of the cash inflows (b) Modified internal rate of return (MIRR)arrow_forward
- 17arrow_forward2. Mathias Company estimated that it has a 20% probability of receiving $240,000 one year from now, a 30% probability of receiving $240,000 two years from now, and a 50% probability of receiving $240,000 three years from now. Required: Using the FASB's concept of "expected cash flows," calculate the present value of the expected cash flows assuming a 10% interest rate compounded annuallyarrow_forwardA firm's current profits are $700,000. These profits are expected to grow indefinitely at a constant annual rate of 3 percent. If the firm's opportunity cost of funds is 5 percent, determine the value of the firm: Instructions: Enter your responses rounded to two decimal places. a. The instant before it pays out current profits as dividends. million b. The instant after it pays out current profits as dividends. millionarrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education





