Blog

Download Income Tax Calculator FY 2023-24 (AY 2024-25)

Incometax

-

February 1, 2023

Income Tax Calculator FY 2023-24 (AY 2024-25). An Income Tax Calculator is a Microsoft Excel-based utility designed to estimate the tax liability of salaried individuals based on their income. It makes the complicated tax calculation process easier, giving users precise numbers quickly. By using this calculator you can calculate your tax liability and decide on tax-efficient investment options and the suitable tax regime for FY 2023-24.

Before downloading the Excel-based income tax calculator let’s get acquainted with the Latest Income Tax Slab for FY 2023-24 and the Income Tax changes made in the Budget 2023.

Income Tax Slabs for FY 2023-24 (AY 2024-25)

The new Income Tax Slab is allowed in the Budget 2023. The new tax slab would be the default tax slab.

The new Tax Slab FY 2023-4 is given below.

Rs 0 to Rs 3 lakh – 0% tax

Rs 3 to 6 lakh – 5% tax

Rs 6 to 9 lakh – 10% tax

Rs 9 lakh to Rs 12 lakh – 15% tax

Rs 12 lakh to Rs 15 lakh – 20% tax

Above Rs 15 lakh above – 30% tax

The old Tax Regime also continued. This means if you want to invest in 80C and save tax you can still use the old tax regime.

The new tax regime announced is more tax efficient and less complicated as you need not exempt any income and remember any complicated tax exemptions such as 80C, 80CCD, 80D, 80DD, etc.

So, still, the taxpayer has two options –

Option 1 – Income Tax Slab – Higher Tax Rate

The first tax slab is with a higher tax rate. In case an individual or HUF wants to claim exemptions under 80C, 80CCC, 80CCD, 80D, 80DD, 80DDB, etc. the tax rate with a higher rate is applicable. The tax slab in case exemption is claimed is given below.

Income Tax Slab	% Rate
Up to Rs. 2,50,000	0%
Rs. 2,50,001 to Rs. 5,00,000	5%
Rs. 5,00,001 to Rs. 10,00,000	20%
Above 10 Lakh	30%

Option 2 – Income Tax Slab – Lower Tax Rate

The second tax slab is with a lower tax rate. If the taxpayer does not want to claim any exemptions new simplified tax regime is applicable. The new simplified tax regime with a lower tax rate is given below.

Income Tax Slab	% Rate
Up to Rs. 3,00,000	NIL
Rs. 3,00,001 to Rs. 6,00,000	5% (With Tax Rebate under Sec.87A)
Rs. 6,00,001 to Rs. 9,00,000	10% (With Tax Rebate under Sec.87A up to 7 Lakh)
Rs. 9,00,001 to Rs. 12,00,000	15%
Rs. 12,00,001 to Rs. 15,00,000	20%
Rs. 15,00,001 and above	30%

The taxpayer is not allowed to claim any exemption under 80C, 80CCC, 80CCD, 80D, 80DD, 80DDB, 80E, 80EE, 80EEA, 80EEB, 80G, 80GG, 80GGA, 80GGC.

However, there are certain deductions you can still claim using the new tax regime and they are as below.

Retirement benefits, gratuity, etc.
Commutation of pension
Leave encashment on retirement
Retrenchment compensation
VRS benefits
EPFO: Employer contribution
NPS withdrawal benefits
Education scholarships

Salaried can select any tax slab. They can switch between old and new tax regime. The option of switching between tax slab is not allowed if an individual or HUF have business income.

Income Tax Calculator FY 2023-24 (AY 2024-25) – Excel Free Download

Download the latest income tax calculator FY 2023-24 (AY 2024-25) from the link given below and calculate your income tax liability easily. There are two parts of this calculator. Both are given in different sheets.

Part 1 – Calculate Tax as per Higher Tax Rate

The first sheet includes a calculator that considers a higher tax rate and allows for deductions and exemptions.

In order to determine your income tax responsibilities at the elevated tax rate, you must supply information like your total income and the amount of exemptions. Furthermore, you must also submit details regarding the investments you have made across different categories. The document includes sections for different inputs like 80C, 80D, 80CCD, and others.

Once you have entered the information, you must proceed to the lower section and choose the appropriate tax bracket by selecting options for Male/Female, Senior Citizen, and Very Senior Citizen.

You will be able to see your tax liability instantly in the Tax Liability with Cess Section.

Part 2 – Calculate Tax as per Lower Tax Rate

The calculator included in the second sheet follows the new tax system that has lower tax rates and does not permit deductions.

In order to determine your income tax obligations based on the updated lower tax rate bracket, you are only required to input your gross income once.

