Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show the work on excel Assume that you have been told by headquarters that you are not allowed to spend more than $20 million
please show the work on excel
- Assume that you have been told by headquarters that you are not allowed to spend more than $20 million dollars to invest. You have the following available projects. Which projects would you take? (15 points)
Project | Investment | NPV |
1 | $3,000,000.00 | $250,000.00 |
2 | $1,000,000.00 | $290,000.00 |
3 | $7,000,000.00 | $3,750,000.00 |
4 | $13,500,000.00 | $575,000.00 |
5 | $6,500,000.00 | $725,000.00 |
6 | $5,000,000.00 | $550,000.00 |
7 | $1,000,000.00 | $89,000.00 |
8 | $4,000,000.00 | $500,000.00 |
9 | $3,000,000.00 | $123,000.00 |
10 | $1,500,000.00 | $230,000.00 |
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