You are the head of the project selection team at SIMSOX. Your team is considering three different projects. Based on past history, SIMSOX expects at least a rate of return of 23 percent. Given the following information for each project, which one should be SIMSOX's first priority? Should SIMSOX fund any of the other projects? (Use the NPV function in Excel to solve this problem. Negative amount should be indicated by a minus sign.) Project: Dust Devils Year Investment Revenue Stream 550, 000 1 35,000 275,000 375,000 2 Project: Ospry Year Investment Revenue Stream 300,e00 30,000 30,000 30,000 75,000 1 2 Project: Voyagers Year Investment Revenue Strean 85,000 25,000 25,00 60,000 55,000 145,000 2 4 The NPV for Dust Devils is The NPV for Ospry is The NPV for Voyagers is How many projects should be funded?

You are the head of the project selection team at SIMSOX. Your team is considering three different projects. Based on past history, SIMSOX expects at least a rate of return of 23 percent. Given the following information for each project, which one should be SIMSOX's first priority? Should SIMSOX fund any of the other projects? (Use the NPV function in Excel to solve this problem. Negative amount should be indicated by a minus sign.) Project: Dust Devils Year Investment Revenue Stream 550, 000 1 35,000 275,000 375,000 2 Project: Ospry Year Investment Revenue Stream 300,e00 30,000 30,000 30,000 75,000 1 2 Project: Voyagers Year Investment Revenue Strean 85,000 25,000 25,00 60,000 55,000 145,000 2 4 The NPV for Dust Devils is The NPV for Ospry is The NPV for Voyagers is How many projects should be funded?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You are the head of the project selection team at SIMSOX. Your team is considering three different projects. Based on past history, SIMSOX expects at least a rate of return of 20 percent. Given the following information for each project, which one should be SIMSOX's first priority? Should SIMSOX fund any of the other projects? (Use the NPV function in Excel to solve this problem. Negative amount should be indicated by a minus sign.) Project: Dust Devils Year Investment 460,000 0 1 2 3 Project: Ospry Year Investment 410,000 0 TEZLO 1 2 4 Project: Voyagers Revenue Stream 0 Year Investment 0 107,000 1244TO 3 5 40,000 330,000 430,000 Revenue Stream 0 78,000 78,000 78,000 99,000 Revenue Stream 0 47,000 25,000 82,000 66,000 134,000 The NPV for Dust Devils is The NPV for Ospry is The NPV for Voyagers is How many projects should be funded?
You have been assigned to perform a project selection based on profitability index. You have collected data on the three project alternatives A1, A2, and A3 and your team has calculated the following (table) present worth equivalent for the benefits, costs, and investments at a social discount rate of 10%. The service life of each alternative is identical. (a) Find the PI(i) for each project alternative (b) Find the best alternative based on incremental PI(i) analysis (c) Why is the profitability index referred to as a measure of capital efficiency?
Hi there, I am working on this problem. Can you please show me each step in solving this question without using excel? I am trying to figure out how to calculate the payback period for each project and also how do I calculate the IRR for each project? Riley Ltd. has the following 5 investment projects to choose from, the company needs to select one project.
You are a project manager for your company and you are faced with five potential projects that you can invest in. Free cash flow projections and additional relevant data are given for each project in the table below. Assume that there are no cash flows after year 3. Assume that you can only take each project once and that you can only choose one project. Which project would you invest in? Select the best answer. Project Project A Project B Project C Project D Project E O I. Project A II. Project B III. Project C IV. Project D O V. Project E FCF Forecasts by Year (in $1,000) 0 2 1 500 (400) (400) (300) (250) (300) 75 60 75 135 115 175 3 650 210 190 200 Interest Rate (EAR) 8.0% 10.0% 10.0% 12.0% 12.0% IRR 25.00% 17.57% 15.92% 17.81% 19.96%
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%.
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 the projects? Omega Alpha Year Inflow YO 0 Y1 0 Outflow 207,000 110,000 Netflow Year Inflow Outflow Netflow (207,000) YO 0 217,000 (217,000) (110,000) Y1 7,000 190,000 (183,000) Y2 150,000 0 150,000 Y2 150,000 0 150,000 Y3 220,000 30,000 190,000 Y3 220,000 30,000 190,000 Y4 161,000 0 161,000 Y4 191,000 0 191,000 Y5 205,000 48,000 157,000 Y5 205,000 38,000 167,000 Y6 197,000 0 197,000 Y6 197,000 0 197,000 Y7 100,000 30,000 70,000 Y7 100,000 30,000 70,000 Total 1,033,000 425,000 608,000 Total 1,070,000 505,000 565,000 The NPV for Omega is The NPV for Alpha is The better project is
You are the head of the project selection team at Broken Arrow Records. Your team is considering two different recording projects. Based on past history, Broken Arrow expects at least a rate of return of 20 percent. Given the following information for each project, calculate the NPV for both projects using the NPV formula in Microsoft 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
You are evaluating five investment projects. You already calculated the rate of return for each alternative investment and incremental rate of return between the two alternatives as well. In calculating the incremental rate of return, a lower cost investment project is subtracted from the higher cost investment project. All rate of return figures are rounded to the nearest integers. Investment Alternative Initial Investment ($) Rate of Return (%) Rate of Return on Incremental Investment (%) A CDE A B C D E b.Select E. c. Select B. 35,000 45,000 d. Do nothing. 50,000 65,000 80,000 12 15 13 20 18 B 28 20 36 27 12 40 22 If all investment alternatives are mutually exclusive and the MARR is 12%, which alternative should be chosen? a. Select D. 42 25 -5
A large company has the opportunity to select one of seven projects: A, B, C, D, E, F, G, or the null (Do Nothing) alternative. Each project requires a single initial investment as shown in the table below. Information on each alternative was fed into a computer program that calculated the IRR for each project as well as all the pertinent incremental IRR(s) as shown in the table below. For example, the IRR for Project A is 10% and the incremental IRR of Project C minus Project B (C-B) is 0.1%. For each value of MARR below indicate which project is preferred and the evaluations you made to arrive at this conclusion. Solve, a. MARR = 12%. b. MARR = 9.5%. c. MARR = 8%. d. MARR = 3.5%. e. MARR = 1.5%.
Use the NPV method to determine whether Kyler Products should invest in the following projects: • Project A costs $275,000 and offers seven annual net cash inflows of $58,000. Kyler Products requires an annual return of 12% on projects like A. • Project B costs $390,000 and offers ten annual net cash inflows of $70,000. Kyler Products demands an annual return of 14% on investments of this nature. (Click the icon to view the present value annuity table.) (Click the icon to view the present value table.) F (Click the icon to view the future value table.) (Click the icon to view the future value annuity table.) Requirement What is the NPV of each project? What is the maximum acceptable price to pay for each project? C Calculate the NPV of each project. (Round your answers to the nearest whole dollar. Use parentheses or a minus sign for negative net present values.) The NPV of Project A is
. Suppose that your organization wants to decide which one of the given two projects can be selected for the development, as summarized in the following table. Calculate the Expected Monetary Value (EMV) for each project and suggest which project can be selected? Probability of occurrence of risk/opportunity (Impact) Estimated Profits/Losses Project 1 40% $140000 60% -$60000 Project 2 80% $40000 20% -$8000

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS