Eaton Medical Devices Optimal Capital Budget Under Capital Rationing 1) Using Solver, determine which of the above projects should be included in the budget if the firm's gol is to maximize sharehold wealth NPV 628,200 $72,658 352,100 $ 36,418 1,245,600 $ 212,150 814,300 $70,925 124,500 $11,400 985,000 $ 56,842 2,356,400 $93,600 226,900 S 65,350 1,650,000 $48,842 714,650 $ 39,815 ProjectCost Include 0 (10 pts) Remember: Solver is an Excel Add In. You may need to go to Excel Options and turn it on Total Constraint $ 5,000,000 is the maximum avalable to spend on projects Solver Set up Eaton Medical Devices Optimal Capital Budget Under Capital Rationing 1) Using Solver, determine which of the above projects should be included in the budget if the firm's gol is to maximize sharehold wealth NPV 628,200 $72,658 352,100 $ 36,418 1,245,600 $ 212,150 814,300 $70,925 124,500 $11,400 985,000 $ 56,842 2,356,400 $93,600 226,900 S 65,350 1,650,000 $48,842 714,650 $ 39,815 ProjectCost Include 0 (10 pts) Remember: Solver is an Excel Add In. You may need to go to Excel Options and turn it on Total Constraint $ 5,000,000 is the maximum avalable to spend on projects Solver Set up