The calculator will calculate tax liability automatically and display it in the Tax Liability with cess Field.

Download the Income Tax Calculator in EXCEL Format.

Note – It is not a comprehensive calculator, it is designed to give you a quick idea about your income tax liabilities so that, you can start tax planning. It also helps you to select an appropriate tax slab.

Key Features of this Income Tax Calculator are given below

This calculator is a two-in-one calculator. You can make use of this calculator for calculating tax liabilities as per old as well as new tax slabs.
You can compare your tax and decide which tax slab to opt.
This calculator is designed exclusively for the salary income only.
It is an Excel-based calculator. You can download and use it forever.
This calculator is for people with a single home.
You will not able to calculate long-term capital gain tax from this calculator.

Conclusion

The Income Tax Calculator for FY 2023-24 is an essential tool for understanding the intricacies of the Indian tax system. Taxpayers can attain precision, effectiveness, and adherence in their tax activities by utilizing its capabilities.

If you have any suggestions share them at info@moneyexcel.com. It will help me to add new features and improve this calculator.

New Income Tax Slab 2023-24

Incometax

Shitanshu Kapadia

-

February 1, 2023

0

New Income Tax Slab 2023-24 is announced by Union Finance Minister Nirmala Sitharaman. New Tax Regime is announced. New Tax Regime will be the default tax regime.

The income tax rebate limit is increased to 7 Lakh. With the new tax regime, those with incomes of Rs 7 lakh would no longer need to pay any income tax. Earlier this limit was Rs 5 lakh. A 5% direct tax would be applicable on a total income between Rs 3 lakh to 6 lakh. 10% direct tax would be applicable on total income between Rs 6 lakh to 9 lakh. 15% on Rs 9 lakh to Rs 12 lakh, 20% on Rs 12 lakh to 15 lakh, and 30% on Rs 15 lakh and above.

The government has reduced the highest surcharge rate from 37 percent to 25 percent in the new tax regime.

This means the basic exemption limit is hiked from Rs 2.5 lakh to 3 lahks. Rebate under section 87A has been hiked from Rs 5 lakh to Rs 7 lakh.

New Income Tax Slab 2023-24

a) Rs 0 to Rs 3 lakh – 0% tax
b) Rs 3 to 6 lakh – 5% tax
c) Rs 6 to 9 lakh – 10% tax
d) Rs 9 lakh to Rs 12 lakh – 15% tax
e) Rs 12 lakh to Rs 15 lakh – 20% tax
f) Above Rs 15 lakh above – 30% tax

A new Income Tax slab is beneficial as it leads to good savings on income tax.

Tax savings due to Income Tax Slab 2023

Earlier if your total income was Rs 7 lakh you were paying Rs 33800 as tax but now you need not pay any tax on Rs 7 lakh.

In case your income is 9 lakh earlier you were paying Rs 62400 as tax but now you need to pay Rs 46800 tax on income of 9 lakh so your total saving would be Rs 15600.

If your income is 10 lakh earlier you were paying Rs 78000 as tax but now you need to pay only Rs 62400 as tax so the total saving would be Rs 15600.

If your income is 12 lakh earlier you were paying Rs 119600 as tax but now you need to pay only Rs 93600 as tax so your total savings would be Rs 26000.

If your income is 15 lakh earlier you were paying Rs 195000 as tax but now you need to pay only Rs 158000 as tax so the total saving would be Rs 37000.

The new income tax regime becomes the default tax regime. However, the individuals will have the option to continue with the old income tax regime.

3 Ways to Generate More Money in Sales

Skills & Productivity

Shitanshu Kapadia

-

January 31, 2023

0

Sales is one of the most important skills required for any business. You can not survive in the business for the long term if you don’t have sales skills. Everyone knows that it takes time to develop sales skills.

If you are a sales professional or in business and wanted to generate more money in sales this post is important for you.

Today in this post, I am gonna teach you three powerful ways that will affect you, how much you earn, how much you bring home, and how much income you generate as a salesperson, and as a sales professional.

3 Ways to Generate more money in Sales

#1 Transaction Size in Sales

The very first way is ticket size or transaction size. Think about this, if you’re selling something for INR 100, you need to make a lot of sales to earn a six-figure or even seven-figure income as a closer.

But if you are selling high tickets for 10000 even 25000 or 1 Lakh you don’t need to make a lot of those sales to make a very, very good income.

You see, to become a highly-paid sales professional, you need to consider what you are selling. What is the ticket size?

Let’s say you’re getting paid based on commission, let’s say you’re commission is 10%. If you’re selling something for INR 1000 and you make a 10% commission, you’re making INR 100.

