solve the question and also provide the working for spreadsheet. thanks

Question 1: (a) A mining company is planning a new project that will run from 2021 to 2031. The project will incur capital costs of $150 Million dollars in 2021. From 2021 to 2025 it will produce 3,000 tonnes of copper at a cost of $3 million dollars in operating expenses per year. From 2026 to 2030 annual production increases to 4,500 tonnes of copper but will cost $3.5 million dollars in operating expenses per year. No copper will be produced in 2031, but closure costs are estimated at $100 Million dollars. Assume that: The copper price is $9000 per tonne The company's discount rate is 12% (starting in 2022). Taxes and inflation can be ignored. i. Calculate the Net Present Value using the accompanying spreadsheet ii. Verify the calculations using the formulas below (note that you may need to account for the delayed start in the annuity calculation). PV = FV. (1 + i)" PV = A 1-(1 + i)- i iii. What is the internal rate of return for the project? iv. Should the company proceed with the project (Why/Why not)? (b) Name two other factors that should be taken into consideration before coming to a final recommendation about the project. Units Notes 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 9000 9000 9000 9000 9000 9000 9000 9000 9000 9000 9000 Project Item Production Copper Price Gross Revenue Capex Opex Closure expenses Net Cash Flow Tonnes $/Tonne SAUD SAUD SAUD SAUD SAUD % 12.00 NA 1 Discount rate Discount factor Present values Net Present Value # SAUD SAUD