solve all Q and use the Excel

Learning Objectives: - Practical solutions to Fossil Fuel + climate mitigation. - Increase resiliency of Municipalities by reducing cost of Fuel. - Improve quality of infrastructure - Solutions to Waste Management problems in Jordan - Learn how to apply financial principles to actual problems. - Assume anything that is not give, and explain why you need it. Given Information: - Greater Amman Municipality received 14 Electric Combactors as donation. - The Trucks work Two shifts. - Each truck works for 8 hours, during this time, it will complete 4 rounds. - Each truck will drive 40km/ shift - Electricity consumption 20KWh /shift/truck. - Diesel Consumption: 1 liter/KM. - Cost of Diesel - From MEMR Website for May 2023. - Diesel cost annual increase: 2% - Municipality works 6 days/ week. - Tariff Annual Increase: 3.5\% - Public Holidays: 14 days/year - Maintenance Cost of electric and diesel is the same. - CO2 emissions= a Liter of diesel produces 2.6391kgs of CO2 - CO2 emissions =1KWh produces 0.4585kgs of CO2 Required Calculations (I=5%,n=10 years ) 1. What is the Electricity Tariff? - Calculate the following: Payback Period, (PBP), Net Present Value, (NPV) - Internal Rate of Return, (IRR), Benefit/Cost Ration (B/C) - Cash Flow Diagram 2. What is the annual Diesel reduction? 3. What is the lifetime Diesel reduction? 4. What is the annual CO2 emission reduction (Metric ton CO2 )? 5. What is the lifetime CO2 emission reduction (Metric ton CO2 )? - Submit the excel sheet calculations