Question: please help show steps and formula on excel for understanding. Thank you for your helps! 5. A company has identified a number of promising projects,

please help show steps and formula on excel for understanding. Thank you for your helps! please help show steps and formula on excel for understanding. Thank you

5. A company has identified a number of promising projects, as in the table below. The cash flows for the first 2 years are shown (they are all negative). The cash flows in later years are positive, and the net present value of each project is shown. The company managers have decided that they can allocate up to $250,000 in each of the first two years to fund these projects. If less than $250,000 is used the first year, the balance can be invested at 5% and used to augment the next year's budget. Which projects should be founded? Project 1 2 3 4 5 6 7 Cash flow ($1000) 1 2 -90 -58 -80 -80 -50 -100 -20 -64 -40 -50 -80 -20 -80 -100 NPV 150 200 100 100 120 150 240

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 Finance Questions!