^That came out smaller than I wanted. Maybe I'll try to re-do it later, but for now my wife is a little annoyed I've spent the last few hours tweaking these.
I'll probably play with the formatting on this one too, as it's kinda hard to account for all the various possibilities via spreadsheet. I'm sure I can probably find a clearer method, but with a handful of individual decisions on options and extensions it's hard to account for it all succinctly.
Keep in mind this is just how everything will be before next July when players can officially be renounced, as of now. I don't actually think we'll hold onto big cap holds for guys like Hawes or Hibbert, but they're listed for completeness' sake.

I started with two main columns, actual salary and cap holds. The majority of players fall into one or the other, however there are two key exceptions. The first is Hawes, whose player option season next year is actually a decrease from this year's salary (thanks to a trade kicker from when we acquired him). The third column is basically a "likely" cap number. Let's face it, if Hawes opts out of his $6M option, we're probably not gonna bother keeping that $9.5M hold on the books, so the $6M is the most likely of the two but it's probably
most likely that we just scrub him from the books altogether.
The key here though is obviously Cody Zeller. While his qualifying offer is a workable $7M, his actual cap hold is nearly double that. Still, if an extension isn't reached, it's hard to imagine us letting him go for nothing. So for that reason I've got his cap hold as the likely amount in the Cap Number Column.
You'll also notice in that column the cap holds for Hibbert, Roberts, and Harrison; as well as the options for Sessions and Wood. While it's highly unlikely that all of these guys are kept, rather than pick and choose I've just listed them all to give sort of a "worst case scenario" as far as how much cap space we'll have.
Conversely, I've also created a "max space" column in order to show how much space we could have
within reason. Sure, we could decline Kaminsky's option or just let Zeller walk for pure cap space, but I don't see either as very likely. You can also imagine a Lamb or Belinelli trade if you'd like, but I'm operating under the assumption that no trades are made (which of course won't happen, but leaving them in there is much more likely to be accurate than just assuming they'll be traded for no incoming salary).
Basically the "max space" option comes down to us keeping all our guaranteed contracts plus Cody and Frank. However, then you have to account for 4 open roster spots, which is where the $2.25M roster charge comes in.
I can probably clarify anything and post a link to my spreadsheet for anyone that wants it...just not tonight. I'm sure I'll think of more to add to this by morning.