Please answer this question in the excel format with the labels listed on the second picture!

A: Given the available information, what are the free cash flows in years 0-10 that should be used to evaluate the proposed project?

B: If the cost of capital for this project is listed below, what is your estimate of the NPV of the new project? (Tax rate is 25% and Cost of Capital is 18%)

1. Calculate the gross profit for Year 1-10 (10 pt.).
2. Calculate the net operating income for Year 1-10 (10 pt.).
3. Calculate the income tax for Year 1-10 (10 pt.).
4. Calculate the net income for Year 1-10 (10 pt.).
5. Calculate the sum of the cost of the machine and the change in the net working capital (happens in Year 0 and 10) (10 pt.)
6. Calculate the cash flow in Year 0 - 10 (20 pt.).
7. Use the information on Cost of Capital, calculate the NPV of this project (10 pt.).

Could you answer it in this format?

You tire a mannger at Rercolated Fober, which is considering expanding its operntions in syuthetic fiber manuficturing. Your boss cotnes into your office, teraps a consultant's report on your desk, and complaints, "We owe these consuitants $1 minison for this report, and I ama not sure their analyeis mikes sesse. Before We spend the 525 millien on tecw equipusent needed for this project, look it over and give me your opinion." You open the report and find the following estanates (in Hiousands of dolliss All of the estinstes in the report seet comect. You note that the consiltants nsed straighitline deprecistion for the new equipment that will ke perchased todidy Hion Minul