Can someone help me with this. Would you tell me which formulas should I put in which cells? Thank you

Calculating NPV - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste -AA AlignmentNumber Conditional Format as Cell Cells Editing FormattingTable Styles- Clipboard r Font Styles Al A firm is evaluating the following project. What is the NPV at each required return? 4 11% 25% Required Return Required Return Annual cash flows Year 0 Year 1 Year 2 Year 3 $(28,000) 12,000 15,000 11,000 10 12 13 14 15 16 17 18 19 Complete the following analysis. Do not hard code values in your calculations. NPV at 11% NPV at 25% 21 Calculating IRR - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste B 1 u. . Alignment Number Conditional Format as ell Cells Editing Clipboard A1 Formatting Table Styles Styles Font A firm is evaluating the following project. What is the IRR of the project? Year 0 Year 1 Year 2 Year 3 $ (28,000) $ 12,000 $ 15,000 $ 11,000 10 Complete the following analysis. Do not hard code values in your calculations. 12 13 IRR 15 16 17 Calibri 11AA B l u . Conditional Format as Cell Formatting TableStyles - Paste Clipboard A1 '. A. Alignment Number N Cells Editing Font Styles Consider the following two mutually exclusive projects. Whichever project you choose, if any, you require a return of 15 percent on your investment 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 Required return 15% 12 13 14 15 16 17 18 19 20 21 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