You are a city examining the costs of a proposed plan to install 20,000 electric vehicle charging stations

IN EXCEL Create a discounted cash flow (DCF) for 10 years. Include NPV, IRR, and Payback Period for the project.

(Show formulas used, do not hard code cells)

Cost of EV infrastructure
Cost per EV charging station	30,000
# of charging stations	20,000
Other infrastructure costs	15,000,000
Total EV Inf. Costs	615,000,000
Revenues for one EV charging station
Fee per kWh	0.125
Cost of electricity per kWh	0.025
profit from sale of kWh	0.100
# of kWh needed / charge /car	77.5
Fee for one full charge / car	9.69
Profit from one full charge / car	7.75
Total revenues / day / station	317.75
Revenues for one EV charging station
Total revenues / day / all stations	6,355,000.00
Total revenues / year	2,319,575,000.00

Interest Rate = 4.5%