# FD Returns Calculator

Document Sample

```					                                                                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
* 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.
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
marked in "Green" to input the values.

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

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