Explore BrainMass

DT International (DT) new equipment: Which vendor is best?

DT International (DT) intends to purchase equipment. To get the best price, DT asked for bids from vendors. Analysis shows that each equipment from the vendors is similar and has estimated useful life of 20 years.

Additionally, each equipment will have year-end maintenance costs as follows:
Year 1-5 Year 6-15 Year 16-20
Cost per year $1,000 $2,000 $3,000

Below are the packages of three vendors:
Vendor 1: DT pays $55,000 cash at time of delivery and payments of $18,000 at end of each of the next 10 years. DT can elect to purchase a 20-year maintenance service agreement for $10,000 one-time fee. The purchase agreement is optional but if purchased, DT won't have to maintain the equipment for a fee for the useful life of the equipment. (Use PV of ordinary annuity table)

Vendor 2: Sales price is $380,000. Payment of $9,500 is payable semi-annually for 20 years. Upon delivery, DT pays $9,500. Then, it makes remaining 39 payments starting 6 months after delivery. The annual maintenance for the next 20 years is included in the price. (Use PV of annuity due table; remember the payment is twice a year, so interest rate will be half of annual interest rate provided below).

Vendor 3: Sales price is $150,000. DT must pay the whole sales price at delivery. (Use PV of ordinary annuity table but take into consideration the years of the maintenance cost).

Assume DT will pay for the maintenance contract with vendor 1 if selected and that vendor 2 will perform maintenance at no extra charge as indicated. Since Vendor 3 doesn't offer maintenance, DT will pay for this based on the year-end maintenance cost provided. Which vendor should DT select if its cost of funds is 10%? (Hint: calculate which one has the lowest PV of cash outflows).

Solution Summary

Analysis of the cash outflows for each vendor are shown in excel.