Thanks MDM and Allen. So I plugged my numbers into the spreadsheet according to what I would like to do (Max my HSA, my Traditional IRA and husband's Roth IRA without touching my 403b because I can't afford it...). My taxes seem wonky. According to my most recent paystub, I am paying 216.64/mo State Tax and 249.38/mo Federal Tax. Are the numbers on the spreadsheet modified by my hypothetical plan to save more in the IRAs and HSA? I entered the Oregon State tax I paid in 2014, although the gross wages I am entering for 2015 will be less because I had a shift change and lost my shift differential. My total mortgage payment is actually 943/mo and I think it has something to do with escrow shortage, but I'm not sure how to account for that in the spreadsheet.
State taxes vary a lot. Some are straight percentages, some have multiple brackets, etc. With a brief glance at Oregon's, for your income range the calculation seems to be ($4,320 is the standard deduction, $16,300 is the beginning of the 9% bracket, and 5%*6500+7%*(16300-6500) is the tax for the lower brackets):
(Federal AGI - Federal Tax - $4,230)*9% + 5%*6500 + 7%*(16300-6500) - (No. of Exemptions) * $191.
In the spreadsheet, with 9% in cell H23, you could enter "=H23*(G5-D34-4320-16300)+5%*6500+7%*(16300-6500)-G9*191" in cell G23. You'll also have to enable iterations, because in theory the federal tax could depend on the state tax (if you itemize) and Oregon's state tax depends on your federal tax...or you could enter some estimate as you did.
The federal tax calculations are pretty good, and do reflect whatever you have input for IRA, HSA, etc. The amount withheld on your paycheck is determined by what you tell your employer on your W-4. If you change your IRA, HSA, etc., do change your W-4 also so you get the cash due you throughout the year.
The spreadsheet calculates "mortgage payment" as the principal plus interest you pay each month. This is the amount you stop paying when the mortgage is over. You might be including a property tax escrow, and maybe insurance, in your monthly payment to the loan holder. Those expenses will continue after the mortgage is paid and should be listed in separate lines on the spreadsheet. You might be undercounting the property tax...$180/yr seems very low...?
I also don't understand the "Time to FIre" Chart and calculations. Why is the "Stash needed @ Retirement" in parentheses and in red? What is the "Have $795,584 extra"? Why does the chart start at $400,000 at year 0? What does it all mean?!
Because you entered $25000/yr as "Income after RE (pension, SS, etc.)", and your "Non-loan, non-work expenses" are only $9,288/yr, the spreadsheet figures you already have more than enough (from a pension, SS, etc.) to retire and don't need any investment income. If you aren't counting on a pension, Soc. Sec., etc. then enter $0 for the "Income after RE."
With that change, it shows ~10 years until you have the $232,200 needed to cover $9,288 in annual expenses. That is a very low annual expense - great for you if true, but "user beware" if you have overlooked something.
Make sense? If not, post back.