Question: You work for the 3T company, which expects to earn at least 12 percent on its investments. You have to choose between two similar projects.

You work for the 3T company, which expects to

You work for the 3T company, which expects to earn at least 12 percent on its investments. You have to choose between two similar projects. Below is the cash flow information for each project. 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 Year Inflow Outflow YO 0 221,000 Y1 5,000 190,000 Y2 150,000 0 Y3 220,000 30,000 Y4 203,000 0 Y5 205,000 34,000 Y6 197,000 0 Y7 100,000 30,000 Total 1,080,000 505,000 Netflow (221,000) (185,000) 150,000 190,000 203,000 171,000 197,000 70,000 575,000 Alpha Year Inflow YO 0 Y1 4,000 Y2 150,000 Y3 220,000 Y4 179,000 Y5 205,000 Y6 197,000 Y7 100,000 Total 1,055,000 Outflow Netflow 213,000 (213,000) 170,000 (166,000) 0 150,000 30,000 190,000 0 179,000 42,000 163,000 0 197,000 30,000 70,000 485,000 570,000 The NPV for Omega is The NPV for Alpha is The better project is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!