solve all calculations and use Excel

Learning Objectives: - Practical solutions to Fossil Fuel + climate mitigation. - Increase resiliency of Cities by using waste water in agriculture - Improve quality of infrastructure, employment of local people - Solutions to water and food 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: - Assume 100,000 units installed in Jordan. - Average Consumption: 2liters/ person/ day - Average family size =5 persons - Energy Consumption =6.6KWh/m3 water - Cost of KWh =0.10JD/KWh. - Cost of water =2JD/m3 - The Ministry of Water and Irrigation (MWI) Issue a regulation to allow only SuperEfficient Water Filters with Water Ration of 1:1. - Submit the excel sheet calculations. Domestic water filters have a waste ratio of between 31 meaning that for every 1 liter of filtered water produced 3 liters of water are wasted. This is because the filters need to flush out contaminants and particulate matter during the filtration process, which results in the loss of some water. - CO2 emissions =1KWh produces 0.4585kgs of CO2 Required Calculations ( I=3%,n=10 years) - Calculate the Water + Electricity Savings cost for MWI: Payback Period, (PBP), Net Present Value, (NPV), Internal Rate of Return, (IRR), Benefit/Cost Ration (B/C)m Cash Flow Diagram 1. What is the annual Water Savings (m3) and in (JD)? 2. What is the annual Electricity Savings (KWh) and in (JD)? 3. What is the annual CO2 emission reduction (Metric ton CO2) ? 4. What is the lifetime CO2 emission reduction (Metric ton CO2 )? 5. Name 3 uses for the waste water from the filter you can use? Submit the excel sheet calculations