TIME VALUE OF MONEY 1

please show excel formula as well

Create an MS Excel\" file (and use its functions) to answer the following problem/s. Make sure to use cell referencing for the variables. Do not forget to highlight the final answer. The Southwestern Electricity and Water Authority authorized construction projects totaling $1.08 million to improve desalination plant efficiency and salinity-reduction technology for reject chemicals. Three bids from potential vendors were received in the amounts of $1.05, $1.063 and 51.075 million. Assume the savings will be realized immediately for each bid, were it accepted. Use an expected life of 10 years and the interest rate is 6% per year to do the following for the savings anticipated from the bids: a. Determine the equivalent future worth of the savings. b. Determine the equivalent annual worth ofthe savings. c. Prepare a chart to visualize parts (a) and (bl