Explore BrainMass

Explore BrainMass

    NPV, and Equivalent annuity for each type of car.

    This content was COPIED 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 ____________________ _____________

    © BrainMass Inc. brainmass.com June 4, 2020, 2:41 am ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/npv-and-equivalent-annuity-for-each-type-of-car-473631

    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

    ADVERTISEMENT