You are more than welcome mate, pls share the outcome. Rgds, Roopesh Kapur
_____ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sergio Abadesso Sent: Wednesday, April 22, 2009 9:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest Hello Roopesh, thanks for your positive feedback and your plenty of ideas for improvement. I will defenitly work on a full-fledged solution. In the next step I will put in all your recommendations and will post a new Version in the next days. Thanks and regards, Sergio 2009/4/22 Roopesh Kapur <roopesh.ka...@gmail.com> Readers, No doubt the excel sheet is brilliant and if correctly implemented it is great. Below is my response: Things that are incorrect: 1. TDS is where most people go wrong. As a thumb rule, TDS is paid to the govt. at either every payout or at year end (31-mar). 2. While compounding only net of tax interest is added to the principal, the TDS gets debited from the interest and get credited to the TDS GL where it remain till it is paid out to the Govt. 3. I am attaching the correct way of calculating for a compounding FD a. If you observe each qtr that has 31-Mar in it has been broken down into 2 parts as banks have to calculated TDS and pay the govt. b. Banks usually take a year to be 365 days and interest is calculated on a daily basis hence it is not correct to calculate annual interest and divide that by 4. Some qtrs have 91 days and even less. c. Enhancements that I recommend in this very useful utility spreesheet. 1. TDS is different for different types of customer (individual 10.3%, Trust 11.33% and non individuals 22.6%) 2. Some customer are exempt from tax, so it will be useful if the macro is able to pick if the TDS is to be deducted firstly and then what amount of TDS is to be deducted. Let me know, if you want to make this spreadsheet into a full-fledged tool for people to look at, will give more ideas. Regards, Roopesh Kapur _____ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sergio Abadesso Sent: Wednesday, April 22, 2009 2:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest Hi Shafiq, I always tried to attach the files through the group Window because I didn't know that it is possible to write an answer through E-Mail. It works fine now! Thank you! Regards, Sergio 2009/4/22 shafiq online <shafiq_onl...@hotmail.com> Attached file and send it through email.........what the problem ! > Date: Tue, 21 Apr 2009 01:34:32 -0700 > Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest > From: groups.abade...@googlemail.com > To: excel-macros@googlegroups.com > > > Hello Ashish, > > I am working on a solution for you! > > But I still don't know how to attach a file in an answer. > > I'm new in this group and I really want to help people with VBA > problems. > > But before I have to know how I can attach files. > > Best Regards, > > Sergio > > On 20 Apr., 15:51, Ashish got engagged <4everash...@gmail.com> wrote: > > Hello, > > > > I am attaching herewith one excel file in which I have calculated Fixed > > Deposit Receipt Interest. Plese give me any fixed format so that I can just > > enter the FDR No, amount, tenure, interest rate. So that it will > > automatically calculate the Interest for each quarter, i.e. June, Sep, Dec, > > Mar end. > > > > Thanks, > > > > Regards, > > > > CA. Ashish > > > > FDR Interest.xls > > 173KAnzeigenHerunterladen > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
