Sponsored posts work much in the same way as paid guest posts, but they are posted by big businesses instead of individual bloggers. Therefore, the scope for fees is much higher, as businesses have larger marketing budgets than humble bloggers. Having sponsored posts by large companies will also help promote your site as reputable and as a leader in its field.
How much will you make? I think my best month with Google AdSense was almost $5,000 over the last ten years. That amazing month blew my mind since it was actually near the beginning of my blogging journey. When you go from making zero to $5,000 in a month, that will rock your world. For me, it also got me even more excited because I knew there were other ways to monetize.