Elizabeth Corporation is starting two new projects. Project A requires an investment of $5,000, has expected return of 16% with standard deviation 14%. Project B has initial investment of $15,000, expected return of 15% with standard deviation 10%. The correlation coefficient between the projects is 0.75. Find the expected return, in dollars, of the portfolio of these two projects. What is the probability that this return is less than $4,000? COMPLETE AND SHOW WORK IN EXCEL

Elizabeth Corporation is starting two new projects. Project A requires an investment of $5,000, has expected return of 16% with standard deviation 14%. Project B has initial investment of $15,000, expected return of 15% with standard deviation 10%. The correlation coefficient between the projects is 0.75. Find the expected return, in dollars, of the portfolio of these two projects. What is the probability that this return is less than $4,000? COMPLETE AND SHOW WORK IN EXCEL

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter14: Real Options

Section: Chapter Questions

Problem 3MC: Tropical Sweets is considering a project that will cost $70 million and will generate expected cash...

See similar textbooks

Similar questions

Tropical Sweets is considering a project that will cost $70 million and will generate expected cash flows of $30 million per year for 3 years. The cost of capital for this type of project is 10%, and the risk-free rate is 6%. After discussions with the marketing department, you learn that there is a 30% chance of high demand with associated future cash flows of $45 million per year. There is also a 40% chance of average demand with cash flows of $30 million per year as well as a 30% chance of low demand with cash flows of only $15 million per year. What is the expected NPV?
Suppose your firm is evaluating four potential new investments. You calculate that these projects, W, X, Y, and Z,have the NPV and IRR figures given below:Project W: NPV = $7,000 IRR = 13%Project X: NPV = $-4,000 IRR = 15%Project Y: NPV = $5,000 IRR = 10%Project Z: NPV = $800 IRR = 18%a) Which project(s) should be accepted if they are independent? Clearly explain your reasoning.b) Which project(s) should be accepted if they are mutually exclusive? Clearly explain your reasoning.
Consider the following projects, X and Y where the firm can only choose one. Project X costs $1500 and has cash flows of $678, $652, $347, $111, $54, $16 in each of the next 6 years. Project Y also costs $1500, and generates cash flows of $738, $693, $405 for the next 3 years, respectively. WACC=11%.Plot NPV profiles for the two projects. Identify the projects’ IRRs on the graph.
Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $3,225,000. The project's expected cash flows are: Year Cash Flow Year 1 $375,000 Year 2 -125,000 Year 3 500,000 Year 4 400,000 If the company's WACC is 8% and the project has the same risk as the firm's average project, what is the project's modified internal rate of return (MIRR)? Should you accept or reject this project?
OmegaTech is considering project A. The project would require an initial investment of $52,100.00, and then have an expected cash flow of $77,900.00 in 4 years. Project A has an internal rate of return of 9.31 percent. The weighted-average cost of capital for OmegaTech is 6.99 percent. The risk of the project is similar to the average risk of the company. Which one of the following assertions is true? The NPV that Omega Tech would compute for project A is less than or equal to -$11.16. The NPV that Omega Tech would compute for project A can not be computed from the information provided The NPV that Omega Tech would compute for project A is equal to greater than $0.00. The NPV that OmegaTech would compute for project A is greater than -$11.16 but less than $0.00.
Perform a financial analysis for an IT Project which requires an initial investment of $32,000, but it is expected to generate revenues of S10,000, $20,000 and $15,000 for the first, second and third years respectively. The target rate of return is 12%. Write the formula and calculate the Net Present Value (NPV). In addition, Justify your result. (For this question Write the answer on the paper and take photo and upload OR Type in the MS Word document and upload the file) tach File Browse My Computer
OmegaTech is considering project A. The project would require an initial investment of $58,500.00, and then have an expected cash flow of $72,800.00 in 4 years. Project A has an internal rate of return of 9.57 percent. The weighted-average cost of capital for OmegaTech is 6.69 percent. The risk of the project is similar to the average risk of the company. Which one of the following assertions is true? The NPV that Omega Tech would compute for project A is less than or equal to -$11.24. The NPV that Omega Tech would compute for project A is greater than -$11.24 but less than $0.00. The NPV that Omega Tech would compute for project A can not be computed from the information provided The NPV that Omega Tech would compute for project A is equal to greater than $0.00.
A company is considering two potential projects. Project Alpha requires an investment of 1,000,000 and will return 185,464.74 per year at the end of each of the next six years. It has an IRR of α%. Project Beta requires and investment of 860,725 and will return 300,000 at the end of year one and 600,000 at the end of year two. It has an IRR of β%. Calculate α-β.
Consider the following projects, X and Y where the firm can only choose one. Project X costs $600 and has cash flows of $400 in each of the next 2 years. Project Y also costs $600, and generates cash flows of $500 and $275 for the next 2 years, respectively. Sketch a net present value profile for each of these projects. Which project should the firm choose if the cost of capital is 10 percent? What if the cost of capital is 25 percent? Show all work.
USE EXCEL TO SHOW FORMULAS Elizabeth Corporation is starting two new projects. Project A requires an investment of $5,000, has expected return of 16% with standard deviation 14%. Project B has initial investment of $15,000, expected return of 15% with standard deviation 10%. The correlation coefficient between the projects is 0.75. 1- Find the expected return, in dollars, of the portfolio of these two projects. 2- What is the probability that this return is less than $4,000?
Cold Goose Metal Works Inc. is analyzing a project that requires an initial investment of $3,000,000. The project’s expected cash flows are: Year Cash Flow Year 1 $325,000 Year 2 –125,000 Year 3 425,000 Year 4 425,000 Cold Goose Metal Works Inc.’s WACC is 9%, and the project has the same risk as the firm’s average project. Calculate this project’s modified internal rate of return (MIRR): 17.95% -19.42% 20.78% 22.67% If Cold Goose Metal Works Inc.’s managers select projects based on the MIRR criterion, they should this independent project.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $34,665 and is expected to generate the following cash flows: First Year Second Year Third Year Total Alpha Project $31,500 $22,000 $4,500 $58,000 Beta Project 7,500 23,500 29,066 60,066 A. Calculate the internal rate of return on both projects. Use the IRR spreadsheet function to calculate internal rate of return. Alpha Project fill in the blank % Beta Project fill in the blank %