Please show how to do it in excel along with highlighting the answers

P10-19 (similar to) Question Help 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 $3,800,000 and will be depreciated using a five-year MACRS life, BB: Projected sales in annual units for the next five years are 300 per year. If the sales price is $26,000 per car, variable costs are $18,000 per car, and fixed costs are $1,200,000 annually, what is the annual operating cash flow if the tax rate is 40%? The equipment is sold for salvage for $550,000 at the end of year five. What is the after-tax cash flow of the salvage? Net working capital increases by $550,000 at the beginning of the project (year 0) and is reduced back to its original level in the final year. What is the incremental cash flow of the project? Using a discount rate of 12% for the project, determine whether the project should be accepted or rejected according to the NPV decision model. First, what is the annual operating cash flow of the project for year 1? $ (Round to the nearest dollar.) i Instructor Tip X This problem is for your NPV Excel Assignment. Compute the NPV using the Excel model as shown in the Camtasia lecture. Save your Excel file. Enter answers here for 5 points and submit the Excel file on Blackboard for another 5 points. Please note that if you close this homework on My Finance Lab and then reopen it, you may get a different problem. If that happens after you have completed your Excel file, you should be able to easily change the inputs to those of the new problem. Close MACRS Fixed Annual Expense Percentages by Recovery Class Click on this icon to download the data from this table Year 3-Year 5-Year 7-Year 10-Year 1 33.33% 20.00% 14.29% 10.00% 2 44.45% 32.00% 24.49% 18.00% 3 14.81% 19.20% 17.49% 14.40% 4 7.41% 11.52% 12.49% 11.52% 5 11.52% 8.93% 9.22% 6 5.76% 8.93% 7.37% 7 8.93% 6.55% 8 4.45% 6.55% 9 6.55% 10 6.55% 11 3.28%