[EXCEL] Payback: Refer to Problem 5. What are the payback periods for production systems 1 and 2? If the systems are mutually exclusive and the firm always chooses projects with the lowest payback period, in which system should the firm invest? please use excel. Problem 5 info: 5. [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? 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] Payback: Refer to Problem 5. What are the payback periods for production systems 1 and 2? If the systems are mutually exclusive and the firm always chooses projects with the lowest payback period, in which system should the firm invest? please use excel. Problem 5 info: 5. [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? 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

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 11P

See similar textbooks

Similar questions

The Michner corporation is trying is trying to choose between the following 2 mutually exclusive design project: Cash Flow 1 Cash Flow 2 Year 0: -82000 -21700 Year 1: 37600 11200 Year 2: 37600 11200 Year 3: 37600 11200 If the required return is 10% and the company applies the profitability index decision rule, which project should the firm accept? If the company applies the NPV decision rule, which project should it take? why are a & b are different
1. Calculate the net present value for each project. 2. Calculate the simple rate of return for each product.3. Which of the two projects (if either) would you recommend that Batelco Inc. accept? Why?
A firm has two potential investment projects. The project information is summarised in the table below. Project A $670 Project B $700 Expected value of profit Standard deviation of profit Coefficient of variation of profit 175 370 0.26 0.53 Which project has a lower absolute risk level? Which project has a lower relative risk level? Which project would you advise the firm to choose? Explain your answers. ---- --- ---- ..- ---
Basic NPV methods tell us that the value of a project today is NPV0. Time value of money issues also lead us to believe that if we choose not to do the project that it will be worth NPV1 one period from now, such that NPV0 > NPV1. Why then do we see some firms choosing to defer taking on a project. Be complete and thorough in your answer.
4. Unequal project lives ABC Telecom has to choose between two mutually exclusive projects. If it chooses project A, ABC Telecom will have the opportunity to make a similar investment in three years. However, if it chooses project B, it will not have the opportunity to make a second investment. The following table lists the cash flows for these projects. If the firm uses the replacement chain (common life) approach, what will be the difference between the net present value (NPV) of project A and project B, assuming that both projects have a weighted average cost of capital of 12%? Cash Flow Project A Year 0: -$17,500 Year 0: $45,000 Year 1: 10,000 Year 1: 9,000 Year 2: 16,000 Year 2: 16,000 Year 3: 15,000 Year 3: 15,000 Year 4: 14,000 Year 5: 13,000 Year 6: 12,000 • $14,124 $14,955 $18,279 ● $16,617 • $13,294 ABC Telecom is considering a three-year project that has a weighted average cost of capital of 10% and a NPV of $45,681. ABC Telecom can replicate this project indefinitely. What…
The Weiland Computer Corporation is trying to choose between the following mutually exclusive design projects, P1 and P2: Year 0 1 2 3 Cash flows (P1) -$53,000 27,000 27,000 27,000 Cash flow (P2) -$16,000 9,100 9,100 9,100 If the discount rate is 10 percent and the company applies the profitability index (PI) decision rule, which project should the firm accept? If the firm applies the Net Present Value (NPV) decision rule, which project should it take? Are your answers in (a) and (b) different? Explain why?
Basic NPV methods tell us that the value of a project today is NPV0. Time value of money issues also lead us to believe that if we choose not to do the project that it will be worth NPV1 one period from now, such that NPV0 > NPV1. Why then do we see some firms choosing to defer taking on a project?
I need solutions for questions d, e, f, g, h and i. Thanks d. Are this project’s cash flows likely to be positively or negatively correlated withreturns on Cory’s other projects and with the economy, and should this matter in youranalysis? Explain.e. Unrelated to the new product, Cory is analyzing two mutually exclusive machines thatwill upgrade its manufacturing plant. These machines are considered average-riskprojects, so management will evaluate them at the firm’s 10% WACC. Machine Xhas a life of 4 years, while Machine Y has a life of 2 years. The cost of each machineis $60,000; however, Machine X provides after-tax cash flows of $25,000 per year for4 years and Machine Y provides after-tax cash flows of $42,000 per year for 2 years. Themanufacturing plant is very successful, so the machines will be repurchased at the endof each machine’s useful life. In other words, the machines are “repeatable” projects.1. Using the replacement chain method, what is the NPV of the better machine?2.…
QUANTITATIVE. Fill in the following statements based on the below project financial analysis. a. The Net Present Value is b. The Return on Investment is c. The project will break even (make back its costs) in Year d. This project Created by: Praju Manageski Note: Change the inputs, such as discount rate, number of years, costs, and benefits. Be sure to Discount rate Costs Discount factor Discounted costs Benefits Discount factor Discounted benefits profitable because the ROI and NPV are both Financial Analysis for Project GGU Assume the project is completed in Year 0 Discounted benefits -costs Cumulative benefits - costs ROI 5% 10,000 1.00 10,000 0 1.00 0 (10,000) (10,000) 16% 0 0.95 2,000 0.95 1,905 Year 0 0.91 5000 0.91 4,535 1,905 4,535 (8,095) (3,560) 0 0.86 . 6000 0.86 5,183 5,183 1,623 10,000 11,623 1,623 NPV
Yonan Inc. is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. If the decision is made by choosing the project with the shorter payback, some value may be forgone. How much value will be lost in this instance? Note that under some conditions choosing projects on the basis of the shorter payback will not cause value to be lost. WACC: 10.25% 0 1 2 3 4 CFS -$800 $650 $350 $0 $0 CFL -$1,900 $550 $600 $600 $840 Please explain and show calculations.
All parts are under one question therefore per your policy all can be answered. 7. The NPV and payback period What information does the payback period provide? Suppose you are evaluating a project with the expected future cash inflows shown in the following table. Your boss has asked you to calculate the project’s net present value (NPV). You don’t know the project’s initial cost, but you do know the project’s regular, or conventional, payback period is 2.50 years. Year Cash Flow Year 1 $375,000 Year 2 $425,000 Year 3 $500,000 Year 4 $400,000 A. If the project’s weighted average cost of capital (WACC) is 9%, the project’s NPV (rounded to the nearest dollar) is: $353,334 $305,152 $273,031 $321,213 B. Which of the following statements indicate a disadvantage of using the regular payback period (not the discounted payback period) for capital budgeting decisions? Check all that apply. The payback period does not…
WorldTrans is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. If the decision is made by choosing the project with the shorter payback, some value may be forgone. How much value will be lost in this instance? Note that under some conditions choosing projects on the basis of the shorter payback will not cause value to be lost. WACC: 14.25% 0 1 2 3 4 CFS -$950 $500 $800 $0 $0 CFL -$2,100 $400 $800 $800 $1,000 Group of answer choices $127.87 $95.90 $93.62 $116.46 $0.00