Please help me answer 6,7, & 8. Thanks so much!

B Year 6. Which is the right formula for B7? a) NPV(B6,B2:B5)/-B2 b) ENPV(B6,B3:B5-B2 c) (NPV(B6,B3:B5)+B2VB2+1 d) =NPV(B6,B3:B5/B2 e) EPI(B6,B2:B5) Cash Flows (60.000) 20.000 25.000 30.000 1296 WACC Profitability Index 7 7. What is the expected NPV in C5? 1 Scenario 2 Worst Case 3 Base Case 4 Best Case 5 Expected NPV Probabilities 0.2 0.6 02 NPV (52.125) 27,652 107.429 Year Cash Flow -5000 8. You wish to create a Data Table that calculates the NPV with various initial outlays in D1:E6. Which cell should be entered into the Data Table dialog box, and in which edit box? Hint: pg. 400 of textbook and ch.13 Worksheet has a sample 1000 2000 3000 4000 10% IO 2,547.98 -7000 -6000 -5000 -4000 -3000 7 WACC Data Table a) B7, Row input b) B7, Column input c) B2, Row input d) B2, Column input e) E1, Column input Row input cell: Column input cell: OK Cancel