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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Engineering Economy Questions!