U- Clipboard Tel Alignment Num Tellus CH Edi B11 C D E F G H K L M N P R S 1 U V w A 1 NPV profiles 2 2 3 WACC 9.00% 4 0 $39.00 1 S8.23 2 56.23 7 $6.23 8 R 36.23 9 58.23 $6.23 10 58.23 11 58.23 12 56.23 13 $6.23 14 S6.23 15 58.23 16 $6.23 17 $6.23 $6.23 18 56.23 19 $6.23 20 50.23 $6.23 S5.23 5 Dollars in Mins) 6 Plan A 7 8 Plan B 9 10 Project NPV Calculations: 11 NPVA $12.00 52.69 $2.59 $2.69 $2.59 S2.68 $2.69 $2.69 $2.09 52.69 52.69 $2.69 S269 $2.69 $2.69 52.69 $2.69 $2.69 $2.59 $2.69 52.69 Formulas NA #NA - NPV NA NA 3 14 Project IRR Caicuados: 15 IRRA 16 IRR -7 18 NPV Profiles: 19 Discount Rates 20 21 0% 22 5% 23 10% 24 25 20% 26 22% 27 25% 28 29 30 31 $1.00 $0.90 23 $0.90 34 $0.70 35 $0.00 36 $0.50 NPVA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NPV) $0.00 $0.00 $ 30.00 $0.00 $0.00 $0.00 $0.00 $0.00 NPV Profiles 28 39 50.00 $0.30+ 50.20 11 42 $0.10 43 $0.00 CNN 15% 201 25% 44 0 $39.00 1 80.23 2 $6.23 4 $6.23 5 $8.23 B $8.23 7 $6.23 8 $6.23 9 $6.23 10 $6.23 11 $6.23 12 $8.23 14 $8.23 15 $6.23 16 $6.23 17 $6.23 18 $6.23 19 $6.23 20 56.23 $6.23 $6.23 $12.00 $2.69 $2.89 $2.89 $2.89 $2.69 $269 $2.89 $2.89 $2.89 $2.69 $2.89 $2.69 $2.89 $2.69 $2.69 $2.89 $2.89 $2.69 $2.69 45 Calculation of Crossover Rate. 16 47 Plan A 18 49 Plan B 50 51 Project Delta 52 Formulas 53 54 55 Crossover Rate = IRR. 56 57 ANTA #NA #N/A #NA #NA #NA #NIA ANA #NA #NA #NA WNIA UNA #NA #NA #NA #NA #NA #NA #NA #NIA Formula NA U- Clipboard Tel Alignment Num Tellus CH Edi B11 C D E F G H K L M N P R S 1 U V w A 1 NPV profiles 2 2 3 WACC 9.00% 4 0 $39.00 1 S8.23 2 56.23 7 $6.23 8 R 36.23 9 58.23 $6.23 10 58.23 11 58.23 12 56.23 13 $6.23 14 S6.23 15 58.23 16 $6.23 17 $6.23 $6.23 18 56.23 19 $6.23 20 50.23 $6.23 S5.23 5 Dollars in Mins) 6 Plan A 7 8 Plan B 9 10 Project NPV Calculations: 11 NPVA $12.00 52.69 $2.59 $2.69 $2.59 S2.68 $2.69 $2.69 $2.09 52.69 52.69 $2.69 S269 $2.69 $2.69 52.69 $2.69 $2.69 $2.59 $2.69 52.69 Formulas NA #NA - NPV NA NA 3 14 Project IRR Caicuados: 15 IRRA 16 IRR -7 18 NPV Profiles: 19 Discount Rates 20 21 0% 22 5% 23 10% 24 25 20% 26 22% 27 25% 28 29 30 31 $1.00 $0.90 23 $0.90 34 $0.70 35 $0.00 36 $0.50 NPVA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NPV) $0.00 $0.00 $ 30.00 $0.00 $0.00 $0.00 $0.00 $0.00 NPV Profiles 28 39 50.00 $0.30+ 50.20 11 42 $0.10 43 $0.00 CNN 15% 201 25% 44 0 $39.00 1 80.23 2 $6.23 4 $6.23 5 $8.23 B $8.23 7 $6.23 8 $6.23 9 $6.23 10 $6.23 11 $6.23 12 $8.23 14 $8.23 15 $6.23 16 $6.23 17 $6.23 18 $6.23 19 $6.23 20 56.23 $6.23 $6.23 $12.00 $2.69 $2.89 $2.89 $2.89 $2.69 $269 $2.89 $2.89 $2.89 $2.69 $2.89 $2.69 $2.89 $2.69 $2.69 $2.89 $2.89 $2.69 $2.69 45 Calculation of Crossover Rate. 16 47 Plan A 18 49 Plan B 50 51 Project Delta 52 Formulas 53 54 55 Crossover Rate = IRR. 56 57 ANTA #NA #N/A #NA #NA #NA #NIA ANA #NA #NA #NA WNIA UNA #NA #NA #NA #NA #NA #NA #NA #NIA Formula NA