178 D F F H 12.00% 1 2 $193 3 $100 4 $800 5 SACO G SA60 7 $180 $300 $400 $133 $133 S133 S133 $133 30 Formulas $200.41 ENPVIB3,DJ6)+00 $146.82 -NPVIB3,D8J8) 08 18.10% SIRRICO:J6) 24.18% =HRIC8:38) 15.10% -MIRRIC6.20,B3,B3) D $300 1 -$367 2 $193 S $100 4 $800 5 SACO 6 SA60 7 -S160 Formulas ANA #N/A ANJA #N/A A 1 Capital budgeting criteria 2 3 WACC 4 5 6 Project A 7 8 Project B 9 TD 11 Protect MPV Cakulations: 12 NPVA 13 14 NPV 15 16 Project IRR Calculators 17 IRRA 18 19 IRR, 20 21 Prolet MIRR Calculations: 22 MIRR 23 24 Alematvely MRR, can be calculated as: 25 26 Project 27 28 PV of Year 1 Outlow 29 PV of Year 2 Outlicw 20 PV of Year 3 Outlow 31 PV of Year 7 Outlaw 32 33 34 35 36 Sum of Outlow PVS 3/ 36 N 39 PV 40 PMT 41 FV 42 VYR = MIRRA 13 44 MIRR. 45 46 Alematvely, MRR, can be calculated as 47 48 Project 40 50 51 52 53 54 55 56 57 58 Sum of Outflow PV's 59 60 N 61 PV 62 PMT 63 FV 64 VYR MIRRS 65 Formulas #NA WNA #N/A FV of Year 6 Intiow at Ycar 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 MINA WNA Sum of Innow FVS Formulas 7 S0.00 0 S0.00 #NIA 17.12% -MIRR[C8:28,B3,BS) 1 5 0 $400 - $133 2 $133 $123 S $133 $133 $133 G $133 7 $0 Fomulas #NA WNA #NA WNA #NA #NA FV of Year 6 Influwal Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflwal Year 7 FV of Year 3 Inflow at Year 7 FV of Year 2 Inow at Year 7 FV of Year 1 Intiow at Year 7 #N/A #NA Sum of Inflow FVS Formulas 7 $0.00 0 S0.00 WNA um of Infow FV Formulas 18.00% 15-18 Discount Rates NPV * A - [h 24 B NPV Profiles 1. 1.0 0.8 02 10.00 Calculation of Crossover Rate 106 Project JOB Proiecte $133 $133 $133 $133 $139 $133 80 110 Project Delle WNA 113 Crossover Rate = IRR. Proiect PR Calculations at WACC = 18% 116 MIRR 119 MIRR Sheet1 + 178 D F F H 12.00% 1 2 $193 3 $100 4 $800 5 SACO G SA60 7 $180 $300 $400 $133 $133 S133 S133 $133 30 Formulas $200.41 ENPVIB3,DJ6)+00 $146.82 -NPVIB3,D8J8) 08 18.10% SIRRICO:J6) 24.18% =HRIC8:38) 15.10% -MIRRIC6.20,B3,B3) D $300 1 -$367 2 $193 S $100 4 $800 5 SACO 6 SA60 7 -S160 Formulas ANA #N/A ANJA #N/A A 1 Capital budgeting criteria 2 3 WACC 4 5 6 Project A 7 8 Project B 9 TD 11 Protect MPV Cakulations: 12 NPVA 13 14 NPV 15 16 Project IRR Calculators 17 IRRA 18 19 IRR, 20 21 Prolet MIRR Calculations: 22 MIRR 23 24 Alematvely MRR, can be calculated as: 25 26 Project 27 28 PV of Year 1 Outlow 29 PV of Year 2 Outlicw 20 PV of Year 3 Outlow 31 PV of Year 7 Outlaw 32 33 34 35 36 Sum of Outlow PVS 3/ 36 N 39 PV 40 PMT 41 FV 42 VYR = MIRRA 13 44 MIRR. 45 46 Alematvely, MRR, can be calculated as 47 48 Project 40 50 51 52 53 54 55 56 57 58 Sum of Outflow PV's 59 60 N 61 PV 62 PMT 63 FV 64 VYR MIRRS 65 Formulas #NA WNA #N/A FV of Year 6 Intiow at Ycar 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 MINA WNA Sum of Innow FVS Formulas 7 S0.00 0 S0.00 #NIA 17.12% -MIRR[C8:28,B3,BS) 1 5 0 $400 - $133 2 $133 $123 S $133 $133 $133 G $133 7 $0 Fomulas #NA WNA #NA WNA #NA #NA FV of Year 6 Influwal Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflwal Year 7 FV of Year 3 Inflow at Year 7 FV of Year 2 Inow at Year 7 FV of Year 1 Intiow at Year 7 #N/A #NA Sum of Inflow FVS Formulas 7 $0.00 0 S0.00 WNA um of Infow FV Formulas 18.00% 15-18 Discount Rates NPV * A - [h 24 B NPV Profiles 1. 1.0 0.8 02 10.00 Calculation of Crossover Rate 106 Project JOB Proiecte $133 $133 $133 $133 $139 $133 80 110 Project Delle WNA 113 Crossover Rate = IRR. Proiect PR Calculations at WACC = 18% 116 MIRR 119 MIRR Sheet1 +