Creating a Crystal Ball for College Finances

As they searched for the right combination of changes to put their institution on course to fiscal sustainability, the members of the Commission on Shaping the Future of Wilson College relied on an intricate model of the college's future finances that was assembled by Brian Ecker, the college's vice president for finance and administration.

Mr. Ecker worked with consultants from Stevens Strategy in creating the model, primarily in Excel. Starting with several years' worth of audited