How to Calculate a 20% Discount on Audi?

[Hylla]

Open an Excel spreadsheet titled "Audi Car Price Calculator". Enter the manufacturer's suggested retail price (MSRP) and the discount percentage. In the cell for the discounted ex-factory price, input the formula "=A3×(1-B3/100)". Press the enter key to calculate the ex-factory price of the Audi with a 20% discount.

[VanLeila]

I just bought an Audi A4 last month with a 20% discount, and there's a lot to it. Simply put, the car price is directly discounted by 20%, so a 400,000 yuan car becomes 320,000 yuan after the discount. But pay attention to four points: First, the 20% discount refers to the base car price, with taxes and insurance calculated separately; second, 4S stores often add back decoration fees, forcing you to spend around 10,000 yuan on window tinting; third, if you buy with a loan, the handling fee can cost you 5,000 to 6,000 yuan; finally, trade-in subsidies are also counted in the discount points to fool people. When I bought the car, the salesperson said it was a 20% discount, but paying in full actually gave 8% less discount than financing, and in the end, it only worked out to about 12% off the total price.