Excel Online Tutorial $$

Excel Online Structured Activity: Corporate valuation

Dantzler Corporation is a fast$-$growing supplier of office products. Analysts project the following free cash flows $($FCFs$)$ during the next $3$ years, after which FCF is

expected to grow at a constant $6\%$ rate. Dantzler's WACC is $16\%.$

Year

FCF $($$

millions$)$

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.

Open spreadsheet

a$.$ 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\mathrm{.}55.$

$

D million

b$.$ 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\mathrm{.}55.$ Do not round your intermediate calculations.

$

million

c$.$ Suppose Dantzler has $$40$ million of debt and $17$ 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\mathrm{.}00025$ million should be entered as $250.$