Question

Question 1 0/10 A company has a 13% WACC and is considering two mutually exclusive investments that cannot be repeated) with the following cash flows: Tools 1 2 3 4 5 6 7 $850 Project Project B -$300 -$405 -S3B2 $131 $193 $131 -$100 $131 $600 $131 $600 $131 -$180 $0 $131 The data has been colected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. aps If 110110 ps Open spreadsheet a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations Project A $ Project B: $ . What is each project's R7 Round your answer to two decimal places Project A: 95 Project B: w c. What is each project's MIRR? (Hint: Consider Perod / as the end of Project B's We) Round your answer to two decimal places. Do not round your intermediate calculations Project A: Project 15 % d. From your answers to parts - which project would be selected?

Answer 1

EXCEL FORMULA:

Note: As per HOMEWORKLIB RULES, only first four sub part questions can be answered.