Consider the following two mutually exclusive projects. Whichever you choose, if any, you require a return of 15% on your investment.

please also include the excel formula

1. Calculate the NPV and IRR of each project. Comparing Investment Criteria - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 06 Calibri Alignment Number Conditional Format as Cell Cells Editing Formatting. Table" Styles Paste . Clipboard A1 Consider the following two mutually exclusive projects. Whichever project you choose, if any, you require a return of 15 percent on your investment. 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 15% 12 13 14 15 16 17 18 19 20 21 Required return 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 Sheet1