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

Last Updated on October 31, 2021 by Galaxy World

I have already published a detailed article on the calculation of interest amount manually on Motorcar, Motorcycle, and House Building Advance. At 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 in 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, the 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, the 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 from July 2012 to June 2013 then the interest rate of the year 2012-13 will be applicable.

## 46 thoughts on “How to Calculate Motorcycle/Motorcar/House Building Advance Interest in MS Excel Sheet”

1. Masood ul haq alvi

I have been granted HBA loan when I was non gazeted now I have been promoted to the post of BPS 16 gazeted will they deduct interest on my remaining balance

1. No, Accounts Office will not deduct interest as you were non-gazetted at the time of getting HBA.

2. Mudassar Rafiq

AOA I cannot download the excel file of calculation of HBA. What was the interest rate for HBA in 2018-2019.
Thank You
Mudassar Rafiq

Please share calculator for calculation of Motor car loan from AGPR

1. I think this is also used for AGPR.

3. Ghulam Farooq

Dear Sir
Please explain/mention in details the calculation for House Building Loan …since the above calculation as per your excel sheet is for the 5 years (whereas the house building loan is for 10 years)

1. You can type 10 instead of 5 where period years is written

4. Engr. Zaman

Dear, i want to avail HBA with interest, plz answer the following .
1). how the interest will be repaid. i know the total interest. how it will be devided in months.
2). Can i repay the actual amount in 5 years, if yes then interest would be half or not.
Thanks

1. Dear Zaman sb kinldy visit the nearest HBL Branch for the latest updates.

1. M mushtaq

Mam y HBL????
@Zaman HBA is interest free for grade 1 to 15 govt employees and you can repay it in 10 years

1. 1to 15 is interest-free and also interest-free for the employees who don’t get interest on GP Fund. But the employees of BPS-16 and above who get interest on their GP Fund will have to pay interest on HBA.

5. koi ha jis ne 36 pays HBA liya ho ???? kia AGPR waly dy dety ha 36 pays ????

6. 10 years regular service punjab govt me ki aur ab mei through proper channel Federal govt mei agaya hon aur ab meri service 11 years show ho rhi ha salary slip py… kia me HBA k liye apply krne k liye eligible houn ya meri 10 years service federal ki hona zrori ha?????

1. M mushtaq

You are eligible to apply

7. Mei nay 11 years punjab govt k under job ki ha aur ab mei through proper channel federal govt me aagya houn aur meri total service pay slip py 12 sal aa rhi ha kia mei HBA k liye apply krnay k liye elligible houn?????

8. Will you please clear what is meant by pay and basic pay for the purpose of HBA. Upto 36 gross pay or basic pay the HBA will be?

1. Amount of HBA is equal to 36 months basic pay not gross pay

1. Dear Khair you are right.

9. Ghazanfar Ullah

Asalmoalikum
Dear mam, can u tell me the status of my HBA loan in Agpr, lahore. I applied in april 2016
now Agpr send me a letter to changing in my previous application of hba in bps-9. now I m in bps11, therefore, I have changed my application according to current basic.
Regards
Ghazanfar Ullah

1. Submit new application as your pay and scale changed…..however your seniority for HBA will remain unchanged

10. M. Irfan

Assalam O Alaikum!
I am an employee of District Council Gujranwala as a Computer Operator in Scale 07. please tell me about HBA or Motorcycle Advance.

1. Dear Irfan U should contact your office for the details of the same.

11. Deepak Raj

Madam sindh govt.employee hba se loan le sakte hain?oar agar kisee sindh govt.employee ne nbp se loan lia hua ho oar woh hba se bhi loan lena chahain to le sakte hain?

1. Dear Deepak GOvt loan and Bank Loan is different. Both can be obtained.

12. perwaiz

dear AOA my name is perwaiz i am federal govt servent bps is 14 my basic pay is 34280 rupee my job length remain is 96 month AGPR giving me airmarking of house building advance they make amount 822720 rupees according my information they wrong and amount is 987264 rupees pl inform me correct amount thanks

13. Respected Mam, AOA. please tell me k HBA apply krnay k liay minimum service ki koi limit hay ya nahi ?

14. A.A’ I actually want to apply for hba.I want to know regarding actual amount as well as return amount.my basic salary is 45000.

15. 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

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

17. haider ali bacha

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

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

1. M mushtaq

You are eligible to applynow motor cycle adv is Rs.100000/- you may fwd application through your channel

19. Ar Saghar

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.

1. Dear Ar Saghar U will have to pay the following:
Amount of Interest 17750
Total Amount Payable 67750

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.

1. Dear Asim u can get interest free any advance.

21. Syed Hamid Ali

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

1. Thanks dear Syed Hanid Ali

1. Dear Saad without interest is HBA for Non Gazetted and cycle advance is also w/out interest. Agar aap apnay GP fund ko without interest kar lain gay to sub advances without interest ho jain gay.

1. Great. I wish to have an interest free GP Fund. It means this will enable me to get intrest free advance. thanks

1. Dear Saad, just see the latest post of mine site. Thanks