For this question you need to attach a file in Excel with your calculations. What do we call the cost of capital at which the two projects have the same NPV? Find this cost of capital for projects X and Y below Project X: CFo= - $3,500; CF1 = $900; CF2 = $1,000; CF3 = $1,200; CF4 = $750; CF5 = $120. Project Y: CFo = -$3,000; CF1 = $700; CF2 = $900, CF3= $1,000; CF4 = $700.

For this question you need to attach a file in Excel with your calculations. What do we call the cost of capital at which the two projects have the same NPV? Find this cost of capital for projects X and Y below Project X: CFo= - $3,500; CF1 = $900; CF2 = $1,000; CF3 = $1,200; CF4 = $750; CF5 = $120. Project Y: CFo = -$3,000; CF1 = $700; CF2 = $900, CF3= $1,000; CF4 = $700.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 10P: Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year...

See similar textbooks

Similar questions

Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
You are considering the following two projects for investment: Project A Project B Year 0 ($10000) ($5000) Year 1 $3000 $3000 Year 2 $7000 $4000 Year 3 $9000 $5000 You must conduct an analysis using your knowledge of capital budgeting (NPV, IRR ect, ) and time value of money to decide which of the options is better. All analysis must be done in Excel. (This will require all calculations to be done using cell references and excel functions). Your analysis will require you to: A. Calculate thefollowing values for the investment proposals: i. The payback period assuming end-of-the-year cash flows. ii. The discounted payback period assuming a required rate of return of 10% and ending of-the-year cash flows. iii. The NPV of each project. iv. The PI of each…
NOTE: Provide a format and show your work (example: N = 6, PV = XXX, I = X%, etc.) 1. As the project manager at Jelz, Inc., you are considering a project that will cost $4,276 and produce cash flows of $1,050 in year 1, $1,250 in year 2, $1,250 in year 3, and $1,550 in year 4. Find the rate of return for the project and determine if you should take the project if your required rate of return is 7.15%. (This is a 2 part question, make sure you answer both parts. Numerical answers should be rounded to 2 decimal places.) 2. You are looking to buy a car. You can afford $550 in monthly payments for five years. In addition to the loan, you can make a $6,000 down payment. If interest rates are 7.25 percent APR, what price of car can you afford (loan plus down payment)? (Do not round intermediate calculations and round your final answer to 2 decimal places.)
You are a financial analyst for the Hittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects’ expected net cash flows are as follows: Expected Net Cash Flows Year Project X Project Y 0 −$10,000 −$10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 a. Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). b. Which project or projects should be accepted if they are independent? c. Which project should be accepted if they are mutually exclusive? d. How might a change in the cost of capital produce a conflict between the NPV and IRR rankings of these two projects? Would this conflict exist if r were 5%? (Hint: Plot the NPV profiles.) e. Why does the conflict exist?
Compare the following projects using the NPV method and the EAA method if the cost of capital is 17%. Year Project A Project B 0 ($400,000) ($400,000) 1 $175,000 $160,000 2 $225,000 $160,000 3 $300,000 $160,000 4 $200,000 $160,000 5 $160,000 6 $155,000 7 $155,000 8 $155,000 Use the information given in problem 8 to replicate Project A and compute the NPV of the new project that lasts for 8 years.
You are a financial analyst for the Vincenzo Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each project is 12%. The projects’ expected net cash flows are as follows: Expected Net Cash Flows Year Project X Project Y 0 ($10,000) ($10,000) 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), and modified internal rate of return (MIRR). Which project or projects should be accepted if they are…
You are asked to evaluate two projects X and Y. The cash flow for each is listed below. The firmAc€?cs cost of capital is 12%. Year X Y 0 (10,000) (10,000) 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 Calculate the NPV of each project? [rounded to the nearest tens] Which project would you select? c) Compute the IRR for project X. [up to two decimal places] Based on the IRR criterion, should project X be accepted? Compute the IRR for project Y. [up to two decimal places] Based on the IRR criterion, should project Y be accepted?
You are a financial analyst for the Hittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12% for both projects. The projects’ expected net cash flows are as follows: Expected Net cash flows Year Project X Project Y 0 -10000 -10000 1 6350 3600 2 2988 3700 3 3145 3500 4 945 3500 Calculate each project’s payback period, net present value (NPV), internal rate of return (IRR), and profitability index (PI)
Suppose x1, x2, and x3 are binary variables that are equal to 1 if the corresponding project (1, 2, or 3) is selected and 0 if the corresponding project is not selected. Also, suppose that y1, y2, and y3 are variables that indicate the amount of money invested in the projects (projects can only be invested in if they are selected). The maximum investment is $2000 for project 1, $4000 for project 2, and $6000 for project 3. Which of the following constraints is needed for this problem? x3 ≤ 6000y3 6000x3 ≤ y3 6000y3 ≤ x3 y3 ≤ 6000x3
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?
Please describe NPV, IRR and their relationship. How do you evaluate each for making an investment decision? That is, what is a favorable NPV and IRR for making an investment decision. If you were developing a capital budgeting process at your employer, how would you prioritize your projects? What is the NPV when IRR = WACC, IRR>WACC, and IRR<WACC? There is a duplex for sale in Absecon for $700,000 at this time. It has 2 units that generate a total of $25,000 in gross rent. The property taxes are $4,000, commercial property insurance is $2,000, flood insurance is $1,000, and annual maintenance is $2,000. You expect to sell it in one year at a price growth of 0%. What is the NPV with a WACC of 10%. Is the IRR greater or less than the WACC? Would you invest in this project and why?
Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5. 5.1.3 Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). 5.1.4 Use your answers from question 5.1.3 to recommend the project that should be chosen. Motivateyour choice. INFORMATION Zeda Enterprises has the option to invest in machinery in projects A and B but finance is only available to invest inone of them. You are given the following projected data:Project A Project BInitial cost R300 000 R300 000Scrap value R40 000 0Depreciation per year R52 000 R60 000Net profitYear 1 R20 000Year 2 R30 000Year 3 R50 000Year 4 R60 000Year 5 R10 000Net cash flowsYear 1 R90 000Year 2 R90 000Year 3 R90 000Year 4 R90 000Year 5 R90 000 Additional informationThe discount rate used by the company is 12%.