Showing posts with label Tax Section 24 B. Show all posts
Showing posts with label Tax Section 24 B. Show all posts

Saturday, 25 September 2021

Auto-fill Income Tax Preparation Software in Excel for the Govt & Non-Govt Employees for the F.Y.2021-22.With tips to increase your home loan eligibility

 

Auto fill income tax calculator

Auto-fill Income Tax Preparation Software in Excel. If you are planning to buy a house, it is important for you to analyze how much money you will have in your own pocket and how much loan you will take from the bank. There is a maximum limit on how much a bank can lend you to buy the property and it varies on a case-to-case basis.

 

Home loan depends on some factors and this article discusses 5 important tips to increase your home loan eligibility.

 

1. Improve your CIBIL score

A CIBIL score is a score that basically indicates your credit history and how likely you are to repay your loan on time. If this score is higher than 750 - it indicates that you have a very good credit history and are likely to repay your loans on time.

 

However, if this score is low - it means that there is a high probability that you will not be able to pay your rep. Money security is just as important as interest rates and so they are not very keen to give higher loans to people with low CIVIL scores.

 

Therefore, it is advisable to have a high credit score for each person.

 

Don't apply for too many credit products at once because each application leads to a new credit score check that lowers your score.

Credit Try to keep the credit usage ratio about 20-30% lower than your credit card spending limit.

 

2. Choose a long-term home

One of the main reasons for paying your EMI is the duration of your home loan. The lower the EMI. And the lower the EMI payable, the easier it will be for you to pay.

 

The easier it is for you to pay, the more likely it is that the lender will recover the EMI. Therefore, if you want to increase your eligibility for a home loan, try to choose a long term home loan.

 

3. Take a joint home loan

One of the best ways to improve your credit score is to apply for a joint home loan, especially with a family member, such as a wife, son or parent. In the case of a joint home loan, lenders consider the income of other co-applicants which significantly increases your eligibility for a home loan. Click here to read more about the paperwork required when applying for a home loan: Eligibility for a home loan

 

4. Pay your existing and in short term

Home loans are long term loans of 10/20 years. However, there are some loans such as vehicles, personal etc. etc. which are 2/3 years old. Before applying for a home loan, try to pay off a smaller period of smaller size as paying it off will increase your monthly net savings and consequently increase your eligibility for a home loan.

 

5. Additional source of income

If you have additional sources of income such as rent or business - this can also help you increase your home loan eligibility. Home payers check your monthly cash flow before approving your home loan and so the higher the monthly cash flow - the better.

 

Banks cannot approve home loans in excess of your purchase price. And they will verify the purchase price through your purchase document. Therefore, make sure that your purchase price is mentioned in the contract and stamp duty is also paid at the time of property registration. In several cases, it was observed that the purchase price was not mentioned in the contract and stamp duty was not paid in the same manner resulting in lower home loans being granted.

Download Automated IncomeTax Preparation Excel Based Software All in One for the Government andNon-Government (Private) Employees for the Financial Year 2021-22 and Assessment Year 2022-23 U/s 115BAC

 

Auto fill income Tax Software

Income Tax Form 16

Income Tax Form 10 E

Feature of this Excel Utility:-


1) This Excel Utility Prepare Your Income Tax as per your option U/s 115BAC perfectly.

 

2) This Excel Utility has all amended Income Tax Section as per Budget 2021

 

3) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E from the F.Y.2000-01 to F.Y.2021-22 (Updated Version)

 

4) Automated Calculation Income Tax House Rent Exemption U/s 10(13A)

 

5) Individual Salary Structure as per the Govt and Private Concern’s Salary Pattern

 

6) Individual Salary Sheet

 

7) Individual Tax Computed Sheet

 

8) Automated Income Tax Revised Form 16 Part A&B for the F.Y.2021-22

 

9) Automated Income Tax Revised Form 16 Part B for the F.Y.2021-22

 

10) Automatic Convert the amount in to the in-words without any Excel Formula

Monday, 26 July 2021

Taking a home loan can help you save tax| With Automated Income Tax Preparation Excel Based Software All in One for the All Government & Non-Government Employees for F.Y.2021-22

 Taking a home loan can help you save tax| The repayment of a Home Loan comprises 2 components:

1. Repayment of Principal and

2. Repayment of Interest

As the repayment comprises of two different components, the tax benefit on a home loan is governed by different sections of the Income Tax Act. Following are the benefits available on loan taken on House Property which can be claimed as deductions in the Income Tax Return: 

1. Deduction on Principal Repayment (U/s 80C): The amount paid as Repayment of Principal of Home Loan taken by an Individual/HUF is allowed as deduction u/s 80C. The maximum deduction allowed u/s 80C is Rs. 1,50,000. This deduction is available on a payment basis. But to claim this deduction, the house property should not be sold within 5 years of possession. Otherwise, the deduction claimed earlier will be added back to the total income in the year of sale. 

