Docstoc

FD Returns Calculator

Document Sample
FD Returns Calculator Powered By Docstoc
					                                                                HOW TO USE THE SHEET
                                                 * The "FD Returns Calculator" sheet has three tables
                * Use the first table to calculate the amount earned if you break the FD that also ta
 * The second table automatically calculates the amount you can earn once you reinvest the amou
                                                         new interest rate in the second table.
                * The third table will give you the amount you would have earned if you had contin
    * The difference table will indicate the difference in amount earned - breaking v/s continuing
indicates that you would earn more if you continue with your deposits while a negative value ind
                                                                     your deposits.
                                              * Use only the fields marked in "Green" to input the valu

 BE ADVISED THAT THIS TOOL IS TO BE USED ONLY FOR INDICATIVE PURPOSES. PLEASE SEEK AP
                                             GET INTO ANY FINANCIAL TRANSACTION.
   TO USE THE SHEET
 Calculator" sheet has three tables.
 ed if you break the FD that also takes into account the penalties.
n earn once you reinvest the amount earned in a new FD. You need to add the
 st rate in the second table.
ould have earned if you had continued with your original deposit.
            breaking v/s continuing the deposits. A positive value in this field
  eposits while a negative value indicates that you would earn more if you break
  your deposits.
marked in "Green" to input the values.

 TIVE PURPOSES. PLEASE SEEK APPROPRIATE FINANCIAL ADVISE BEFORE YOU
 Y FINANCIAL TRANSACTION.
  * Use only the fields highlighted in green to
                                                                                     STEP 1
               input your values                                                      interest rate if you


Use this table to Calculate Returns on Premature
                                                            Data
                   Withdrawal
              Principal Amount Invested                     0.00
  Applicable FD Rate as per the invested time period        0.00
                 Interest Rate Per Day                      0.00
               Original Tenure in Days                      0.00
  Day on which Premature Withdrawal was Effected              0
               Interest Earned Per Day                      0.00
                Initial Interest Earned                     0.00
               Initial Maturity Amount                      0.00
                   Penalty Applicable                       0.00
                 FD Rate Post Penalty                       0.00
                 Interest Rate Per Day                      0.00
               Interest Earned Per Day                      0.00
                 Final Interest Earned                      0.00
               Final Maturity Amount                        0.00


This Table Gives you the returns earned on amount re-       Data
            invested after breaking the FD
                  Reinvested Principal                      0.00
                        FD Rate                             0.00
                 Interest Rate Per Day                      0.00                    STEP 5
                   Remaining Tenure                           0
                Interest Earned Per Day                     0.00
                    Interest Earned                         0.00
                Final Maturity Amount                       0.00


    Returns Expected If you Stick to Your Original
                                                            Data               Input the original
                     Investment
              Oringal Amount Invested                       0.00                  per your original contr
                        FD Rate                             0.00
                Interest Rate Per Day                       0.00
                   Oringal Tenure                             0
              Interest Earned Per Day                       0.00
               Initial Interest Earned                      0.00
               Final Maturity Amount                        0.00

                     Difference                             0.00


                                  Convert Days to Month and Year
                       Day(s)                             Month(s)   Year(s)
                         0                                    0        0.0

                                  Convert Year to Days and Month
 Year(s)                             Month(s)      Day(s)
   0                                   0            0.0

           Convert Month to Days and Year
Month(s)                            Day(s)         Year(s)
  0                                    0             0.0

       Use only the "Pink Cells" to Input Values
      STEP 1 - Check with your bank for the applicable
       interest rate if you chose to prematurely break
                            your FD



              STEP 2 - Input the original tenure in days (Use the
                         Month/Year/Day Converter)



          STEP 3 - the number of days after which you intend to break
                  the FD (Use the Month/Year/Day Converter)



         STEP 4 - Add the penalty in percentage terms if applicable. Else
                     leave this as zero in case of no penalty




      STEP 5 - Input the new rate of




Input the original /old FD rate as
   per your original contract

				
DOCUMENT INFO
Shared By:
Stats:
views:15
posted:4/3/2012
language:simple
pages:5