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

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

$ 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 $$42$ million of debt and $33$ 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.$