i need a 100% correct solution for both these question. the solution shoulb be in solved in excel. Thank you in advance.

3. Firm 2 has issued 1,000,000 bonds. Each bond is priced at $980 and has a face value of $1000. It parys semiannual coupon payments and has a coupon rate of 6%. The bonds will mature in 20 years. Stock price of Firm 2 is 510 , and there are 40 million shares outstanding. There are 3 million shares of preferred stock, which offers $2 dividend and is priced at $40. Equity beta of Firm Z is 1.5 and current market portfolio yields 8% and the risk free rate is 2%. Corporate tax rate is 30%. Find the costs of debt, equity, preferred stock and WACC. Please show your work. [20 points] Firm Z las inwested $ million is marketing campaign to assess the demand for the product Misish. 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 $40 million. The firm spends $20 million immediately on equipment that will be depreciated asing MACRS depreciation to zero. Additionally, it will use some fully depecciated existing equipeneat that has a anarket valae of $6 million, Finally, Minish will have no incremental cash or inventory requirements (products will be shipped direstly from the contract manafacturer to customers). But, receivables are expected to account for 10% of annual sales. Payables are expected to be 10% 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 shou your work. [30 points]