ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
E-7 20 Year BRS PensionO-5 20 Year BRS Pension
2
These spreadsheets are provided as is, without warranty of any kind, and only for information purposes.These spreadsheets are provided as is, without warranty of any kind, and only for information purposes.
3
This calculator assumes the servicemember retires in 2017 and what the lump sum would look like in effect today.This calculator assumes the servicemember retires in 2017 and what the lump sum would look like in effect today.
4
2017 High 3 Retired Pay$21,600.002017 High 3 Retired Pay$41,520.00
5
Retires at age 3829 years until 67 (FRA)Retires at age 4225 years until 67 (FRA)
6
DoD Discount Rate7.30%50% Lump Sum25% Lump SumDoD Discount Rate7.30%50% Lump Sum25% Lump Sum
7
Annuity Present Value (Until Age 67)$348,908.80$174,454.40$87,227.20Annuity Present Value (Until Age 67)$618,264.06$309,132.03$154,566.02
8
9
AgeInflationAnnual Pension (No Lump Sum)Annual Pension (50% Lump Sum)Annual Pension (25% Lump Sum)AgeInflationAnnual Pension (No Lump Sum)Annual Pension (50% Lump Sum)Annual Pension (25% Lump Sum)
10
383%$21,600.00$10,800.00$16,200.00423%$41,520.00$20,760.00$31,140.00
11
393%$22,248.00$11,124.00$16,686.00433%$42,765.60$21,382.80$32,074.20
12
403%$22,915.44$11,457.72$17,186.58443%$44,048.57$22,024.28$33,036.43
13
413%$23,602.90$11,801.45$17,702.18453%$45,370.03$22,685.01$34,027.52
14
423%$24,310.99$12,155.50$18,233.24463%$46,731.13$23,365.56$35,048.34
15
433%$25,040.32$12,520.16$18,780.24473%$48,133.06$24,066.53$36,099.79
16
443%$25,791.53$12,895.76$19,343.65483%$49,577.05$24,788.53$37,182.79
17
453%$26,565.28$13,282.64$19,923.96493%$51,064.36$25,532.18$38,298.27
18
463%$27,362.23$13,681.12$20,521.68503%$52,596.29$26,298.15$39,447.22
19
473%$28,183.10$14,091.55$21,137.33513%$54,174.18$27,087.09$40,630.64
20
483%$29,028.59$14,514.30$21,771.45523%$55,799.41$27,899.70$41,849.56
21
493%$29,899.45$14,949.73$22,424.59533%$57,473.39$28,736.70$43,105.04
22
503%$30,796.44$15,398.22$23,097.33543%$59,197.59$29,598.80$44,398.19
23
513%$31,720.33$15,860.16$23,790.25553%$60,973.52$30,486.76$45,730.14
24
523%$32,671.94$16,335.97$24,503.95563%$62,802.73$31,401.36$47,102.04
25
533%$33,652.10$16,826.05$25,239.07573%$64,686.81$32,343.40$48,515.11
26
543%$34,661.66$17,330.83$25,996.24583%$66,627.41$33,313.71$49,970.56
27
553%$35,701.51$17,850.75$26,776.13593%$68,626.23$34,313.12$51,469.68
28
563%$36,772.55$18,386.28$27,579.42603%$70,685.02$35,342.51$53,013.77
29
573%$37,875.73$18,937.87$28,406.80613%$72,805.57$36,402.79$54,604.18
30
583%$39,012.00$19,506.00$29,259.00623%$74,989.74$37,494.87$56,242.30
31
593%$40,182.36$20,091.18$30,136.77633%$77,239.43$38,619.72$57,929.57
32
603%$41,387.83$20,693.92$31,040.88643%$79,556.61$39,778.31$59,667.46
33
613%$42,629.47$21,314.73$31,972.10653%$81,943.31$40,971.66$61,457.48
34
623%$43,908.35$21,954.18$32,931.26663%$84,401.61$42,200.81$63,301.21
35
633%$45,225.60$22,612.80$33,919.20Sum$1,513,788.65$756,894.33$1,135,341.49
36
643%$46,582.37$23,291.19$34,936.78
37
653%$47,979.84$23,989.92$35,984.88
38
663%$49,419.24$24,709.62$37,064.43
39
Sum$976,727.16$488,363.58$732,545.37
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100