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)

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 1CMA

See similar textbooks

Similar questions

Use the information provided to answer the questions Calculate the Accounting Rate of Return (on average investment) of Project B (expressed to twodecimal places).Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). Use your answers from previous question to recommend the project that should be chosen. Motivateyour choice.
Homework i 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. Complete this question by entering your answers in the tabs below. Required A 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? FI Compute the net present value of each project. Potential Projects Project A Present value of net cash flows Initial investment Net present value 2 Required B W F2 # Required C 3 APR 11 80 F3 $ 4 m tv 6 Project A $ 9,972 (10,000) 2 of 8 c F6 # & 7 Project B $ 10,697 (10,000) F7 Next > Y U il A 8 Project C $ 10,653 (10,000) FB DD ( F9 9 FU O
Internal rate of return For the project shown in the following table, , calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. ..... The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF,) $150,000 Year (t) Cash inflows (CF;) $35,000 $30,000 $35,000 $40,000 $50,000 1 2 3 4 5 Print Done
You are analyzing a project and have prepared the following data: a. Based on the net present value of this project, should you reject or accept this project? (Please provide the formulas for calculation or the keys applied if a financial calculator is used) b. What is the internal rate of return (IRR) of this project? Should you reject or accept this project? (Please use a financial calculator and list the keys you use)
(a) Calculate the payback period for each project. (b) Calculate the net present value (NPV) for each project. (c) Calculate the profitability index of each project. (d) Explain to the company which project should be implemented. Support your answer.
You are a project manager for your company and you are faced with five potential projects that you can invest in. Free cash flow projections and additional relevant data are given for each project in the table below. Assume that there are no cash flows after year 3. Assume that you can only take each project once and that you can only choose one project. Which project would you invest in? Select the best answer. Project Project A Project B Project C Project D Project E O I. Project A II. Project B III. Project C IV. Project D O V. Project E FCF Forecasts by Year (in $1,000) 0 2 1 500 (400) (400) (300) (250) (300) 75 60 75 135 115 175 3 650 210 190 200 Interest Rate (EAR) 8.0% 10.0% 10.0% 12.0% 12.0% IRR 25.00% 17.57% 15.92% 17.81% 19.96%
Mf4. 1. Calculate the Payback period 2. Calculate the Net Present Value (NPV) of both projects 3. Calculate the Internal Rate of Return (IRR) of both projects 4. Critically discuss the merits of each investment appraisal method, then discuss the result of the evaluations you have made of the two projects and advise the company which project should be undertaken
The internal rate of return (IRR) on a project is the average annual rate of return provided by investing in the project. A. Explain this thoroughly. B. Give some example if you have any idea.
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!
Which of the following statements is CORRECT? a. The NPV profile graph for a normal project will generally have a positive (upward) slope as the life of the project increases. b. An NPV profile graph shows how a project's payback varies as the cost of capital changes. O c. An NPV profile graph is designed to give decision makers an idea about how a project's contribution to the firm's value varies with the cost of capital. d. An NPV profile graph is designed to give decision makers an idea about how a project's risk varies with its life. e. We cannot draw a project's NPV profile unless we know the appropriate WACC for use in evaluating the project's NPV.
Internal rate of return For the project shown in the following table, calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable.
What are the internal rates of return (IRR) on the three projects? Does the IRR rule in this case give the same decision as NPV? How do you know? If the opportunity cost of capital is 11%, what is the profitability index for each project? Please analyze if, in general, decisions based on the profitability index are consistent with decisions based on NPV. What is the most generally accepted measure to choose between the projects? Please justify your answer. Project A -5000 +1000 +1000 +3000 0 B -1000 0 +1000 +2000 +3000 C -5000 +1000 +1000 +3000 +5000 I will need full analysis (qualitative examples and references citations and examples of relative current investments of big companies.