Mutually exclusive project-calculate npv for each project

Assignment Help Financial Management

Reference no: EM132018935

Consider the following two mutually exclusive projects: A and B. Both projects require an annual rate of return of 15%. The cash flows for the two projects are as below:

Year Project A Project B

0 -600,000 -1,800,000

1 270,000 1,000,000

2 350,000 700,000

3 300,000 900,000

Calculate the IRR (using the Excel function, “=IRR”) for each project. Based on the IRR, which one should be your choice?

Calculate the NPV for each project, using your calculator (please also use the Excel function to double check your result). Based on the NPV rule, which one should you recommend?

Is there a conflict between the two rules? If yes, which project should be taken?

2. Tom is considering three different investment plans--A, B, and C--that his broker has offered to him. Each plan requires the same amount of investment but provides different cash flows as follows:

End of Year A B C

1 $200 0 $500

2 200 0 0

3 200 0 0

4 200 200 500

5 0 200 0

6 0 200 0

7 0 200 0

8 0 200 500

Because Tom only has enough savings for one investment, his broker has proposed the third alternative to be, according to his expertise, “the best in town.” However, Tom questions his broker’s recommendation and asks you for help. The required rate of return for the three investments is the same: 10%. What is Tom’s best alternative? Why? [Hints: Compare the PV of the future cash flows.]

Reference no: EM132018935

Questions Cloud

Consumption associated with defaulting and repaying : Write down expressions for the levels of consumption associated with defaulting and repaying, respectively.

What price do you need to pay if you were to buy bond today : It has been 75 days since the last coupon was paid. What price do you need to pay if you were to buy this bond today?

About real rate of interest that customer is being charged : A customer is considering taking out a loan to purchase a piece of furniture. What does this imply about real rate of interest that customer is being charged.

Transaction deposits on its balance sheet : BSW Bank currently has $900 million in transaction deposits on its balance sheet.

Mutually exclusive project-calculate npv for each project : Consider the following two mutually exclusive projects: Calculate the NPV for each project,

Incremental net present value of replacing current machine : Assuming a discount rate of 7%, what is the incremental net present value of replacing the current machine?

Maximize annual returns through equity investments : Consider a portfolio manger whose mission is "to maximize annual returns through equity investments in the single-family homebuilding industry."

Calculation for cost of debt : What number should the CFO put in his WACC calculation for the cost of Debt, assuming ABC pays taxes using a 21% income tax rate?

What is net present value of buying part instead of making : what is the net present value of buying the part instead of making it?

User Account

All Pages