This deposit matures on a exact date in the coming along with all the deposits ended every month. Therefore, Recurring Deposit schemes allow customers with a chance to build up their savings over regular monthly deposits of fixed sum over a fixed era of time.
Minimum Period of RD is 6 months and maximum is 10 years. More about nidhi company registration online , producer company registration online. Once the RD account is opened, the maturity value is pointed to the customer accepting that the monthly installments will be paid frequently on due dates. If any installment is delayed, the interest payable in the account will be reduced and will not be sufficient to reach the maturity value. Just remember that your Interest Compounding Frequency must be equal to or greater than the Payment Frequency.
Our Recurring Deposit is made Monthly but our compounding frequency is Quarterly or any. Now the rest is simple. I have used the FV function in the cell D17 to the maturity value. We have used the same pmt value, the same rate per period here. But the procedure is direct. Let me explain. If you have followed this article step by step, you have learned a very important lesson.
Now it is simple to me. So, this is my way of calculating interest for recurring deposits in Excel. What is your feedback with this article? Was it useful? Did you face any problem using my calculator? Let me know in the comment box. This I say with personal experience, and I think everyone should get in the habit of forcing themselves to save at least a little every month and with time all of this adds up.
This great Excel RD Calculator will help you in getting an exact number on how much you will get in a few years time, and is a very useful tool.
Please download it and keep it with you as a ready reference. Please post any feedback, or report any bugs that you may have in comments — it is greatly appreciated.
Finally, a big thank you to Pattu for letting me share this great tool and I certainly do appreciate the hard work and skills that have gone into making it and I am sure other readers do too! Appreciate youir efforts. It seems that this Calc can clculate max months. Please mention max period in notes as you have mentioned min period.
Thanks Furqan. The max. Hence the months. Will mention this in the file. I was not able to download the file. Can you please let me know persons like me who are not computer savy the steps required to open the file?
While downloading I got a message What do you want to do with this file and gave me two options. I chose the File option. Desktop Enhancements. Networking Software. Trending from CNET. Download Now. Recurring Deposit RD 1. Name, any word of address, denomination, card no.
Collection : View ledger of clients 3. New Active Reports: 1. List of All Account With Photos and without photo. List of Matured Accounts. Complete details of the depositor whose investment will be matured 5. Automatic penalty and rebate calculation with Date Wise 8. RD Extension with moth RD Account wise Report
0コメント