Learning

:$.$ Excel Online Student Work

C

chegg.com$/$homework$-$help$/$c

chegg.com$/$homework$-$help$/$c

hdex.html$?$deploymentld$=59326323871810820347156469662$&eISBN$=9781337909686$&id$=1975570461$&snapshotld$=3778.$

MGMT $309$ Exam...

Employees first, c$...$

NDTAP

: Corporate valuation

Dantzler Corporation is a fast$-$growing supplier of office products. Analysts project the following free cash flows $($FCFs$)$ during the nex: years, after which FCF is expected to grow at a constant $6\%$ rate. Dantzler's WACC is $10\%.$

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

$