there are other options for you that will fit the need for 6 passengers.
buying that new Rogue (or even slightly used)... it will still take a good amount of time to recoup the initial purchase price you had to put out with just the fuel savings.
if you are really thinking about overall savings. purchase, fuel, repairs, insurance... etc all need to play a part.
you might find that getting a slightly older toyota highlander, which someone else mentioned, or maybe a mazda5... which is still small, and about the same size as the rogue inside... works out better. the initial purchase price will be much lower, even old toyotas are still very reliable, cheap to fix, and insurance may turn out cheaper. all of which would offset that slightly higher fuel cost for a long while.