From http://www.socialsecurity.gov/OACT/COLA/piaformula.html
There is this paragraph;
For an individual who first becomes eligible for old-age insurance
benefits or disability insurance benefits in 2008, or who dies in 2008
before becoming eligible for benefits, his/her PIA will be the sum of:
(a) 90 percent of the first $711 of his/her average indexed monthly
earnings, plus
(b) 32 percent of his/her average indexed monthly earnings over
$711 and through $4,288, plus
(c) 15 percent of his/her average indexed monthly earnings over
$4,288.
I would like to write a single line to take the income (shown in an
adjacent cell) and produce the benefit based on this rule. I'm sure it's
simple, but I am having a brain freeze. Would someone be so kind as to
help me?
Joe
www.blog.joetaxpayer.com
|