You may also like- Automated Income Tax Preparation Excel Based Software All inOne For the Assam State Employees for the F.Y.2021-22 as per Budget 2021[This Excel Utility can prepare at a time your Income Tax Computed Sheet + Individual Salary Structure as per the Assam State Employees Salary Pattern + Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Revised Form 16 Part A&B + Automated Income Tax Form 16 Part B for F.Y.2021-22]

 

House Building Loan Interest

2. Deduction for Stamp Duty and Registration Charges (u/s 80C): A deduction for stamp duty and registration charges paid on the purchase of house property can also be claimed u/s 80C but within the overall limit of Rs. 1,50,000. It can be claimed only in the year in which these expenses are incurred.

 

3. Deduction of interest on Home loan. As per Sec 24(B), the maximum deduction for Interest payable on the Loan is Rs. 2,00,000 where the loan has been taken on or after 01-04-1999 for the Purchase or Construction of a self-occupied property and the property has been acquired or constructed within 5 years from the year in which the loan was taken. The maximum tax deduction allowed u/s 24 of interest on the loan on a self-occupied property is Rs. 30,000 where the loan was taken before 01-04-1999 or the loan was taken for repair, renewal or reconstruction. There is no maximum limit in case the house property for which the Home Loan has been taken is not self-occupied and the taxpayer can take a deduction of the whole interest amount.

You may also like- Automated Income Tax Preparation Excel Based Software All inOne For the Bihar State Employees for the F.Y.2021-22 as per Budget 2021[This Excel Utility can prepare at a time your Income Tax Computed Sheet + Individual Salary Structure as per the Bihar State Employees Salary Pattern + Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Revised Form 16 Part A&B + Automated Income Tax Form 16 Part B for F.Y.2021-22]

Income Tax Deduction U/s 24 B


4. Additional deduction of interest u/s 80EEA: Additional deduction of interest on home loans taken from any financial institution is available to individuals up to a maximum limit of Rs. 1,50,000 provided the following conditions are satisfied:

The stamp value of the property does not exceed Rs. 45 lacs.

The loan must have been sanctioned between 1st April 2019 to 31st    March 2021.

On the date of sanction of loan, the individual does not own any other residential house property. 

5. Additional deduction of interest u/s 80EE: 

Things to Remember

Section 80EE came into effect from the financial year 2013-14. It was available for only 2 years, FY 2013-14 and FY 2014-15. The deduction allowed earlier was limited to a maximum of Rs 1 lakh in total and was available for only 2 financial years.

You may also like- Automated Income Tax Preparation Excel Based Software All inOne For the West Bengal State Employees for the F.Y.2021-22 as per Budget 2021[This Excel Utility can prepare at a time your Income Tax Computed Sheet + Individual Salary Structure as per the West Bengal State Employees Salary Pattern + Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Revised Form 16 Part A&B + Automated Income Tax Form 16 Part B for F.Y.2021-22]

Income tax Salary Statement

 

However, this section has been reintroduced, effective F.Y 2016-17 (A.Y 2017-18). Now the deduction is allowed for up to Rs. 50,000 per year until the loan is repaid. Additional deduction of interest on home loans taken from any financial institution is available to individuals up to a maximum limit of Rs. 50,000 provided Additional deduction of interest on home loan taken from any financial institution is available to individuals up to a maximum limit of Rs. 50,000 provided the following conditions are satisfied:

The value of residential house property does not exceed fifty lakh rupees.

The loan must have been sanctioned between 1st April 2016 to 31st March 2017.

The amount of loan sanctioned for acquisition of the residential house property does not exceed thirty-five lakh rupees.

On the date of sanction of loan, the individual does not own any other residential house property.

Summary

Section

Nature

Maximum Deduction

Conditions

24

Interest

Rs. 2,00,000

Construction must be completed within 5 years from the end of FY in which loan was taken.

80C

Principal

Rs. 1,50,000

Property should not be sold within 5 years of possession.

80C

Stamp Duty

Rs. 1,50,000

The claim is allowed in the year of expense incurred.

80EE

Interest

Rs. 50,000

Property Value should not exceed Rs. 50 lakhs and the loan amount should not exceed Rs. 35 lakhs.

80EEA

Interest

Rs. 1,50,000

The stamp value of a property should not exceed Rs. 45 lakhs and deduction u/s 80EE must not be claimed.

Download Automated Income Tax Preparation Excel Based Software All in One for the Government & Non-Government Employees for the F.Y.2021-22 as per Budget 2021 

Taxable Home Loan

Tax Computed Sheet

Tax exemption home loan

Feature of this Excel Utility-


# This Excel Utility can prepare your Income Tax Computed Sheet

 

# Individual Salary Structure as per the Andhra Pradesh State Employees Salary Pattern

 

# Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A)

 

 

# Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10 E for the F.Y.2021-22