View the step-by-step solution to:

Question

This question was created from Excel Project #1 - Capital Budgeting.pdf https://www.coursehero.com/file/25407398/Excel-Project-1-Capital-Budgetingpdf/

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?

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents