I was looking though some retention websites, and i eventually found the formula for Bonus Payout, but it makes no sense to me. can anyone help me out with a simplified formula? i've been in for 4 years and 7 months, i'm an E-5 and i'm looking to re-enlist for 6 years at a 1.5 bonus in the B zone. can anyone help me??
A while back, I snagged an SRB calculator in excel format, had all the formulas programed in for Deployed vs Non Deployed bonus amounts. Had a small section for calculating sold leave days as well. Sadly it's outdated and does not reflect the current pay scale. I didn't create it, so I have no clue on how to update it. If any excel gurus want to have a crack at updating it, I can dig it up.
Posts: 59 | Location: NTC | Registered: 12 February 2004
So I'm going through this Excel bonus calculator... aaaaaand I'm lost. I don't understand some of the things, like "Date after old ETS". What's that all about?
Posts: 1127 | Location: Ft. Sill, OK | Registered: 11 February 2005
Originally posted by nckwnchstr: i've been in for 4 years and 7 months, i'm an E-5 and i'm looking to re-enlist for 6 years at a 1.5 bonus in the B zone. can anyone help me??
You're not in the B Zone yet. You're in the A Zone (17 months to 6 years active service).
Your multiplier is 1A, not 1.5B.
Your maximum bonu payment is $10,000.
If you reenlisted for the following years, you'd receive approximately:
4 Years = $5,500 5 Years = $7,500 6 Years = $9,750