Your in-laws are correct and your friend is wrong. Historically the largest depreciation hit on new cars is in the first few years. Getting a low mileage used car that's a few years old is typically the sweet spot for value. You have to price out new and used to understand where the best deals are but generally it's true.

That did go strange for a while during COVID but has mostly become true again.