James-Day

Appendix B-E reproduction

Generated by appendix_calculations.py from the paper’s stated assumptions (Appendices A-D). Each figure is recomputed and compared with the value printed in analysis/research-paper.pdf (revision 16). Cents are compared where the paper prints cents; otherwise whole dollars.

Result: 56 of 56 figures match.

Figure Computed Printed Match Where
Civilian adjusted compensation 305,005.33 305,005.33 yes App. B, C
Civilian modeled taxes 149,989.96 149,989.96 yes App. C
PV of adjusted gaps at 5% 557,014.21 557,014.21 yes App. B, D
PV of gross gaps, 10 years 1,349,196.04 1,349,196.04 yes App. B, D; Results
PV of gross gaps, first 4 years 636,208.84 636,208.84 yes App. B; Results
Year-1 Navy federal tax 28,988.80 28,989.00 yes App. C
Year-1 Navy California tax 11,566.56 11,567.00 yes App. C
Year-1 Navy payroll tax 14,513.58 14,514.00 yes App. C
Year-1 Navy total tax 55,068.94 55,068.94 yes App. C
Year-1 civilian federal tax 89,506.24 89,506.00 yes App. C
Year-1 civilian California tax 34,539.14 34,539.00 yes App. C
Year-1 civilian payroll tax 25,944.58 25,945.00 yes App. C
Year-1 Navy value 227,548.82 227,548.82 yes App. C
Year-1 difference 77,456.51 77,456.51 yes App. C
High-3 basic pay 125,685.60 125,685.60 yes App. D
Annual BRS pension 50,274.24 50,274.24 yes App. D
Pension PV, untaxed 733,228.13 733,228.13 yes App. D; Results
Pension PV, 32% tax 498,595.13 498,595.13 yes App. D
Net value, gross basis -615,967.91 -615,967.91 yes App. D, D1; Results
Net value, adjusted -58,419.08 -58,419.08 yes App. D, D1, E; Results
Retiree health PV 62,273.31 62,273.31 yes App. D
D1: add retiree health 3,854.23 3,854.00 yes App. D1
Navy state income tax PV 94,602.25 94,602.25 yes App. D
D1: add no-income-tax domicile 98,456.49 98,456.00 yes App. D1; Results
Continuation pay amount 23,550.00 23,550.00 yes App. A
Continuation pay PV after tax 16,351.50 16,351.50 yes App. D
D1: add continuation pay 114,807.98 114,808.00 yes App. D1; Results
Later civilian pay after penalty 436,104.15 436,104.15 yes App. D
Later pay penalty PV 85,736.06 85,736.06 yes App. D
D1: add 5% later pay penalty 29,071.92 29,072.00 yes App. D1; Results
E: pension discount 5% -234,384.35 -234,384.00 yes App. E; Policy
E: civilian salary $400,000 201,024.79 201,025.00 yes App. E
E: civilian salary $350,000 436,421.88 436,422.00 yes App. E
E: pension tax 41.3% -126,609.30 -126,609.00 yes App. E; Policy
Table B1 year 1: Navy gross 276,965.76 276,966.00 yes App. B
Table B1 year 1: Navy tax 55,068.94 55,069.00 yes App. B
Table B1 year 1: Navy value 227,548.82 227,549.00 yes App. B
Table B1 year 1: Civilian gap 77,456.51 77,457.00 yes App. B
Table B1 year 3: Navy gross 282,585.36 282,585.00 yes App. B
Table B1 year 3: Navy tax 56,909.36 56,909.00 yes App. B
Table B1 year 3: Navy value 231,608.98 231,609.00 yes App. B
Table B1 year 3: Civilian gap 73,396.35 73,396.00 yes App. B
Table B1 year 5: Navy gross 286,498.56 286,499.00 yes App. B
Table B1 year 5: Navy tax 58,190.93 58,191.00 yes App. B
Table B1 year 5: Navy value 234,436.27 234,436.00 yes App. B
Table B1 year 5: Civilian gap 70,569.06 70,569.00 yes App. B
Table B1 year 7: Navy gross 288,744.96 288,745.00 yes App. B
Table B1 year 7: Navy tax 58,926.62 58,927.00 yes App. B
Table B1 year 7: Navy value 236,059.30 236,059.00 yes App. B
Table B1 year 7: Civilian gap 68,946.04 68,946.00 yes App. B
Table B1 year 9: Navy gross 290,044.56 290,045.00 yes App. B
Table B1 year 9: Navy tax 59,352.24 59,352.00 yes App. B
Table B1 year 9: Navy value 236,998.26 236,998.00 yes App. B
Table B1 year 9: Civilian gap 68,007.08 68,007.00 yes App. B
Break-even, gross (years) 14.27 14.27 yes App. D; Results
Break-even, adjusted (years) 10.90 10.90 yes App. D; Results