Explore BrainMass
Share

# NPV, and Equivalent annuity for each type of car.

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 ____________________ _____________

#### Solution Summary

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.

\$2.19
Similar Posting

## NPV: Keep 3/4/5/6 years, equivalent annuity, MACRS real property

1. 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 5.3 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 ____________________ _____________

Which type of car should be chosen?______________________

2. An asset costs \$247,000 and will generate cash benefits of \$80,000 at the end of each year for six years for Hartford Corporation. Salvage values are \$160,000, \$145,000, \$85,000, and \$45,000 at the end of years 3, 4, 5, and 6 respectively. The required return is 5.25 percent.
Please compute the net present value, and the equivalent annuity and record these below:
Keep for 6 years ________________ ____________________
Keep for 5 years ________________ ____________________
Keep for 4 years ________________ ____________________
Keep for 3 years ________________ ____________________
When is the optimal time to abandon the investment?_____________________

3. You place a commercial building into service on February 27th, 2015 costing \$3,202,000. What is the depreciation expense allowed by the IRS for this building for tax years 2015? _____________And 2016?______________

View Full Posting Details