A company is considering three alternative Investment projects with different net cash flows. The present value of net cash flows iscalculated using Excel and the results follow.Potential ProjectsPresent value of net cash flows (excluding initial investment)Initial investmentComplete this question by entering your answers in the tabs below.a. Compute the net present value of each project.b. If the company accepts all positive net present value projects, which of these will It accept?c. If the company can choose only one project, which will it choose on the basis of net present value?Required A Required BCompute the net present value of each project.Potential ProjectsProject APresent value of net cash flowsInitial investmentNet present valueRequired CProject E< Required AProject A$ 8,328(10,000)Project CProject B$10,809(10,000)Required B >Project C$10,685(10,000)

>Present value of net cash flows is the discounted future net cash flows that are converted to…

A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment a. Compute the net present value of each project. Project A $ 8,328 (10,000) Project B $ 10,809 (10,000) Project C $ 10,685 (10,000)

A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment a. Compute the net present value of each project. Project A $ 8,328 (10,000) Project B $ 10,809 (10,000) Project C $ 10,685 (10,000)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Thomas Company is considering two mutually exclusive projects. The firm, which has a cost of capital of 8%, has estimated its cash flows as shown in the following table attached: a. Calculate the NPV of each project, and assess its acceptability. b. Calculate the IRR for each project, and assess its acceptability.
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 6% return from its investments. Project X1 Project X2 Initial investment $ (114,000) $ (188,000) Net cash flows in: Year 1 42,000 85,500 Year 2 52,500 75,500 Year 3 77,500 65,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places.
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Project X1 Project X2 IRR 21.00 % 12.00 % Project X1 $ (90,000) Yes Yes 30,000 40,500 65,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places. Acceptable? Project X2 $ (140,000) 67,500 57,500 47,500
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.
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 5% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Project X2 Project X1 $ (112,000) $ (184,000) 41,000 84,000 51,500 76,500 74,000 64,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places. Project X1 Project X2 IRR Acceptable? % Yes % Yes
Yokam Company is considering two alternative projects. Project 1 requires an initial investment of $420,000 and has a present value of all its cash flows of $1,350,000. Project 2 requires an initial investment of $5 million and has a present value of all its cash flows of $6 million. (a) Compute the profitability index for each project.(b) Based on the profitability index, which project should the company select?
Carol, Inc. is considering three different independent investment opportunities. The present value of future cash flows, initial investment, and net present value for each of the projects are as follows: Project A Project B Project C Present value of future cash flows $ 651,200 $ 476,700 $ 585,200 Initial investment 280,000 235,000 270,000 Net present value $ 371,200 $ 241,700 $ 315,200 In what order should Carol prioritize investment in the projects? Multiple Choice A, B, C C, A, B C, B, A A, C, B
You are given the following financial information related to a capital investment project. What is the project's Year 1 Net Cash Flow? Sales revenues Depreciation Other operating costs Interest Exp Tax rate WACC Select one: a. $8,580 b. $8,900 c. $9,350 d. $9,463 e. $9,832 $22,250 $8,000 $12,000 $800 40.0% 12.0%
Andrew Oxnard, chief financial officer, has been asked by Harry Pendel, chief executive officer and co-founder of Pendel & Braithwaite, Ltd. (P&B), to analyze two capital investment projects (projects A and B), which are expected to generate the following profit (p)streams: Profit Streams for Projects A and B period ?? ($) ?? ($) 1 100,000 350,000 2 200,000 300,000 3 250,000 200,000 4 300,000 100,000 5 325,000 100,000 Total 1,175,000 1,050,000 Profits are realized at the end of each period. Assuming that P&B is a profit maximizer if the discount rate for both projects is 12%, which of the two projects should be adopted?
A company has two projects that are under evaluation. The project investment costs, annual projected cash flows, and required rates of return are shown below: Project 1 Project 2 Rate of Return: 0.065 0.065 Project Cost: -$1,397,654 -$1,619,835 Year 1 $245,367 $267,345 Year 2 $302,542 $343,563 Year 3 $316,543 $367,834 Year 4 $367,843 $432,098 Year 5 $450,425 $589,435 Compute the NPV for each project using Microsoft Excel NPV's function. Be sure to show your work. Which project should be pursued? Why?
Consider two investments A and B with the following sequences of cash flows: Net Cash Flow n Project A Project B 0 -$120,000 -$100,000 1 20,000 15,000 2 20,000 15,000 3 120,000 130,000 (a) Compute the IRR for each investment. (b) At MARR = 15%, determine the acceptability of each project. (c) If A and B are mutually exclusive projects, which project would you select, based on the rate of return on incremental investment?
Carmen, Inc. is considering three different independent investment opportunities. The present value of future cash flows, initial investment, net present value, and profitability index for each of the projects are as follows: Project A Project B Project C Present value of future cash flows $450,100 $313,100 $405,000 Initial investment 200,000 155,000 190, еее Net present value $250, 100 $158,100 $215,000 Profitability index 2.25 2.02 2.13 In what order should Carmen prioritize investment in the projects? Multiple Cholce С, В, А O A, B, C А, С, В C, A, B