solve all calculations and use Excel

Learning Objectives: - Practical solutions to Fossil Fuel + climate mitigation. - Increase resiliency \& reducing cost of Fuel. - Learn how to apply financial principles to actual problems. - Assume anything that is not give, and explain why you need it. Given Information: - Cost of Solar Water Heater for each Pool =25,000JD - Diesel Consumption: 7000 liter/ yeal pool - Cost of Diesel - From MEMR Website for May 2023. - Diesel cost annual increase: 2% - CO2 emissions= a Liter of diesel produces 2.6391kgs of CO2 Required Calculations (I=5%,n=20 years ) - Calculate the following: Payback Period, (PBP), Net Present Value, (NPV) - Internal Rate of Return, (IRR), Benefit/Cost Ration (B/C) - Cash Flow Diagram 1. What is the annual Diesel reduction? 2. What is the lifetime Diesel reduction? 3. What is the annual CO2 emission reduction (Metric ton CO2 )? 4. What is the lifetime CO2 emission reduction (Metric ton CO2 )? - Submit the excel sheet calculations