**Show work in Excel with formula**

A proposed bridge on the interstate highway system is being considered at the cost of 10 million dollars. It is expected the bridge will have a life of 30 years. Construction costs will be paid by government agencies. Operation and maintenance costs are estimated to be 180,000 per year. Benefits to the public are estimated to be 900,000 per year. The building of the bridge will result in an estimated cost of 250,000 per year to the general public. The project requires a return of 5 percent. Determine the benefit/cost (B/C) ratio.

0.78

1.08

0.01