Download Income Tax Calculator in Excel for FY 2020-21 [AY 2021-22] Comparison Old and New Regime.
Excel Tax calculator ready To help taxpayers here is a simple excel based Income Tax Calculator for the financial year 2020–21 (AY 2021-22). The calculator is made using simple excel formulas and functions.
Download free automatic salary and CTC breakup calculator in Excel.
CTC (cost to company) of an employee OR for all employee’s in a organization is always difficult task. As you know, CTC mean salary breakup should be as India laws.
I have create a VBA based Excel sheet to calculate CTC cost to company salary breakup automatic as per all rules.
What’re Features in this Sheet?
You can calculate CTC breakup one by one individually meanwhile you can calculate all employee ( up to 5000) breakup in 1 Click.
Reset option for reset all sheet as blank.
Employee Type and State name selection required for calculating.
This sheet will be calculate Basic, HRA and Special Allowance as per Minimum wages Act as applicable Indian States.
User can update minimum wages in Second attached sheet even ever required.
Basic Salary and other calculations based on excel formulas which can be changed if required.
Bonus will be calculate 20% as per Bonus Payment Act 1965.
Gratuity will be calculate as per Gratuity Payment Act 1972.
User can change HRA % 50 to 40% in case required.
User can rename the other allowances head name if required.
Download NSC Interest Calculator in Excel for deduction under section 80C of Income Tax Act, 1961. Interest earned on NSC purchased of last 5 years is taxable in hand of assesses and it also deductible under section 80C up to limit of section ( currently 80 max. limit is 150000). Click here to download NSC Calculator in Excel.
What is NSC:
National Savings Certificate is a popular mode of small savings investment in India. The NSC rate of interest has been fixed by the government. The NSC (National Saving Certificate) Calculator allows you to calculate the return on your investment when saving using the National Savings Certificate Scheme.
NSC Restrictions
The National Saving Certificate Scheme (NSC) is an excellent investment opportunity but there are some restrictions you should be aware of.
The National Saving Certificate (NSC) scheme has a minimum investment threshold of ₹100.00
National Saving Certificates are issued at a minimum of ₹100.00 certificates though you can also purchase ₹500.00, ₹1,000.00, ₹5,000.00, ₹10,000.00 denomination certificates.
There is no limit on the number of National Saving Certificates that you can buy.
Type of NSC Certificates
There are 3 different types of National Savings Certificate
Single holder Type Certificate: Issued to an individual (the holder) or to an individual on behalf of a minor.
Joint A type Certificate: Issued jointly to two adults. On maturity, the NSC is paid to both of the joint holders
Joint B type Certificate: Issued jointly to two adults in the same way as Joint A type NSC (see above) withe the difference that on maturity, the NSC is paid to one (either one) of the joint holders.