I have attached two files including a Word file with the question and an Excel template. Thank you!

Terminal value refers to the valuation attached to the end of the planning period; it captures the value of all subsequent cash flows. Estimate the value today for each of the following sets of future cash flow forecasts. A) Claymore Mining Company anticipates that it will earn firm FCFs of $4 million per year for each of the next five years. Beginning in Year 6, the firm will earn FCF of $5 million per year for the indefinite future. If Claymore's cost of capital is 10%, what is the value of the firm's future cash flows? B) Shameless Commerce Inc. has no outstanding debt and is being evaluated as a possible acquisition. Shameless' FCFs for the next five years are projected to be $1 million per year and, beginning in Year 6, the cash flows are expected to begin growing at the anticipated rate of inflation, which is currently 3% per annum. If the cost of capital for Shamless is 10%, what is your estimate of the present value of the FCFs? C) Dustin Electric Inc. is about to be acquired by the firm's management from the firm's founder for $15 million in cash. The purchase price will be financed with $10 million in notes that are to be repaid in $2 million increments over the next five years. At the end of this five-year period, the firm will have no remaining debt. The FCFs are expected to be $3 million a year for the next five years. Beginning in Year 6, the FCFs are expected to grow at a rate of 2% per year into the indefinite future. If the unlevered cost of equity for Dustin is approximately 15% and the firm's borrowing rate on the buyout debt is 10% (before taxes at a rate of 30%), what is your estimate of the value of the firm? PROBLEM 9-9 a. Claymore Mining Company Given Unlevered Cost of Capital Solution Legend 10.00% = Value given in problem = Formula/Calculation/Analy = Qualitative analysis or Sho = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output Year FCF $ 1 4,000,000 2 ### $ 3 4,000,000 4 ### $ 5 4,000,000 $ 6+ 5,000,000 ### $ 5 1,000,000 $ 6+ 1,000,000 4 3,000,000 $ 5 ### $ Solution Present value of free cash flows: Planning period Terminal value Enterprise Value b. Shameless Commerce, Inc. Given Unlevered Cost of Capital growth rate in terminal cash flow 10.00% 3.00% Year FCF $ 1 1,000,000 $ 2 1,000,000 $ 3 1,000,000 4 Solution Valuing the unlevered cash flows Planning period Terminal value Enterprise Value c. Dustin Electric, Inc. Given K-WACC (Cost of capital) growth rate in terminal cash flow Corporate tax rate Cost of debt Unlevered cost of equity 10.00% 2.00% 0.30 0.10 15.00% Solution 0 FCF Debt Interest Tax shields After-tax interest debt principal paid Equity FCF $ $ 1 3,000,000 $ 10,000,000 Valuing the unlevered cash flows Planning period Terminal value Valuing the interest tax savings Planning period Terminal value Enterprise Value = Value of the unlevered firm + Value of interest tax savings Less: Debt (at time 0) Equity Value 2 3,000,000 Year 3 6+ 3,000,000 ort answer required