Three mutually exclusive alternative public-works projects are currently under consideration. Their respective costs and benefits are included in the table that follows. Each of the projects has a useful life of 50 years, and MARR is 10% per year. Which, if any, of these projects should be selected?

Solve by hand and by (Excel) spreadsheet. (Send excel or excel print screen that function is seen)

A B C

Capital investment 8,500,000 10,000,000 12,000,000

Annual operating and 750,000 725,000 700,000

maintenance costs

Market value 1,250,000 1,750,000 2,000,000

Annual benefit 2,150,000 2,265,000 2,500,000

PLEASE SHOW THE STEPS OF THE EXCEL AND THE NECESSARY FORMULAS