Question

Mr. Cyrus Clops, the president of Giant Enterprises, has to make a choice between two possible...

  1. Mr. Cyrus Clops, the president of Giant Enterprises, has to make a choice between two possible investments:

Cash Flows ($ thousands)

Project

C0

C1

C2

IRR (%)

A

-400

+250

+300

23

B

-200

+140

+179

36

The opportunity cost of capital is 9%. Which project should Mr. Clops invest in?

(Use Excel & show functions)

Homework Answers

Answer #1

We should find the NPV of these projects

Screenshot with formulas

NPV of Project A = $81,862

NPV of Project B = $79,101

Mr. Clops should invest in Project A because it has a higher NPV as compared to that of Project B.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mr. Oriento of Zed Ltd. Has to make a choice between two mutually exclusive investments:                    ...
Mr. Oriento of Zed Ltd. Has to make a choice between two mutually exclusive investments:                     Cash flows (Shs. ‘000’) T0 T1 T2 IRR Alpha -400 250 300 23 Omega 200 140 179 36 The opportunity cost of capital is 9% per annum. Mr. Oriento wants to invest in Omega which has the higher IRR. Do you agree with Mr. Oriento’s choice?   Show appropriate computations. (5 marks
Mr. Oriento of Zed Ltd. Has to make a choice between two mutually exclusive investments:                    ...
Mr. Oriento of Zed Ltd. Has to make a choice between two mutually exclusive investments:                     Cash flows (Shs. ‘000’) T0 T1 T2 IRR Alpha -400 250 300 23 Omega 200 140 179 36 The opportunity cost of capital is 9% per annum. Mr. Oriento wants to invest in Omega which has the higher IRR. Do you agree with Mr. Oriento’s choice?   Show appropriate computations. (5 marks
2. A project has the following cash flows             C0                    C1    &n
2. A project has the following cash flows             C0                    C1                    C2                    C3                                       ($1000)             $300                $400                $600 What is the project’s payback period? Year 0 1 2 3 Cash Flow ($1000) $300 $400 $600 Cumulative ($1000) ($700) ($300) 300 a. Calculate the projects NPV at 10%. b. Calculate the project’s PI at 10%. c. Calculate an IRR for the project in question 2 How would you answer a,b, and c in excel? I am getting...
Problem Set 4 If you insulate your office for $10,000, you will save $1,000 a year...
Problem Set 4 If you insulate your office for $10,000, you will save $1,000 a year in heating expenses. These savings will last forever. What is the NPV of this investment when the cost of capital is 8%? 10%? What is the IRR? A project costs $5,000 at t = 0 and will generate annual cash flows of $750 for 10 years, starting at t = 1. The discount rate is 6%. What is the NPV? What is the IRR?...