Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding financial statements

Authors: Lyn M. Fraser, Aileen Ormiston

9th Edition

136086241, 978-0136086246

More Books

Students also viewed these Finance questions