Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You work for the 3T company, which expects to eain at least 15 percent on its investments. You have to choose between two simil projects.
You work for the 3T company, which expects to eain at least 15 percent on its investments. You have to choose between two simil 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 projects? Omega Year Inflow Ye Y1 Y2 150,000 Y3 228,000 Y4 161, 688 Y5 285, 280 Y6 197,606 YZ 100, 60e Total 1,633, 606 Outflow 207,600 110, eee e 30,000 Netflow (287, 000) (110,000) 150,000 190,000 161, 600 157,600 197,600 78,888 608, 600 Alpha Year Inflow YO Y1 7,000 Y2 150,000 Y3 220,000 Y4 191, 200 Y5 205, 200 Y6 197,000 47 100, 200 Total 1,670,000 Outflow Netflow 217,000 (217,000) 190,000 (183, 000) o 150,000 30,000 190,000 191,000 38,000 167,200 197,000 30,000 70,000 505,000 565,000 48, 600 @ 30,000 425,000 The NPV for Omega is The NPV for Alpha is The better project is Omega
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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