Are you the Record reporter assigned to write this week’s story on the College’s financial troubles? How come you haven’t contacted me (or someone else knowledgeable) so that your article is more sophisticated than similar coverage in the The Greylock Echo? Just asking!

Anyway, after you finish with this overview, here are the key data/documents/answers you need to gather.

The article must feature a table with the key elements of the College’s revenues and costs. Although more detail is nice, the critical feature is reasonable estimates for fiscal years 2009 (ending June 30, 2009) and 2010. Start with these financial statements. The 2008 numbers are not public, but the accountants are done so someone knows the details. You can use the last few years data to provide a forecast for 2009 and 2010 spending. Assuming 6% increases each year is probably consistent with experience this decade.

On the spending side, you don’t need anything beyond the overall number. Later articles can break that up into categories. A key distinction is between total employee compensation (salary, benefits, retirement, etc) and all other costs. HWC notes that employee costs were 55% of the total at Swarthmore. I bet that Williams is similar. Since Morty has promised no cuts (even in the rate of growth?!) in these expenses at Williams, it means that cuts in other areas need to be even larger.

On the revenue side, you should provide the breakdown for the three categories that Morty mentioned in his e-mail: student payments, annual giving and endowment spending. Get these numbers for the last few years (if you contact HWC, he will help you out with the details). You could then forecast the student money out into 2009 and 2010. Find out what the value of the endowment is now. (Assume that it is \$1.4 billion if the Investment Office won’t tell you.) Endowment spending would then be \$70 million (assuming the historical 5% spending rate — anything higher is eating the seed corn). For alumni giving, assume a decrease by 20% for 2009 and then constant in 2010.

Put all that together, and you know how many dollars need to be cut out of the College’s baseline budget. My guess would be somewhere between \$5 and \$20 million, but you should be able to narrow that down.