D Sign In A 3 Calculating NPV-Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 A A % Paste B IU- A Alignment Number Conditional Format as Formatting Table Styles Cell Cells Editing Clipboard Font 1 Styles 1 x fx C D F G H A 3 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 on a three-year MACRS schedule. The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The project requires an initial investment in net working capital of $300,000, and the fixed asset will have a market value of $210,000 at the end of the project. What is the project's Year 0 net cash flow? Year 1? Year 2? Year 3? The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? 456789 Asset investment Estimated annual sales $ $ Costs Net working capital 10 Pretax salvage value SSSSS 2,900,000 2,190,000 $ 815,000 $ 300,000 $ 210,000 11 Tax rate 21% 12 Project and asset life 13 Required return 12% 14 MACRS percentages 15 Year 1 0.3333 16 Year 2 0.4445 17 Year 3 0.1481 18 10