Mr. Roopesh, The calculatiion sent in your sheet is not matching by the calculation done by Bank. The sheet which I have attached is actually as per the Bank calcualtion only.
Ashish. On Wed, Apr 22, 2009 at 8:08 PM, Roopesh Kapur <roopesh.ka...@gmail.com>wrote: > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
