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,
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
Get step-by-step solutions from verified subject matter experts
