2024 BRS Lump Sum Calculations

	A	B	C	D	E	G	H	I	J	K
1	E-7 20 Year BRS Pension					O-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 2024 and what the lump sum would look like in effect today.					This calculator assumes the servicemember retires in 2024 and what the lump sum would look like in effect today.
4	2024 High 3 Retired Pay Est.	$26,682.24				2024 High 3 Retired Pay Est.	$50,322.72
5	Retires at age 38	29 years until 67 (FRA)				Retires at age 42	25 years until 67 (FRA)
6	2024 DoD Discount Rate	6.26%		50% Lump Sum	25% Lump Sum	2024 DoD Discount Rate	6.26%		50% Lump Sum	25% Lump Sum
7	Annuity Present Value (Until Age 67)		$486,915.50	$243,457.75	$121,728.88	Annuity Present Value (Until Age 67)		$835,317.92	$417,658.96	$208,829.48
8
9	Age	Inflation	Annual Pension (No Lump Sum)	Annual Pension (50% Lump Sum)	Annual Pension (25% Lump Sum)	Age	Inflation	Annual Pension (No Lump Sum)	Annual Pension (50% Lump Sum)	Annual Pension (25% Lump Sum)
10	38	3%	$26,682.24	$13,341.12	$20,011.68	42	3%	$50,322.72	$25,161.36	$37,742.04
11	39	3%	$27,482.71	$13,741.35	$20,612.03	43	3%	$51,832.40	$25,916.20	$38,874.30
12	40	3%	$28,307.19	$14,153.59	$21,230.39	44	3%	$53,387.37	$26,693.69	$40,040.53
13	41	3%	$29,156.40	$14,578.20	$21,867.30	45	3%	$54,988.99	$27,494.50	$41,241.75
14	42	3%	$30,031.10	$15,015.55	$22,523.32	46	3%	$56,638.66	$28,319.33	$42,479.00
15	43	3%	$30,932.03	$15,466.01	$23,199.02	47	3%	$58,337.82	$29,168.91	$43,753.37
16	44	3%	$31,859.99	$15,929.99	$23,894.99	48	3%	$60,087.96	$30,043.98	$45,065.97
17	45	3%	$32,815.79	$16,407.89	$24,611.84	49	3%	$61,890.60	$30,945.30	$46,417.95
18	46	3%	$33,800.26	$16,900.13	$25,350.20	50	3%	$63,747.32	$31,873.66	$47,810.49
19	47	3%	$34,814.27	$17,407.14	$26,110.70	51	3%	$65,659.74	$32,829.87	$49,244.80
20	48	3%	$35,858.70	$17,929.35	$26,894.02	52	3%	$67,629.53	$33,814.76	$50,722.15
21	49	3%	$36,934.46	$18,467.23	$27,700.85	53	3%	$69,658.41	$34,829.21	$52,243.81
22	50	3%	$38,042.49	$19,021.25	$28,531.87	54	3%	$71,748.17	$35,874.08	$53,811.12
23	51	3%	$39,183.77	$19,591.88	$29,387.83	55	3%	$73,900.61	$36,950.31	$55,425.46
24	52	3%	$40,359.28	$20,179.64	$30,269.46	56	3%	$76,117.63	$38,058.81	$57,088.22
25	53	3%	$41,570.06	$20,785.03	$31,177.55	57	3%	$78,401.16	$39,200.58	$58,800.87
26	54	3%	$42,817.16	$21,408.58	$32,112.87	58	3%	$80,753.19	$40,376.60	$60,564.89
27	55	3%	$44,101.68	$22,050.84	$33,076.26	59	3%	$83,175.79	$41,587.89	$62,381.84
28	56	3%	$45,424.73	$22,712.36	$34,068.55	60	3%	$85,671.06	$42,835.53	$64,253.30
29	57	3%	$46,787.47	$23,393.73	$35,090.60	61	3%	$88,241.19	$44,120.60	$66,180.90
30	58	3%	$48,191.09	$24,095.55	$36,143.32	62	3%	$90,888.43	$45,444.21	$68,166.32
31	59	3%	$49,636.83	$24,818.41	$37,227.62	63	3%	$93,615.08	$46,807.54	$70,211.31
32	60	3%	$51,125.93	$25,562.97	$38,344.45	64	3%	$96,423.54	$48,211.77	$72,317.65
33	61	3%	$52,659.71	$26,329.85	$39,494.78	65	3%	$99,316.24	$49,658.12	$74,487.18
34	62	3%	$54,239.50	$27,119.75	$40,679.63	66	3%	$102,295.73	$51,147.86	$76,721.80
35	63	3%	$55,866.69	$27,933.34	$41,900.01		Sum	$1,834,729.35	$917,364.67	$1,376,047.01
36	64	3%	$57,542.69	$28,771.34	$43,157.01
37	65	3%	$59,268.97	$29,634.48	$44,451.72
38	66	3%	$61,047.04	$30,523.52	$45,785.28
39		Sum	$1,206,540.21	$603,270.11	$904,905.16
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