Consider the following cashflow of the two mutually exclusive projects. Assume that the discount rate for both projects is 10%. Year Project A Project B O -$380,000 -$625,000 1 292,000 396,000 2 165,000 319,000 3 107,000 204,000 1) Please fill in the following table Project A Project B NPV IRR 2) Based on the NPV, which project should be chosen?
Q: Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0…
A: Net present value (NPV) is the value of all the cash flow of the investment (positive and negative)…
Q: Project Y has initial cost of $7,000, and the discount rate for each project is 6%. Expected cash…
A: Given Data: Discount Rate = 6% Intial Investment 7000 Cash FLow : Year 1 2000 Year 2 2500…
Q: alculate the NPV of project X
A: It refers to the long term investment decisions that has been taken by the top management of a…
Q: M/s Sons & Sons is considering two projects, A &B, with cash flows as shown below: Cash Flow of…
A: Project A @13%- Discounted Payback Period- 4.034 years Year Cash Flow Net Cash Flow Discounted…
Q: A company is considering two projects. The discount rate is 10 percent, and the projects' cash flows…
A: Net present value (NPV) is the difference between the present value of cash inflows and cash…
Q: The Janet Corporation is considering two mutually exclusive projects. The free cash flows associated…
A: Since more than three parts are asked at a time. The answer for first three questions is only…
Q: From the following information calculate the Net Present Value of the two projects & sugge which of…
A: Capital budgeting is a process of investing funds into long terms projects that provide benefits in…
Q: Consider the following cash flows of two mutually exclusive projects for A-Z Motorcars. Assume the…
A: The Payback period is one the techniques of capital budgeting which does not consider the concept of…
Q: Two projects, Y and Z, have the following cash flows: Year Project Y Project Z 0 -500 -1700…
A: Payback(PB) Period shows time in which initial outlay for any proposal is completely recovered from…
Q: Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0…
A: NPV is defined as the difference between the present value of all the cash outflows and cash inflows…
Q: according to the following methods. Explain with reasons a) discounted payback period b) Net…
A: Information Provided: Financing with equity = 60% Financing with debt = 40% Cost of debt = 20% Cost…
Q: The following net cash flows relate to two projects: (i) Calculate the NPVs for each project,…
A: Net Present Value (NPV) is the sum of present values of the cash flows less initial investment. If…
Q: Nashville's Kitchen Corp. is considering a proposed project with the following cash flows. If both…
A: MIRR = Future value of cash inflowPresent value of cash outflow1/n-1 Note: Alternatively we can…
Q: Consider the following cash flows of two mutually exclusive projects for AZ-Motorcars. Assume the…
A: The payback period refers to the time required by an investment to cover its initial investment.…
Q: Calculate the NPV for both projects if the discount rate is 10%
A: Net Present Value (NPV) is one of the method of capital budgeting used for evaluating the projects…
Q: You are considering two mutually exclusive projects with the following cash flows. The discount rate…
A: Pay back period is the amount of years required to recover the initial investment of the project and…
Q: Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash…
A: Calculation of IRR of both the projects and IRR of A-B: Excel workings:
Q: Consider the following cash flows on two mutually exclusive projects: Year Project A…
A: Cash flows given for project A are in real terms, so real discount rate should be used to calculate…
Q: You are considering two independent projects both of which have been assigned a discount rate of…
A: Accept project if NPV is positive and reject project if NPV is negative
Q: Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year…
A: Net Present Value: The net present value can be calculated by subtracting the present value of all…
Q: Consider the following two mutually exclusive projects: Net Cash Flow End of year Project A Project…
A: According to the time value of money concept, money available today is worth more than the same…
Q: Assume two mutually exclusive projects have the estimated net incremental after-tax cash flows shown…
A: NPV is the net current worth of cash flows that have occurred in the past or present. It is computed…
Q: The following information regarding an investment project is available. Discount rate 7% Year…
A: The net present value is an important method for capital budgeting. It refers to the difference…
Q: consider the following cash flows of two mutually exclusive projects, assume the discount rate is…
A: Net present value (NPV) is used to determine the present value of all future cash flows. Net present…
Q: 5
A: Calculation of EAA for project A: Answer: Equivalent annual annuity (EAA) for project A is $20,179
Q: Given the following cash +pws for project X and project Y, Year Project X Project Y -62000 -105000 1…
A: GIVEN, year X Y 0 -62000 -105000 1 27000 10000 2 13500 18000 3 11000 22000 4 10000…
Q: A project has cash flows of -$152,000, $60,800, $62,300, and $75,000 for Years 0 to 3, respectively.…
A: Year Cash flow 0 -152000 1 60800 2 62300 3 75000 Required rate of return = 13%
Q: Pound Industries is attempting to select the best of three mutually exclusive projects. The initial…
A: Capital budgeting indicates the evaluation of the profitability of possible investments and projects…
Q: A company is considering two projects. The discount rate is 10 percent, and the projects' cash flows…
A: Using the NPV and IRR function in Excel
Q: A company is considering two projects. The discount rate is 10 percent, and the projects' cash flows…
A: Net present value (NPV) is the difference between the present value of cash inflows and cash…
Q: A company is considering two projects. The discount rate is 10 percent, and the projects' cash flows…
A: ANSWERS OF ALL THREE QUESTIONS WILL BE STEPS PROVIDED BELOW
Q: The following are the cash flows of 2 projects Year 0, Project A $340, Project B $340 Year 1,…
A: Net present value is the difference between the present value of cash inflow and present value of…
Q: Your firm is considering two projects that are mutually exclusive. Each project will require an…
A: STEP 1: NPV is the current worth of cash flows that are going to happen in the future. It is…
Q: Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0…
A: Present worth (NPV) is one of the techniques of capital budgeting analysis. NPV will be the…
Q: You are considering two mutually exclusive projects with the following cash flows. Which project(s)…
A: YEAR PROJECT A PROJECT B 0 -$275,000 -$202,000 1 0 113,600 2 0 81,900 3 360,000 47,000
Q: If the two projects are independent, which project(s) should be chosen? If the two projects are…
A: a) To calculate NPV and IRR, we use excel By entering the following formulas,
Q: Dragon Products Company is considering two projects. The projects’ cash flows are as follows:…
A: “Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: The following are the cash flows of two projects: Year Project A Project B 0 $ (400 ) $ (400…
A: a) NPV for Project A and project B is $329.07 and $346.06. Computation of NPV: Excel spread…
Q: The Butler-Perkins Company (BPC) must decide between two mutually exclusive projects. Each project…
A: Standard Deviation(SD) and Coefficient of Variation(COV) are the tools used to measure uncertainty…
Q: Vital Silence, Inc., has a project with the following cash flows: Year Cash Flow 0 –$ 27,800…
A: IRR is the rate at which the Net Present value is ZERO. Net Present Value is the Present Value of…
Q: BAG Corporation is considering the following two projects; namely Project X and Project Y: Project Y…
A: YEAR PROJECT X PROJECT X PROJECT X PROJECT Y PROJECT Y PROJECT Y CASH FLOW ACC. CASH FLOW CAL.…
Q: Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0…
A: Net Present Value(NPV) is excess of present value(PV) of cash inflows over initial outlay of…
Step by step
Solved in 3 steps with 2 images
- Calculate the net present value of the following project for discount rates of 10,20 and 40 percent. Based on the NPVs you obtain, under which discount rates do you accept this project? Show your calculations. Cash Flows ($) Year 1 -7000 Year 2 4000 Year 3 19,000 NPV formula: NPV=sum_(t=0)^(n)(EATCF)/((1+k)^(t)) dution:-Consider the following cash flows, for four different projects: (given) (a) Calculate the conventional payback period for each project.(b) Determine whether it is meaningful to caJculate a payback period for Project D.(c) Assuming i = I 0% calculate the discounted-payback period for each project.Project Y has following cash flows: C0 = -800, C1 = +6,000, and C2 = -6,000. Calculate the IRRs for the project: For what range of discount rates does the project have positive NPV (Plot a graph with NPV on the vertical axis and discount rate on the horizontal axis).
- 11. IRR rule (S5.3) Consider the following two mutually exclusive projects: Cash flows ($) Project A B Co -50 -50 C₁ +60 0 C₂ +60 0 0 +140 Page 142 a. Calculate the NPV of each project for discount rates of 0%, 10%, and 20%. Plot these on a graph with NPV on the vertical axis and discount rate on the horizontal axis. b. What is the approximate IRR for each project? c. In what circumstances should the company accept project A? d. Calculate the NPV of the incremental investment (B – A) for discount rates of 0%, 10%, and 20%. Plot these on your graph. Show that the circumstances in which you would accept A are also those in which the IRR on the incremental investment is less than the opportunity cost of capital.Consider the following two mutually exclusive investment projects:Project Cash Flowsn A B 0 -$4,000 -$8,5001 $400 $11,5002 $7,000 $400Assume that the MARR = 15%.(a) Using the NPW criterion, which project would you select?(b) On the same chart, sketch the PW(i) function for each alternative fori = 0% and 50%. For what range of i would you prefer Project B?3) could you use the Figure below that shows the net present value profile of two projects Y and W to answer the following questions: What is the internal rate of return on project Y? Determine the “approximate” discount rate at which you would be indifferent between the two projects Find the “approximate” net present value of project W when the discount rate is 4%.
- Use the table for the question(s) below. Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Discount Rate A -100 40 50 60 N/A .15 B -85 30 30 20 40 10% 11) The NPV of project B is closest to:Consider the two mutually exclusive projects described in the table below. the question requires a step by step excel solutionFor any positive value of the MARR, divide the possible MARR values into ranges with different decisions;describe and discuss what decision would be made in each range and why. You will need to calculate the crossover rate to determine the precise MARR where the decision changes. Include an NPV profile table and chart to illustrate your answer.Year Cash Flow Project A Cash Flow Project B0 -450,000 -700,0001 200,000 200,0002 150,000 200,0003 100,000 200,0004 100,000 200,0005 75,000 200,000Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site. Gardial Fisheries is considering two mutually exclusive investments. The projects expected net cash flows are as follows: a. If each projects cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? b. Construct NPV profiles for Projects A and B. c. What is each projects IRR? d. What is the crossover rate, and what is its significance? e. What is each projects MIRR at a cost of capital of 12%? At r = 18%? (Hint: Consider Period 7 as the end of Project Bs life.) f. What is the regular payback period for these two projects? g. At a cost of capital of 12%, what is the discounted payback period for these two projects? h. What is the profitability index for each project if the cost of capital is 12%?
- (Mutually exclusive projects and NPV) You have been assigned the task of evaluating two mutually exclusive projects with the following projected cash flows: Project A Cash Flow Project B Cash Flow $(102,000) Year 0 1 2340 5 $(102,000) 35,000 35,000 35,000 35,000 35,000 0 0 0 0 230,000 (Click on the icon in order to copy its contents into a spreadsheet) If the appropriate discount rate on these projects is 12 percent, which would be chosen and why? The NPV of Project A is S. (Round to the nearest cent.)a. They payback period of project A is ___ years (round to two decimal places) The payback period of project B is ____ years. (round to two decimal places) According to the payback method, which project should the firm choose? b. The NPV of project A is $___ The NPV of project B is $___ c. The IRR of project A is ___ The IRR of project B is ___ d. Make a reccomendationProject A and B have a cost of OMR (700). Each project generates cash flows as seen in the below table, According to the payback period method and in the line of risk and liquidity preference, answer the following:- (Hint:- Your answer must be not random.) which is the project you will select? Justfy your decision. End-of- Year Cash Flow Project 1 2 3 A 500 300 100 B 400 450 100