Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 48

THE ALLSTATE CORPORATION
NET INVESTMENT INCOME, YIELDS AND REALIZED CAPITAL GAINS AND LOSSES (PRE-TAX)
($ in millions)
 |  |  | Three months ended |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twelve months ended
 |  |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Dec. 31,
 |  |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2012 |  |  | 2011
NET INVESTMENT INCOME
 | Fixed income securities |  | $ | 793 |  | $ | 817 |  | $ | 818 |  | $ | 806 |  | $ | 823 |  | $ | 862 |  | $ | 899 |  | $ | 900 |  | $ | 3234 |  | $ | 3484
 | Equity securities |  |  | 53 |  |  | 29 |  |  | 24 |  |  | 21 |  |  | 46 |  |  | 23 |  |  | 34 |  |  | 19 |  |  | 127 |  |  | 122
 | Mortgage loans |  |  | 97 |  |  | 92 |  |  | 92 |  |  | 93 |  |  | 92 |  |  | 91 |  |  | 87 |  |  | 89 |  |  | 374 |  |  | 359
 | Limited partnership interests (1) |  |  | 110 |  |  | 22 |  |  | 107 |  |  | 109 |  |  | 27 |  |  | 33 |  |  | 18 |  |  | 10 |  |  | 348 |  |  | 88
 | Short-term |  |  | 2 |  |  | 2 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 |  |  | 2 |  |  | 6 |  |  | 6
 | Other |  |  | 35 |  |  | 33 |  |  | 34 |  |  | 30 |  |  | 31 |  |  | 27 |  |  | 26 |  |  | 11 |  |  | 132 |  |  | 95
 | Sub-total |  |  | 1090 |  |  | 995 |  |  | 1076 |  |  | 1060 |  |  | 1020 |  |  | 1038 |  |  | 1065 |  |  | 1031 |  |  | 4221 |  |  | 4154
 | Less:  Investment expense |  |  | -57 |  |  | -55 |  |  | -50 |  |  | -49 |  |  | -45 |  |  | -44 |  |  | -45 |  |  | -49 |  |  | -211 |  |  | -183
 | Net investment income |  | $ | 1033 |  | $ | 940 |  | $ | 1026 |  | $ | 1011 |  | $ | 975 |  | $ | 994 |  | $ | 1020 |  | $ | 982 |  | $ | 4010 |  | $ | 3971
PRE-TAX YIELDS (2)
 | Fixed income securities |  |  | 4.4 | % |  | 4.5 | % |  | 4.4 | % |  | 4.4 | % |  | 4.5 | % |  | 4.6 | % |  | 4.6 | % |  | 4.6 | % |  | 4.4 | % |  | 4.6 | %
 | Equity securities |  |  | 6.1 |  |  | 3.4 |  |  | 2.8 |  |  | 2.2 |  |  | 4.3 |  |  | 2.2 |  |  | 3.3 |  |  | 1.9 |  |  | 3.5 |  |  | 2.9
 | Mortgage loans |  |  | 5.7 |  |  | 5.4 |  |  | 5.2 |  |  | 5.2 |  |  | 5.2 |  |  | 5.2 |  |  | 5.2 |  |  | 5.4 |  |  | 5.4 |  |  | 5.3
 | Limited partnership interests |  |  | 8.9 |  |  | 1.8 |  |  | 9.2 |  |  | 9.3 |  |  | 7.4 |  |  | 9.4 |  |  | 5.2 |  |  | 2.8 |  |  | 7.3 |  |  | 6.2
 | Total portfolio |  |  | 4.7 |  |  | 4.3 |  |  | 4.6 |  |  | 4.6 |  |  | 4.5 |  |  | 4.5 |  |  | 4.5 |  |  | 4.3 |  |  | 4.6 |  |  | 4.4
REALIZED CAPITAL GAINS AND LOSSES
(PRE-TAX) BY TRANSACTION TYPE
 | Impairment write-downs |  | $ | -54 |  | $ | -43 |  | $ | -49 |  | $ | -39 |  | $ | -122 |  | $ | -190 |  | $ | -70 |  | $ | -114 |  | $ | -185 |  | $ | -496
 | Change in intent write-downs |  |  | 0 |  |  | -3 |  |  | -1 |  |  | -44 |  |  | -2 |  |  | -13 |  |  | -16 |  |  | -69 |  |  | -48 |  |  | -100
 | Net other-than-temporary impairment
 |  | losses recognized in earnings |  | -54 |  |  | -46 |  |  | -50 |  |  | -83 |  |  | -124 |  |  | -203 |  |  | -86 |  |  | -183 |  |  | -233 |  |  | -596
 | Sales |  |  | 261 |  |  | -24 |  |  | 70 |  |  | 229 |  |  | 220 |  |  | 692 |  |  | 141 |  |  | 283 |  |  | 536 |  |  | 1336
 | Valuation of derivative instruments |  |  | -12 |  |  | 0 |  |  | -10 |  |  | 11 |  |  | -9 |  |  | -254 |  |  | -50 |  |  | 22 |  |  | -11 |  |  | -291
 | Settlements of derivative instruments |  |  | 9 |  |  | -2 |  |  | 17 |  |  | 11 |  |  | -33 |  |  | 20 |  |  | -3 |  |  | -89 |  |  | 35 |  |  | -105
 | EMA limited partnership income (1) |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 32 |  |  | 9 |  |  | 55 |  |  | 63 |  |  | 0 |  |  | 159
 | Total |  | $ | 204 |  | $ | -72 |  | $ | 27 |  | $ | 168 |  | $ | 86 |  | $ | 264 |  | $ | 57 |  | $ | 96 |  | $ | 327 |  | $ | 503
TOTAL RETURN ON INVESTMENT PORTFOLIO (3) |  |  |  | 1.1 | % |  | 2.4 | % |  | 1.8 | % |  | 2 | % |  | 1.8 | % |  | 1.1 | % |  | 2.2 | % |  | 1.5 | % |  | 7.3 | % |  | 6.6 | %
AVERAGE INVESTMENT BALANCES (in billions) (4) |  |  | $ | 92.2 |  | $ | 92.9 |  | $ | 93.2 |  | $ | 93.1 |  | $ | 93.9 |  | $ | 96 |  | $ | 97.4 |  | $ | 98.5 |  | $ | 92.7 |  | $ | 96.3
(1) | Income from EMA limited partnerships is reported in net investment income in 2012 and realized capital gains and losses in 2011.
(2) | Pre-tax yields are calculated as annualized investment income (including dividend income in the case of equity securities) divided by the average of investment balances at the end of each quarter during the year.  Investment balances, for purposes of the pre-tax yield calculation, exclude unrealized capital gains and losses.  EMA limited partnership interests are included in the 2012 yields since their 2012 income is reported in net investment income.
(3) | Total return on investment portfolio is calculated from GAAP results including the total of net investment income, realized capital gains and losses, the change in unrealized net capital gains and losses, and the change in the difference between fair value and carrying value of mortgage loans and cost method limited partnerships, divided by the average investment balances.
(4) | Average investment balances for the quarter are calculated as the average of the current and prior quarter investment balances. Year-to-date average investment balances are calculated as the average of investment balances at the beginning of the year and the end of each quarter during the year.  For purposes of the average investment balances calculation, unrealized capital gains and losses are excluded.