Docstoc

Retirement Calculator (Online)

Document Sample
Retirement Calculator (Online) Powered By Docstoc
					#### Control

RETIREMENT SAVINGS CALCULATOR
Inputs Current Age: Retirement Age: Investments up to Now: Expected Annual Return: Annual Payments: # of Payments to be made: 1,200,000.00 35 58 10000 6.00 2,000.00 15 1,000,000.00 % 800,000.00 600,000.00 400,000.00 Outcome Years until Retirement: 23 Estimated Values at Retirement Invested Interest Earned 40,000.00 72,394.22 112,394.22 200,000.00
0.00

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Age 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

Rate 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%

Invested (Payment) 10,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Cumulative Payments 10,000.00 12,000.00 14,000.00 16,000.00 18,000.00 20,000.00 22,000.00 24,000.00 26,000.00 28,000.00 30,000.00 32,000.00 34,000.00 36,000.00 38,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00

Interest 0.00 600.00 756.00 921.36 1,096.64 1,282.44 1,479.39 1,688.15 1,909.44 2,144.00 2,392.65 2,656.20 2,935.58 3,231.71 3,545.61 3,878.35 4,231.05 4,484.91 4,754.01 5,039.25 5,341.60 5,662.10 6,001.83 6,361.94 6,743.65 7,148.27

Cumulative Interest 0.00 600.00 1,356.00 2,277.36 3,374.00 4,656.44 6,135.83 7,823.98 9,733.42 11,877.42 14,270.07 16,926.27 19,861.85 23,093.56 26,639.17 30,517.52 34,748.57 39,233.49 43,987.50 49,026.75 54,368.35 60,030.45 66,032.28 72,394.22 79,137.87 86,286.14

26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95

6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00

7,577.17 8,031.80 8,513.71 9,024.53 9,566.00 10,139.96 10,748.36 11,393.26 12,076.86 12,801.47 13,569.55 14,383.73 15,246.75 16,161.56 17,131.25 18,159.13 19,248.67 20,403.59 21,627.81 22,925.48 24,301.01 25,759.07 27,304.61 28,942.89 30,679.46 32,520.23 34,471.44 36,539.73 38,732.11 41,056.04 43,519.40 46,130.56 48,898.40 51,832.30 54,942.24

93,863.31 101,895.11 110,408.81 119,433.34 128,999.34 139,139.31 149,887.66 161,280.92 173,357.78 186,159.25 199,728.80 214,112.53 229,359.28 245,520.84 262,652.09 280,811.21 300,059.88 320,463.48 342,091.29 365,016.76 389,317.77 415,076.84 442,381.45 471,324.33 502,003.79 534,524.02 568,995.46 605,535.19 644,267.30 685,323.34 728,842.74 774,973.30 823,871.70 875,704.00 930,646.24

GS CALCULATOR

Balance Payments

Interest

Cumulative Interest 0.00 600.00 1,356.00 2,277.36 3,374.00 4,656.44 6,135.83 7,823.98 9,733.42 11,877.42 14,270.07 16,926.27 19,861.85 23,093.56 26,639.17 30,517.52 34,748.57 39,233.49 43,987.50 49,026.75 54,368.35 60,030.45 66,032.28 72,394.22 79,137.87 86,286.14

Balance 10,000.00 12,600.00 15,356.00 18,277.36 21,374.00 24,656.44 28,135.83 31,823.98 35,733.42 39,877.42 44,270.07 48,926.27 53,861.85 59,093.56 64,639.17 70,517.52 74,748.57 79,233.49 83,987.50 89,026.75 94,368.35 100,030.45 106,032.28 112,394.22 119,137.87 126,286.14

Payments 36%
Interest 64%

93,863.31 101,895.11 110,408.81 119,433.34 128,999.34 139,139.31 149,887.66 161,280.92 173,357.78 186,159.25 199,728.80 214,112.53 229,359.28 245,520.84 262,652.09 280,811.21 300,059.88 320,463.48 342,091.29 365,016.76 389,317.77 415,076.84 442,381.45 471,324.33 502,003.79 534,524.02 568,995.46 605,535.19 644,267.30 685,323.34 728,842.74 774,973.30 823,871.70 875,704.00 930,646.24

