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 $5\%$ rate. Dantzler's WACC is $12\%.$

Year

FCF

milli

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$ discountec

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.$

$ 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 $$77$ million of debt and $11$ 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.$

$