Phoenix Company is considering investments in projects C1 and C2. Both require an initial investment of $270,000 and would yield the following annual net cash flows. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Net cash flows Project C1 Project C2 Year 1 $ 26,000 $ 110,000 Year 2 122,000 110,000 Year 3 182,000 110,000 Totals $ 330,000 $ 330,000 a. The company requires a 10% return from its investments. Compute net present values using factors from Table B.1 in Appendix B to determine which projects, if any, should be accepted. b. Using the answer from part a, is the internal rate of return higher or lower than 10% for (i) Project C1 and (ii) Project C2? Hint: It is not necessary to compute IRR to answer this question.

Phoenix Company is considering investments in projects C1 and C2. Both require an initial investment of $270,000 and would yield the following annual net cash flows. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Net cash flows Project C1 Project C2 Year 1 $ 26,000 $ 110,000 Year 2 122,000 110,000 Year 3 182,000 110,000 Totals $ 330,000 $ 330,000 a. The company requires a 10% return from its investments. Compute net present values using factors from Table B.1 in Appendix B to determine which projects, if any, should be accepted. b. Using the answer from part a, is the internal rate of return higher or lower than 10% for (i) Project C1 and (ii) Project C2? Hint: It is not necessary to compute IRR to answer this question.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter19: Capital Investment

Section: Chapter Questions

Problem 12E: Refer to Exercise 19.11. 1. Compute the payback period for each project. Assume that the manager of...

See similar textbooks

Net cash flows	Project C1	Project C2
Year 1	$ 26,000	$ 110,000
Year 2	122,000	110,000
Year 3	182,000	110,000
Totals	$ 330,000	$ 330,000

Similar questions

1-Build an Excel Model to compute the NPV of investment project I or II and make sure that the model works (allows for changes in the inputs ,updates the output-NPV-and gives the same result). 2-Make your assumptions for a hypothetical project and compute the NPV. Then, show how NPV would change when you change specific inputs (ceteris paribus). Do this analysis for at least 3 inputs using scenario analysis or data tables, assigning different values to each input.
If we are comparing projects of unequal sizes (requiring unequal amounts of investment), screening methods like NPV are only good for deciding if a product or service is worth considering along with other valid opportunities. In that case, we have to use a ranking method after screening the projects. How do we do that? For example, you have been given the following information: (n = 3; i = 10%) How will you rank these projects? Project R Project S Project T Investment required $13,000 $59,000 $89,000 Annual net cash flows $6,000 $25,000 $43,000
These questions are intended for self-study. Click the [solution] box to reveal a detailed solution. Two mutually exclusive investment projects have been presented to your company. Project A’s rate of return is 6%, and Project B’s rate of return is 8%. The cost of Project A is less than the cost of Project B. Incremental analysis yields a rate of return of 4%. If both alternatives have the same useful life and the MARR is 5%, which project should be chosen?
Use the information below and help the management in choosing the most desirable Project using all the following techniques:1) Payback Period Technique.2) Discounted Payback Period Technique.3) Net Present Value Technique4) Profitability Index Technique. Based on your answer which project is better and why? please show the steps and formula Thanks
The following stages of a project are each contingent upon the preceding stage. If the preceding stage is not performed (accepted), then none of the subsequent stages may be performed. Solve, a. Remembering that no stages can be skipped, which set of the five stages do you recommend be purchased? b. Of the ten principles, which one(s) is(are) well illustrated by thisproblem? c. Of the systematic economic analysis technique’s 7 steps, which one(s) is(are) well illustrated by this problem?
d. What is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Using excel how to I find the PI for this question?
You have been assigned to perform a project selection based on profitability index. You have collected data on the three project alternatives A1, A2, and A3 and your team has calculated the following (table) present worth equivalent for the benefits, costs, and investments at a social discount rate of 10%. The service life of each alternative is identical. (a) Find the PI(i) for each project alternative (b) Find the best alternative based on incremental PI(i) analysis (c) Why is the profitability index referred to as a measure of capital efficiency?
Solve the following problem using excel: The program is estimated to require a 10-year commitment to fully achieve the desired result. Analyze the following information using both the Net Present Value (NPV) method and the Internal Rate of Return (IRR) method.(I have already worked and solved this problem, however as it is complex and contains a large number of values to be calculated, I want to be sure that I applied all appropriate concepts correctly.)I have attached the directions and problem in a screenshot.
Can someone help me figure out this problem? Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your…
Based on the picture, a. Calculate the Internal Rate of Return for the project. b. If you were the financial manager, would you accept this project? Why? Please help me ASAP. Thanks!
Show the answer on excel and how you did it: Puppet is evaluating two alternative, mutually exclusive methods for delivering cloud platforms It has developed the following estimated after-tax cost savings for each alternative. Project managers want to see an incremental IRR and NPV before making the decision. If the project discount rate is 9%, which method would you recommend? Explain and provide evidence. Show all cash flows and related analyses. Clearly specify your recommendation and reasoning clearly on your worksheet. clearly show inputs and outputs areas.(Input Area: Show all of your key inputs, with appropriate labels, before creating your analysis. Add lines as needed.)(Output Area: Show the development of your answers to each question below. Clearly label inputs, steps and identify key results.) Project cash flows are as follows: Software Solution 1: To: -115,000, T1: 45,000, T2: 40,000, T3: 35,000, T4: 20,000, T5: 10,000 Software Solution 2: To: -175,000, T1: 5,000,…
Your firm is considering what has been estimated to be a positive NPV project (NPV > 0). What can you say or infer about the project's payback period, discounted payback method, IRR, profitability index, and accounting rate of return (Please be thorough)?