You wish to evaluate four independent projects that all have a 10-year life at MARR = 15% per year. Preliminary estimates for first cost, annual net income, and SV have been made.

(a) Accept or reject each project using a present worth analysis. On your spreadsheet, include the logical IF function to make the accept/reject decision.

(b) The preliminary estimates have changed for projects A and B as shown below. Use the same spreadsheet to reevaluate them.

Transcribed Image Text:

A B D First cost, $ Annual net income, $/year Salvage value, $ -1,200 -2,000 -5,000 -7,000 200 400 1100 1300 5 6. First cost, $ Annual net income, $/year -1,000 -2,200 300 440 Salvage value, $