| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Assumptions | Notes | ||||
2 | Calculate in Today's dollars or Future dollars? | Future | Today | |||
3 | Inflation Rate | 3.50% | Future | |||
4 | Average Rate of Return on Investments | 6.00% | Note: Please provide a strict RoR number, ignoring inflation. If you chose to calculate in "Today" dollars, the formulas will compensate based on your inflation rate provided. | |||
5 | Starting Salary | $55,000 | Note: For ease of use, include expected bonuses | |||
6 | Avg. Annual Salary Increase | 0% | Note: Take into account whether or note you chose "Today" dollars or "Future Dollars". | |||
7 | 401k Contribution | 12% | Note: For ease of calculations, enter as a percentage of salary. The formula will set a ceiling of $17,500 (the IRS limit for 2013), so don't worry about going over. | |||
8 | 401k Match | 6% | Note: Enter this as a flat rate of your salary. Ex: If your employer matches half your contributions up to 6% of your salary, enter "3%". Calculations are going to assume that if you're contributing at all, you're contributing up to the match. | |||
9 | Profit Sharing | 0% | Note: Enter as a flat percentage of your salary. Ex: 3% | |||
10 | Spouse? | Yes | Yes | |||
11 | Spouse's Starting Salary | $52,000 | Note: For ease of use, include expected bonuses | No | ||
12 | Spouses Avg. Annual Salary Increase | 0% | Note: Take into account whether or note you chose "Today" dollars or "Future Dollars". | |||
13 | Spouses 401k Contribution | 25% | Note: For ease of calculations, enter as a percentage of salary. The formula will set a ceiling of $17,500 (the IRS limit for 2013), so don't worry about going over. | |||
14 | Spouses 401k Match | 2% | Note: Enter this as a flat rate of your salary. Ex: If your employer matches half your contributions up to 6% of your salary, enter "3%". Calculations are going to assume that if you're contributing at all, you're contributing up to the match. | |||
15 | Spouses Profit Sharing | 0% | Note: Enter as a flat percentage of your salary. Ex: 3% | |||
16 | Yearly Roth IRA Contributions | $5,500 | Note: If you have a spouse, enter the total combined amount | |||
17 | Yearly Taxable Account Contributions | $2,400 | Note: If you have a spouse, enter the total combined amount | |||
18 | Current 401k Total Balance | $75,400 | Note: If you have a spouse, enter the total combined amount | |||
19 | Current Roth IRA Total Balance | $55,000 | Note: If you have a spouse, enter the total combined amount | |||
20 | Current Taxable Account Balance | $0 | Note: If you have a spouse, enter the total combined amount | |||
21 | Current Overall Spending Requirement | $40,000 | Note: It's up to you whether you include mortgage expenses or not. Just take into consideration this choice later when looking at SWR | |||