Option 1	Option 2
Chiller capital cost	1,000,000.00	700,000.00	AED
Annual maintenance additional maintenance	10,000.00	5,000.00	AED
Annual electricity savings	325,000.00	250,000.00	kWh
Average electricity cost	0.43	0.43	AED/kWh
Lifetime	10		Years
Discount rate	3.00%

Calculate for each option:

Annual discounted cash flow graph for the lifetime of the project

NPV at the end of the lifetime

NPV cumulative graph

IRR at the end of the lifetime

SPP

Brief discussion (100 words) of which option is preferred and why

Presentation format:

Excel file