Lexus with Carvana license plate

The Spreadsheet and Comparison Figures I Used When Buying My Used Car

Last summer, my wife and I decided it was time to replace our aging sedan. But, instead of buying an actual new car, we decided to shop the used market for something that would be an upgrade for us but at a decent price. Basically, the goal was to find a reliable car that would be comfortable for our many road trips and, if possible, would be a hybrid. While we were initially thinking of a Prius to fit the bill, I stumbled across the now-discontinued-in-the-U.S. Lexus CT200h as a possible alternative as it literally has the same engine as a Prius (being built by Toyota after all) and was surprisingly about the same price. The question then became, which used CT200h do we buy?

Being a discontinued model, we weren’t able to find any in our immediate area but we did have more success on various “car”-named websites like CarGurus, Carmax, and eventual winner Carvana. So, with all of these options at our disposal, how could we compare them objectively to find the one that made the most financial sense? That’s where my “mileage to dollar-cost” spreadsheet came in.

I had actually forgotten about this document until my wife came across it in her Google Drive earlier this week, but I’m kind of proud of it in hindsight. Since we were in search of a car with low miles at a low price, my idea was to take the asking price for each available vehicle and divide that by the number of miles each had on it to find what I’ll call the “cost per mile driven” or CPMD. While I did note other potential factors, such as notable upgrades, car color, model year, etc., this spreadsheet put an emphasis on how much value we were getting from a “miles on the road” perspective.

Surprisingly, the range we found was quite large. On the low end, one vehicle had 28,109 miles and was being sold for $18,491— amounting to a cost of $0.66 per driven mile. The catch here is that this particular car had been in accidents, which made it a no-go for us. On the other end of things, one dealership we found was asking $17,988 for a car with 72,000 miles. That gives it a CPMD of $0.25. Although the lower dollar figure might instinctively make that seem like a better deal, keep in mind that, in this case, a higher figure actually means a better value.

With all the other vehicle listings falling somewhere in between that spread, I’m excited to say that the one we eventually bought (and named Gwen, for the record) was the second-highest overall, with a $0.55 CPMD. That was thanks in part to its remarkably low 33,712 miles — pretty good for a 2015 model. Plus, since we decided to drive up to Carvana’s car vending machine in Kansas City, we didn’t have to pay any additional fees aside from tax and registration, of course.

Looking even closer into this tool, before making our final decision, we were torn between two vehicles in particular: a) a grey vehicle with 36,072 miles for $18,600 or b) a white vehicle with 33,712 miles for $18,700. If you were paying attention, you already know which we ended up with but, with color not being a huge dealbreaker for us and other specs being comparable, we were left with the question, “Are the fewer miles worth the extra cost?” To determine that, we took the price difference ($100) and divided that by the mileage difference (2,360). This figure comes out to about 4¢ — in other words, we’d be paying 4¢ for every mile not driven on the car. Ultimately, we decided that was a pretty good deal.

Obviously this simplistic spreadsheet might not be right for everyone as there may be certain features you value more than others. Still, as a starting point, we definitely found this method to be helpful — if for no other reason than it helped us keep all the cars we were looking at straight. Thus, if you’re in the market for a new-to-you car, perhaps you should consider drawing up your own Google Sheet for such purpose.

P.S.: Shout out to my dad for helping me make sense of what I calculated as I was super confused about how to explain it for this article.

Author

Kyle Burbank

Kyle is a freelance writer and author whose first book, "The E-Ticket Life" is now available on Amazon. In addition to his weekly "Money at 30" column on Dyer News, he is also the editorial director and a writer for the Disney fan site LaughingPlace.com and the founder of Money@30.com.

Other Articles by Kyle Burbank

Fellow Ode 2 Coffee Grinder

My Quick Review of the Fellow Ode 2 Coffee Grinder

A couple of weeks back, in my column on Fioney, I somewhat lamented a recent splurge purchase — not because I was necessarily upset with what I bought but what the process of doing so said about some of my personal finance failings. The item in question was the Fellow...

Should You Buy, Lease, or Finance Your Next Smartphone?

Remember a few years ago when you thought that friend of yours who always had the latest model iPhone was crazy for spending that much? That’s changed in recent years as carriers and others now allow you to essentially lease your device. Taking a page from the auto industry, you...
Bilt and Curve credit cards

Bilt Has Seemingly Shut Down Rewards on Curve Transactions

Ya know, some weeks I really struggle to find a quick tip post to share. And then there are weeks like this that are so overflowing with news that I don't even know where to start. So, since I trust you've already read about the big news regarding Delta SkyMiles...

Very useful tool you have there. In that way you could see and compare each one with accuracy.

You’re very thorough with your comparison. Wish I could do that with my large purchases.

Thanks for sharing your comparison spreadsheet. It may come in handy in the future.

Comments are closed.

The "Email" field is empty, you must enter some text to proceed.The text you entered in the "Email" field appears to be invalid, please edit it and try again
Get Posts in Your Inbox
Featured Articles
Fellow Ode 2 Coffee Grinder

My Quick Review of the Fellow Ode 2 Coffee Grinder

A couple of weeks back, in my column on Fioney, I somewhat lamented a recent splurge purchase — not because I was necessarily upset with what I bought but what the process of doing so said about some of my personal finance failings. The item in question was the Fellow...

Should You Buy, Lease, or Finance Your Next Smartphone?

Remember a few years ago when you thought that friend of yours who always had the latest model iPhone was crazy for spending that much? That’s changed in recent years as carriers and others now allow you to essentially lease your device. Taking a page from the auto industry, you...
Bilt and Curve credit cards

Bilt Has Seemingly Shut Down Rewards on Curve Transactions

Ya know, some weeks I really struggle to find a quick tip post to share. And then there are weeks like this that are so overflowing with news that I don't even know where to start. So, since I trust you've already read about the big news regarding Delta SkyMiles...
model of the American Express Centurion Lounge at EWR

Travel Tuesday: Amex Centurion Lounge Coming to EWR in 2026

When I was a kid, my family would travel between Phoenix's Sky Harbor International Airport and Newark Liberty International Airport in New Jersey at least once per year. Because of this, I have plenty of distinct memories from both hubs — but especially EWR. I still think about the signs at...