Hello Ashish and Roopesh, I'm currently working on a solution that contains all the data like they are in the Worksheets of Ashish.
In the next step we can also implement the details that you Mr. Roopesh mentioned. I will continue on the sheet after work. Regards, Sergio 2009/4/23 Ashish got engagged <4everash...@gmail.com> > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
