Please help me answer these questions for FINANCE

ASAP

Please follow the following additional instructions when completing the assignment: Assume that cash flows arrive continuously throughout the year. In other words, make a midyear adjustment to your NPV calculations. Assume that New Balance is profitable enough so that if a project has an operating loss in any given year, the company can offset profits from other divisions with that loss. In other words, assume the project gets a tax benefit whenever it has negative EBIT. For the Persistence Project: Assume that the factory space used for production would not remain idle but would be rented out for $500,000 per year if the project would not be taken. Use Excel (or equivalent) for all your calculations and to create the tables showing your valuation results for Questions 4 and 6. For you valuation tables, please use a layout similar to the one provided in the template on page 4 of this assignment for your calculations. Note that the template on page 4 may not be complete. If you feel like additional items (e.g. opportunity costs, project externalities, or liquidation values) need to be included, add them as separate line items in the appropriate place. Express all $- amounts in millions of dollars and round to two decimals. Please make your tables fit on one page. Choosing a slightly smaller font size as well as Word's Auto Fit to Page feature can help you with this. Additionally, you may present the tables in landscape format if necessary. If your write-up has several pages, please staple them together. Question 4 (20 points) Produce a detailed free cash flow statement for the Sneaker 13 project and calculate the NPV, IRR, and Payback period for the project. Use a table similar to the one provided in the template on page 4 of this assignment for your calculations and make any necessary adjustments. Express all $-amounts in millions of dollars and round to two decimals. Question 5 (5 points) Which of the following should be included in the free cash flow projections for the Persistence project? Briefly explain why or why not. a) The $1.8 million in fixed overhead expenses allocated to the project b) The rental income from the factory if the project were not taken c) The cost of $50 million for the design technology 2 Question 6 (20 points) Produce a detailed free cash flow statement for the Persistence project and calculate the NPV, IRR, and Payback period for the project. Use a table similar to the one provided in the template on page 4 of this assignment for your calculations and make any necessary adjustments. Express all $-amounts in millions of dollars and round to two decimals. Please follow the following additional instructions when completing the assignment: Assume that cash flows arrive continuously throughout the year. In other words, make a midyear adjustment to your NPV calculations. Assume that New Balance is profitable enough so that if a project has an operating loss in any given year, the company can offset profits from other divisions with that loss. In other words, assume the project gets a tax benefit whenever it has negative EBIT. For the Persistence Project: Assume that the factory space used for production would not remain idle but would be rented out for $500,000 per year if the project would not be taken. Use Excel (or equivalent) for all your calculations and to create the tables showing your valuation results for Questions 4 and 6. For you valuation tables, please use a layout similar to the one provided in the template on page 4 of this assignment for your calculations. Note that the template on page 4 may not be complete. If you feel like additional items (e.g. opportunity costs, project externalities, or liquidation values) need to be included, add them as separate line items in the appropriate place. Express all $- amounts in millions of dollars and round to two decimals. Please make your tables fit on one page. Choosing a slightly smaller font size as well as Word's Auto Fit to Page feature can help you with this. Additionally, you may present the tables in landscape format if necessary. If your write-up has several pages, please staple them together. Question 4 (20 points) Produce a detailed free cash flow statement for the Sneaker 13 project and calculate the NPV, IRR, and Payback period for the project. Use a table similar to the one provided in the template on page 4 of this assignment for your calculations and make any necessary adjustments. Express all $-amounts in millions of dollars and round to two decimals. Question 5 (5 points) Which of the following should be included in the free cash flow projections for the Persistence project? Briefly explain why or why not. a) The $1.8 million in fixed overhead expenses allocated to the project b) The rental income from the factory if the project were not taken c) The cost of $50 million for the design technology 2 Question 6 (20 points) Produce a detailed free cash flow statement for the Persistence project and calculate the NPV, IRR, and Payback period for the project. Use a table similar to the one provided in the template on page 4 of this assignment for your calculations and make any necessary adjustments. Express all $-amounts in millions of dollars and round to two decimals