Excel Online structured Activity: NPV profilesA company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of$6.39 million per year for 20 years. Plan B requires a $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.91 millionper year for 20 years. The firm's WACC is 11%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answerthe questions below.Open spreadsheeta. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in millions. For example, an answer of$10,550,000 should be entered as 10.55.Plan A: $millionPlan B: $millionCalculate each project's IRR. Round your answer to two decimal places.Plan A:%Plan B:%b. By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent.c. Calculate the crossover rate where the two projects' NPVS are equal. Round your answer to two decimal places.CA

NPV refers to net present value. It is one of the important tools in the domain of capital budgeting…

a. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate $10,550,000 should be entered as 10.55. Plan A: $ million Plan B: $ million Calculate each project's IRR. Round your answer to two decimal places. Plan A: Plan B: % b. By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent. %

a. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate $10,550,000 should be entered as 10.55. Plan A: $ million Plan B: $ million Calculate each project's IRR. Round your answer to two decimal places. Plan A: Plan B: % b. By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent. %

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

(c) Compute the annual rate of return for each project. (Hint: Use average annual net income in your computation.) (Round answers to 2 decimal places, e.g. 10.50%.) Annual rate of return Project Bono % Project Edge % Project Clayton %
Consider projects A and B with the following cash flows: C0 C1 C2 C3 A − $ 27 + $ 16 + $ 16 + $ 16 B − 52 + 27 + 27 + 27 a-1. What is the NPV of each project if the discount rate is 10%? (Do not round intermediate calculations. Round your answers to 2 decimal places.) a-2. Which project has the higher NPV? b-1. What is the profitability index of each project? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b-2. Which project has the higher profitability index? c. Which project is most attractive to a firm that can raise an unlimited amount of funds to pay for its investment projects? d. Which project is most attractive to a firm that is limited in the funds it can raise?
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (1) Cash Flow (II) 0 123 -$ 73,000 33,000 33,000 3 33,000 -$ 17,100 9,250 9,250 9,250 a-1.If the required return is 11 percent, what is the profitability index for both projects? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Project I Project II - If the company applies the profitability index decision rule, which project should the 2. firm accept? O Project I O Project II b- What is the NPV for both projects? (A negative answer should be indicated by a 1. minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Project I Project II
Coore Manufacturing has the following two possible projects. The required return is 10 percent. Project Y -$ 27,900 13,900 Project Z -$ 59,000 17,500 12,300 30,000 14,700 10,300 Year 0 1 2 3 4 15,500 28,000 a. What is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 3- b. What is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 3. c. Which, if either, of the projects should the company accept? a. Project Y Project Z b. Project Y Project Z c. Accept project
A project has initial costs of $3,000 and subsequent cash inflows of $1350,275,875 and 1525 . The company's 10% cost of capital is an appropriate discount rate for this average risk project. Calculate the following: NPV IRR Profitability Index Please number/label each of your answers as shown above. Be sure to show your TVM function calculator inputs, and four decimal places.
Internal rate of return and modified internal rate of return For the project shown in the following table,, calculate the internal rate of return (IRR) and modified internal rate of return (MIRR). If the cost of capital is 12.13%, indicate whether the project is acceptable according to IRR and MIRR. The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Initial investment (CF) Year (t) 1 2 3 4 5 Print $70,000 Cash inflows (CFt) $15,000 $25,000 $25,000 $15,000 $10,000 Done X
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (1) Cash Flow (II) -$ -$ 0 55,000 1 25,000 2 25,000 3 25,000 a-1. If the required return is 10 percent, what is the profitability index for both projects? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Project I Project II 18,900 10,150 10,150 10,150 a- If the company applies the profitability index decision rule, which project should the 2. firm accept? Project I O Project II Project I Project II 1. b- What is the NPV for both projects? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
Information on four investment proposals is given below: Investment required. Present value of cash inflows Net present value Life of the project Answer is complete but not entirely correct. Profitability Index Investment Proposal ABCO A В Required: 1. Compute the profitability index for each investment proposal. (Round your answers to 2 decimal places.) 2. Rank the proposals in terms of preference. с D 3 0.41 0.38 0.50 0.33 Rank Preference A $ (240,000) 337,300 $ 97,300 Second Third First Fourth ✓ ✔ 5 years Investment Proposal $ (73,500) 110,250 $36,750 B $ (105,000) 144,900 $ 39,900 7 years 6 years $ (126,000). 168,000 $ 42,000 6 years
You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 4.7%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 Project A Year 1 - -$51 $27 B - $101 $22 Year 2 $21 $42 Year 3 $20 Year 4 $13 $51 $59 - ☑
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?
Consider two mutually exclusive projects, A and B, whose costs and cash flows are shown in the following table: Year Project A Project B 1 $(15,000) $(22,840) 2 9,000 8,000 3 8,000 8,000 4 2,500 8,000 5 3,000 8,000 Calculate the cross over rate. Please use equations not just excel
Coore Manufacturing has the following two possible projects. The required return is 12 percent. Year Project Y Project Z 0 -$27,500 -$55,000 1 13,500 19,500 234 2 11,900 26,000 3 14,300 17,500 9,900 24,000 a. 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.) b. What is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. Which, if either, of the projects should the company accept? a. Project Y Project Z 1.38 ง b. Project Y 3 decimal places required. Project Z c. Accept project x

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