I was thinking about Keith Hennessey’s post of Thursday on the implications of the OMB forecast on unemployment. The OMB forecast says that in the fourth quarter of 2010, the unemployment rate will be 9.7%. Inspired by Hennessey’s work, I decided to write a small spreadsheet. My goal: what does the forecast say about the number of jobs created? Here’s a screen cap of the spreadsheet:

Let me explain each column. The source of this data is the Current Population Survey from BLS. Data projected is italicized. The two bold numbers for unemployment rates are the projections from the OMB economic assumptions. My other assumptions, working left to right:

What we see here is that at the end of 2010, based on what I think are reasonable assumptions on LFPR and population, there are 152,000 fewer people employed than in the fourth quarter of 2008. The employment ratio stays below 60% through the period. Any effect of the stimulus now has to be “well yeah, we lost 152k jobs, but we’d’ve lost A LOT MORE if we hadn’t passed that stimulus package!” Hell is the place where you go to become an economist that has to sell that line.

CBO has its own projections, and when I try to run those into the spreadsheet and when I run those in I have to assume something about 4th quarter unemployment (OMB gives you that number, CBO does not.) I do have their estimated average 2010 unemployment rate of 10.2%. I make that to give us a decline of employment over the first two years of the Obama administration in the range of 750-800 thousand workers, versus 152 thousand. Hennessey notes that this new CBO figure is down 2.3 million workers from estimates last March. But the range of difference in terms of jobs is much smaller than that, probably 600,000 or so our of 145,000,000.

Feel free to whip, chop or puree your own jobs report with this spreadsheet.

UPDATE: Thanks to a reader via Twitter, I found a typo in my population line for 2009:II, which is the worst place to have it because that’s what drives the projections. I’ve updated the file and re-cast the image. It makes matters worse: The size of the decline in jobs between the fourth quarters of 2008 and 2010 is now 1.96 million rather than the earlier figure. This makes sense given my earlier, higher population figures.

This post was promoted from GreenRoom to HotAir.com.
To see the comments on the original post, look here.