Your company is considering two mutually exclusive, equally 'risky, and not repeatable projects, A and B....

 

Transcribed Image Text:

Your company is considering two mutually exclusive, equally 'risky, and not repeatable projects, A and B. Their cash flows are shown below. The CFO asked you to evaluate these two projects and is now waiting for your analysis and recommendation. You will set up your analysis in an Excel worksheet and address the following 4 questions. Year 01234567 Expected Net Cash Flows Project A ($375) ($300) ($200) ($100) $600 $600 $926 $1000 Project B ($575) $290 $290 $290 $290 $290 $290 $290 1. Calculate the NPV of both Project A and Project B when the discount rate (WACC) is 10% 2. Calculate the NPV of both Project A and Project B when the discount rate (WACC) is 18% 3. Calculate the IRR of both projects 4. Create a graph to show how NPV of each project changes when you use different discount rate (NPV profile) Your company is considering two mutually exclusive, equally 'risky, and not repeatable projects, A and B. Their cash flows are shown below. The CFO asked you to evaluate these two projects and is now waiting for your analysis and recommendation. You will set up your analysis in an Excel worksheet and address the following 4 questions. Year 01234567 Expected Net Cash Flows Project A ($375) ($300) ($200) ($100) $600 $600 $926 $1000 Project B ($575) $290 $290 $290 $290 $290 $290 $290 1. Calculate the NPV of both Project A and Project B when the discount rate (WACC) is 10% 2. Calculate the NPV of both Project A and Project B when the discount rate (WACC) is 18% 3. Calculate the IRR of both projects 4. Create a graph to show how NPV of each project changes when you use different discount rate (NPV profile)

Answer rating: 100% (QA)

To perform the analysis you can follow these steps in Excel 1 Calculate NPV at 10 discount rate WACC ... View the full answer