PLEASE ANSWER AS A FORMULA!!! PLEASE ANSWER AS A FORMULA!!!

HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 12 AA IU- EB- A Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles and Font Complete the following analysis. Do not hard code values in your calculatio DHE TFG H 1 $ 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 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 What is the IRR of each project? IRR of Project A IRR of Proiect B Sheet1 Lt