Question: I need help in this question. Please do it in excel and show the formulas please. Please do it correctly and clearly and show the
I need help in this question. Please do it in excel and show the formulas please. Please do it correctly and clearly and show the formulas. Please do not make any mistake, i need in 1 hour please


forecasts are found below: Initial Outlay Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Mall-1 BHD (11,000,000) 3,000,000 3,000,000 4,000,000 0 7,000,000 7,000,000 Mall-11 BHD (16,950,000) 8,100,000 2,900,000 4,400,000 (1,400,000) 8,100,000 8,100,000 Since these projects involve additions to SEEF's portfolio of high-quality malls, the company requires a rate of return on both projects equal to 8,75%. As you are no doubt aware, SEEF relies on several criteria when evaluating new investment opportunities. In particular, we require that projects that are accepted have a payback of no more than 4 years, provide a positive NPV, and have an IRR that exceeds the company's discount rate. Give me your thoughts on these two projects by 9am Sunday morning. Noora was not surprised by the memo, for she had been expecting something like this for some time. SEEF followed a practice of testing each new financial analyst with some type of project evaluation exercise after the new hire had been on the job for a few months. After re-reading the memo, Noora decided on her plan of attack. Specifically, she would first do the obligatory calculations of Payback, NPV, and IRR for both projects. Noora knew that the Vice Chairman would grill her thoroughly on Sunday morning about her analysis, so she wanted to prepare well for the experience. One of the things that occurred to Noora was that the memo did not indicate whether the two projects were independent or mutually exclusive. So, just to be safe, she thoughts he had better rank the two projects under all assumptions in case she was asked to do so on Sunday morning. Noora sat down and made up the following "to do" list: 1. Compute Payback, NPV, and IRR for both projects. (6 marks) 2. Evaluate the two projects' acceptability using all three decision criteria (listed above) and based on the assumptions that the projects are both independent and mutually exclusive. (4 marks) 3. Rank the two projects according to Profitability Index and make a recommendation as to which (if either) should be accepted under the assumption that the projects are mutually exclusive. (2 marks) 4. What would you do if economic lives of the projects were unequal? Research, Explain and Make some suggestions based on the assumption that the projects are mutually exclusive. Also list the sources you have benefited such as 1) Richard Brealey. 2017. "Principles of Corporate Finance", McGraw Hill, New York
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
