Please show how you did it in Excel

Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $4,500,000 and will be depreciated using a five-year MACRS life, E. The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 260 Year two: 280 Year three: 320 Year four: 370 Year five: 330 If the sales price is $28,000 per car, variable costs are $19,000 per car, and fixed costs are $1,200,000 annually, what is the annual operating cash flow if the tax rate is 30%? The equipment is sold for salvage for $500,000 at the end of year five. Net working capital increases by $600,000 at the beginning of the project (year 0) and is reduced back to its original level in the final year. Find the internal rate of return for the project using the incremental cash flows. CO First, what is the annual operating cash flow of the project for year 1? (Round to the nearest dollar.) MACRS Fixed Annual Expense Percentages by Recovery Class Click on this icon to download the data from this table Year 3-Year 1 7-Year 14.29% 24.49% 2 33.33% 44.45% 14.81% 7.41% 3 5-Year 20.00% 32.00% 19.20% 11.52% 11.52% 5.76% 17.49% 12.49% 4 VOUW 5 10-Year 10.00% 18.00% 14.40% 11.52% 9.22% 7.37% 6.55% 6.55% 6.55% 6.55% 3.28% 8.93% 8.93% 8.93% 4.45% 6 7 8 OOOO 9 10 11