There is a capital constraint of £10,000 in the initial period. The two scalable projects available for investment are projects B and C from Example 10.2. The cash flows, NPVS at 10 percent, and profitability indexes are given below. Which is the better project? Cash Flow (in £000s) at Date Net Present Values Profitability Index 1 2 (in £000s) -1 -5 22 -12.1 9 10 Project B Project C 44 -24.2 15 4
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: An investor is presented with alternative projects, A and B with the following end-of-year cash…
A: Frist we need to calculate the Net present value(NPV) of each project. NPV is the difference between…
Q: Compute the NPV statistic for Project Y given the following cash flows if the appropriate cost of…
A: Net present value: Net present value is the difference between the present value of cash inflow and…
Q: Based on the cash flow predictions of the given project below, what is the project's profitability…
A: The profitability index(PI) is one of the techniques of capital budgeting. It is known as the…
Q: Investment Criteria. Consider the following information. (20 points)…
A: the discounted payback period is 2.532 years. since the initial investment is recovered during the…
Q: A project requires an initial investment of $225,000 and is expected to generate the following net…
A: NPV or net present value is an important capital budgeting tool. It is used to determine if a…
Q: The firm XYZ is considering two investment projects: project L and project S. Both projects take…
A: Cross over rate is the IRR at which both the projects would have same NPV.
Q: Retsa Company is considering an investment in technology to improve its operations. The investment…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: You have been asked by MPAC Ltd to analyse two projects, Xand Y. Each project costs £1,000,000, and…
A: We will analyze these projects by calculating Net Present Value of each of the projects. Calculation…
Q: A Project has a cost of $65,000 and it's expected cash inflows are $12,000 per year for 9 years and…
A: MIRR- Formula to be used: MIRR = Terminal Cash inflowsPV of cash outflows1n-1 Data given: Cash…
Q: You are financial analyst for the XYZ company. The director has asked you to analyze two proposed…
A: Cost of Capital = 12% Cash Flows: Year Cash Flow - A 0 -10,000.00 1 6,500.00 2 3,000.00 3…
Q: Find internal rate of return of a project with an initial cost of $43,000, expected net cash inflows…
A: Excel Spreadsheet:
Q: A given project requires an initial investment of 29800 in order to collect the following cash…
A: The first question is answered for you. Please resubmit specifying the question number you want…
Q: A project requires an initial investment of $40 million. It generates cash flows of $25 million in…
A: Calculation of Profitability Index:The profitability index is 1.16.Excel Spreadsheet:
Q: The total investment required for two projects are estimated at OMR100, 000. The cash flows expected…
A: Using excel for calculations
Q: D'Arcy (Builders) Ltd is considering three possible investment projects: A, B and C. The expected…
A: NPV or net present value is discounting the cash inflows to see the present value of the cash…
Q: Estimated cash inflows for project A are as follows , respectively ; $ 10.000 , 7.000…
A: Profitability index method does not consider lives of the project. Profitability index method…
Q: A 17-year project has a cost of $900,000 and has annual cash flows of $140,000 in years 1-8, and…
A: NPV is the sum of present value of future cashflows less initial investment
Q: The net cash flow per year for the investment projects A and B, is presented in the table below.…
A: NPV is the Net Present value of the project and is the sum of the present value of all cash inflows…
Q: The net cash flows of two alternative projects that require an investment of 120,000 TL are as…
A: The capital budgeting is a technique that helps to analyze the profitability of the project and…
Q: A two-year project has an initial investment of $38,643,310 and involves both a cash inflow and…
A: The net present value is used to measure the profitability of a project. It does so by adding up the…
Q: A firm evaluates all of its projects by applying the IRR rule. A project under consideration has the…
A: Year Cash flow 0 -25000 1 11000 2 17000 3 10000
Q: Consider the following cash flows for two mutually exclusive capital investment projects. The…
A: PROJECT B Year Cash flows 0 -20000 1 6000 2 6000 3 6000 4 5400 5 5400 6 5400
Q: Hello Mitty Ltd is considering a project MEA as shown below. The estimated cash flows for this…
A: NPV stands for Net Present Value, and it represents the positive and negative future cash flows…
Q: Jill Harrington, a manager at Jennings Company, is considering several potential capital investment…
A: Pay Back Period - It refers to the amount of time taken for recover of the cost of an investment. It…
Q: Find internal rate of return of a project with an initial cost of $43,000, expected net cash inflows…
A: We can find the internal rate of return for a stream of constant cash flows using RATE function of…
Q: A firm whose cost of capital is 10% is considering two mutually exclusive projects A and B, the cash…
A: Net present value refers to the capital budgeting technique that is used by the management to…
Q: An investment has an initial cost of $3.2 million. This investment will be depreciated by $900,000 a…
A: The average accounting return or average rate of return is an accounting metric which helps in…
Q: The expected cash flows of a project are as follows. Year Cash Flow -100000, 20,000 ,30,000 40,000…
A: Note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…
Q: firm is considering two projects and the cash flows associated with them are shown in the following…
A: Pay back period is the number of years required to recover the initial investment and it must be…
Q: Howell Petroleum, Ic., is trying to evaluate a generation project with the following cash flows:…
A: NPV can be calculated by following function in excel =NPV(rate,value1,[value2],…) + Initial…
Q: You have been asked by MPAC Ltd to analyse two projects, X and Y. Each project costs £1,000,000, and…
A: Because you have asked question with multiple parts (MULTI PART) , we will solve the first 3 parts…
Q: Find internal rate of return of a project with an initial cost of $43,000, expected net cash inflows…
A: Capital budgeting approaches are the techniques that the management of the company adopts to…
Q: A project requires a $3 million investment in net working capital (NWC) today, and will be fully…
A: As per the given information: Investment in net working capital (NWC) - $3 million Recovered fully…
Q: An investment project has the following characteristics: Cost, P22,820; Annual cash inflows, P5,000;…
A: The time period or the number of years (NPER) refers to the time it would require for the investment…
Q: A project which requires an investment of OMR 25,000, duration of the project is 2 years, average…
A: NPV iathw difference between the present value of cash inflows and the present value of cash…
Q: A project which requires an investment of OMR 18,000, duration of the project is 2 years, average…
A: Sensitvity of Net Present Value (NPV) is calculated on the changes in the initial investment of the…
Q: Phoenix Company is considering investments in projects C1 and C2. Both require an initial investment…
A: As per the given information: Initial investment - $330,000 Rate of return - 8%Net cash flowsProject…
Q: (a)Determine the net present value of the project.(b) An investment project requires a net…
A: Net Present Value (NPV) is a capital budgeting technique that helps in evaluating various capital…
Q: Use the following information to answer questions 11-15: A firm evaluates a project with the…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: Referring to the table below, calculate the Net Present Value (NPV) and Profitability Index (PI).…
A: Net present value is the sum of all the discounted cash flows during the tenure of the investment.…
Q: 21
A: Profitability index is the ratio between the initial investment made and the present value of future…
Q: A project has estimated annual cash flows of $95,000 for four years and is estimated to cost…
A: Net present value = Present value of cash inflows - Initial investment To calculate present value,…
Q: The total investment required for a project is estimated at OMR100, 000. The cash flows expected…
A: The payback period is the amount of time required for cash inflows generated by a project to…
Q: The total investment required for two projects are estimated at OMR90, 000. The cash flows expected…
A: Year Cash flow cumulative cash flow 1 25000 25000 2 38500 63500 3 42000 105500 4 48000…
Q: A project has an initial cost of $264,000 and is expected to generate a single cash inflow of…
A: Internal Rate of Return (IRR) is that discounting rate at which Net Present Value of the project is…
Q: XYZ is considering a project that would last for 3 years and have a cost of capital of 18.20…
A: Year 0 1 2 3 Revenue $ - $ 12,500.00 $ 10,400.00 $…
Step by step
Solved in 2 steps
- 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%?Consider the following projects: Cash Flows ($) Project D E CO00 C101 -11,700 23,400 -21,700 37,975 Assume that the projects are mutually exclusive and that the opportunity cost of capital is 12%. a. Calculate the profitability index for each project. b-1. Calculate the profitability-index using the incremental cash flows. b-2. Which project should you choose?Based on the cash flow predictions of the given project below, what is the project's profitability index? (required rate of return = 6%) Years Cash Flows -60,000 -12,000 55,000 26,000 Select one: a.-0,81 ь.0.41 C-0,11 d.0.99
- Comparing 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 conclusionsConsider the following two mutually exclusive projects:Year Cash Flow (X) Cash Flow (Y)0 -$365,000 -$38,0001 25,000 16,0002 65,000 12,0003 65,000 17,0004 425,000 15,000Whichever project you choose, if any, you require a 13 percent return on your investment. i. Which investment will you choose if you use the payback decision criteria? Justify your answer.ii. Which investment will you choose if you use the NPV decision criteria? Justify your answer.iii. Which project will you choose ultimately based on your answers above?Consider cash flows Year 0: -6900 Y1: 1700 Y2: 2900 Y3: 2900 Y4: 3500 What is the profitability index for this project if the return is 10%
- The cash flows associated with an investment project are as follows: Year Project Y 0 (40 000) 1 10000 2 10000 3 15000 4 20000 The required return is 5 percent. Reinvestment rate 6%. What’s the discount payback period of the projects? (compile a spreadsheet) Calculate NPV, PI, IRR , MIRR of a projects Should the firm accept the project?Consider the following projects: Cash Flows ($) Project C0 C1 C2 C3 C4 C5 A −2,200 2,200 0 0 0 0 B −4,400 2,200 2,200 5,200 2,200 2,200 C −5,500 2,200 2,200 0 2,200 2,200 If the opportunity cost of capital is 10%, which project(s) have a positive NPV? Calculate the payback period for each project. Which project(s) would a firm using the payback rule accept if the cutoff period is three years? Calculate the discounted payback period for each project. Which project(s) would a firm using the discounted payback rule accept if the cutoff period is three years?The cashflow of a project in Year 0, 1, 2, and 3 are -$200, $100, $100, $100. If opportunity cost of capital is 10%. Its profitability index is a. 0.20 b. 0.26 c. 0.24 d. 0.22
- Consider the following two mutually exclusive projects: YEAR CASH FLOW (A) CASH FLOW (B)0 -$300,000 -$39,0001 20,000 18,0002 70,000 12,0003 80,000 18,0004 400,000 19,000 Whichever project you choose, if any, you require a 15 percent return on your investment.i) If you apply the payback period (PBP) criterion, which investment will you choose? Why?ii) If you apply the net present value (NPV) criterion, which investment will you choose? Why?iii) If you apply the profitability index (PI) criterion, which investment will you choose? Why?iv) If you apply the internal rate of return (IRR) criterion, which investment will you choose?Why?v) Based on your answers in (i) through (iv), which project will you finally…Consider the investment project with net cash flows shown. There are 2 rates of return for the project. One is 43.47%. What is the other? Enter as a percentage without the percent sign. For instance, if your answer is 10.23%, enter as 10.23. n Net Cash Flow 0 -$8000 1 $10000 2 $30000 3 -$40000Assume a project has cash flows of -$54,300, $18,200, $37,300, and $14,300 for Years 0 to 3, respectively. What is the profitability index given a required return of 12.6 percent? 1.02 .95 .98 1.06 ☐ 1.00