133,863.31 141,895.11 150,408.81 159,433.34 168,999.34 179,139.31 189,887.66 201,280.92 213,357.78 226,159.25 239,728.80 254,112.53 269,359.28 285,520.84 302,652.09 320,811.21 340,059.88 360,463.48 382,091.29 405,016.76 429,317.77 455,076.84 482,381.45 511,324.33 542,003.79 574,524.02 608,995.46 645,535.19 684,267.30 725,323.34 768,842.74 814,973.30 863,871.70 915,704.00 970,646.24

Follow the steps to enable your online Retirement Savings Calculator.
>> 1)

2)

3) >> >>

Your calculator is ready to use. Following steps are for online use. Vist the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password. Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. Click "Add Web Application" to upload this file. Your online calculator will be created automatically. You can simply use the calculator from that link or place it on your website. Your online Retirement Savings Calculator will look like: https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=6f9082a3-090b-4eb4-b5e2-e42864f37 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc., http://www.pagos.com/

a3-090b-4eb4-b5e2-e42864f37afa

Chart 1 Year Balance Payments Interest 0 10,000.00 10,000.00 0.00 1 12,600.00 12,000.00 600.00 2 15,356.00 14,000.00 1,356.00 3 18,277.36 16,000.00 2,277.36 4 21,374.00 18,000.00 3,374.00 5 24,656.44 20,000.00 4,656.44 6 28,135.83 22,000.00 6,135.83 7 31,823.98 24,000.00 7,823.98 8 35,733.42 26,000.00 9,733.42 9 39,877.42 28,000.00 11,877.42 10 44,270.07 30,000.00 14,270.07 11 48,926.27 32,000.00 16,926.27 12 53,861.85 34,000.00 19,861.85 13 59,093.56 36,000.00 23,093.56 14 64,639.17 38,000.00 26,639.17 15 70,517.52 40,000.00 30,517.52 16 74,748.57 40,000.00 34,748.57 17 79,233.49 40,000.00 39,233.49 18 83,987.50 40,000.00 43,987.50 19 89,026.75 40,000.00 49,026.75 20 94,368.35 40,000.00 54,368.35 21 100,030.45 40,000.00 60,030.45 22 106,032.28 40,000.00 66,032.28 23 112,394.22 40,000.00 72,394.22 24 119,137.87 40,000.00 79,137.87 25 126,286.14 40,000.00 86,286.14 26 133,863.31 40,000.00 93,863.31 27 141,895.11 40,000.00 101,895.11 28 150,408.81 40,000.00 110,408.81 29 159,433.34 40,000.00 119,433.34 30 168,999.34 40,000.00 128,999.34 31 179,139.31 40,000.00 139,139.31 32 189,887.66 40,000.00 149,887.66 33 201,280.92 40,000.00 161,280.92 34 213,357.78 40,000.00 173,357.78 35 226,159.25 40,000.00 186,159.25 36 239,728.80 40,000.00 199,728.80 37 254,112.53 40,000.00 214,112.53 38 269,359.28 40,000.00 229,359.28 39 285,520.84 40,000.00 245,520.84 40 302,652.09 40,000.00 262,652.09 41 320,811.21 40,000.00 280,811.21 42 340,059.88 40,000.00 300,059.88 43 360,463.48 40,000.00 320,463.48 44 382,091.29 40,000.00 342,091.29 45 405,016.76 40,000.00 365,016.76 46 429,317.77 40,000.00 389,317.77 47 455,076.84 40,000.00 415,076.84 48 482,381.45 40,000.00 442,381.45

49 50 51 52 53 54 55 56 57 58 59 60

511,324.33 542,003.79 574,524.02 608,995.46 645,535.19 684,267.30 725,323.34 768,842.74 814,973.30 863,871.70 915,704.00 970,646.24

40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00

471,324.33 502,003.79 534,524.02 568,995.46 605,535.19 644,267.30 685,323.34 728,842.74 774,973.30 823,871.70 875,704.00 930,646.24

Chart 2 Interest Payments 72,394.22 40,000.00


				
DOCUMENT INFO
Description: This template is prepared for projecting retirement plans. A comparison of gains by principal payments and gains by interest is provided with charts. Also a simulation of the coming 60 years is available.