PLEASE USE EXCEL OR INCLUDE FORMULAS USED and GRAPH. THE WACC I SOLVED FOR FROM QUESTION 1 IS 5.42%.

Firm Z has invested $4 million in marketing campaign to assess the demand for the product Minish. This product will be in the market next year and will last five years. Revenues are projected to be $50 million per year along with expenses of $20 million. The firm spends $15 million immediately on equipment that will be depreciated using MACRS depreciation to zero. Additionally, it will use some fully depreciated existing equipment that has a market value of $4 million. Finally, Minish will have no incremental cash or inventory requirements (products will be shipped directly from the contract manufacturer to customers). But, receivables are expected to account for 15% of annual sales. Payables are expected to be 15% of the annual cost of goods sold (COGS) between year 1 and year 4 . All accounts payables and receivables will be settled at the end of year 5 . Based on this information and WACC in the first part of the question, find the NPV of the project. Identify the IRR of the project. Draw NPV vs r graph of the project. Will you accpet this project? Why? Please show your work. [30 points]