Excel Spreadsheet

Savings Calculator Template

You must be logged in to download this document
Reviews
Shared by: Marie Ruby
Categories
Stats
views:
60
downloads:
6
rating:
not rated
reviews:
0
posted:
4/1/2008
language:
English
pages:
0
Savings Interest Calculator http://www.vertex42.com/Calculators/savings-interest-calculator.html v 1.0 © 2008 Vertex42 LLC Savings Plan Inputs Years to Invest Initial Investment Expected Annual Interest Rate Summary of Results Estimated Future Value $ 95,580.75 Value After 20 Years Gain / Loss Summary Total Invested $ 58,000.00 $ 37,580.75 Interest Earned (Lossed) $ 20 10,000 4.00% Scheduled Deposits Deposit Amount $ 200.00 Deposit Frequency Monthly Additional Annual Investments $120,000 Balance $100,000 $80,000 $60,000 $40,000 $20,000 $0 5 10 15 20 25 My Investment Min Max Average Use Random Rates FALSE -4.00% 10.00% 4.00% (Press F9 to Recalculate) Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Rate 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Interest $451.91 $568.10 $689.02 $814.88 $945.85 $1,082.17 $1,224.04 $1,371.69 $1,525.35 $1,685.28 $1,851.72 $2,024.94 $2,205.22 $2,392.84 $2,588.11 $2,791.33 $3,002.84 $3,222.96 $3,452.04 $3,690.46 $3,938.60 $4,196.84 Scheduled Deposits $ 10,000 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 Extra Annual Deposits $ Balance 10,000.00 12,851.91 15,820.01 18,909.03 22,123.91 25,469.76 28,951.93 32,575.97 36,347.66 40,273.01 44,358.29 48,610.01 53,034.94 57,640.16 62,433.00 67,421.11 72,612.45 78,015.28 83,638.24 89,490.28 95,580.75 101,919.35 108,516.19 © 2008 Vertex42.com Year 23 24 25 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 Rate 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Interest $4,465.61 $4,745.33 $5,036.44 $5,339.41 $5,654.72 $5,982.89 $6,324.42 $6,679.86 $7,049.79 $7,434.79 $7,835.48 $8,252.48 $8,686.48 $9,138.16 $9,608.25 $10,097.48 $10,606.65 $11,136.56 $11,688.06 $12,262.03 $12,859.38 $13,481.07 $14,128.09 $14,801.47 $15,502.29 $16,231.65 $16,990.73 $17,780.74 $18,602.94 $19,458.63 $20,349.18 $21,276.02 $22,240.62 $23,244.51 $24,289.31 $25,376.68 $26,508.34 $27,686.11 Scheduled Deposits 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 Extra Annual Deposits Balance 115,381.80 122,527.12 129,963.56 137,702.97 145,757.69 154,140.58 162,865.00 171,944.86 181,394.65 191,229.44 201,464.92 212,117.40 223,203.89 234,742.05 246,750.29 259,247.77 272,254.42 285,790.98 299,879.04 314,541.06 329,800.45 345,681.52 362,209.61 379,411.08 397,313.36 415,945.02 435,335.75 455,516.49 476,519.43 498,378.06 521,127.24 544,803.26 569,443.88 595,088.40 621,777.71 649,554.39 678,462.73 708,548.84 © 2008 Vertex42.com
Related docs
Savings Calculator Template
Views: 60  |  Downloads: 6
Savings Calculator
Views: 124  |  Downloads: 4
savings-calculator
Views: 305  |  Downloads: 52
Savings Calculator
Views: 66  |  Downloads: 2
retirement-savings-calculator
Views: 302  |  Downloads: 41
Retirement Savings Calculator Template
Views: 41  |  Downloads: 3
Simple Savings Calculator
Views: 88  |  Downloads: 7
retirement-savings-calculator
Views: 137  |  Downloads: 6
Savings Interest Calculator
Views: 71  |  Downloads: 14
Retirement Planner Savings Calculator
Views: 17  |  Downloads: 0
monthly savings interest calculator
Views: 18  |  Downloads: 0
Foreign Trade Zone Savings Calculator
Views: 232  |  Downloads: 8
Energy Savings Calculator For Motors
Views: 414  |  Downloads: 25
Savings Account Interest Calculator
Views: 210  |  Downloads: 7
savings calculators
Views: 39  |  Downloads: 0
Acid Disposal vs ecover Savings Calculator
Views: 188  |  Downloads: 4
Other docs by Marie Ruby
Yearly Calendar Template
Views: 989  |  Downloads: 23
Work Schedule Template
Views: 834  |  Downloads: 41
Capital Budgeting Template
Views: 213  |  Downloads: 21
What-If Analysis Template
Views: 308  |  Downloads: 48
Weekly Calendar Template
Views: 285  |  Downloads: 19
Tool Project Manager Template
Views: 186  |  Downloads: 31
Time Value of Money Template
Views: 135  |  Downloads: 2
Timeline Template
Views: 569  |  Downloads: 6
Three-Year Profit Projection 1 Template
Views: 159  |  Downloads: 7
Capital Budgeting 2 Template
Views: 112  |  Downloads: 1