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?
-
Wick Corporation has a Mexican subsidiary that had the following balance sheet at December 31, 20X1 (stated in millions of pesos): (millions of pesos) Cash 300 Accounts receivable 125 Inventory 400...
-
What are the characteristics and advantages of the graphical user interface (GUI)?
-
Olympic National Agencies was organized with an authorized capitalization of preferred stock and common stock. The articles of incorporation provided for a 7 percent annual dividend for the preferred...
-
Hudson Goins is a 45% partner in the Holly & Goins Partnership. During 2021, the partnership reported the total items below (100%) on its Form 1065: i (Click the icon to view the items on the Form...
-
The diagram opposite gives details about a companys 115 employees. For example, it employs four unqualified, part-time females. Two employees are selected at random. Find the probability that: a. One...
-
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...
-
A student makes the following observation: The Dow Jones Industrial Average currently has a value of 17,500, while the S&P 500 has a value of 2,000. Therefore, the prices of the stocks in the DJIA...
-
Chira is doing a fitness program where on the fifth day, he has to do 22 push-ups, and on the eighth day, he has to do 31 push-ups. a) Write the general term that relates the number of push-ups to...
-
Basements that are prone to flooding are generally equipped with a sump pump, as illustrated in the image. (For purposes of illustration, the house above the basement has been removed, and dimensions...
-
The net force is obviously in the z-direction, so it suffices to calculate 2 (47 COR) ( . da) = T da, + T da, + Tu da, = (2 sin 0 cos 0 de d. 2 the "houl" is therefore
-
7.2 A wire in the shape of a parabola z = rotates about the vertical z axis with 2a constant angular frequency . Here r is the distance from the z axis, and a is a constant. A constant gravitational...
-
4. When 50.0 mL of 1.0 M HCl is neutralized with 50.0 mL of 1.0 M NaOH in a calorimeter having a heat capacity of 15.6 J/g C, the temperature of the reaction solution is found to increase 6.0 C....
-
A client is experiencing a reaction to the penicillin injection that the nurse administered approximately hour ago. The nurse is concerned that it might be an anaphylactic reaction. What signs and...
-
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...
-
Consider a $1000 face value 3-year treasury with 2.5% annual coupon and a yield of 1.3%. Suppose that after one year and after receiving one coupon payment, you decide to sell your treasury note....
-
How in a perfect world would muni bonds pay interest? Explain the correlation between the greater premium and high tax states. Will you invest in Muni bonds based on the new findings? Please discuss.
-
CityLight Co. is struggling financially. Prior to debt renegotiations, the company's total assets were $11 million and total liabilities were $18 million. The company has negotiated with the debtors...
Study smarter with the SolutionInn App