Q5. Consider the investment projects given in the following table: Net Cash Flow Project A Project B Project C - $100 - S150 - $10 1 30 50 410 2 50 50 -558 3 50 252 50 IRR 23.24% 21.11% 20%, 40%, 50% Assume that MARR = 12% in the following questions: Identify simple and non-simple projects. Identify pure and mixed investments. Determine the IRR for Project C. (Hint: You can use trial-error method followed by linear interpolation.)
Q: Year Investment A Investment B 0 –$100 –$100 1 10 50 2 30 40 3 50 30 4 70 20…
A: The net present value method of investment appraisal is to invest in a project with a positive NPV.…
Q: A firm evaluates all of its projects by applying the IRR rule. Year Cash Flow 0 –$ 150,000…
A: IRR is the rate at which NPV of the project is 0
Q: Consider the following projected cash flows in the indicated cells in Excel for years zero through…
A: We know, Net Present Value (NPV) is the difference between the present value of cash inflows and…
Q: Your division is considering a project with the following net cash flows (in millions): Period…
A: Therefore, the net present value (NPV) is -$1.44.
Q: Consider the following two mutually exclusive projects: Cash Flow Cash Flow Year (A) (B) 5353,000…
A: Formulas: Calculations: Therefore, the Project B should be selected as it has lower discount…
Q: Cummings Products Company is considering two mutually exclusive investments whose expected net cash…
A: Given, The net cash flows of Cummings Products Co. is as follows: Expected Net Cash Flows…
Q: Consider two investments with the following sequences of cash flows: (a) Compute the IRR for each…
A: Given information:
Q: Org Pvt. Ltd. is considering two mutually exclusive capital investments. The project’s expected net…
A: Determination of the Net Present Value of the project helps the organization to decide whether to…
Q: Hart Corp. is considering a project that has the following cash flow data. What is the project's…
A: The modified internal rate of return is another technique or method under capital budgeting…
Q: Org Pvt. Ltd. is considering two mutually exclusive capital investments. The project’s expected net…
A: IRR is the rate of return a project generates through its lifetime expressed in annual terms. It is…
Q: Consider two investments with the following sequences of cash nows:Net Cash flown Project A Project…
A: The computations as follows: Hence, the IRR of project A is 17% and project B is 13%. The internal…
Q: A firm evaluates all of its projects by applying the IRR rule. Year Cash Flow 162,000 -%24 54,000 1…
A: Internal Rate of Return (IRR) is that discounting rate at which Net Present Value of the project is…
Q: Consider the following investment projects.Year (n) Net Cash FlowProject 1 Project 20 -$1,200…
A: Internal Rate of return: Internal Rate of Return can be defined as a financial measure used to…
Q: Expected Cash Flows Year Project A Project B 0 -400 -575 1 95 150 2 110 200 3 118 250 4 125 275 5…
A: Net Present Value is used to find out the present worth of an investment or a project by considering…
Q: Q7 - Consider the following project: Year Cash Flow 0 – $ 3,024…
A: Given information: Year Cash Flow 0 -3,024 1 17,172 2 -36,420 3 34,200 4 -12,000
Q: E Click the icon to view the cash flows for the projects. More Info a) Compute the IRR for each…
A: Net present value (NPV) and internal rate of return (IRR) are the capital budgeting techniques used…
Q: Consider the two investments with the following sequences of cash flows. At Marr of 15%. What is the…
A: IRR refers to the annualized rate of return for a given project. Higher the IRR, better the…
Q: A firm is considering the following independent projects. The total amount of capital available for…
A: Net Present Value is the sumof the present value of cash inlows and outlows. A project which adds…
Q: Use the information in the table below for the following 5 a A capital investment project is…
A: Profitability Index =Sum of present value / Initial Investment
Q: Barry Inc. is considering a project that has the following cash flow and WACC data. What is the…
A: We will make use of the MIRR function of excel to get the desired MIRR
Q: Watts Co. is considering a project that has the following cash flow and WACC data. What is the…
A: GIVEN, WACC = 10% YEAR CASHFLOW 0 -725 1 375 2 400 3 425 4 450
Q: A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 1 3…
A: Year Project S Project L 0 -1000 -1000 1 871.53 0 2 260 260 3 10 400 4 10 766.36
Q: Viva's Junkshop is considering a project that has the following cash flow and WACC data. What is the…
A: Project NPV is calculated as difference of present value of cash inflows and initial cost
Q: Compute the NPV statistic for Project Y given the following cash flows if the appropriate cost of…
A: Cost of Capital is 10% To Find: NPV
Q: Consider the cash flows for the following investment projects: (a) For Project A. find the value of…
A: a. Projects A's investmenti(1+i)n(1+i)n-1 - Projects A's 1st year income = (X- Project A's 1st year…
Q: Org Pvt. Ltd. is considering two mutually exclusive capital investments. The project’s expected net…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: for the following cash flow, if i; = ib = 12% and MARR= 15%, 1. Determine i* by using MIRR? (final…
A: MARR = 15% i = 12% Cash Flows: Year Cash Flow 0 -450,000 1 -42,500 2 92,800 3 386,000…
Q: Donald's Inc. is evaluating a project that has the following annual free cash flows: Period Free…
A: Project IRR = Cash inflow / cash outflow
Q: Filter Corp. has a project available with the following cash flows: Year Cash Flow -$16,200 5,600…
A: Year Cash flow 0 -16200 1 5600 2 6900 3 6300 4 4700
Q: A project has the cash flows shown in the following table. If the cost of capital is 11%, what is…
A: NPV is the difference between present value of cash inflows and initial investment NPV =Present…
Q: Compute the NPV for Project X and accept or reject the project with the cash flows shown below if…
A: A method of capital budgeting that helps to evaluate the present worth of cash flow and a series of…
Q: 1. Consider the following investment projects: Year(n) Net cash flow Project 1 -$1,200 Project 2…
A: We need to find the incremental IRR (r) Initial incremental cashflow (I) = - $2000 - (- $1200) = -…
Q: You are analyzing two proposed capital investments with the following cash flows: Year Project X…
A: Formulas:
Q: Consider two investments with the fo llowing sequences of cash flows:Net Cush FlowII Project A…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 4…
A: An investment and a financial commitment are both parts of a capital budgeting decision. By…
Q: Consider the following cash flows of two mutually exclusive projects. Year Project A Cash Flow…
A: According to the rule, we will answer the first three subparts only, for the remaining subparts,…
Q: Cummings Products is considering two mutually exclusive investments whose expected net cash flows…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Barry Inc. is considering a project that has the following cash flow and WACC data. What is the…
A: Future value factor = 0.0975 (9.75%) Initial cash outflow = $53,600 n = Period i.e. 5 Years
Q: A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 1 2…
A: Internal Rate of Return The internal rate of return refers to the exact return that an investment…
Q: Consider the cash flows for the following investment projects. Assume that MARR=12%/year. C A в 0…
A: The Annual Worth (AW) method: The annual worth method gives the value of equivalent annual cash…
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 2 images
- Start 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%?Q7 - Consider the following project: Year Cash Flow 0 – $ 3,024 1 17,172 2 – 36,420 3 34,200 4 – 12,000 a) Determine the IRR (s) for this project. b) At which rates of return will the project be acceptable?Please give exact answer and excel steps Jeans LLC has a project with the following cash flows . Its required rate of return is 5 % , Year 012345 Cash Flow Project A -52,000.00 25,000.00 17,000.00 14,000.00 12,000.00 -3,000.00 What is the internal rate of retum ( IRR ) for this project ? options: a. 11.73859230479%b. 11.73962884992%c. 11.738592037872%d. 11.738591574995%e. 11.738592402818%f. 11.738672984783% Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
- Consider two investments with the following sequences of cash nows:Net Cash flown Project A Project B0 -$3,000 -$3,000I $1,500 $3002 $1.200 $6003 $600 $6004 $600 $1,2005 $300 $2, 100At MARR of 12%, which project would you select?A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $131 $131 $131 $131 $131 $131 $0 What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. a. Project A: $ b. Project B: $ 3 What is each project's IRR? Round your answer to two decimal places. c. Project A:% d. Project B: % What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations. e. Project A: % f. Project B: % g. From your answers to parts a-c, which project would be selected? h. If the WACC was 18%, which project would be selected? Construct NPV profiles for Projects A and B. Round your answers to the nearest cent.…Cummings Products is considering two mutually exclusive investments whose expected net cash flows are as follows: expected Net Cash Flows Year Project A Project B 0 ($400) ($650) 1 -528 210 2 -219 210 3 -150 210 4 1100 210 5 820 210 6 990 210 7 -325 210 a. Construct NPV profiles for Projects A and B. b. What is each project’s IRR? c. If each project’s cost of capital were 10%, which project, if either, should be selected? If the cost of capital were 17%, what would be the proper choice?d. What is each project’s MIRR at the cost of capital of 10%? At 17%? (Hint: Consider Period 7 as the end of Project B’s life.)e. What is the crossover rate, and what is its significance?
- A firm whose cost of capital is 10% is considering two mutuallyexclusive projects A and B, the cash flows of which are as below: YearProject AProject B7050.00080.000162,50096.170Suggest which project should be taken up using (i) net presentComparing Investment Criteria [L01,2,3,5,7] Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 -$300,000 -$40,000 1 20,000 19,000 2 50,000 12,000 3 50,000 18,000 4 390,000 10,500 Whichever project you choose, if any, you require a 15 per cent return on your investment. a. If you apply the payback criterion, which will you choose? Why? b. If you apply the discounted payback criterion, which investment will you choose? Why? c. If you apply the NPV criterion, which investment will you choose? Why? d. If you apply the IRR criterion, which investment will you choose? Why? e. If you apply the profitability index criterion, which investment will you choose? Why? f. Based on your answers in (a) through (e), which project will you finally choose? Why? Please explain your calculations and conclusionsBates & Reid, LLC, has identified two mutually exclusive projects, A and B. Project A has a NPV of $14,050.47. Project B has cash flows as described below. Year Cash Flow B 0 -$77,000 1 35,000 2 25,000 3 25,000 4 25,000 If the WACC is 8%, then B’s NPV is _______ and therefore the firm should accept _________ $11,337.55; project B because NPVA > NPVB. $15,062.43; project B because NPVA < NPVB. $15,062.43; project A because NPVA < NPVB. The projects are equally profitable. $11,337.55; project A because NPVA > NPVB.
- 4. The following information was extracted from the books of ABC Ltd that required to invest in any of the following investment projects that had the following cash flows: Year Project A (sh.) Project B (sh.)0 (300,000) (300,000)1 150,000 200,0002 220,000 280,0003 100,000 50,0004 50,000 350,000 Required:For each of the following projects calculate:i. Payback period ii. Net present value when required rate of return is 10% .A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Year 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $133 $133 $133 $133 $133 $133 $0 Open spreadsheet What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ fill in the blank 2 Project B: $ fill in the blank 3 What is each project's IRR? Round your answer to two decimal places. Project A: fill in the blank 4% Project B: fill in the blank 5% What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations. Project A: fill in the blank 6% Project B: fill in the blank 7%…Expected Cash FlowsYear Project A Project B0 -400 -5751 95 1502 110 2003 118 2504 125 2755 140 2306 150 180a. If you were told that each project’s cost of capital was 10%, which project should be selected using the NPV criteria?