(Solved): Please use excel functions... not sure exactly what to do. Thanks! Esfandairi Enterprises is conside ...

Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of \( \$ 2.18 \) million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate \( \$ 1.645 \) million in annual sales, with costs of \( \$ 610,000 \). The tax rate is 21 percent and the required return is 12 percent. Suppose the project requires an initial investment in net working capital of \( \$ 250,000 \), and the fixed asset will have a market value of \( \$ 180,000 \) at the end of the project. What is the project's Year 0 net cash flow? Year 1 ? Year 2 ? Year 3? What is the NPV? Sales Costs Depreciation EBT Taxes Net income Fixed asset book value in three years Aftertax salvage value Sell equipment Taxes Aftertax salvage value Year 1 Capital spending Net working capital OCF Total cosh flow NPV