1. Select a Ford, Chevrolet, GM, Honda, Toyota, Subaru, Mazda, Hyundai or Kia car and model that you think would be a nice, reasonable car for you to purchase when you graduate. What is the brand, model and MSRP of the car?

2. Select a luxury car that you would dream of buying when you graduate. Suggested brands include BMW, Mercedes, Audi, Volvo, Lexus, Porche, etc. What is the brand, model and MSRP of the car?

3. Calculate the difference between the prices of the two cars. If you purchase the nice, reasonable car rather than the luxury car when you graduate, and invest the difference between the prices of the cars in the stock market and earn 8% per year until you are 65, how much would you have at that time? In other words, by purchasing the affordable car at graduation, how much more will you have in savings at retirement from this one decision. (Use your age at graduation to calculate how many years there will be until your turn 65. Make sure to state this clearly in your excel sheet as an input so it can be easily changed.)

B10 A x fx A B C D E F G 1 MODEL 2 3 BRAND 1 Kia 2 Audi Optima A8 MSRP 23,590 86,500 4 22 5 6 3b 7 8 9 10 62,910 Age at Grad Years until 65 % per year 43 8% 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25