When I was a kid, my dream car was a little British sports car, a Triumph or Lotus or MG like my sister's BFs drove, except when they were under them fixing oil leaks, which was "every second weekend".
Then I forgot about it until two things happened: first, my Dad died (I was 39), secondly, I drove past the Mazda showroom and saw a limited edition MX5 (Miata).
Our kids were 11 and 9. Could we make it work? We found a way. I would drive them to school on my way to work in the minivan, then DW would drive in later in the Miata, swap the cars over at my office car park, drive them home, and I would get a big smile on the drive home.
That was 10 years ago last month. Kids are at college and we now live close enough that I can bike or bus to work. But the Miata is still what I drive every weekend. I can't tell you how glad I am that I didn't wait until I was too old to enjoy it. (I'm still not, but this way I've had 10 more years!)
That said, I didn't get that car until I could buy it for cash and not touch the emergency fund. And a Miata is very, very cheap to run. If I were the OP I'd be asking myself what I'll be doing with my "dream car" in 7 or 8 years when the Beemer starts to get old and you get hit with the cost of replacement parts. I intend to keep the Miata more or less until the wheels fall off, because if necessary I can afford to turn it into a 6-weekends-a-year runabout and get another car.