You need to talk to a lot of prospects to make any kind of significant income. Yet, if you’re selling something for INR 100000, and you’re making 10% commission, you’re making INR 10000, a sale. You just make a couple of sales a week, you’ll make 80000, 1 Lakh, 2 Lakh per month.

3 Proven Steps to Create the Best Ad or Sales Copy

#2 Lead Flow in Sales

Now as a salesperson, I don’t care how amazing you are as a closer, or how high your closing ratio is if you’re not talking to enough prospects.

Guess what, you’re not gonna get paid, right? The consistency and quality of the leads are extremely critical to how much money you earn.

So lead flow. I want you to think about in terms of sales, there are two types of salespeople. You have first, what I call prospectors. They go out there, and they do outbound, they do cold calling, and they are doing prospecting.

Maybe in some cases, they are the appointment setters. Those types of sales professionals will never make a lot of money because that’s not where the money is.

And then you have, what I call, the closer. They are the ones who go in, and they close the deal. They are the ones who go in and make it happen. They are the rainmakers. The closers, within the sales world, are the ones who make the most amount of money, because guess what, you don’t make money prospecting.

You don’t make money because you get a lead. You make money when you close a sale.

#3 Closing Ratio

Now when it comes to the closing ratio, it depends on what you do. A lot of people, talk about sales, oh sales is a numbers game.

You gotta talk to a lot of people. Smile and dial man, you talk to 100, 200 people. You get enough no’s, you’ll get some yes.

You know what, that’s the old model. That model sucks. Even if it works, it is draining, it is exhausting. Why do you wanna do it that way?

So instead of closing one out of 100, you have to understand as a sales professional, as a closer, your most valuable asset is your time,and your time is limited.

You only have 24 hours a day, and you’re not on the phone 24 hours a day.

If you and I are honest, right? You’re lucky if you’re on the phone eight hours a day, even 10 hours a day. Let’s say you work hard. You are exhausted by the end of the day. So if you’re selling the high ticket, right?

And you are selling something that’s at a premium price, you don’t need a lot of transactions. You don’t need to make a lot of sales to make a very high income.

So I want you to think about this piece, closing ratio. Instead of closing one out of 100, what if you could close one out of 10? What if you could close one out of eight? What if you could close one out of five?

Do you see how that would affect how much you earn as a salesperson?

So those three ways, if in terms of closing ratio, instead of doing the prospecting, you’re closing for the company. You’re closing for an entrepreneur. You’re closing for a product and service that nobody wants, or you’re talking to leads and prospects that are not properly qualified.

Let me give you a model.

Pick a company, influencer, partner, or entrepreneur with whom they’ve already got their marketing in place.

They are generating leads. They’ve got a strong brand. They have a consistent lead flow, and they are selling high ticket.

INR 10000, 25000, 50000, and up, and they are willing to give you a nice commission chunk.

And from there instead of you outbound or doing all these outreach, have them create a process where they are generating leads, and people are booking an appointment with you.

So instead of doing outbound, you’re doing inbound.

Every single call that you, every single prospect that you talk to, have pre-interest, pre-qualify, and pre-motivated. Of course, you’re closing ratio is gonna be high, once you have those three things together.

That’s how you become the highest-paid salesperson.

4 Proven Ways to Attract New Commercial Tenants

Real Estate

Shitanshu Kapadia

-

January 27, 2023

0

There are several things you can do to attract new commercial tenants.

First, make sure that your property is well-maintained and in good condition. This will show potential tenants that you take good care of your property and that it is an excellent place to do business.

Another important factor is location. If your property is in a convenient and accessible location, it will appeal more to potential tenants. Consider promoting nearby amenities, public transportation options, and easy access to major highways.

Offer competitive rental rates. Conduct market research to determine the average rental rates in your area and make sure your rates are competitive.

Consider offering tenant incentives, such as free rent for the first few months or a tenant improvement allowance. This can make your property more attractive to potential tenants.

Attracting new commercial tenants involves ensuring your property is well-maintained and in a good location, offering competitive rental rates, and potentially offering tenant incentives.

Read on to find more tips on how to attract commercial tenants.

4 Proven Ways to Attract New Commercial Tenants

Offer A Rent-Free Period

Offering a rent-free period is one way to attract commercial tenants to your property. This is a form of tenant incentive that can make your property more attractive and help you stand out from the competition.

During the rent-free period, the tenant will not be required to pay rent for a specified time. This can help make your property more affordable for the tenant, especially if they are just starting a new business and are building up their customer base.

To make this incentive attractive to potential tenants, you can offer a rent-free period of several months or even a year. This can help entice potential tenants and make your property more appealing.

