Estimating prices is more art than science.
There is no magic formula. It comes down to supply, demand, sales ability, and vehicle condition, as well as the "luck" factor of someone looking for your vehicle at the time you wish to sell it.
05 S4 4.2 6 spd
07 A3 3.2 - Wifey's