How much will it help me in my future jobs? Is it sufficient to handle a small or mid level company management?

Mba teaches u wide variety of skills from leadership, team manager, conflict and stress management, marketing, financial knowledge, operations, HR, International business and hence you can successfully manage any senior management post.