Question
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
Financial Management For Nurse Managers Merging The Heart With The Dollar Merging The Heart With The Dollar
Authors: J. Michael Leger, Janne Dunham-Taylor
4th Edition
1284127257, 978-1284127256
