Friends
The following excel utility has been generated for calculation of 200 FDR's at a time. There are two type of calculations can be done in a single excel sheet which is given below :-
- Interest calculation on the basis of Maturity Date on quarterly basis.
- Interest calculation on a particular date as shown in white cell of the last Column.
If white cell of last column is blank than calculations will be done on the basis of Maturity Date other wise Interest calculations will be done on your desired date as shown in white cell of the last column.
The white cell of last column can be blanked through delete button of your key board. In case you use space bar or backspace button to blank the white cell of last column , there may be problem. This utility is workable in M S Office 2007 or above.
How to use ?
How to use ?
- Use Microsoft office 2007 or above version.
- Use only white cell for data entry.
- Other than white cell are password protected.
- Utility calculate two type of interest as mentioned above.
- Interest calculation are based on quarterly compound.
Free Excel Utility for calculation of multiple Bank FDR's in a single Excel Sheet.
Download Free FDR Calculator.