ABC Company has the following list of projects. The company has only $1,500,000 available for investment. Which projects should the company undertake? Why? Projects Initial Investment
A) initial investment is 750,000, NPV 75,000
B )Initial investment 1,000,000 , NVP 250,000
C )initial investment 750,000 ,NVP 50,000
D )initial investment 500,000 NVP 90,000
E )initial investment 500,000 , NVP 100,000
Project (B) and (E) have the highest NPVs at 250000 and 100000 respectively. Further, the initial investments of the two projects combined exactly match the total investment capital available worth $ 1500000.No other project combination provides a higher NPV within the available capital constraint
Hence, the correct options are (B) and (E).
ABC Company has the following list of projects. The company has only $1,500,000 available for investment....
EXCEL ONLY, PLEASE SHOW FORMULA WORK A company is considering three capital budgeting projects. Data relative to each is given below. Each project has a life of 5 years. The company uses the NPV method to evaluate capital budgeting projects and its discount rate is 9%. Project A Project B Project C Initial cash outlay (cost) -$5,000,000 -$6,000,000 -$3,000,000 Cash inflows per year $1,500,000 $1,800,000 $ 600,000 Residual value $ 500,000 0 $100,000 1. If the projects are mutually exclusive,...
VDSL Company has two mutually exclusive projects. Below is a table representing the initial investment and cash flows for these projects over four (4) years. Project A Project B Year Cash Flow Cash Flow $ $ 0 -750,000 -750,000 1 250,000 200,000 2 350,000 400,000 3 250,000 100,000 4 200,000 175,000 a. If the company’s required rate of return is 8%, calculate the Profitability Index of each project and determine which project is the best investment. b. If the company...
Knapsack problem. From the following list of potential projects, use Excel solver to find the optimal allocation of your budget of $1,000,000 to maximize profit. Select the projects that you will select and attach your answer report. Project ID Cost Expected profit Check selected 1 $400,000 $1,000,000 2 $50,000 $400,000 3 $300,000 $800,000 4 $150,000 $300,000 5 $400,000 $600,000 6 $600,000 $2,000,000 7 $200,000 $300,000 8 $250,000 $700,000 9 $100,000 $300,000 10 $100,000 $300,000 11 $250,000 $100,000 12 $350,000 $700,000...
The following table gives the available projects for a firm. A B C D E Initial Investment 10 13 6 7 2 NPV 3.5 –2 0.5 6 3 The firm has only $20 million to invest. Which project(s) will be accepted?
Norwich Manufacturing is considering three capital investment proposals. At this time, the company has funds available to pursue only one of the three investments. B (Click the icon to review the proposals.) Requirement Which investment should Norwich Manufacturing pursue at this time? Why? Since each investment presents a positive NPV, Norwich Manufacturing should use the to compare the profitability of each investment © Data Table - X Equipment A Equipment B Equipment C Present value of net cash inflows ........S...
Quattro, Inc. has the following mutually exclusive projects available. The company has historically used a four-year cutoff for projects. The required return is 11 percent. The payback for Project A is ____ while the payback for Project B is ____. The NPV for Project A is _____ while the NPV for Project B is ____. Which project, if any, should the company accept? 3.92 years; 3.64 years; $780.85; $1,211.48; accept both Projects 3.92 years; 3.79 years; -$17,108.60; $1,211.48; accept Project...
Lapides Ltd. is a small company that is currently analyzing
capital expenditure proposals for the purchase of equipment. The
capital budget is limited to $250,000, which Lapides believes is
the maximum capital it can raise. The financial adviser is
preparing an analysis of four projects that the company is
considering, as follows:
Instructions
a. Calculate the cash payback period for each of the four
projects.
b. Calculate the net present value for each project at a cost of
capital of...
Consider four projects, which you expect to generate the following cash flows: Year Project A Project B Project C Project D 0 (200,000) (2,000) (200,000) (200,000) 1 210,000 18,000 100,000 90,000 2 (100,000 is for project c & d ONLY) 100,000 100,000 3 100,000 115,000 , Your required return on all of the investments is 8%. For each project estimate the Payback Period, Internal Rate...
Yong Importers, an Asian import company, is evaluating two mutually exclusive projects, A and B. The relevant cash flows for each project are given in the table below. The cost of capital for use in evaluating each of these equally risky projects is 10 percent. initial investment project a project b $350,000 $425,000 year cash inflows (cf) 1 140,000 175,000 2 165,000 150,000 3 190,000 125,000 4 100,000 5 75,000 6 50,000 Which project should be chosen on the basis of...
Q1. Inatech is contemplating two different projects and decides to perform a financial analysis to determine which is more financially lucrative. Project A and B have the cash flows as shown and Inatech uses a required rate of return of 10% and an inflation rate of 4%. Compute the payback in years and the net present value for both projects and offer advice as to the best course of action. (4 marks) Yearl A B 0 -$100.000|-$400,000 $20,000 $75,000 2....