Modeling the Impacts of COVID-19 on Public Institutions White Paper and Excel Tool

NCHEMS, in partnership with SHEEO and with funding from the Bill & Melinda Gates Foundation, has developed an Excel tool to help state agency staff think about and model the potential impacts of the COVID crisis on enrollments, finances, costs, and completions. They also have produced a white paper describing the underlying theories and assumptions that inform the tool, how the tool might be used, a few example scenarios using three different states, and step-by-step instructions for using the tool.

Please reach out to David Tandberg (, at SHEEO, or Brian Prescott (, at NCHEMS, with any questions.