Depends - there are kids that choose “lesser ranked” schools each day.
So he wants to study finance. Make sure you check for secondary admission - like a UVA, etc.
JHU, for example, has a business minor (and MBA) but not major.
Northwestern does not have business - just a certificate - so if you want to major in finance, not sure why they’d be on the list. But again, for grad school in finance, it’s wonderful.
As for where you want to end up, you can do so today anywhere - from anywhere - you are not geographically restricted to where you went to school - especially in the era of linkedin and indeed.
I’d find the right fit - and that includes affordability (often the most important thing for a family). If someone wants a big school (a Bama, UMD, etc.) and not a mid size or smaller - then I’d choose a big school even if the smaller one is ranked higher, etc - because in the end, you have to be somewhere four years, day after day.
Richmond - he’ll love or hate - there doesn’t seem to be too much in between (mine hated the “isolation” but others truly love it!!!
Given the student doesn’t have a specific finance interest (like capital markets, IB, etc.) the where likely will matter less - but I would never choose a school where I couldn’t study (no matter its national overall rank) what I think I want to study - and you do have a few of those on your list.
Best of luck.