Need an excel spreadsheet for this project.

Please do all calculations in excel if possible. Make sure to label your answers clearly and completely. Problem 1: Each question is worth 12.5 points You are considering investing in a project that costs $20,000,000 and are evaluating which capital structure is most beneficial to shareholders. Currently financed only with equity, the company currently has a beta of .7. If the company borrows money for the project, the cost of borrowing will be as follows: Total Debt Cost of debt $5,000,000 3% $8,000,000 3.25% $10,000,000 5% The expected market return is 10% and the risk free rate is 2%. The corporate tax rate is 21%. Part of the project will be funded by selling a 5 year asset that was purchased 4 years ago for $8,000,000. The old asset has a current market value of $1,000,000. If kept in operation, the old asset would produce EBDITA of $1,000,000 next year and likely be non-productive thereafter. The new asset is projected to produce EBIDTA at the at a constant rate of $12,000,000 per year for 6 years. The project uses assets with a 5 year depreciable life and have no salvage value after 6 years. 1. What return should shareholder expect at each capital structure based on CAPM? 2. What are the incremental cash-flows of the proposed project? 3. What is the appropriate discount rate for each capital structure? 4. How much value is created for shareholders using each of the proposed capital structures? 5. Based on your calculations, which capital structure produces the best return for shareholders based on the risk(s) taken?Each question is worth 12.5 points You enter into a contract with Taylor county to pave several miles of roads in the coming years. In order to meet DOT standards, you must buy $60,000,000 worth of equipment. The interest rate on the loan is 5.5%. Funds Received Date $25,000,000 1/1/2022 $20,000,000 6/1/2022 $10,000,000 11/1/2023 $15,000,000 3/1/2024 $12,000,000 6/15/2024 $18,000,000 12/31/2025 6. What is the present value of this project? 7. What is the internal rate of return on this project? 8. Good weather allows you to complete the first and last projects 3 months early. As a result, you not only get paid faster, but get a 10% bonus. How much value did good weather add to the value of the projects