Build a model using excel

A new engineer is evaluating whether to use a higher-voltage transmission line. It will cost \$245,000 more initially, but it will reduce transmission losses. The optimistic, most likely, and pessimistic projections for annual savings are $21,000, $14,000, and $9,000 respectively. The interest rate is 7%, and the transmission line has a life of 30 years. (a) What is the present worth for estimated value of each scenario? (b) What is the expected (mean) Present Worth