Please show all your work excel...please show all the formulas too. and if using

1). As the newly appointed financial manager of HOMEWORK co., you are about to analyze a project. Here is the data you have collected. The project requires an investment of $180,000 today. The forecasted cash flows from the project are listed below. All the entries are nominal. To calculate tax liability, you assume that for tax purposes the company uses straight-line depreciation during the economic life the project and the salvage value is zero. However, there is a salvage value of $10,000 in year 4. The tax rate is 21%. The opportunity cost of capital is 18%. Year: 3 Revenues 273,000 322,887 342,610 Cost of goods sold 100,000 143,729 159,552 Increase in inventory 20,000 5,000 -10,000 -15,000 Increase in accounts payable Increase in accounts receivable 8,000 10,000 4,000 5,000 -6,000 -5,000 -6,000 -10,000 ", Please fill in the blanks below. If the answer is blank, put "O" in the cell. Don't add "$" or or "." in your answers. All the answers are in $1 unit. No decimals. [42 points) Year 0 1 2 3 4 Panel A Capital Investment Cash flow from capital investment [ ] [] [] [ ] [ ] Panel B Operating Cash Flow [] [] [] Operating cash flow [] [] Panel C Investment in Working Capital Cash flow from investment in working capital [ ] [] [ ] [] [] Panel D Project Valuation [ ] [] [] [ ] [] Discounted cash flows NPV []