Please help me with Questions 3 and 4 Specifically, Thank You!

XYZ, Inc. is considering a 5-year project. The production will require net working capital investments each year equal to 15% of the projected sales . Total fixed costs are $1,350,000 per year, variable production costs are $210 per unit, and the units are priced at $345 each. The equipment needed to begin production has an intalled cost of $23,000,000. The equipment is qualified as seven-year MACRS property. The company is in the 35% marginal tax bracket and has a required rate of return on all its projects of 18\%. Salvage value will be the same as the book value at the end of year 5 . Please finish the project valuation and answer the following questions. All the colored cells need to 3 4. Using the following table and Excel scenario manager function to conduct a scenario analysis. In this analysis, please cover worst, expected, and best scenario. Pleas change the rell references in the seenarin summarv tahle to neneer variahle names sn vour results are understandahle. 17 nointsl XYZ, Inc. is considering a 5-year project. The production will require net working capital investments each year equal to 15% of the projected sales . Total fixed costs are $1,350,000 per year, variable production costs are $210 per unit, and the units are priced at $345 each. The equipment needed to begin production has an intalled cost of $23,000,000. The equipment is qualified as seven-year MACRS property. The company is in the 35% marginal tax bracket and has a required rate of return on all its projects of 18\%. Salvage value will be the same as the book value at the end of year 5 . Please finish the project valuation and answer the following questions. All the colored cells need to 3 4. Using the following table and Excel scenario manager function to conduct a scenario analysis. In this analysis, please cover worst, expected, and best scenario. Pleas change the rell references in the seenarin summarv tahle to neneer variahle names sn vour results are understandahle. 17 nointsl