Excel Activity: Free Cash Flow Valuation Model

Start with the partial model in the file Ch$08$ P$25$ Build a Model.xlsx$.$ Selected data for the Derby Corporation are shown here. Use the data to answer the questions.

INPUTS $($In Millions$)$

Year

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.

$$1\mathrm{.}23$ million should be entered as $1\mathrm{.}23,$ not $1,230,000.$ Round your answer to two decimal places.

$$,$ million

Round your answers to two decimal places.

c$.$ Calculate the estimated Year$-0$ price per share of common equity. Round your answer to the nearest cent.