All answers must be entered as formula

1. Calculate the NPV and IRR of each project Comparing Investment Criteria - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste B 1 u . E 2 . Alignment Number Conditional Format as . Cell Cells Editing Formatting" Table" Styles Styles Clipboard r Font A1 Consider the following two mutually exclusive projects. Whichever project you choose, if any, you require a return of 15 percent on your investment a rf on yo 4 Annual cash flows Year 0 Year 1 Year 2 Year 3 Year 4 $ (350,000) $ $45,000 $ $65,000 $ $65,000 $ $ 440,000 $ (50,000) 24,000 22,000 19,500 14,600 10 12 13 14 15 16 17 18 19 20 Required return 15% Complete the following analysis. Do not hard code values in your calculations. What is the NPV of each project? NPV of Project A NPV of Project B Year 1 Year 2 Year 3 Year 4 $ 45,000 $ $ 65,000 $ $ 65,000 $ $ 440,000 $ 24,000 22,000 19,500 14,600 9 10 12 13 14 15 16 17 18 19 20 21 Required return 15% Complete the following analysis. Do not hard code values in your calculations What is the NPV of each project? NPV of Project A NPV of Project E 23 24 25 26 27 28 29 What is the IRR of each project? IRR of Project A IRR of Project B Sheet1