Langley Company is considering two capital investments. Both investments have an initial cost of $6,000,000 and total
Question:
Requirements
1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue?
2. Explain the relationship between NPV and IRR. Based on this relationship and the company€™s required rate of return, are your answers as expected in Requirement 1? Why or why not?
3. After further negotiating, the company can now invest with an initial cost of $5,500,000. Recalculate the NPV and IRR. Which plan, if any, should the company pursue?
Year Plan Alpha Plan Beta 1S 1,400,000 $ 1,400,000 1,700,000 2,000,000 1,700,000 1,400,000 1,000,000 700,000 400,000 100,000 3,600,000 Total 14,000,000 14,000,000 1,400,000 1,400,000 1,400,000 1,400,000 1,400,000 1,400,000 1,400,000 1,400,000 1,400,000 4 6 10
Step by Step Answer:
Requirement 1 Microsoft Excel Results Microsoft Excel Formulas Plan Alpha Plan Beta Net present value NPV 130539 rounded 111172 rounded Internal rate of return IRR 1936 rounded 2058 rounded Based on t...View the full answer
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Related Video
NPV stands for \"Net Present Value,\" which is a financial concept used to determine the value of an investment or project. It measures the difference between the present value of cash inflows and the present value of cash outflows over a given period of time, using a specific discount rate. To calculate the NPV of an investment, you need to first estimate the cash inflows and outflows associated with the investment, and then discount them back to their present values using a discount rate. The discount rate represents the cost of capital or the expected rate of return required by investors. The formula for calculating NPV is: NPV = sum of (cash inflows / (1 + discount rate)^t) - sum of (cash outflows / (1 + discount rate)^t) Where: Cash inflows: the expected cash received from the investment Cash outflows: the expected cash paid out for the investment Discount rate: the required rate of return or the cost of capital t: the time period in which the cash flow occurs If the NPV is positive, it means that the investment is expected to generate a return higher than the required rate of return or the cost of capital, and it may be considered a good investment. If the NPV is negative, it means that the investment is not expected to generate a return higher than the required rate of return or the cost of capital, and it may be considered a bad investment.
Students also viewed these Accounting questions
-
Buckner Company is considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 over 10 years. Buckner requires a 16 % rate of...
-
The capital investment committee of Arches Landscaping Company is considering The capital investment committee of Arches Landscaping Company is considering The capital investment committee of Arches...
-
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: The radio station requires an investment of $999,250,...
-
a. Calculate the quick ratio of company B in FY2020. State what factors need to be considered when evaluating company B?s short-term liquidity and analyse the impact of these factors on the...
-
What is the effect of sections 91 and 92 of the Constitution Act, 1867 formerly the British North America Act?
-
A homologous DNA region, which was 20,000 bp in length, was sequenced among four different species. The following number of nucleotide differences were obtained: Construct a phylogenetic tree that...
-
Refer to E5-31A and E5-32A. Assume the Woodson Dairy Forming Department has the following costs per equivalent unit (EU) on its own production cost report for the month of January: Cost per EU...
-
1. Do you believe ABDs products are in a state of readiness to begin exporting to Europe? Why or why not? Are the products ready for exporting to emerging markets (e.g., China, Mexico, Russia)? Why...
-
4. The atomic numbers of elements, U, V, W and X are 13, 14, 16 and 17 respectively. Which one of the elements will react with oxygen to form an ionic compound? (Atomic number of oxygen is 8) X A. B....
-
The accountant for the City of Abernethy calls the local CPA firm that audits the citys financial statements with a question. At the start of the current year, city officials signed a contract to...
-
Mandel Manufacturing, Inc. has a manufacturing machine that needs attention. The company is considering two options. Option 1 is to refurbish the current machine at a cost of $1,100,000. If...
-
Splash City is considering purchasing a water park in Omaha, Nebraska, for $1,910,000. The new facility will generate annual net cash inflows of $487,000 for eight years. Engineers estimate that the...
-
Two kilograms of water with a quality of 50% and a pressure of 1000 kPa are contained in the cylinder of Fig. 3.47 by a frictionless piston. The water is heated at constant pressure until the...
-
Suppose we have a compression function c, which takes a bit string s to a compressed string c(s). (a) Show that for any integer N, there must be a string s of length N for which length(c(s)) N; that...
-
We have just introduced Parisian down-and-in options with a call feature, denoted here C D I P a C D I P a . One can also define Parisian up-and-in options P UIPa P UIPa with a put feature, i.e.,...
-
If a high-pressure homogenizer operating at 200 bars is used to recover the same protein, how many passes are required to recover the maximum amount of protein. Assume k = 0.1.
-
A uranium nucleus \({ }^{238} \mathrm{U}\) at rest decays to a thorium nucleus \({ }^{234} \mathrm{Th}\) by emitting an alpha particle (which is a helium nucleus \({ }^{4} \mathrm{He}\) ): The mass...
-
6 Ingredients produces a single cookbook. The cost of producing and selling one book at the companys normal activity level of 8000 books per month is as follows: The normal selling price is \($22\)...
-
Describe semiquantitatively the motion of an electron under the presence of a constant electric field in the x direction, and a space varying magnetic field given by where E 0 , B 0 , and are...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
Lena Kay and Kathy Lauder have a patent on a new line of cosmetics. They need additional capital to market the products, and they plan to incorporate the business. They are considering the capital...
-
Valley Mills Construction, Inc. had the following stockholders equity on June 30, 2015: Common StockNo Par Value; 200,000 shares authorized, 100,000 shares issued and outstanding $ 250,000 Retained...
-
Stan Sewell paid $ 50,000 for a franchise that entitled him to market software pro-grams in the countries of the European Union. Sewell intended to sell individual franchises for the major language...
-
A client required an IP address from DHCP server, please list the steps of the DHCP process?
-
Bijan's pipelined processor features separate instruction and data caches. The instruction cache (I-cache) has a single level and the data cache (D-cache) has two levels, as shown in the figure...
-
Peter opened a brokerage account to sell short 1,200 shares of Carb Farm stock at the current market price of $160 per share. The brokerage firm charges 12% per annum on the margin loan. a. Suppose...
Study smarter with the SolutionInn App