[EXCEL] Net present value: Crescent Industries management is planning to replace some existing machinery in its plant. The cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses an 18 percent discount rate for projects like this, should management go ahead with the project? Please use excel Year Cash Flow 0 −$3,300,000 1 875,123 2 966,222 3 1,145,000 4 1,250,399 5 1,504,445

[EXCEL] Net present value: Crescent Industries management is planning to replace some existing machinery in its plant. The cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses an 18 percent discount rate for projects like this, should management go ahead with the project? Please use excel Year Cash Flow 0 −$3,300,000 1 875,123 2 966,222 3 1,145,000 4 1,250,399 5 1,504,445

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter12: Capital Investment Analysis

Section: Chapter Questions

Problem 6E: Cash payback method Lily Products Company is considering an investment in one of two new product...

See similar textbooks

Similar questions

[EXCEL] Net present value: Blanda Incorporated management is considering investing in two alternative production systems. The systems are mutually exclusive, and the cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses a 9 percent discount rate for production system projects, in which system should the firm invest? Please use excel. Year System 1 System 2 0 −$15,000 −$45,000 1 15,000 32,000 2 15,000 32,000 3 15,000 32,000
[EXCEL] Net present value: Kingston, Inc. management is considering purchasing a new machine at a cost of $4,133,250. They expect this equipment to produce cash flows of $814,322, $863,275, $937,250, $1,017,112, $1,212,960, and $1,225,000 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? Please use excel.
Sunland, Inc. management is considering purchasing a new machine at a cost of $4,390,000. They expect this equipment to produce cash flows of $845,890, $819,250, $917,830, $1,103,400, $1,093,260, and $1,306,800 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.) The NPV is $enter the NPV in dollars rounded to 0 decimal places
17. Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B)0 −$291,000 −$41,6001 37,000 20,0002 55,000 17,6003 55,000 17,2004 366,000 14,000 a) What is the Internal Rate of Return (IRR) for each of these projects? b) Using the IRR decision rule, which project should the company accept? c) If the required return is 11 percent, what is the Net Present Value (NV) for each of these projects? d) Using the NPV decision rule, which project should the company accept? e) Why do you think the NPV and IRR rules do not agree on same project approval/rejection direction?
Sons Inc. management is considering purchasing a new machine at a cost of $4,390,000. They expect this equipment to produce cash flows of $845,890, $819,250, $917,830, $1,103,400, $1,093,260, and $1,306,800 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.) The NPV is $
Kingston, Inc. management is considering purchasing a new machine at a cost of $4,150,315. They expect this equipment to produce cash flows of $756,424, $834,614, $932,657, $1,071,731, $1,298,352, and $1,243,375 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? (Enter negative amounts using negative sign e.g. -45.25. Round answer to 2 decimal places, e.g. 15.25.) The NPV is $ _____________
Ivanhoe Industries management is planning to replace some existing machinery in its plant. The cost of the new equipment and the resulting cash flows are shown in the accompanying table. The firm uses an 18 percent discount rate for projects like this. Should management go ahead with the project? Year Cash Flow 0 -$3,046,900 1 803,710 2 889,200 3 1,247,600 4 1,285,160 5 1,576,500 What is the NPV of this project? - NPV $?
5). The HC Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow I (in dollars) Cash Flow II (in dollars) 0 -64, 000 -18,000 1 31, 000 9,700 2 31, 000 9,700 3 31, 000 9,700 a). If the required return is 10%, and the company applies the profitability index decision rule, which project should the firm accept? Why? b). If the company applies the NPV decision rule, which project should it take? Why? c). Explain why your answers in (a) and (b) are different.
The McNally Co. is considering an investment in a project that generates a profitability index of 1.3. The present value of the cash inflows on the project is P44,000. What is the net present value of this project?
2. Incremental costs - Initial and terminal cash flow Consider the case of Alexander Industries: Alexander Industries is considering a project that requires an investment in new equipment of $3,570,000. Under the new tax law, the equipment is eligible for 100% bonus depreciation at t = 0 so the equipment will be fully depreciated at the time of purchase. Alexander estimates that its accounts receivable and inventories need to increase by $680,000 to support the new project, some of which is financed by a $272,000 increase in spontaneous liabilities (accounts payable and accruals). The company's tax rate is 25%. A. The after-tax cost of Alexander’s new equipment is . B. Alexander’s initial net investment outlay is . C. Suppose Alexander’s new equipment is expected to sell for $400,000 at the end of its four-year useful life, and at the same time, the firm expects to recover all of its net operating working capital…
1.A company is considering a R250 000 investment with the following cash flows Year 1 : R30 000 Year 2: R60 000 Year 3: R120 000 Year 4: R130 000 Year 5: R160 000 a) Determine the payback period of the investment ( present in table format) b) If the company wants to recover its initial investment in year 3, is the investment worthwhile? c) Identify and explain any 3 advantages of using payback method.
Q9. Required information A new advertising campaign by a company that manufactures products that apply biometric, surveillance, and satellite technologies resulted in the cash flows shown. Year Cash Flow, $1000 0 2000 1 1200 2 –4000 3 –3000 4 2000 Calculate the unique external rate of return values using the MIRR approach with an investment rate of 30% and a borrowing rate of 10% per year. The unique external rate of return value using the MIRR approach is %.