Home Developer Insert Draw Page Layout Formulas Data Review View Developer Acrobat Tell me Share Comments X Arial 10 - A SEE General v Conditional Formatting Format as Table Cell Styles 4 Paste Cells B Ideas I U A Editing $% Create and Share Adobe PDF F9 X fx A G H 1 J K 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. (10 pts) B D E F Eaton Medical Devices Optimal Capital Budget Under Capital Rationing Cost NPV Include $ 628,200 $ 72,658 1 $ 352,100 $ 36,418 1 $ 1,245,600 $ 212,150 1 $ 814,300 $ 70,925 1 $ 124,500 $ 11,400 0 $ 985,000 $ 56,842 1 $ 2,356,400 $ 93,600 0 $ 226,900 $ 65,350 1 $ 1,650,000 $ 48,842 0 $ 714,650 $ 39,815 1 $ 4,966,750 $ 554,158 S 5,000,000 is the maximum avalable to spend on projects 0 0 1 2 3 4 Project 5 A 6 B 7 8 D 9 E 10 F 11 G 12 H 131 14 J 15 Total 16 Constraint 17 Remember: Solver is an Excel Add In. You may need to go to Excel Options and turn it on