In: Finance
There are three mutually exclusive alternatives, as vendors to outsource a project, with the following cash flow and useful life. Which of these three alternatives would you recommend to be selected? The MARR is 10% per year.
| 
 Vendor 1  | 
 Vendor 2  | 
 Vendor 3  | 
|
| 
 First Cost  | 
 $60,000  | 
 $35,000  | 
 $25,000  | 
| 
 Annual operating and maintenance cost  | 
 $3,000 every 4 years  | 
 $1,000 per year  | 
 $2,000 in yr 1 and it increases by $200 every year thereafter  | 
| 
 Salvage value  | 
 $10,000  | 
 $4,000  | 
 $3,000  | 
| 
 Useful life, years  | 
 8  | 
 2  | 
 4  | 
Answer-
We have to calculate NPV of all the three alternatives and the alternative with the highest NPV should be selected.
Vendor 1
NPV = - $ 60000 - $ 3000 / 1.104 - $ 3000 / 1.108 + $ 10000 / 1.088
NPV = - $ 60000 - $ 3000 / 1.464 - $ 3000 / 2.143 + $ 10000 / 2.143
NPV = - $ 60000 - $ 2049.2 - $ 1399.9 + $ 4666.35
NPV = - $ 58782.75
Vendor 2
NPV = - $ 35000 - $ 1000 / 1.10 - $ 1000 / 1.102 + $ 4000 / 1.12
NPV = - $ 35000 - $ 1000 /1.10 - $ 1000 / 1.21 + $ 4000 / 1.21
NPV = - $ 35000 - 909.09 - $ 826.45 + $ 3305.78
NPV = - $ 33429.76
Vendor 3
NPV = - $ 25000 - $ 2000 / 1.1 - $ 2200 / 1.12 - $ 2400 / 1.13 - $ 2600 / 1.14 + $ 3000 / 1.14
NPV = - $ 25000 - $ 2000 /1.10 - $ 2200 / 1.21 - $ 2400 / 1.331 - $ 2600 / 1.464 + $ 3000 / 1.464
NPV = - $ 25000 - $ 1818.18 - $ 1818.18 - $ 1803.15 - $ 1775.96 + $ 2049.18
NPV = - $ 30166.29
Alternative or Vendor 3 has the highet NPV therefore Alternativeor Vendor 3 should be selected