How to Calculate Motorcycle/Motorcar/House Building Advance Interest in MS Excel Sheet

I have already published a detailed article on the calculation of interest amount manually on Motorcar, Motorcycle and House Building Advance. On the request of the visitors of my site I am today publishing a detailed article on “Calculation of Motorcycle/Motorcar/House Building Advance Interest in MS Excel Sheet".

Calculation of Interest on Motorcar & Motorcycle Advance

Generally the Motorcar & Motorcycle Advance refundable amount is in 60 monthly installments. The interest amount will further increase the number of installments. 60 installments are for the amount that is taken as advance.  A sum of Rs. 75,000 is granted as Motorcycle Advance provided the basic pay of the employee is between Rs.7501/- to Rs/19,999/- while a sum of Rs. 450,000/- is granted as Motorcar Advance provided the Basic Pay of the employee is Rs.20,000/- or more.

Just enter the total amount, number of installments and the interest rate during which the advance was taken.

Calculation of Interest on House Building Advance

The return of HBA Advance is in 120 monthly installments. For Non-Gazetted Employees the amount is interest free while the Gazetted Employees have to pay the Interest on the House Building Advance. 120 monthly installments are for the actual amount drawn as HBA while the interest amount will increase the number of installments.

36 Basic Pays are granted as HBA and the minimum service for the same is 10 years.

Just also enter the total amount taken as HBA, number of installments and the interest rate during which the advance was taken.

Note: Interest Rate is the same as GP Fund Annual Interest Rate and it is taken from the year during which the amount has been taken as Advance.

Suppose your amount of advance is passed during July 2012 to June 2013 then the interest rate of the year 2012-13 will be applicable.

 

Download Motorcar, Motorcycle & HBA Advance Interest Calculator

 

Motor Cycle Advance

 

 

Summary
Article Name
How to Calculate Motorcycle/Motorcar/House Building Advance Interest in MS Excel Sheet
Description
Just enter the total amount of advance, number of installments and the interest rate for the Calculation of Motorcycle/Motorcar/House Building Advance Interest
Author

17 Comments

  1. Atiya says:

    Sir mujay baatian mai and my husband job kartay hay 20 lak loan lana chtay hay with interest kitni payment karni ho g return hum 2nu ki pay total 70 tak hay

  2. muhammad Ishaq says:

    we are in NTDC Wapda please tell us the latest position of up gradation of Divisional accounts officers.

  3. haider ali bacha says:

    my GP fund is interest free what are the procedure to obtained house building loan n advance

  4. M ahsan says:

    Ma post office Ma cleark ho or mama na motorcycle advance lana ha 75000 plz inform me how can get

  5. Ar Saghar says:

    Dear Admin
    AoA
    Mn ny january 2011 mn 50000 Rs. motor cycle advance lya tha jis ki monthy instalment 834 rupees hy plz mjhy kitni amount dainy pary gi or kb tk.

  6. Muhammad Asim says:

    dear GP Fund pay ap interest last 2-3 years say na ly rhy houn tab he ap jo bhe advances lain gy un pay koe interest nhn dena ho ga.

  7. Syed Hamid Ali says:

    Very Beautiful. bohat hi umdah kawish hy. Allah Pak aap ko lambi zindgi dy. Ameen

  8. Saad says:

    Dear madam please baten ke kea without interest be koi advance lana mumken hay?

Leave a Comment

Comment moderation is enabled. Your comment may take some time to appear.