Life Cycle Costing calculations (Project Cost Management)

Order Description
Assignment details file is attached.

You are contemplating the purchase of a new SUV for family use including towing the caravan. You are to choose a brand new model that has a petrol and diesel equivalent and perform a Life Cycle Costing calculations using the Net Present Value method to determine their life cycle costs, over a period of 5 years. The vehicle is to be purchased by obtaining a loan from a reputable car financing institution. As the vehicle is for private use only you should ignore any tax implications in your life cycle costing, but must consider the resale value