Question: 11-26. Suppose that, for an engineering project, the optimistic, most likely, and pessimistic estimates are as shown in the accompanying table. Develop a spreadsheet to
11-26. 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. (11.4) Optimistic Most Likely Pessimistic Capital $90,000 $100,000 $120,000 investment Useful life 12 years 10 years 6 years Market value $30,000 $20,000 $0 Net annual $35,000 $30,000 $20,000 cash flow MARR (per 11% 11% 11% year)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
