| Instructions & Credits | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| Analysis Sheet | | | | | | | | | | | | | | | | | |
| 1. Select the Metro Area with drop drown. | | | | | | | | | | | | | | | | | |
| 2. Select to use the provided home price or your own home price by selecting "Yes" or "No" | | | | | | | | | | | | | | | | | |
| *The provided home price is approximately double the local median price (upscale home). | | | | | | | | | | | | | | | | |
| *If you select "No", enter desired home price in cell B8. | | | | | | | | | | | | | | | | |
| 3. Enter estimated inflation rate in cell B9. | | | | | | | | | | | | | | | | | |
| 4. Enter estimated mortgage rate in cell B10. | | | | | | | | | | | | | | | | | |
| 5. Enter term for a fixed rate mortgage (in years) in cell B11. | | | | | | | | | | | | | | | | | |
| 6. Enter "Spread of Correction in cells E7:E12 | | | | | | | | | | | | | | | | | |
| *The spread of correction is the portion of the total correction per year | | | | | | | | | | | | | | | | |
| *The total of the spread of correction should equal 100% unless you want to be bullish or bearish. | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| Credits | | | | | | | | | | | | | | | | | |
| This spreadsheet was created by Kevin, author of the Baltimore Housing Bubble | | | | | | | | | | | | | | | | | |
| http://bubblemore.blogspot.com | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| Data is based off of Shawn Tully's article How Low Can They Go?, in the November 12, 2007 issue of Fortune Magazine | | | | | | | | | | | | | | | | | |
| Shawn Tully's sources of data are: Fortune Analysis, Moody's Economy.com, PPR, NAR | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| Use of this spreadsheet is free without warranty or guarantee of forward-looking statements and/or market conditions. | | | | | | | | | | | | | | | | | |
| By no means will this constitute as an offer of advice. | | | | | | | | | | | | | | | | | |
| If you plan on using this spread sheet, please credit accordingly. | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
