$7900 is way high on the prices. Unless the car is 100% pristine and had been a garage queen with less than 50k miles, I would consider maybe close to $6k.
Lets just say I was offered $5k for my 5 year old 2003 GLX convertible at 70k, needless to say I still have my 2003 at this point as there was no way I was accepting $5k on a 5 year old car that cost almost $30k new!
Check pricing on KBB -
Kelley Blue Book
I did not have all the info on your car & location, but I would say $5500 in EXCELLENT condition, this means 100% unmolested, all keys, great paint & body, lower skid pan installed, no window or door lock issues and so forth.
I can guarantee you will need to do something with the transmission. You need the valve body reworked, they oversize some of the bores, install new valves in the oversize bores, either your valve body is reworked or you get an exchange valve body. The 6 speeds usually do not need the transmission wiring harness replaced.
My guess is the dealer probably paid about $3500 for the car at auction. There is a LOT of fat in the car at $7900, this is a crazy price for the car, I would never pay this much unless we were talking garage queen with about 40k miles and then I would not be happy knowing all the issues and money you would have to put into the car.
Also remember dealers make more money on used cars than new cars, much higher profit margin.
Get the cars VIN and search it on the Internet. We had someone here recently that found the car was wrecked badly and sold at a wholesale auction. Had pictures of all the damage and how much the car was sold for at the auction.
Do not give into the pressure. Guessing, I would go no higher than $6k for the car. This is $1900 less than the dealer is asking, I doubt the will drop this much unless they have been sitting on the car too long, but dealers NEVER want to take a loss if they have been sitting on the car too long.
Good luck.