There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,192 and is expected to generate the following cash flows: First Year Second Year Third Year Total Alpha Project $32,000 $22,000 $5,000 $59,000 Beta Project 7,000 23,000 29,047 59,047 A. Calculate the internal rate of return on both projects. Use the IRR spreadsheet function to calculate internal rate of return. Alpha Project % Beta Project % B. Make a recommendation on which one to accept.

There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,192 and is expected to generate the following cash flows: First Year Second Year Third Year Total Alpha Project $32,000 $22,000 $5,000 $59,000 Beta Project 7,000 23,000 29,047 59,047 A. Calculate the internal rate of return on both projects. Use the IRR spreadsheet function to calculate internal rate of return. Alpha Project % Beta Project % B. Make a recommendation on which one to accept.

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

The Whenworth Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) Cash Flow (II) -$84,000 33,900 44,000 50,000 -$42,000 12,600 31,500 25,500 1 a-1. If the required return is 17 percent, what is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 17 percent, what is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b-2. If the company applies the net present value decision rule, which project should it take? a-1. Project I Project II а-2. b-1. Project I Project II
Perform a financial analysis for a project using the format below. Assume the projected costs and benefits for this project are spread over four years as follows: estimated costs are $100,00 in year 1 and $25,000 each year 2, 4, and 4. (hint: just change the years in the template file from 0,1,2,3, and 4. This discount factors will automatically be recalculated). Estimated benefits are $0 in Year 1 and $80,000 each years 2,3, and 4. Use an 8% discount rate. Use the business case financials template provided on the companion web site to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, explain whether you would recommend investing in this project based on your financial analysis.
(Paybackperiod, NPV, PI, and IRR calculations) You are considering a project with an initial cash outlay of $80,000 and expected free cash flows of $26,000 at the end of each year for 6 years. The required rate of return for this project is 7 percent. a. What is the project's payback period? b. What is the project's NPV? c. What is the project's PI? d. What is the project's IRR?
A firm is evaluating a project with the following cash flows. At a required return of 11 percent, what is the project's NPV? What if the required return is 24 percent? Input area: Required Return Required Return Year 0 Year 1 Year 2 Year 3 Output area: es es es es NPV at 11% NPV at 24% Մ $ $ 11% 24% (Use cells A6 to B11 from the given information to complete this question. You must use the built Excel function to answer this question.) (41,000) 20,000 23,000 14,000
The Whenworth Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) Cash Flow (II) -$87,000 36,900 47,000 27,000 -$55,000 11,700 34,500 28,500 1 3 a-1. If the required return is 10 percent, what is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 10 percent, what is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b-2. If the company applies the net present value decision rule, which project should it take? a-1. Project I Project II а-2. b-1. Project I Project II b-2.
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.)
(Related to Checkpoint 11.4) (IRR calculation) Determine the internal rate of return on the following project: An initial outlay of $9,500 resulting in a cash inflow of $1,600 at the end of year 1, $4,700 at the end of year 2, and $7,800 at the end of year 3. This project's internal rate of return is %. (Round to two decimal places.)
The Mansford Co. Evaluates projects using payback. Suppose that a project requiring an outlay of $816 dollars is followed by the following inflows for the next four years: Year 1 312 Year 2 459 Year 3 78 Year 4 210 What is the payback for this project to two significant places?
When inputting an answer, round your answer to the nearest 2 decimal places. If you need to use a calculated number for further calculations, DO NOT round until after all calculations have been completed. For the final answer, Round to 2 decimal places. A firm has a WACC of 8.35% and is deciding between two mutually exclusive projects. Project A has an initial investment of $63.06. The additional cash flows for project A are: year 1 = $17.78, year 2 = $38.17, year 3 = $46.29. Project B has an initial investment of $72.12. The cash flows for project B are: year 1 = $52.25, year 2 = $37.11, year 3 = $33.12. Calculate the Following: Payback Period for Project A: Payback Period for Project B: NPV for Project A: NPV for Project B: If can't solve all pls skip it i dont need your answer then i wil definitely like for complete answer and skip if you can't.
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Please help me solve this problem using Excel.
A project with an initial cost of $29,900 is expected to provide cash flows of $9,750, $11,000, $14,100, and $8,600 over the next four years, respectively. If the required return is 8.4 percent, what is the project's profitability index? Multiple Choice .994 839
Consider the following projects, X and Y where the firm can only choose one. Project X costs $1500 and has cash flows of $678, $652, $347, $111, $54, $16 in each of the next 6 years. Project Y also costs $1500, and generates cash flows of $738, $693, $405 for the next 3 years, respectively. WACC=11%.Calculate the projects’ NPVs, IRRs, payback periods.

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