{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Investment Projections"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Investment Projections","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"merged":[[0,0,0,6],[2,1,8,5],[9,1,10,5],[12,2,12,5],[24,2,24,3],[30,2,30,5],[52,1,53,5]],"flags":["formulas_cached_only"]}
["Investment Projections"]
[]
[null,"You can use the following worksheets to help you plan and meet your investment goals:\n• Section 1: projects the value of an investment after a specified number of annual payments.\n• Section 2: determines the amount of time needed to reach a specified investment goal.\n• Section 3: calculates the monthly payment needed to reach a specified investment goal over a given period of time\n\nEnter values in the yellow cells, replacing the sample data. Results will be shown in the green cells."]
[]
[]
[]
[]
[]
[]
[null,"Important: These worksheets provide rough estimates only. They are not intended for commercial use. Check with your investment counselor for more detailed information."]
[]
[]
[null,null,"Section 1: How much will my investment be worth?"]
[]
[null,null," Interest or dividend rate per period (e.g., 8.25)",{"v":0.0825,"d":"8.25%"},null,"Use this worksheet to find how much a "]
[null,null," Number of periods",20,null,"a series of regular investments – for "]
[null,null," Amount of each investment",{"v":250,"d":"$250.00"},null,"example, an annual contribution to an  "]
[null,null," Initial value*",{"v":0,"d":"$0.00"},null,"IRA – will earn over a specified number"]
[null,null," Total payments",{"v":5000,"d":"$5,000.00"},null,"of investment periods at a constant rate"]
[null,null," Total interest",{"v":6762.284938634437,"d":"$6,762.28"},null,"of return, compounded. On this worksheet,"]
[null,null," Total value of investment, before taxes",{"v":11762.284938634437,"d":"$11,762.28"},null,"\"period\" can mean year, month, or quarter,"]
[null,null," Tax bracket (percent – e.g., 28)",{"v":0.28,"d":"28%"},null,"assuming one equal investment payment"]
[null,null," Total taxes",{"v":1893.4397828176425,"d":"$1,893.44"},null,"each period, with compounding based on "]
[null,null," Net value of investment, after taxes",{"v":9868.845155816794,"d":"$9,868.85"},null,"the same period. Note that if you base this"]
[null,null,"* Amount, if any, on balance prior to your first periodic payment.",null,null,"calculation on a period other than a year, "]
[null,null,"you must make sure the interest or dividend rate is expressed in terms of the same period. For example, if"]
[null,null,"your investment period is a month and your annual return is 9.00 percent, your periodic return will be "]
[null,null,"9.00/12, or 0.75."]
[null,null," "]
[]
[null,null,"Section 2: How long will it take to reach my goal?"]
[]
[null,null," Goal (total amount I'd like to have)",{"v":250000,"d":"$250,000.00"},null,"Set an investment goal – an amount you'd"]
[null,null," Amount of each monthly investment",{"v":1000,"d":"$1,000.00"},null,"like to achieve – and calculate how long it"]
[null,null," Annual percentage rate of return (e.g., 11.25)",{"v":0.1125,"d":"11.25%"},null,"will take to reach your goal, assuming"]
[null,null," Number of years required",{"v":10.779932266350983,"d":"10.78"},null,"– A constant rate of return"]
[{"$nulls":5},"– A regular monthly investment"]
[{"$nulls":5},"– Reinvestment of all interest or dividend"]
[{"$nulls":5},"   earnings"]
[]
[]
[null,null,"Section 3: How much do I need to invest each month?"]
[]
[null,null," Goal (total amount I'd like to have)",{"v":250000,"d":"$250,000.00"},null,"Set an investment goal for a specific time"]
[null,null," Number of years",10,null,"in the future, and calculate how much you"]
[null,null," Annual percentage rate of return (e.g., 7.95)",{"v":0.0795,"d":"7.95%"},null,"need to invest each month to reach your"]
[null,null," Monthly contribution required",{"v":1370.3388805740892,"d":"$1,370.34"},null,"goal, assuming:"]
[{"$nulls":5},"– A constant rate of return"]
[{"$nulls":5},"– Reinvestment of all interest or dividend"]
[{"$nulls":5},"   earnings"]
[]
[]
[null,"This worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password."]