All answers must be entererd as formulas

CHAPTER 8 Saved Help Save & Exit Submit A1 A D G H I J Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? 4 2,900,000 2,190,000 815,000 21% Asset investment 6 $ 7 Estimated annual sales $ Costs 8 x rate Project and asset life Required return 9 10 12% 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations. 15 Help Save & Exit Subr Saved CHAPTER 8 for Al J G I F B A 21% Tax rate 9 Project and asset life 10 12% Required return 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 15 Sales 16 Costs 17 Depreciation T 18 19 Taxes 20 Net income 21 22 OCF 23 24 NPV 25 26