File Home Insert Page Layout Formulas Data Review View Help Share Comments DT AutoSum Calibri 11 A = a Wrap Text General TIX 47 0 5 X Cut [Copy Format Painter Fill Paste A Insert Delete Format Ideas B I U + Merge & Center $ % OOO Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity L16 Row: 1 J K L M N O 0 R S U V W 0 3 4 5 6 7 8 9 200 A B C D E F G H 1 Problem 3 2 #3. (20 points) B 4. Please draw the NPV profile of A and B. 5 CFs are given below in teh table. Please use interest rate from 0% to 30% with 1% increment. 7 Your answer should contain a graph of the NPV Profile. 3 9 0 1 2 3 NPER 1 2 4 A -800 300 300 100 100 200 100 5 B -800 100 100 200 200 500 200 6 A-B 7 8 9 Rate NPV_A NPV_B $1.20 0 0% 1 1% $1.00 2. 2% 3 3% $0.80 4. 4% 5 5% $0.60 6 6% 7 7% $0.40 8 8% 9 9% $0.20 | Information P1 P2 P3 P4 200 200 2001 200 10 NPV @0% IRR 200 200 200