I updated the spreadsheet to the discounted cashflow model. I also added perceived utility from driving the car, so you can not only decide which option is the best, but also if either of them is of an added value to you. So if the present value (yellow) is negative, you should not go for that option.
2 Likes