Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part A: Estimate the beta of FSC stock using the stock price data given in the FSC spreadsheet, Stock and Market Data tab (Hint:
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, fixed 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 end of the previous year, for example, the NWC to support 2018 sales must be in the NWC account at the end of 2017). Part D: Tabulate the after-tax cash flows (OCF's, NCS, ANWC, 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 E: 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started