
Excel formula to compute NPV =NPV(RATE,INFLOW1, INFLOW 2,...)+OUTFLOW
ANSWER is 169.58

With Discount rate of 11% NPV is -71.99
At 9% I will advise a company to Accept the project because it have Positive NPV
At 11% I will advice a company to Reject the project because it have Negative NPV

Answer is 10.38% and formula is Visible In fx bar
$3,000 $300 $500 $600 $600 $800 $800 $800 $300 You have been told you should evaluate...
Aa Aa 7. Uneven CF streams You are evaluating a proposed project for your company. The project is expected to generate the following end-of-year cash flows: $3,000 $300 500 $600 $600 $800 $800 $800 $200 You have been told you should evaluate this project with an interest rate of 9%, what is the project's NPV? $51.43 O $151.80 O $119.39 O $101.62 O $169.58 Your group leader has now told you that the risk of the project was understated before....
Please answer questions 10-15.
10) If you have $10,000 to invest and you evaluate two mutually exclusive projects each requiring $10,000 of capital and both have positive NPV's should you invest in both. 10b) Are these projects independent? 11) Define IRR. 12) A project has the following cash flow and WACC data. What is the project's IRR? WACC: 11.00% Year Cash flows 0 $1,000 1 $450 2 $450 3 $450 12b) What is the MIRR? 13) Calculate the IRR WACC:...
3. Analysis of an expansion project Companies invest in expansion projects with the expectation of increasing the earnings of its business. Consider the case of Yeatman Co.: Yeatman Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Year 1 Year 2 Year 3 Year 4 Unit sales 5,500 5,200 5,700 5,820 Sales price $42.57 $43.55 $44.76 $46.79 Variable cost per unit $23.45 $22.83 $22.97 $23.87 Fixed operating costs $66,750 $68,950 $69,690 $68,900...
3. Analysis of an expansion project Companies invest in expansion projects with the expectation of increasing the earnings of its business. Consider the case of McFann Co.: McFann Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Unit sales Sales price Variable cost per unit Fixed operating costs Year 1 5,500 $42.57 $22.83 $66,750 Year 2 5,200 $43.55 $22.97 $68,950 Year 3 5,700 $44.76 $23.45 $69,690 Year 4 5,820 $46.79 $23.87 $68,900...
Fox Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Year 1 Year 2 Year 3 Year 4 4,400 $29.82 $30.00 $30.31 $33.19 $12.15 $13.45 $14.02 14.55 Fixed operating costs except depreciation $41,000 $41,670 $41,890 $40,100 7% 4,200 4,100 4,300 Unit sales Sales price Variable cost per unit Accelerated depreciation rate 33% 45% 15% This project will require an investment of $25,000 in new equipment. The equipment wil have no salvage value...
Don't need explanations, just comparing my answers. Thank
you.
Fuzzy Button Clothing Company is analyzing a project that requires an initial investment of $2,500,000. The project's expected cash flows are: Year Cash Flo Year 1 $350,000 Year 2 -175,000 Year 3 400,000 Year 4 425,000 Fuzzy Button Clothing Company's WACC is 7%, and the project has the same risk as the firm's average project. Calculate this project's modified internal rate of return (MIRR). О О О O 19.71% 18.68% 16.60%...
Ch 12: Assignment - Cash Flow Estimation and Risk Analysis < Back to Assignment Attempts: Keep the Highest: / 5 3. Analysis of an expansion project Companies invest in expansion projects with the expectation of increasing the earnings of its business. Consider the case of Fox Co.: Fox Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Unit sales Sales price Variable cost per unit Fixed operating costs Year 1 3,000 $17.25...
Question 5 Suppose you have been hired as a consultant by Stevens Steel. Stevens Steel has prepared the following estimates for a long-term project it is considering. The initial investment is $35,510, and the project is expected to yield after-tax cash inflows of $5,000 per year for 10 years. The company has also supplied you with the following information: • There are 100 million shares outstanding, trading at $5 a share • The firm has debt outstanding of $300 million,...
Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDS). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $7.2 million in anticipation of using it as a toxic dump site for waste chemicals, but it...
Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI). a large, publicly traded firm that is the market share leader in radar detection systems (RDSS). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $7.1 million in anticipation of using it as a toxic dump site for waste chemicals, but it...