No video

How To Calculate Income Tax FY 2021-22 Excel Examples | Income Tax Calculation FY 2021-22

  Рет қаралды 109,831

FinCalC TV

FinCalC TV

3 жыл бұрын

How To Calculate Income Tax FY 2021-22 Excel Examples | Income Tax Calculation FY 2021-22
In this video by FinCalC TV, we will see how to calculate new Income Tax FY 2021-22 using Excel examples. Income Tax calculation for FY 2021-22 using Old Income Tax slab Rates and New Income Tax slab rates and which one you should choose while calculating Income Tax.
DOWNLOAD our FREE ANDROID APP "FinCalC":
play.google.com/store/apps/de...
ONLINE INCOME TAX CALCULATOR:
fincalc-blog.in/income-tax-ca...
ALL EXCEL CALCULATORS VIDEOS:
• All EXCEL Calculators
DOWNLOAD INCOME TAX EXCEL CALCULATOR:
fincalc-blog.in/how-to-calcul...
After watching this video following queries will be solved:
How To Calculate Income Tax FY 2021-22?
What are the income tax slab rates for FY 2021-22?
What is standard deduction for FY 2021-22?
Old Slab rates vs new slab rates?
Income Tax calculation FY 2021-22 using excel examples?
Tax rebate under section 87A?
What is tax rebate u/s 87a
Eligibility for tax rebate 87a
Old income tax slab rates calculation vs new income tax slab rates calculation
New Budget 2021 income tax
Books I Read:
Rich Dad Poor Dad: amzn.to/3hh0Y8q
Richest Man in Babylon: amzn.to/2WLLGPt
The Intelligent Investor: amzn.to/3pqw3Jz
Think & Grow Rich: amzn.to/38yqli8
Money Master the Game: amzn.to/34K3HlK
DOWNLOAD ANDROID APP "FinCalC":
play.google.com/store/apps/de...
OUR 2nd CHANNEL LINK:
/ @gharkirecipes558
NEW INCOME TAX SLAB RATES INTRODUCED IN BUDGET 2021:
- No Income Tax on Income between Rs. 0 to Rs. 2.5 lacs
- 5% Tax on Income between Rs. 2.5 lacs to Rs. 5 lacs
- 10% Tax on Income between Rs. 5 lacs to Rs. 7.5 lacs
- 15% Tax on Income between Rs. 7.5 lacs to Rs. 10 lacs
- 20% Tax on Income between Rs. 10 lacs to Rs. 12.5 lacs
- 25% Tax on Income between Rs. 12.5 lacs to Rs. 15 lacs
- 30% Tax on Income above Rs. 15 lacs
OLD INCOME TAX SLAB RATES (STILL APPLICABLE):
- No Income Tax on Income between Rs. 0 to Rs. 2.5 lacs
- 5% Tax on Income between Rs. 2.5 lacs to Rs. 5 lacs
- 20% Tax on Income between Rs. 5 lacs to Rs. 10 lacs
- 30% Tax on Income above Rs. 10 lacs
EXAMPLES:
Let's say your Income from Salary is Rs. 6 lacs.
Your income from other sources is Rs. 15000
This makes your gross total income as Rs. 6,15,000
Let's say your investments include Rs. 60,000 under Section 80C, Rs. 10,000 under Section 80D and Rs. 5000 under Section 80TTA.
This makes your total investments as Rs. 75,000. So your net taxable income becomes equal to Rs. 6,15,000 minus Rs. 75,000, which is equal to Rs. 5,40,000. These Deductions are applicable only if you are using Old Tax slab rates. Your net taxable income when considering New Tax slab rates remains Rs. 6,15,000, as no deductions are applied on your total income.
Now to calculate your income tax, if you are an employee or pensioner, you get a standard deduction of Rs. 50,000 only if you are using old tax slab rates. Standard deduction will not be applied if you are using new tax slab rates based on the condition we have seen at the start of this video.
So your net taxable income becomes equal to Rs. 4,90,000 if you are using Old Tax Slab Rates. But it remains as Rs. 6,15,000 based on new Tax Slab rates.
Let's see income tax calculation process using old tax slab rates for which taxable income is Rs. 4,90,000.
No Tax on income between Rs. 0 to Rs. 2.5 lacs
5% Tax on income between Rs. 2.5 lacs to Rs. 4,90,000, which is equal to Rs.12,000
20% and 30% tax slabs will not be applicable in this example.
As we know, when taxable income is below Rs. 5 lacs, we get a maximum tax rebate of Rs. 12,500 u/s 87A.
In this example, income tax of Rs. 12,000 is cancelled by the tax rebate of Rs. 12,500, so effective income tax = Rs. 0.
WATCH FULL VIDEO TO KNOW MORE ABOUT NEW INCOME TAX SLAB RATES AND MORE EXAMPLES.
#IncomeTax #FY2021-22 #ExcelCalculator #IncomeTaxCalculation #IncomeTaxFY2021-22 #Excel #Calculator #FinCalCTV
===========================
LIKE || SHARE || COMMENT || SUBSCRIBE
Mujhe Social Media par FOLLOW kare:
Facebook : / fincalctv
Twitter : / fincalctv
BLOG: fincalc-blog.in
Telegram: t.me/fincalc_tv
Instagram: / fincalc_tv
=============================
MORE VIDEOS:
SIP Excel Calculator: • SIP Returns Excel Calc...
Loan EMI Calculator: • Home Loan EMI Calculat...
20 Years SIP Calculator: • 20 Years SIP Returns E...
Thank you for watching :)
DISCLAIMER:
Examples used are for Illustration purpose only and might not cover every detail of examples shown. It is advised to seek professional help before taking any financial decisions. The owner of this channel shall not be liable in any way.

