Overview
SavingsHelp
Sheet 1: Savings
Sheet 2: Help
| HELP & DEFINITIONS | ||
| © 2008 Vertex42 LLC | ||
| This spreadsheet is for illustrative purposes only. Results are just estimates. Interests rates vary. Taxes on interest earned are not taken into account. Please consult a qualified professional regarding financial decisions. | ||
| INPUTS | ||
| Expected Annual Interest Rate | ||
| This spreadsheet assumes a fixed annual interest rate. | ||
| The interest is compounded according to the deposit frequency that you choose, and it is assumed that the deposits are made at the end of each period. | ||
| Initial Investment | ||
| This is the starting value of your savings account. All other deposits are made at the end of the year or at the end of the specified investment period. | ||
| Deposit Amount | ||
| The amount you plan to add to your savings account or investment at the end of each deposit period. | ||
| Deposits Per Year | ||
| Used to specify the number of contributions or deposits made per year. The deposit is made and the end of the period. | ||
| 1 | Annually | |
| 2 | Semi-Annually | |
| 4 | Quarterly | |
| 12 | Monthly | |
| 24 | Semi-Monthly | |
| 26 | Bi-Weekly | |
| 52 | Weekly | |
| 365 | Daily | |
| Additional Annual Investment | ||
| The amount you plan to add to your savings account or investment at the end of each year. | ||
| YEARLY SUMMARY | ||
| Rate: Estimated Annual Interest Rate | ||
| If you want to enter a different rate for each year (such as a negative value for a particularly bad year), you can enter the value in place of the default formula. But, you will need to either undo the change or enter the formula manually if you want to replace the value you entered with the original formula. | ||
| Estimated Annual Interest | ||
| The interest is calculated using the FV formula to account for the contributions that may be made monthly, weekly, etc. within the year. | ||
| Scheduled Deposits | ||
| The total scheduled deposits made this year, including the Deposit Amount and the Extra Annual Investments, if any. | ||
| Extra Annual Deposits | ||
| You can enter a negative amount here to indicate that you plan to make less than the scheduled Additional Annual Investment in a particular year, or a positive amount to indicate that you plan to make a more sizable contribution in a particular year. | ||
Wyszukiwarka
Podobne podstrony:
Kalkulator oszczednosci isover
Kalkulator OSZCZEDNOSCI oszczędności Rockwool
Kalkulator oszczednosci isover
Sposoby oszczędzania energii elektrycznej i cieplnej domy zeroemisyjne
oszczędność energii
KALKULACYJNY RACHUNEK KOSZTÓW
T 6 Inwestycje i oszczędności
arkusz kalkulacyjny 4
Inteligentne oszczedzanie fragment
25 Kalkulowanie cen potraw i napojów
III filar czyli o czym warto wiedziec oszczedzajac tcm75 28875
kalkulator budowlany Xella XELLA2
referat kalkulacja kosztow, Rachunkowosc zarzadcza
Kalkulacje polityczne w RUE, KE, PE
koszty rodzjowe i kalkulacyjne
Mikroklimat kalkulatory
więcej podobnych podstron