Excel Online Structured Activity: Capital Budgeting criteris A company has a 12% WACC and considering twa mulually exclusive investment (inal cannot be repealea) with the following cash flows: D 1 2 3 4 5 6 7 Project A Project B - DC -$4DD - JB7 $132 - $19) $112 - $1DD $132 $6DD $132 $6DD $132 $BSD $132 - $1BD $D The dala nas been callected in the Micravail Excel Online lile below. Open the spreadsheel and perform the required analysis la answer the questions below. Open spreadsheel 4. What each project's NPV? Round your answer la the nearest cent. Da nalound your intermediale calculations. Praject A: $ Praject G: $ D. What each praject's [RR? Round your answer la lwa decimal places. Praject A: W Praject B: c. What each project's MIRR? (Hint: Canside, Pero 7 as the end al Paject B's life.) Raund you' answer la lwa decimal places. Do not und you intermediale calculations. Prajeci A: Prajeci B: 4. Figm your answers la pailsa-c, which project would be seleclea? Er lhe WACC was 18%, when project would be selected? e. Cansliucl NPV paliles lai Pajeck A and B. Round your answers la lhe nearest cent. Da nalound your intermediate calculations. Negalive value should be indicated by a minus sign. Dount Rale NPV Pigisch NPV Pigjet E $ DW $ 5 $ $ 1D $ $ 12 $ $ 15 $ $ 18.1 $ $ 23.86 $ $ 1. Calculate the ciawave, ale where the Lwa prajects' NPVs are equal. Round your answer la lwa decimal places. Do nalound your intermediale calculations. g. What each project's MERR ala WAC al 18W Round your answer la Lwa decimal places. Da nalund you intermediale calculations. Praject : Praject B: 4 Excel Online Structured Activity: Capital Budgeting criteris A company has a 12% WACC and considering twa mulually exclusive investment (inal cannot be repealea) with the following cash flows: D 1 2 3 4 5 6 7 Project A Project B - DC -$4DD - JB7 $132 - $19) $112 - $1DD $132 $6DD $132 $6DD $132 $BSD $132 - $1BD $D The dala nas been callected in the Micravail Excel Online lile below. Open the spreadsheel and perform the required analysis la answer the questions below. Open spreadsheel 4. What each project's NPV? Round your answer la the nearest cent. Da nalound your intermediale calculations. Praject A: $ Praject G: $ D. What each praject's [RR? Round your answer la lwa decimal places. Praject A: W Praject B: c. What each project's MIRR? (Hint: Canside, Pero 7 as the end al Paject B's life.) Raund you' answer la lwa decimal places. Do not und you intermediale calculations. Prajeci A: Prajeci B: 4. Figm your answers la pailsa-c, which project would be seleclea? Er lhe WACC was 18%, when project would be selected? e. Cansliucl NPV paliles lai Pajeck A and B. Round your answers la lhe nearest cent. Da nalound your intermediate calculations. Negalive value should be indicated by a minus sign. Dount Rale NPV Pigisch NPV Pigjet E $ DW $ 5 $ $ 1D $ $ 12 $ $ 15 $ $ 18.1 $ $ 23.86 $ $ 1. Calculate the ciawave, ale where the Lwa prajects' NPVs are equal. Round your answer la lwa decimal places. Do nalound your intermediale calculations. g. What each project's MERR ala WAC al 18W Round your answer la Lwa decimal places. Da nalund you intermediale calculations. Praject : Praject B: 4
