Assume you are 22 years old and buy a new car every 5 years until you are 72. The car is a $60,000 brand new BMW, calculate the following and display in an Excel or Word spreadsheet:

1. The cost of this vehicle every five years based on 5% inflation annually, calculated until you are 72
2. The future value of each purchase price at age 72, based on 6% interest
3. The total for each of the above columns

These costs do not include the additional costs of financing a car loan. Briefly discuss how these calculations change your perception of purchasing a new car.