{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Instructions","Calculator"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"merged":[[1,1,1,4],[14,1,14,10]],"flags":["formulas_cached_only"]}
[]
[null,"What This Spreadsheet Tells You"]
[null,"Suppose Jim has been contributing 6 percent of his gross income to his 401(k) at work."]
[null,"This coming year, he wishes to begin saving 10 percent of his gross income, but he wants to keep saving"]
[null,"the current 6 percent in his 401(k), and make up the 4 percent difference by contributing to a"]
[null,"separate retirement account (for example, a Roth IRA)."]
[]
[null,"This spreadsheet tells Jim what monthly contribution he needs to make to his Roth IRA in order to"]
[null,"reach his goal of saving 10 percent of his gross income."]
[]
[null,"Using the example figures given, Jim would need to continue his 401(k) contributions as before (8%), and"]
[null,"fund his Roth IRA with an additional $111.05 per month.  By doing so, he would be saving approximately"]
[null,"10 percent of his gross income."]
[]
[null,"Instructions"]
[null,"Boxes requiring inputs are marked with a yellow background."]
[]
[null,1,"Enter the percentage of your gross (pre-tax) income you wish to save in the upcoming year."]
[null,2,"Enter your gross income from the previous year."]
[null,3,"Enter the percentage of your gross income you saved the previous year."]
[null,4,"Enter your expected gross income for the upcoming year."]
[null,5,"Enter the amount you have already contributed to your savings this year, if any."]
[null,6,"Enter the number of full months remaining in the current / upcoming year."]
[null,7,"Enter your expected income tax rate for the current year."]
[]
[]
[null,"The spreadsheet is set up to get you to your desired savings percentage in regard to the current year,"]
[null,"no matter how much of it has passed.  In other words, it allows you to play \"catch up\" for the current year.  "]
[]
[null,"If you wish to simply begin saving your desired percentage from this point on, then enter a value"]
[null,"of \"0\" (zero) for Question 5, and a value of \"12\" (twelve) for Question 6."]

{"sheet":"Calculator","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["Savings Contribution Calculator"]
[]
[null,"Percentage of Your Gross Income You Wish to Save This Year:",1,{"v":0.1,"d":"10.0%"}]
[null,"Previous Year's Gross Income:",2,{"v":57092,"d":"$57,092.00"}]
[null,"Previous Year % Of Gross Income You Saved (in 401k, IRAs, etc.):",3,{"v":0.08,"d":"8.0%"}]
[null,"Expected Gross Income This Year:",4,{"v":59000,"d":"$59,000.00"}]
[null,"Funds Already Contributed to Savings This Year:",5,0]
[null,"Full Months Remaining This Year:",6,{"v":12,"d":"12.0"}]
[null,"Your Expected Income Tax Rate This Year:",7,{"v":0.25,"d":"25.0%"}]
[]
[null,"Previous Year $ Saved (by Percentage):",null,{"v":4567.36,"d":"$4,567.36"}]
[null,"Previous Year Monthly $ Saved:",null,{"v":380.6133333333333,"d":"$380.61"}]
[]
[null,"New Yearly $ To Be Saved (Total, by Percentage):",null,{"v":5900,"d":"$5,900.00"}]
[null,"New Yearly $ To Be Saved (In Addition to Already Contributed):",null,{"v":5900,"d":"$5,900.00"}]
[null,"New Monthly $ To Be Saved:",null,{"v":491.6666666666667,"d":"$491.67"}]
[]
[null,"Additional Savings Contribution Necessary (Monthly):",null,{"v":111.0533333333334,"d":"$111.05"}]
[null,"Additional Savings Contribution Necessary (Rest of This Year):",null,{"v":1332.6400000000008,"d":"$1,332.64"}]
[null,"Monthly Savings If Doing This In a Pre-Tax Retirement Acct.:",null,{"v":27.76333333333335,"d":"$27.76"}]