Calculate the NPV of each project. (Use the NPV function in Excel to solve this problem.)Which of the two projects would you fund if the decision is based only on financial information and you could only choose one of theprojects?OmegaAlphaYearInflowYO0Y10Outflow207,000110,000NetflowYearInflowOutflowNetflow(207,000)YO0217,000(217,000)(110,000)Y17,000190,000(183,000)Y2150,0000150,000Y2150,0000150,000Y3220,00030,000190,000Y3220,00030,000190,000Y4161,0000161,000Y4191,0000191,000Y5205,00048,000157,000Y5205,00038,000167,000Y6197,0000197,000Y6197,0000197,000Y7100,00030,00070,000Y7100,00030,00070,000Total 1,033,000425,000608,000Total1,070,000505,000565,000The NPV for Omega isThe NPV for Alpha isThe better project is

NPV Calculations and Project RecommendationNPV for Omega Project:We can't calculate the NPV for…

Answered: Calculate the NPV of each project. (Use…

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows

Section: Chapter Questions

Problem 23SP: Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site....

See similar textbooks

Similar questions

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.
A2. (PaybackandNPV)Threeprojectshavethecashflowsgivenhere.Thecostofcapitalis10%. a. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs c. Why are these two sets of rankings different? YEAR 0 1 2 3 4 5Project 1 −10 4 3 2 1 5 Project 2 −10 1 2 3 4 5 Project 3 −10 4 3 2 1 10
Use the information for the question(s) below. Project A - 10,000 Project B Time 0 - 10,000 Time 1 5,000 4,000 Time 2 4,000 3,000 Time 3 3,000 10,000 If WiseGuy Inc. uses IRR rule to choose projects, which of the projects (Project A or Project B) will rank highest? OA. Project A OB. Project B OC. Project A and Project B have the same ranking OD. Cannot calculate a payback period without a discount rate.
Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the present value tables provided in APPENDICES1. Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand).Use your answers to recommend the project that should be chosen. Motivateyour choice.
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%.
Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 14,420 16,480 21,630 4 14,420 12,360 13,390 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.) Click here to view the factor table. Compute the cash payback period for each project. (Round answers to 2 decimal places, e.g. 10.50.) Project Bono years Project Edge years Project Clayton years
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
Suppose that you could invest in the following projects but have only $24,480 to invest. Which projects would you choose? Project Cost NPV w $ 7,970 $ 3,000 x 10,990 7,530 y 8,500 4,280 z 6,750 3,890 You should invest in project(s)?
Suppose you would like to invest your money for your future. You have three choices of funding agencies namely, FA 1, FA 2, and FA 3. Based on the given data below, compute for the future interest of each funding agency. What would you choose? Explain your answer. (Kindly explain your answer and put a step-by-step formula. I can't understand excel)
Whispering Winds Company is considering a long-term investment project called ZIP. ZIP will require an investment of $130,000. It will have a useful life of four years and no salvage value. Annual cash inflows would increase by $81,000, and annual cash outflows would increase by $40,500. In addition, the company's required rate of return is 10% Click here to view the factor table (a) Calculate the net present value on this project. (If the answer is negative, use either a negative sign preceding the number eg-5,275 or parentheses es. (5,275), For calculation purposes, use 5 decimal places as displayed in the factor table provided, eg. 1.25124 and final answer to O decimal places, eg. 5,275) Net present value $ Identify whether the project should be accepted or rejected. The project should be (b) Q Search 458 PM
Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 3 14,420 16,480 21,630 4 14,420 12,360 13,390 5 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.)
A financial analyst is evaluating the following projects, which are mutually exclusive, meaning that only one of them can be chosen. Based on financial theory and the NPV criterion, which one of these projects should be chosen over the other three? Time A C D -26,000 -7,200 -14,500 -19,600 8,100 11,900 8,100 2,360 8.600 1,150 10,000 2,120 5,700 800 11,100 11,00O0 4,200 850 1,130 9,800 12,480 9,700 830 11,600 Discount 13.9% 13.9% 13.9% 13.9% Rate O Project A O Project B O Project C O Project D O12 345

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

SEE MORE TEXTBOOKS