BRS Lump Sum Calculations
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
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.00
2017 High 3 Retired Pay
$41,520.00
5
Retires at age 38
29 years until 67 (FRA)
Retires at age 42
25 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
AgeInflation
Annual Pension (No Lump Sum)
Annual Pension (50% Lump Sum)
Annual Pension (25% Lump Sum)
AgeInflation
Annual 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
Loading...
 
 
 
Sheet1