A B C D E F G H J K L M N 1 NPV profiles 0 P 234567891 WACC 9.00% (Dollars in Millions) Plan A 0 1 2 3 4 -$41.00 $6.55 $6.55 $6.55 $6.55 5 $6.55 6 7 $6.55 $6.55 8 $6.55 9 $6.55 10 $6.55 11 12 13 $6.55 $6.55 $6.55 $6 Plan B -$13.00 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2.91 $2 10 Project NPV Calculations: Formulas 11 NPVA #N/A 12 NPVB #N/A 13 14 Project IRR Calculations: 15 IRRA #N/A 16 IRRB #N/A 17 18 NPV Profiles: 19 Discount Rates NPVA NPVB 20 $0.00 $0.00 21 0% $0.00 $0.00 22 5% $0.00 $0.00 23 10% $0.00 $0.00 24 15% $0.00 $0.00 25 20% $0.00 $0.00 26 22% $0.00 $0.00 27 25% $0.00 $0.00 28 29 NPV Profiles 30 $1.00 31 32 $0.90 33 $0.80 34 $0.70 35 $0.60 36 $0.50 37 $0.40 38 39 $0.30 Sheet1 + Workbook Statistics Give Feedback to Microsoft 100%