Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
EX2-4 (Algo) You work for the 3T company, which... You work for the 3T company, which expects to earn at least 14 percent on its
EX2-4 (Algo) You work for the 3T company, which... You work for the 3T company, which expects to earn at least 14 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? Outflow 210,000 140,000 Omega Year Inflow YO 0 Yi 0 Y2 150,000 Y3 220,000 44 170,000 Y5 205,000 Y6 197,000 YZ 100,000 Total 1,042,000 30,000 0 45,000 0 30,000 455,000 Netflow (210,000) (140,000) 150,000 190,000 170,000 160,000 197,000 70,000 587,000 Alpha Year Inflow YO 0 Y1 0 Y2 150,000 Y3 220,000 Y4 200,000 Y5205,000 Y6 197,000 Y? 100,000 Total 1,072,000 Outflow Netflow 220,000 (220,000) 190.000 190,000) 0 150,000 30,000 190,000 0 200,000 35,000 170,000 0 197.000 30,000 70,000 505,000 567,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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started