The federal government is planning a hydroelectric project for a river basin.In addition to the production of electric power, this project will provide flood control, irrigation, and recreation benefits.The estimated benefits and costs expected to be derived from the three alternatives under consideration are listed below.

	Decision Alternative
	A	B	C
Initial cost	$8,000,000	$10,000,000	$15,000,000
Annual benefits or costs
Power sales	$1,000,000	$1,200,000	$1,800,000
Flood control savings	250,000	350,000	500,000
Irrigation benefits	350,000	450,000	600,000
Recreation benefits	100,000	200,000	350,000
O&M costs	200,000	250,000	350,000

The interest rate is 10%, and the life of each of the projects is estimated to be 50 years.

(a)Find the benefit-cost ratio for each alternative

(b)Select the best alternative based on BC(i).

PLEASE SOLVE USING EXCEL AND KINDLY SHARE EXCEL FORMULA FOR REFERENCE .