PLEASE SHOW HOW TO SOLVE USING EXCEL, PLEASE INCLUDE ALL FORMULAS USING FOR EXAMPLE: =PV(C42,C41.C40,0,0)

K29 - L M N 1 1 1 1 1 1 1 A B D E F G H K Eaton Medical Devices 2 Optimal Capital Budget 3 Under Capital Rationing 1) Using Solver, determine which of the above 4 Project Cost NPV Include projects should be included in the budget if the 5 A $ 628,200 $ 72,658 firm's gol is to maximize sharehold wealth. 6 (10 pts) B $ 352,100 $ 36,418 7 C $ 1,245,600 $ 212, 150 1 Remember: Solver is an Excel Add In. You may 8 D $ 814,300 $ 70,925 1 need to go to Excel Options and turn it on. 9 E $ 124,500 $ 11,400 10 F $ 985,000 $ 56,842 11 G $ 2,356,400 $ 93,600 1 12 H $ 226,900 $ 65,350 1 13 | $ 1,650,000 $ 48,842 14 J $ 714,650 $ 39,815 15 Total 16 Constraint $ 5,000,000 is the maximum avalable to spend on projects 17 0 18 19 20 Solver Set up 21 22 23 24 25 26 27 28 29