
While each sport had an individual model, within each I added a worksheet that rolled up all of the key reporting metrics across the various worksheets as rows (weeks) and columns (metrics), which could then serve as a flat, query-able table → combining all of these models’ sheets into a …
…n the 2nd month of the quarter”, while all of our key inputs, e.g., monthly price, remain the same. To account for this possibility we would create a scenario, using the offset function in Excel, that allows us to select whether or not we want the impact of this potential outcome to change certain inputs and then flow through the model. On top of this, we could combine the “Large New Event” scenario with a “Bull” case → “what if we c…