Reference no: EM131276056
Felicia & Fred's executive board have asked you to complete a decision model for their intended refurbishment of the former mill building. In order to make an appropriate decision, the executive team has provided you with the following information regarding WACC and cash flows. It is your job to calculate the decision rules for NPV and IRR given the information provided.
Requirements:
1. Determine the target weighted average cost of capital for Felicia & Fred, given following assumptions:
• Weights of 30% debt and 70% common equity (no preferred equity)
• A 35% tax rate
• The cost of debt is 9%
• The beta of the company is 1.2
• The risk free rate is 2%
• The return on the market is 12%
Use the CAPM for calculation of the cost of equity.
2. Calculate the cash flows of the project given the following assumptions:
• Initial investment outlay of $60 million, comprised of $50 million for machinery with $10 million for net working capital (metal and gemstone inventory)
• Project and equipment life is five years
• Revenues are expected to increase $50 million annually
• Gross margin percentage is 60% (not including depreciation)
• Depreciation is computed at the straight line rate for tax purposes
• Selling, general, and administrative expenses are 5% of sales
• Tax rate is 30%, a reduced rate that reflects a tax credit due to the repurpose of the building
Compute net present value and internal rate of return of the project. You may use Excel to complete this project. The text has a number of resources that provide examples of spreadsheet solutions for this purpose. Model your responses according to these examples. (I have already done the calculation in attached excel)
Also, provide a 350-500 word executive summary on the results of the decision rule. Would you recommend that Felicia & Fred move forward with this project based on the NPV and IRR rules and outcomes? Why or why not? Consider any qualitative aspects of the decision as well. Provide a response with quantitative details which will be presented for consideration at the next executive board meeting.
Attachment:- Calculation.xlsx
|
Can managers succeed in protecting the stock price
: Explain how long-term price-to-earnings (P/E) ratios in the U.S. stock market of around 15 times are consistent with long-term expected stock returns of around 6 to 7 percent a year in real terms.
|
|
Design an ecc decoder for distance-3 hamming codes
: How many check bits are required for a distance-3 Hamming code for 8-bit data words? Sketch a parity-check matrix and write the equations to compute each of the check bits.
|
|
Find at least one quotation from the story
: One of the issues explored in this story is the way men and women see things differently. What, specifically, do you think is being said about that? Does the story argue that one sex is better at seeing things than the other? Find at least one quotat..
|
|
Why do investors spend so much time
: If a company's value is not driven by its short-term earnings, why do investors spend so much time analyzing a company's annual or even quarterly earnings announcements?
|
|
Calculate the cash flows of the project
: Calculate the cash flows of the project given the following assumptions. Compute net present value and internal rate of return of the project. You may use Excel to complete this project.
|
|
What is ethical and unethical
: What is ethical and unethical when the company design a printers and the ink catridges will work only if made in the same region. i.g. ink catridges from U.S. will not work in Asia.This will prevent consumers from buying the product at a lower price ..
|
|
Change from fifo to lifo inventory accounting
: In inflationary periods for input prices, what happens to earnings when firms change from first-in first-out (FIFO) to last-in first-out (LIFO) inventory accounting?
|
|
Conduct self-assessment of their own leadership style
: Conduct a self-assessment of their own leadership style and will describe areas in which they feel they are strong as well as areas that need to be developed. The various leadership skills should be illustrated with personal examples. As part of this..
|
|
Decision analysis can be used to develop optimal strategy
: "Decision Analysis can be used to develop an optimal strategy when a decision maker is faced with several decision alternatives and an uncertain or risk-filled pattern of future events."
|