Part A: Estimate the beta of FSC stock using the stock price data given in the FSC spreadsheet, “Stock

and Market Data” tab (Hint: remember to use stock returns — not prices). Assuming the expected return

on the market is 11.5% and the 10-year Treasury rate is the risk-free rate, compute the cost of equity

using the CAPM. Compute the cost of debt using Excel’s RATE function. Part B: Compute the weights of debt and equity, and the weighted average cost of capital (WACC).

Calculate the costs associated with issuing new debt and equity, as well the dollar value of new debt and

equity to be issued. Part C: Create pro-forma income statements for the new manufacturing plant for the ten years it will be

in operation (these should include sales revenue, ﬁxed costs, variable costs, depreciation, EBIT, interest

expense, EBT, taxes, and net income). Determine the net working capital required each year (assume this

amount is required at the m of the previous year, for example, the NW C to support 2018 sales must be

in the NWC account at the end of 2017). Part D: Tabulate the after—tax cash ﬂows (OCF's, N CS, ANW C, ATS, FC, etc.) on a yearly basis and

compute the NPV, IRR, and MIRR (using the NPV, IRR, and MIRR functions, remember how to

properly use the NPV function). Indicate if FSC should accept or reject the project. Part B: What is the minimum price FSC can initially charge (in 2018) and still accept the project? What

is the maximum percentage of sales can variable costs be and the project still be accepted?