Offering a rent-free period can be risky for the property owner. You will not be receiving any rental income during this time, so you must ensure that you can afford this. Additionally, you should ensure that the tenant is financially stable and has a solid business plan before agreeing to a rent-free period.

Offering a rent-free period can be an excellent way to attract commercial tenants to your property. It can make your property more affordable for the tenant and help you stand out from the competition. However, it is essential to consider the potential risks carefully and ensure that the tenant is financially stable before agreeing to this type of incentive.

Provide Rent Abatement (Reduction)

Providing rent abatement or rent reduction is another way to attract commercial tenants to your property. This can be an attractive incentive for potential tenants, especially if they are facing financial challenges or are just starting a new business.

Rent abatement is a temporary reduction in the amount of rent that a tenant is required to pay. This can be offered for a specific period, such as a few months or a year, and can help to make your property more affordable for the tenant.

To offer rent abatement, you can agree to a temporary reduction in the rental rate with the tenant. This can be done through a lease amendment or a rent abatement agreement. Clearly outline the rent abatement terms, including the amount of the reduction and the duration of the abatement period.

Providing rent reduction can be an excellent way to attract commercial tenants to your property, but Carefully consider the potential risks. You will be losing rental income during the abatement period, so you need to make sure that you can afford to do this. Additionally, you should ensure that the tenant is financially stable and has a solid business plan before agreeing to a rent reduction.

Providing rent reductions can be an excellent way to attract commercial tenants to your property. It can make your property more affordable for the tenant and help you stand out from the competition. However, consider the potential risks carefully and ensure that the tenant is financially stable before agreeing to this incentive.

Consider Fit-Out Contribution

A fit-out contribution is another way to attract commercial tenants to your property. This is a form of tenant incentive that can help make your property more attractive and help you stand out from the competition.

A fit-out contribution is a payment or allowance the property owner provides to the tenant to help fit out the leased space. This can include renovations, new fixtures, or specialized equipment tenants need for their business.

To offer a fit-out contribution, you can provide the tenant with a specified amount or percentage of the fit-out costs. This can be done through a lease amendment or a fit-out contribution agreement. Clearly outline the terms of the fit-out contribution, including the amount of the assistance and the types of expenses it can be used for.

A fit-out contribution can be an excellent way to attract commercial tenants. This is because you are willing to invest in the tenant’s business and are committed to helping them succeed. In addition, a well-fitted space can make your property more attractive and increase your property value. However, it is essential to consider the potential risks of offering a fit-out contribution.

You will provide financial support to the tenant, so you must ensure they are financially stable and have a solid business plan. Additionally, you should carefully assess the potential return on your investment and ensure it is worth it.

Offering a fit-out contribution can be an excellent way to attract commercial tenants to your property. It shows that you are willing to invest in the tenant’s business and can help to make your property more attractive. However, it is essential to consider the potential risks carefully and ensure that the tenant is financially stable before agreeing to this type of incentive.

Make Building Upgrades to Attract Commercial Tenants

Making building upgrades is another way to attract commercial tenants to your property. By investing in improvements to your building, you can make it more attractive and modern, which can help to attract tenants who are looking for high-quality space.

Some examples of building upgrades that can help to attract commercial tenants include:

Updating the building’s exterior, such as repainting or installing new windows or doors
Renovating common areas, such as lobbies, restrooms, or elevators
Installing new lighting or HVAC systems
Upgrading the building’s security system or fire safety features
Adding amenities, such as a fitness center or tenant lounge

Investing in building upgrades like energy-efficient lighting, modern interiors, and dependable HVAC repair services NWA can significantly attract commercial tenants. These improvements ensure a comfortable and productive space while showcasing your commitment to maintaining high-quality facilities.

Before making any upgrades, carefully assess the needs of your potential tenants and the current state of your property. This will help you to determine which upgrades will be the most effective in attracting commercial tenants and will provide the best return on your investment.

Improving your building’s HVAC (heating, ventilation, and air conditioning) system is one way to attract commercial tenants. A modern and efficient HVAC system can provide tenants with a more comfortable and healthy working environment.

There are several ways that you can improve your building’s HVAC system to attract commercial tenants.

Some examples include:

Upgrading to a newer, more efficient HVAC system
Installing programmable thermostats to allow tenants to control the temperature in their space
Adding air purifiers or air filters to improve the air quality
Installing zoning controls to enable tenants to control the temperature in different areas of their space
Regularly maintaining and servicing the HVAC system to ensure that it is working correctly and efficiently

In conclusion, improving your building’s HVAC system can be an excellent way to attract commercial tenants. A modern and efficient HVAC system can provide a more comfortable and healthy working environment, which can be an essential factor for tenants when choosing a commercial space.