Interest Rates

1603 views 15 replies

May any one can help me in finding a single formulae in excel to calculate interest

Amount     25000

Due date 15.10.10

Date of Payment 07.04.11

Replies (15)

Find the attachment..

 

                             25,000.00      
                             40,466.00      
                             40,640.00       174.00  Diff. In Days 
 In case of company       
 As per Sec 75     1,549.00    
 As per Sec 76     2,860.00    
   34,800.00    
 Subject to max of tax liab.     25,000.00  
 Total amoun to be paid as intt.   26,549.00  
       

Hope Both of u r not aware about the recent budget

from 1-04-11 interest rate is 18% know

yes you are right ajay interest on late deposit of service tax has increased...

Originally posted by : Ajay s

Hope Both of u r not aware about the recent budget

from 1-04-11 interest rate is 18% know

I m aware of it..But as the liablity is for the period prior to budget then i think interest at the rate of 13 % will apply..

Interest needs to be paid at the rate existing at the time of payment. The words used under sec 11AB is interest at such rate as is "for the time being" fixed by the central government by notification. Whcih meas at present prevailing rates.

Regards

Dayananda

Originally posted by : DAYANANDA K N

Interest needs to be paid at the rate existing at the time of payment. The words used under sec 11AB is interest at such rate as is "for the time being" fixed by the central government by notification. Whcih meas at present prevailing rates.

Regards

Dayananda

Which Section 11 B? R u talking about section 11B [ Claim for refund of duty and interest, if any, paid on such duty ] of central excise act, 1994.???

Section 11AB of Central excise Act. Interest on non payment or non levy of duty etc.

Regards

Dayananda

ok i agreed with dayananda , but can u solve my problem

 

Dear Mr. Ajay Y,

 

Pleas use the following formulla in excel sheet for Calculation of Interest for 174 days (from 15.10.2010 to 07.04.2011) @ 18% p.a.

=ROUND((A1*18%)*(174/365),0)

Note : A1 is the address of the row in which you have put the figure (i.e. 25,000/-) and interest will come Rs. 2,145/-.

 

I hope it will helpful for you.

 

Regards,

Vikash Kharvar

 

 

Sry Vikash up to 31.03.11 Interest rate is 13% only and from 1.04.11 its 18% then how its possible??

 

Pinki was right service tax payable amount must be of March than the interest rate will be applicable 13 % not 18 %....

Mr.Ajay

According me since you have dishcarged tax on 7th Apr 2011 which is falls after amendment has taken place you need to pay interest at 18%.

Interest is payable at prevailing rates at the time of discharge of tax

Regards

Dayananda

 

In current Budget announced if turnover is below 60 Lac Than assess have to pay interest 15 & on late remit of service tax.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 08 July 2026
Article internship

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

View Details