You are put in charge of replacing the fleet of sales and executive automobiles for your company. Three types of cars have been identified. The first type would cost less upfront, have higher maintenance cost, and lower salvage values after shorter lives. The second type would cost a little more upfront, have slightly lower maintenance cost, and slightly higher salvage values after slightly longer operating lives. The third type would cost more upfront, have lower maintenance cost, and higher salvage values after longer operating lives. The cash flow estimates for each type is given below:
Type one: Purchase price per car $16,000; Annual operating expense per car $4,000; Disposition value per car $4,000; Estimated useful life of the car 4 years
Type two: Purchase price per car $32,000; Annual operating expense per car $3,600; Disposition value per car $5,500; Estimated useful life of the car 6 years
Type three: Purchase price $48,000; Annual operating expense $2,800; Disposition value $8,000; Estimated useful life of the asset 8 years
All cars can be replaced at the end of their asset lives. Using a 6.5 percent discount rate and the equivalent annuity method, which car is the better investment? Please show the NPV, and Equivalent annuity for each type of car.
NPV Equivalent Annuity
Car Type One ____________________ _____________
Car Type Two ____________________ _____________
Car Type Three ____________________ _____________
Your tutorial is in Excel, attached. You use NPV and PMT in Excel to solve for these. In the last year, the cost is netted by the proceeds from disposal.