Sam decided to buy a new car. He did some research and found two cars he likes. And he is indifferent between the two cars. One is an American car. (Lets call this car A car) The other is a Japanese car. (Lets call this car J car) So the only factor that can help him to make the final choice is the present value of the cash outflows for the two cars. The sticker prices of Japanese cars are usually close to their dealers bottom line price. Therefore, buyers do not have much room to bargain. In contrast, the sticker prices of American cars are usually significantly higher than the bottom line price, which leaves some room for bargaining. In order to find the best deal, Sam went around to talk with dealers. With some efforts and bargaining, a dealer agrees to sell him an A car with a sticker price of $37,000 for $29,000. Another dealer agrees to sell him a J car with a sticker price of $31,000 for $28,500. Sam also found that he has two options to pay for the new car. One is to pay with cash from his savings account. The other is to take a 5-year auto loan. Besides buying the car, Sam can also lease the car for three years. If Sam leases the car, the residual value of the car after three year is 50% of the sticker price. This means that the lease payment every month is to cover the difference between the final price and the residual price. Currently, there are promotions going on for the leasing option and the financing option. For the auto loan option, the current promotion interest rate is 0% APR. For the leasing option, the monthly payment for car A is $270 plus sales tax and exercise tax. The monthly payment for car J is $290. The detail terms for the auto loan and the leasing option are listed in the following table.

The sales tax is based on the payment. The buyer needs to pay the sales tax based on the final price if he chooses to buy the car. If the buyer is leasing the car, he just needs to pay the sales tax base on the lease payment. However, since lease payment is paid every month, the sales tax is also due every month based on the lease payment. The exercise tax is due on an annual basis to the government. The tax rate for the first 4 years are 2.25%, 1.5%, 1%, and 0.625% respectively. Starting in the fifth year, the exercise tax rate is 0.25%. The base of the exercise tax rate is the sticker price. If Sam chooses to lease the car, instead of paying one exercise tax payment according to the exercise tax rate every year, he needs to pay $51 exercise tax every month with the lease payment. If Sam chooses to buy a car, he is planning to sell the car after 6 years because he worries about the maintenance cost after 6 years. With three different options and a lot of details, it is really hard for a normal person to make a decision. Please help Sam to figure out the best option. You should turn in an excel file and a short report to explain what Sam should do and why.

Hint:

1. Present Value

2. The average historical return on S&P 500 index is about 6%. 3.

3. With the buying option, Sam is going to keep it for 6 years. Therefore, for the leasing option, you should consider leasing a car for 3 years, then leasing another new car with the same price (including new exercise tax) for three years. Remember to discount the cash flows in the second 3-year period.

4. You can make reasonable assumptions

Cars Sticker Price (MSRP Final Price Sales Tax Trade-in Value after 3 years $16,000 Trade-in Value after 6 years $9,300 $37,000 $31,000 $28,500 6.25% $18,000 $11,000 $29,000 | 6.25%