Suppose that, for an engineering project, the optimistic, most likely, and pessimistic estimates are as shown in the accompanying table.
Develop a spreadsheet to determine the AW for each of the three estimate conditions. It is thought that the most critical elements are useful life and net annual cash flow. Include in your spreadsheet a table showing the AW for all combinations of the estimates for these two factors, assuming that all other factors remain at their most likely values.

Transcribed Image Text:

Optimistic Most Likely Pessimistic Capital $90,000 $100,000 $120,000 investment Useful life 12 years 10 years 6 years $0 Net annual 35,000 $30,000 $20,000 Market value 30,000 20,000 cash flow MARR (per 11% 11% 11% year)