ou are hired as financial manager in Abis Investment Co., you made cash flow projection for two different projects.  You are asked to estimate the feasibility of the projects by using the following investment criteria: NPV, IRR, MIRR and BCR. They are mutually exclusive.  Show all your calculation. The details of that projects are given below:    Year 0 1 2 3 4 5 Project A -1,000 1,200 4600 1,800 -8,000 5,000 Project B -2,000 1,000 3600 800 8,000 500 Discount rates 12% 13% 12% 14% 15% 11%

Carmen, Inc. is considering three different independent investment opportunities. The present value of future cash flows, initial investment, net present value, and profitability index for each of the projects are as follows: Project A Project B Project C Present value of future cash flows $450,100 $313,100 $405,000 Initial investment 200,000 155,000 190, еее Net present value $250, 100 $158,100 $215,000 Profitability index 2.25 2.02 2.13 In what order should Carmen prioritize investment in the projects? Multiple Cholce С, В, А O A, B, C А, С, В C, A, B

Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000

(Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 Year 2 Year 3 Year 0 -$50 -$101 $26 $20 $22 $22 $39 $49 Project A B Year 4 $16 $62 You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?

Exercise 24-10 (Algo) Net present value, unequal cash flows, and profitability Index LO P3 Following is information on two alternative investment projects being conside return from its investments. (PV of $1, FV of $1. PVA of $1, and FVA of $1) Note: Use appropriate factor(s) from the tables provided. y Tiger Company. The company requires a 4% Initial investment Project X1 $ (130,000) Project X2 $ (220,000) Net cash flows in: Year 1 Year 2 Year 3 50,000 97,500 60,500 87,500 85,500 77,500 a. Compute each project's net present value. b. Compute each project's profitability index. c. If the company can choose only one project, which should it choose on the basis of profitability index? Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute each project's net present value. Note: Round your final answers to the nearest dollar. Net Cash Flowe Present Value of 1 at 4% Present Value of Net Cash…

The following are the cash flows of two independent projects:   Year Project A Project B 0 $ (270 ) $ (270 ) 1   150     170   2   150     170   3   150     170   4   150             a. If the opportunity cost of capital is 12%, calculate the NPV for both projects. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

The answer is project B but please answer why that is the correct answer. Engineering economic question

MAKE SURE YOU ANSWER THIS QUESTION IN EXCEL FORMULA, NOT ALGEBRAICALLY!!!!!

An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?

solve a and b given in the image provided.