Year 6. Which is the right formula for B7? a) =NPV(B6,B2:B5)/-B2 b) =NPV(B6,B3:B5)/-B2 c) =(NPV(B6,B3:B5)+B2)/B2+1 d) ENPV(B6,B3:B5)/B2 e) =PI(B6,B2:B5) Cash Flows (60,000) 20,000 25,000 30.000 12% 6 WACC 7 Profitability Index 7. What is the expected NPV in C5? 1 Scenario 2 Worst Case 3 Base Case 4 Best Case Expected NPV Probabilities 0.2 0.6 0.2 NPV (52,125) 27,652 107,429 2,547.98 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 A B Year Cash Flow 0 -5000 1 1000 2 2000 3000 4000 7 WACC 10% D 10 -7000 -6000 -5000 -4000 -3000 53 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 I Cancel