to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
The sellers, Drs. Frederic E. Wondisford and Sally Radovick, were asking for $1.95 million. Senator Barack Obama paid $1.65 million for his current home in 2005, a $300,000 discount off the asking price.
But how much was it really worth?
We've been systematically working through to the answer to that question. Previously, using a third party copy of a public record that indicated that the house at 5046 S Greenwood Ave in Kenwood, Illinois had been purchased for $825,000 on 25 August 2000.
With that data point, we next assumed that properties in Senator Obama's neighborhood were growing in value at or near the same rate at the rest of the Chicago metropolitan area and projected the property's value forward in time based on that presumption. We found that in June 2005, when Senator Obama closed on the property, it would have been worth $468,502 less than what he paid. Projecting forward to the end of the second quarter of 2008, it would be worth $1.37 million.
Then all that changed. Newsweek's Michael Isikoff published professional appraisal data from November 2005 that allowed us to precisely determine the rate at which real estate in Senator Obama's neighborhood appreciates. As it happens, in Senator Obama's neighborhood, property values have historically grown at a much slower rate than that seen generally throughout Chicagoland.
Today, we're going to go back and redo our property value projections, but first, we're going to revisit the value that the previous owners of Barack Obama's house paid for it. We're starting there, because in reviewing previous news articles, we found a pretty big discrepancy between the copy of the public record detailing the value of the transaction and what was being reported in the media.
Here's the Boston Globe's Binyamin Appelbaum description of the house that Obama bought back on 16 March 2008:
Its 6,400 square feet included six bedrooms, six bathrooms, and a wine cellar for 600 bottles. It had been renovated five years earlier in high style: antique Chinese washbasins, mahogany bookshelves, a granite kitchen floor.
It was a fitting home for a new senator. And it was a good deal. The list price was $1.95 million, but the Obamas paid $1.65 million, the same price the sellers had paid five years before.
Leaving aside Appelbaum's slobbering prose description of the house's luxurious features, he's reporting that the Wondisfords purchased the property for $1.65 million.
So how much did they really pay? If they paid $1.65 million as Appelbaum reports, then that $825,000 figure we previously found is way off. If that $825,000 figure is right, then the house is bizarrely overpriced, as the Wondisfords purchased the house *after* it had been fully renovated with all those wonderful luxury features that a drooling Binyamin Appelbaum believes befits a new U.S. Senator, so their value should be fully reflected in the price they paid.
To find out, we went digging into the public database records of the Cook County Recorder of Deeds, which are available on their website. Sure enough, we found the public database record of the Trustees Deed for the Wondisford's purchase of the house (Document Number 00661600), which was executed on 19 July 2000 and recorded on 25 August 2000:
We noticed however that the record for the Property Description (UPIN: 20-11-115-004-0000) didn't match that for all the other public records associated with the property (UPIN: 20-11-115-026-0000).
Searching the Cook County Recorder of Deeds transaction database by the house UPIN identifier turned up additional records, including the mortgage amounts documented for the Wondisfords' purchase of the property in 2000. Here, we believe we found the source for a lot of erroneous reporting regarding the price the Wondisfords paid for the house when they originally purchased it.
There are two separate mortgage records for the Wondisfords' purchase of the property at 5046 S Greenwood Ave in the Hyde Park neighborhood of Chicago:
Recorded Mortgage Documents for 5046 S Greenwood Ave, Kenwood, IL | ||||||
---|---|---|---|---|---|---|
Document Number | Document Type | Grantor | Grantee | Executed | Recorded | Amount |
00603541 | Mortgage | Frederic E. Wondisford Sally Radovick | Emigrant Mtg Co. | 19 July 2000 | 08 August 2000 | $ 1,237,500 |
00603542 | Mortgage | Frederic E. Wondisford Sally Radovick | University of Chicago | 19 July 2000 | 08 August 2000 | $ 412,500 |
We see the execution dates for these two mortgages fully coincide with the execution dates listed on the Trustees Deed. What this tells us is that both were prepared on the day the negotiation for the property was concluded.
We also see that if we add these values together, we obtain a value of $1.65 million, the same amount we see mentioned in all the media reports that provide this information. But, if we take the larger amount of $1,237,500 and subtract the lesser $412,500 from it, we obtain a value of $825,000, the amount recorded on the Trustees Deed.
The answer is neither, but we'll note that the real answer is already evident in these records!
The amount for which the Wondisfords purchased the property that Barack Obama would buy from them less than five years later is $1,237,500. We know this is the case since the University of Chicago is the Grantee on the smaller mortgage.
At the time, the Wondisfords were in the process of moving from Massachusetts to Chicago since they had been hired away from Harvard University by the University of Chicago's medical school. As with most corporate relocations, the hiring firm will provide relocation assistance for its new employees.
Here, we presume that the Wondisfords had not yet concluded the sale of their previous residence in Massachusetts, so the University of Chicago assisted them by loaning them up to one third of the value of the new residence they would acquire in Chicago to cover their down payment, allowing them to settle in before beginning work in September 2000. The University of Chicago would then be recompensated when the Wondisfords completed the sale of their previous home in Massachusetts.
We confirm that the $412,500 is exactly one third of $1,237,500, which we recognize as being the Wondisfords' negotiated purchase price for the house at 5046 S Greenwood Ave in Chicago.
Now that we have the data and the tool to do something useful with it, the rest just falls into place! We've projected the actual value of Senator Obama's property all the way from the third quarter of 2000 through the second quarter of 2008 in the chart below, and calculated the amount that Senator Obama overpaid for the property:
We find that in June 2005, the actual market value of Senator Obama's would be $1,427,830. Since he paid $1,650,000, that figure represents an overpayment of $222,170.
Projecting forward, we see a bump in his property valuation where Senator Obama acquired a 10 foot by 150 foot long strip adjacent to his property (one-sixth of the "Rezko Lot") in the first quarter of 2006. That transaction took place in January 2006.
And going into today, we find that the most current value that we can project for the house that Barack Obama bought in June 2005 is $1,436,420. Considering the expanded property, we estimate the total value of Barack Obama's primary residence to be $1,516,705 as of the end of the second quarter of 2008.
You can use the tool below to confirm our estimates for Barack Obama's house (not including the expansion of his lot):
There is no question that Barack Obama knew the property was overvalued. We recognize this in that his first bid for the house was for just $1.3 million, which as we saw yesterday, would put it right in line with the other properties that have recently sold that are very comparable to the house on paper!
His second bid, $1.5 million, as compared to the true value of $1.43 million, was high, but not outrageously so. His third, "successful" bid of $1.65 million more than vaults over that line.
More disturbing, if we accept that the only thing keeping him from spending the $1.95 million the previous owners were originally asking was his inability to get that much money, what could the United States be in for should Senator Obama become President Obama? Remember, the amount of money he could get was the only constraint he had in the transaction! Ethical constraints, as recognized by his reliance upon favors done for him by shady political associates, were absent from the beginning.
Discounting that apparent reliance upon receiving favors from political associates for his personal benefit, we find that the price that Barack Obama paid for his house reveals a serious lack of fiscal discipline, all the more remarkable for it being on display in the largest single financial transaction of his life to that date. Rather than carefully steward his own money, he instead sought to fulfill his vision of "a fitting home for a new senator."
He might be President. What price will America be compelled to pay to fulfill his grandiose ambitions? And how much will it cost to fix the certain damage?
We find, using the value of a comparable property sold in August 2008, that 1.43 million seems to be right after accounting for the luxury features his house incorporates! That doesn't include the additional strip of land he bought in January 2006, but turns out to be amazingly close to what we found using projecting data forward from the past. We've got the values bookended!
New information about the appraised value of the "Rezko Lot" led us to revisit our analysis of the transactions involving this lot and 2008 Democratic party presidential candidate Barack Obama we had originally presented in The House That Obama Bought
Now obsolete! Here, using that data and assumptions that we have replaced with new information, we showed that at a minimum, 2008 Democratic Party presidential nominee and current Senator Barack Obama (D-IL) paid $360,738 more than his house in Chicago was worth in 2005. At a maximum, he overpaid by as much as $468,502 for the property where his family now resides.
Our tongue-in-cheek look into the negotiations and transactions surrounding Senator Obama's purchase of his current home - kind of a fun introduction to the relative valuations involved, all in the context of a trip to McDonald's! Remarkably, even though we've redone all our calculations, this post stands the test of time!
We looked into suggestions that Senator Biden unduly benefited from the purchase of the property where he built his current home. We introduced our analytical method for projecting the value of real estate properties in this post.
Here, we looked into long-standing allegations that have dogged Senator Biden regarding whether or not he unduly profited from the sale of his previous home in 1996. We originally couldn't make a determination, but thanks to one of our intrepid readers, we were able to find that he did not. Also, where we first built a tool to do the math!
Labels: personal finance, politics, real estate, tool
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.