Пікірлер: 85
@fincalc
@fincalc 2 жыл бұрын
MORE VIDEOS: SIP Excel Calculator: kzfaq.info/get/bejne/b96bhpql2Jqvppc.html Income Tax Calculator: kzfaq.info/get/bejne/o91dmNV32r_Gn4E.html Loan EMI Calculator: kzfaq.info/get/bejne/fLmSjNJ5pruwmGQ.html 20 Years SIP Calculator: kzfaq.info/get/bejne/Zp5ohpWL0J3XiYk.html PPF Excel Calculator: kzfaq.info/get/bejne/kLSWi5OjttHGgH0.html Loan EMI Prepayment Calculator: kzfaq.info/get/bejne/os93msmYstSZqJs.html All Excel calculators: kzfaq.info/sun/PLDLJ6DuVa3LxjgwXKCpm8fvcUwE6_YP1E
@suryakantchavan1948
@suryakantchavan1948 2 жыл бұрын
बहुतही अच्छी और महत्वपूर्ण जानकारी आपने दी है,धन्यवाद सर!💐💐💐
@sagarlandge3271
@sagarlandge3271 3 жыл бұрын
Cleared all my doubts, thanks a lot
@fincalc
@fincalc 3 жыл бұрын
Welcome 🙂👍 Subscribe and share with your friends 🙂👍
@nayanamalar9169
@nayanamalar9169 3 жыл бұрын
Thank you for the info 👍🏼
@fincalc
@fincalc 3 жыл бұрын
Welcome 🙂👍
@harik1999
@harik1999 3 жыл бұрын
Good one,thanks for posting this 🙏🙏
@fincalc
@fincalc 3 жыл бұрын
Welcome. Please share with your contacts 👍🙂
@harik1999
@harik1999 3 жыл бұрын
Will do bro,thanks👍👍
@educatortheguru
@educatortheguru 2 жыл бұрын
Thanks for knowledge
@fincalc
@fincalc 2 жыл бұрын
welcome
@prodous3677
@prodous3677 2 жыл бұрын
Thankyou bhaiya 😄
@amarclasses3354
@amarclasses3354 3 жыл бұрын
Thank You
@fincalc
@fincalc 3 жыл бұрын
welcome
@sksajidbux9495
@sksajidbux9495 2 жыл бұрын
Thank You So Much Bhai
@fincalc
@fincalc 2 жыл бұрын
Welcome
@fragrenceful
@fragrenceful 3 жыл бұрын
Sir I have send some question about gold loan EMI and early loan EMI repayment in Excel, 40lac loan with interest how to pay early as early in 15or20 years in Excel format, please create video on both of subject ASAP also save the interest amount.this point also consider while creating video on both subject.
@fincalc
@fincalc 3 жыл бұрын
Video created for loan prepayment using Excel Link: kzfaq.info/get/bejne/os93msmYstSZqJs.html
@vthomaskurian9236
@vthomaskurian9236 3 жыл бұрын
You may kindly upload videos in English also, so that it will be easier for those who are not well in Hindi
@sachinkhartade7482
@sachinkhartade7482 Жыл бұрын
good bro ❤️
@ravikantmahato5948
@ravikantmahato5948 3 жыл бұрын
Sir my father senior citizen unka: - FD interest: - 373000 / year. Or Pension: - 252000 / year Total FD interest + Pension: = 625000 / year hoo ja raha sir or maine 15H form submit kar diya hu kya mera TDS ya Tax kuch v katega kya sir or maine ULIP ka plan liya hu jo 80C ke ander aata hai or kya mujhe ITR file v karna hogga sir reply plz plz plz plz plz ....
@sandipdhumal8645
@sandipdhumal8645 2 жыл бұрын
Sir....What is about Rs.50000 standard deduction in old regime...
@vinaykumar-wg6tk
@vinaykumar-wg6tk 6 ай бұрын
sir ,HRA ka labh lane k liya HRA ke receipt lagane hige ya nahi
@rajlaxmi1615
@rajlaxmi1615 2 жыл бұрын
Very good
@fincalc
@fincalc 2 жыл бұрын
Thanks 👍🙂
@ahmadsalm3361
@ahmadsalm3361 3 жыл бұрын
Kya Standard deduction include h isme?
@monikayadav5269
@monikayadav5269 3 жыл бұрын
Good
@fincalc
@fincalc 3 жыл бұрын
thanks :)
@parnajain3548
@parnajain3548 2 жыл бұрын
I have one doubt also that why we have two taxes old taxe regime and new taxes regime ?Please tell me .
@fincalc
@fincalc 2 жыл бұрын
It's by government of India. Both tax regimes need to be evaluated by user to pay less income tax accordingly. I have made an income tax calculator to help evaluating the same. Do check out link fincalc-blog.in/income-tax-calculator/
@janardhanreddytanubuddi217
@janardhanreddytanubuddi217 2 жыл бұрын
Can you provide the app for IOS users?
@sowmyagudala1817
@sowmyagudala1817 3 жыл бұрын
Is tax rebate automatically applied for less than 5lakh income
@fincalc
@fincalc 3 жыл бұрын
Yes
@sonugharu20
@sonugharu20 3 жыл бұрын
Fixed travelling allowance will be exempt
@ahmadsalm3361
@ahmadsalm3361 3 жыл бұрын
Which is better old or new slabs?
@fincalc
@fincalc 3 жыл бұрын
Depends on your income and investments. If your income is with 8 Lacs in FY then you can invest and go for old slabs else go for new slabs 🙂 Download my android app to calculate your income tax Link: play.google.com/store/apps/details?id=com.rrr.apps.financialcalculator
@hopehope7184
@hopehope7184 2 жыл бұрын
my annual income 727908 aur NPS 5888 every month deduct hota hai ,PPF account b abhi start kiya 4k monthly se basic salary 44900 , plzz income bataye kuch samajh ni a raha clerk ne 2k last 2month se tax k cut rhai hai , I m govt employe
@fincalc
@fincalc 2 жыл бұрын
Ye income tax calculator use Karo fincalc-blog.in/income-tax-calculator/ Yaha se mera androidp app bhi download kar sakte ho jisme pata chalega ki kitna investments karne par tax bacha sakte ho
@fincalc
@fincalc 3 жыл бұрын
Kaisa laga aapko income tax calculation video using Excel for FY 2021-22? COMMENT BELOW👇👇
@mukeshprajapati3783
@mukeshprajapati3783 3 жыл бұрын
Sir excel file send Karo na
@SubhasnataNandi
@SubhasnataNandi 3 жыл бұрын
Sir can we take standard deduction 50k in case GP is more than 6 lakhs in old regime ?
@fincalc
@fincalc 3 жыл бұрын
@@SubhasnataNandi yes Standard deduction is applicable under old tax regime if you are salaried employee.
@SubhasnataNandi
@SubhasnataNandi 3 жыл бұрын
@@fincalc Thank you sir
@casekaiser1867
@casekaiser1867 2 жыл бұрын
instablaster...
@sreenishnair9964
@sreenishnair9964 3 жыл бұрын
Can I get the excel file??
@SufyanShaikh91
@SufyanShaikh91 2 жыл бұрын
Ye sab cheeze offices me sikhani chahiye.
@fincalc
@fincalc 2 жыл бұрын
Sahi
@jsinghinfo4343
@jsinghinfo4343 3 жыл бұрын
10 E how to deduct vedio plz bhaii
@ManpreetSingh-rd8mu
@ManpreetSingh-rd8mu 3 жыл бұрын
Sir mera 5 years old case chal raha hai 11 lac penalty lagi hai uski apele lagi hai budget mai bola hai 3 years old case khatam ho jayege kiya sahi hai kiya ??🙏🙏🙏🙏
@ManpreetSingh-rd8mu
@ManpreetSingh-rd8mu 3 жыл бұрын
Please reply sir
@vashasawariya1575
@vashasawariya1575 2 жыл бұрын
best quetion rply sir . penelty 11lkh deni pdti h kya yh
@FaizSheikh
@FaizSheikh 2 жыл бұрын
550000 income pe 5% slab + 10% slab which becomes 15% and not 10%. I don't understand, for 550000 the tax amount is 10% or 15%?
@samtarane
@samtarane 2 жыл бұрын
Arrears show financial year 2020-21 Please calculate me. Sir
@samtarane
@samtarane 2 жыл бұрын
Please sir send incometax excel file download chart Great morning sir 🙏
@fincalc
@fincalc 2 жыл бұрын
download from here fincalc-blog.in/how-to-calculate-income-tax-fy-2021-22-video-excel-calculator-examples/
@puneet520
@puneet520 2 жыл бұрын
Sir aapne income tax deduction me Standard Deduction jo ki 50000 hai use include nhi kiya.
@dhammalone1140
@dhammalone1140 2 жыл бұрын
k6 hum abhi 21-22ka income tax dekh sakte hai... To kaise
@smartguysmp007
@smartguysmp007 2 жыл бұрын
Apna arrears ki राशि को कैसे रिबेट कैसे ले
@pratyakshkumaryadav4022
@pratyakshkumaryadav4022 3 жыл бұрын
App par kab update hoga FY 21-22
@fincalc
@fincalc 3 жыл бұрын
App ko jald hi update Karne wala hu 4-5 Dino me. Stay tuned 👍🙂
@ssnegi8463
@ssnegi8463 2 жыл бұрын
सेविंग भी होती है,,1.5
@abhinandhan1097
@abhinandhan1097 2 жыл бұрын
how did you get 1,50,000 for 4 lakh??
@irshadahmadkhan7990
@irshadahmadkhan7990 3 жыл бұрын
Sir how to make this
@fincalc
@fincalc 3 жыл бұрын
I have already given the link of excel sheet in description
@pratyakshkumaryadav4022
@pratyakshkumaryadav4022 3 жыл бұрын
Standard deduction kya hota hai
@fincalc
@fincalc 3 жыл бұрын
Standard deduction flat deduction hai Jo employee and pensioners ko milta hai. Gross income me se 50k minus Karke income tax calculate Hoga, Which is called standard deduction
@kapilsharma6046
@kapilsharma6046 3 жыл бұрын
Bhai dhanyawad tune , Sahi samjhaya calculate karke or sab log to chutiya Bana rahe Hain sasure
@fincalc
@fincalc 3 жыл бұрын
Thank you Bhai 👍🙂 Subscribe Karo aur share Karo 👍🙂
@sonugharu20
@sonugharu20 3 жыл бұрын
App not calculate income ta
@parnajain3548
@parnajain3548 2 жыл бұрын
You have said that 4 lakh is income so the interest will be 5% in 4 lakh. why you will take 150000 in 5% ? Please tell me
@fincalc
@fincalc 2 жыл бұрын
Because Rs. 0 to 2.5 lacs, we don't have to pay any tax.. from 2.5 lacs to 4 lacs of income 5% will be applicable. So 5% is applicable on 150000 Hope this helps
@parnajain3548
@parnajain3548 2 жыл бұрын
@@fincalc Thanks
@AbhishekRajput-vu9hu
@AbhishekRajput-vu9hu 3 жыл бұрын
Can i get this excel file.
@fincalc
@fincalc 3 жыл бұрын
You can find the excel file download link in video description
@AbhishekRajput-vu9hu
@AbhishekRajput-vu9hu 3 жыл бұрын
@@fincalc Could you share this excel file directly here. I am unable to find it.
@rameshvenkat8818
@rameshvenkat8818 2 жыл бұрын
formula for caluclating above 15.00 lakhs *30/100 how to caluclate in excel
@fincalc
@fincalc 2 жыл бұрын
please download the excel calculator from here for more info: fincalc-blog.in/how-to-calculate-income-tax-fy-2021-22-video-excel-calculator-examples/
@lokeshpatel1715
@lokeshpatel1715 2 жыл бұрын
Grade 3 Teacher Gross 555628 Less 50000 Deduction 150000 Total 355628. Ab mere kitna tax banega . Pls bataye koi ???
@fincalc
@fincalc 2 жыл бұрын
Tax = 0.. tax rebate aaplicable hoga
@lokeshpatel1715
@lokeshpatel1715 2 жыл бұрын
@@fincalc thanks
@ravishukla2219
@ravishukla2219 2 жыл бұрын
Excel file download link do
@fincalc
@fincalc 2 жыл бұрын
fincalc-blog.blogspot.com/2021/02/how-to-calculate-income-tax-FY-2021-22-video-excel-calculator-examples.html
@ircsbmv8520
@ircsbmv8520 2 жыл бұрын
income tax calculator link
@fincalc
@fincalc 2 жыл бұрын
You can use this income tax calculator link fincalc-blog.in/income-tax-calculator/
@smartguysmp007
@smartguysmp007 2 жыл бұрын
Apna arrears ki राशि को कैसे रिबेट कैसे ले
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 35 МЛН
Пранк пошел не по плану…🥲
00:59
Саша Квашеная
Рет қаралды 6 МЛН
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 7 МЛН
How To Save Income Tax In India With No Investment?
15:58
Asset Yogi
Рет қаралды 655 М.
What Is XIRR? XIRR Vs IRR Vs CAGR  | XIRR In Excel Explained By CA Rachana Ranade
17:19
Make your Income Tax ZERO! | Ultimate Tax Saving Masterclass | LLA
46:54
Labour Law Advisor
Рет қаралды 873 М.
NRIs - 10 Must Attend Issues During Your India Visit Next
19:21
NRI Money Clinic
Рет қаралды 1,3 МЛН
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 35 МЛН