Crane Incorporated management is considering investing in two alternative production systems. The systems are mutuallyexclusive, and the cost of the new equipment and the resulting cash flows are shown in the accompanying table. The firm uses a 7percent discount rate for production system projects.YearSystem 1System 20-$15,300-$43,700115,30031,700215,30031,700315,30031,700Calculate NPV. (Enter negative amounts using negative sign, e.g. -45.25. Do not round discount factors. Round answersto 2 decimal places, e.g. 15.25.)NPV of System 1 is $In which system should the firm invest?The firm should invest in System 190.22 and NPV of System 2 is $43.58

For your convenience, I will also provide an Excel sheet. THANK YOU (please give to me rating)

Answered: Crane Incorporated management is…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Mendez Company has identified an investment project with the following cash flows. Year 1234 Cash Flow $ 1,090 940 1,490 1,850 a. If the discount rate is 12 percent, what is the present value of these cash flows? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. What is the present value at 15 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. What is the present value at 21 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. a. Present value at 12 percent b. Present value at 15 percent c. Present value at 21 percent
Duo Corporation is evaluating a project with the following cash flows: Year Cash Flow 0 1 2 3 4 5 The company uses an interest rate of 9 percent on all of its projects. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) MIRR -$ 29,500 11,700 14,400 16,300 13,400 -9,900 MIRR Calculate the MIRR of the project using the reinvestment approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) % MIRR % Calculate the MIRR of the project using the combination approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) %
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
es McCann Co. has identified an investment project with the following cash flows. Year 1 234 a. If the discount rate is 10 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the present value at 16 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the present value at 25 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Cash Flow $820 1,130 1,390 1,525 b. C. Present value at 10% Present value at 16% Present value at 25%
Salsa Company is considering an investment in technology to improve its operations. The investment costs $241,000 and will yield the following net cash flows. Management requires a 10% return on investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) Note: Use appropriate factor(s) from the tables provided. Year Net cash Flow 1 $ 48, 200 2 53,900 3 76, 400 4 95,500 5 126,500 Required: Determine the payback period for this investment. Determine the break - even time for this investment. Determine the net present value for this investment. Should management invest in this project based on net present value?
Case 1: Assume you are evaluating two mutually exclusive projects,the cash flows of which appear below, and that your company uses a cost of capital of 8 percent to evaluate projects such as these. Time Project A Cash Flow Project B Cash Flow 0 -$650 -$700 1 100 300 2 250 -200 3 250 550 4 200 200 5 100 80 a. Calculate the payback of Project A. b. Calculate the discounted payback of Project A. c. Calculate the IRR of Project A. d. Using the NPV method and assuming a cost of capital of 8 percent, which of these projects should be accepted?
Wildhorse 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 0 1 2 3 4 5 Cash Flow -$3,485,400 871,710 896,700 1,104,400 1,340,360 1,450,600 What is the NPV of this project? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to O decimal places, e.g. 1,525.) The NPV is $
Janu diku
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 $?
Dogwood Company is considering a capital investment in machinery: (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dogwood invest in the machinery? 8. Calculate the payback. Amount invested Expected annual net cash inflow Payback 1,500,000 24 500,000 3 years 9. Calculate the ARR. Round the percentage to two decimal places. Average annual operating income Average amount invested ARR Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 15%
Beyer Company is considering buying an asset for $350,000. It is expected to produce the following net cash flows. Compute the payback period for this investment. (Cumulative net cash outflows must be entered with a minus sign. Round your Payback Period answer to 2 decimal places.)
This is the problem. I need to do cash flow diagram , PW cost for each vendor, and which vendor would choose.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS