Tuesday, January 22, 2013

20YRS. 1988-2007, 20YRS 1989-2008 & 1988-2011 24 YEARS OF SANTA BARBARA COUNTY'S ECONOMIC ASSUMPTIONS v. ACTUAL (SBCERS) PENSION FUND PERFORMANCE 1988-2007

Take a look at the Pension Growth graph below and how it represents the 8.16% Actuarial Rate nice and smooth. The reason I like the graph so much is because it is simple. It is just a smooth growth that does not care about assumption or Inflation factors. It all actuality that 8.16% is the all inclusive number, so why are the pension audits an the explanations that people give about them always trying to lose us with additional numbers and factors?






 Look at the 20 Net Return on Assets picture above to the right that shows a annual 10.10% return on investments. If that data was added to the graph on the left the line representing 10.10%  it would show that 600 million dollars more was earned for the pension than the 8.16%. Then if you add some more money because of the unfunded future pension obligations (UAAL) like I did the pension should have earned a billion dollars more than the 8.16% would have. I have made my own work sheet showing the differences between Santa Barbara County's Pension Assumptions and the SBCERS Pensions Actual Performances.


Now I included three graphs that I made this weekend. In all three examples the Red line is the desired or assumption rate growth the County desired, nice and smooth. But you have to remember if this benchmark is met the pension should then be properly funded depending on the beginning funding level.

The Pink line represents the actual net return on assets earned by the pension which was greater than the desired rate (Red) in all three graphs. 

The third Blue line takes into account that the County has represented additional contributions were required because of a constant unfunded future pension obligations (UAAL). By averaging the yearly additional contributions made because of the pension deficit then dividing that number by 12. You get a monthly deposit amount in addition to the multiplied rate 10.10% multiplied by the number of years (20) in a given period. Now in order to show how the monthly deposits affect the funds growth above the actual return rate I added the two factors together. So for example the chart below looks like this starting value of $270,540,000 but adding a monthly for 20 years (H) deposit of 580,000 X 10.10% this would be equal to an ending value of $2.37 billion dollars. Or another way to show this would be 270,540,000 X 11.16% (10.10 plus the effect of the additional contributions)(E) X 20 years is equal the same  $2.37 billion dollars.

Regardless of how complicated and confusing my explanation is the bottom line is this. In each graph below the pension funds value ( Pink or Blue) is always greater than the assumption (Red) rate by as much as a billion dollars. You cannot earn more than you wanted, contribute more than you had too, and have your Inflation factor below what you anticipated and have any type of deficit, it is mathematically impossible. So I hope you can understand why I have been working so hard on challenging what the real status of the SBCERS pension fund should be.


I have two other work sheets showing assumptions v. actual earned return average. 1989-2008 9.6% represents the 20 YEAR NET RETURN ON ASSETS and 1988-2011 8.5% represents 24 YEARS of NET RETURN ON ASSETS both sheets can be found further down this posting.



20 YEARS OF SANTA BARBARA COUNTY'S ECONOMIC ASSUMPTIONS
v. ACTUAL (SBCERS) PENSION FUND PERFORMANCE 1988-2007

Valuation Date
(A) Earnings Rate Assumption
(B) CPI Inflation Assumption
 (C )Rate Of Return Assumption 
(D)UAAL
(unfunded actuarial accrued liability)
12/31/88
8.50%
5.50%
3.00%
3.18%
12/31/90
8.50%
5.50%
3.00%
4.61%
12/31/92
8.25%
5.00%
3.25%
4.72%
12/31/94
8.00%
4.75%
3.25%
6.06%
12/31/95
8.00%
4.75%
3.25%
8.12%
12/31/96
8.00%
4.75%
3.25%
5.20%
12/31/97
8.00%
4.75%
3.25%
6.08%
12/31/98
8.00%
4.75%
3.25%
1.03%
12/31/99
8.00%
4.75%
3.25%
-0.09%
12/31/00
8.00%
4.50%
3.50%
0.08%
12/31/02
8.00%
4.50%
3.50%
2.29%
6/30/03
8.00%
4.50%
3.50%
3.65%
6/30/04
8.00%
4.50%
3.50%
6.63%
6/30/05
8.00%
4.50%
3.50%
8.40%
6/30/06
8.00%
4.00%
4.00%
9.29%
6/30/07
8.16%
3.50%
4.66%
11.74%
Assumptions Averaged over 20 Years

8.15% AVG. (A)
4.75%AVG.(B)
3.40%AVG.(C)
A-B=C
4.02%AVG.(D)
Actual Pension Performance Out Earns 20 Year Assumption Average By More Than One Billion Dollars. See examples under chart
Actual 20 Year (E) Average Return on Assets 10.10%
20% Greater Than Assumption
Actual 20 Year (F)
CPI Index Averaged
3.10%
35%
Lower Than Assumption

(G)Real Rate of Return Earned
7.00%
51.5% Greater
Than Assumption
E-F = G
(H)  UAAL Average Monthly Cost
7 Million a Year
 580,000.00 (F)
A Month Deposit/Payment

1-Using assumption factor; $270,540,000 X 8.15% (A) X 20 years = $ 1.34 billion dollars.
2- Using Actual Performance Factor; $270,540,000 X 10.10% (E.) X 20 years = $1.94 billion dollars,
3-Same as example 2 plus a monthly deposit; Again a starting value of $270,540,000 but adding a monthly (H) deposit of 580,000 X 10.10% which is to earning 11.16% (E) X 20 years = $2.37 billion dollars.

America how are our pensions earning more than they wanted (8.16%), contributing more than the normal rate( 4.02%) of County's yearly payroll for the entire 20 year period 1988-2007 and claim to have a Billion dollar unfunded deficit? I have just done the math that shows a Billion dollar surplus would have been earned, look at the graph below. WAKE UP AMERICA!




















The other work sheets  9.6% represents the 20 YEAR NET RETURN ON ASSETS 1989-2008 

20 YEARS OF SANTA BARBARA COUNTY'S ECONOMIC ASSUMPTIONS


v. ACTUAL (SBCERS) PENSION FUND PERFORMANCE 1989-2008




Valuation Date
(A) Earnings Rate Assumption
(B) CPI Inflation Assumption
 (C )Rate Of Return Assumption 
(D)UAAL
(unfunded actuarial accrued liability)
12/31/89
8.50%
5.50%
3.00%
3.18%
12/31/90
8.50%
5.50%
3.00%
4.61%
12/31/92
8.25%
5.00%
3.25%
4.72%
12/31/94
8.00%
4.75%
3.25%
6.06%
12/31/95
8.00%
4.75%
3.25%
8.12%
12/31/96
8.00%
4.75%
3.25%
5.20%
12/31/97
8.00%
4.75%
3.25%
6.08%
12/31/98
8.00%
4.75%
3.25%
1.03%
12/31/99
8.00%
4.75%
3.25%
-0.09%
12/31/00
8.00%
4.50%
3.50%
0.08%
12/31/02
8.00%
4.50%
3.50%
2.29%
6/30/03
8.00%
4.50%
3.50%
3.65%
6/30/04
8.00%
4.50%
3.50%
6.63%
6/30/05
8.00%
4.50%
3.50%
8.40%
6/30/06
8.00%
4.00%
4.00%
9.29%
6/30/07
8.16%
3.50%
4.66%
11.74%
6/30/08
8.16%
3.50%
4.66%
9.10%
Assumptions Averaged over 20 Years

8.10% AVG. (A)
4.65%AVG.(B)
3.50%AVG.(C)
A-B=C
4.31%AVG.(D)
Actual Pension Performance Out Earns 20 Year Assumption Average By More Than 900 Million Dollars. See examples under chart
Actual 20 Year (E) Average Return on Assets 9.60%
15% Greater Than Assumption
Actual 20 Year (F)
CPI Index Averaged
3.10%
33%
Lower Than Assumption

(G)Real Rate of Return Earned
6.50%
46% Greater
Than Assumption
E-F = G
(H)  UAAL Average Monthly Cost
8 Million a Year
 666,000.00 (F)
A Month Deposit/Payment

1-Using assumption factor; $293,038,000 X 8.10% (A) X 20 years = $ 1.44 billion dollars.
2- Using Actual Performance Factor; $293,038,000 X 9.60% (E.) X 20 years = $1.91 billion dollars,
3-Same as example 2 plus a monthly deposit; Again a starting value of $270,540,000 but adding a monthly (H) deposit of 666,000 X 9.60% which is equal to earning 10.75% (E) X 20 years = $2.38 billion dollars.
 See the graph below




















1988-2011 8.5% represents 24 YEARS of NET RETURN ON ASSETS 
SBCERS 24 YEARS of ECONOMIC ASSUMPTIONS
v. ACTUAL PENSION FUND PERFORMANCE 1988-2011
Valuation Date
(A) Earnings Rate Assumption
(B) CPI Inflation Assumption
 (C )Rate Of Return Assumption 
(D)UAAL
(unfunded actuarial accrued liability)
12/31/88
8.50%
5.50%
3.00%
3.18%
12/31/90
8.50%
5.50%
3.00%
3.18%
12/31/92
8.25%
5.00%
3.25%
4.72%
12/31/94
8.00%
4.75%
3.25%
6.06%
12/31/95
8.00%
4.75%
3.25%
8.12%
12/31/96
8.00%
4.75%
3.25%
5.20%
12/31/97
8.00%
4.75%
3.25%
6.08%
12/31/98
8.00%
4.75%
3.25%
1.03%
12/31/99
8.00%
4.75%
3.25%
-0.09%
12/31/00
8.00%
4.50%
3.50%
0.08%
12/31/02
8.00%
4.50%
3.50%
2.29%
06/30/03
8.00%
4.50%
3.50%
3.65%
06/30/04
8.00%
4.50%
3.50%
6.63%
06/30/05
8.00%
4.50%
3.50%
8.40%
06/30/06
8.00%
4.00%
4.00%
9.29%
06/30/07
8.16%
3.50%
4.66%
11.74%
06/30/08
8.16%
3.50%
4.66%
9.10%
06/30/09
8.16%
3.50%
4.66%
14.67%
06/30/10
7.75%
3.25%
4.50%
16.00%
06/30/11
7.75%
3.25%
4.50%
16.00%





Assumptions Averaged over 24 Years

8.10% AVG. (A)
4.50%AVG.(B)
3.60%AVG.(C)
A-B=C
6.02%AVG.(D)
Actual Pension Performance Out Earns 24 Year Assumption Average By More Than One Billion Dollars. See examples under chart
Actual 24 Year (E) Average Return on Assets 8.50%
5% Greater Than Assumption
Actual 24 Year (F)
CPI Index Averaged
2.90%
35%
Lower Than Assumption

(G)Real Rate of Return Earned
5.60%
45% Greater
Than Assumption
E-F = G
(H)  UAAL Average Monthly Cost
13 Million a Year
 1,008,000. (F)
A Month Deposit/Payment

1-Using Assumption Factor; $270,540,000 X 8.10% (A) X 24 years = $ 1.82 Billion dollars.
2- Using Actual Performance Factor; $270,540,000 X 8.50% (E.) X 24 years = $1.99 Billion dollars,
3-Same as example 2 plus a monthly deposit; Again a starting value of $270,540,000 but adding a monthly (F) deposit of 1,008,000 X 8.50% which is equal to earning 9.79% (E) X 24 years = $2.68 Billion dollars. 
See the graph below


















S.B.C.C.C. The place where COMMON SENSE never goes out of style!

No comments: