How To Create Income Tax Calculation Excel Worksheet

Microsoft Excel may be used to prepare employee pay sheet with Basic pay, medical allowance, conveyance allowance, house rent and income tax entries. Each of the mentioned entries in worksheet will be calculated automatically using functions and custom formulas applied to required cells in worksheet.

income tax calculation employees formulas excel

Income Tax calculation Formulas Calculate pay of employee using income tax in Excel

After entering the sample data in the worksheet, following formulas will be applied:

Q: Create an MS Excel Worksheet to calculate Net Pay of Employees. Input is EmpID, Name, Job
and Basic Pay. Fill sample data in it as shown in the figure. Calculate Medical Allowance 10% of basic pay, House Rent 50% of basic Pay and Conveyance Allowance 30% of basic pay. Deduct income tax 5% of basic pay if basic pay is less than 30000 and income tax 10% otherwise.
BASIC FORMULAS:
Medical Allowance = D3 * 10%
House Rent = D3 * 50%
Conveyance Allowance = D3 * 10%
Income Tax = IF(D3<30000,D3*5%,D3*10%)
Net Pay = SUM(D3:G3)-H3

You would like to :

EXPLORE more Microsoft Excel Formulas for Worksheets and downloads

Electricity Bill Calculator Formulas in Excel

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel

Students Test Score Grades Result Sheet in Excel

Microsoft Office Word Processing Practicals

Comments

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...

Paper Pattern For B.Sc. ACS - Advanced Computer Studies Class Islamia University Bahawalpur

Download Paper Pattern For B.Sc. Advanced Computer Studies ACS Class Islamia University Bahawalpur The Islmia University of Bahawapur REVISED CURRICULUM of ADVANCED COMPUTER STUDIES (ACS) For B.A / B.SC.EXAMINATION 2005 & ONWARDS Paper Pattern For ACS, B.Sc. Advanced Computer Studies, Islamia University Bahawalpur COURSE MARKS: 200 THEORY: 160 PRACTICAL & PROJECT: 40 ACS - Third Year (B.Sc Part-I) Paper I, II and C++ practical will be offered in the third year ACS - Fourt Year (B.Sc Part-II) Paper III. IV and project work will be offered in fourth year. Paper I, II, III and IV all have two sections each which carry equal mark. THIRD YEAR PAPER – I Introduction to information Technology 40 PAPER -II Programming using C++ 40 PROJECT PRACTICAL using C++ 20 FOURTH YEAR PAPER -III Data Base Management system 40 PAPER-IV Introduction to Web Programming 40 PROJECT 20 ASSESSMENT METHOD ...

Bus Topology Advantages Disadvantages

Bus Topology Bus topology is the simplest network topology . In bus topology , all computers in network are connected to a common communication wire. This wire is called BUS. Terminators are used at both ends of wire. Bus Topology is Cheap, easy to handle and implement. Bus Topology require less cable. Bus Topology is best suited for small networks. Working of Bus Topology with Advantages and Disadvantages Advantages of Bus Network Topology 1. It is very simple topology . 2. It is easy to use. 3. It needs small amount of wire for connecting computers. 4. It is less expensive due to small wire needed. 5. If one computer fails, it does not disturb the other computers in network. Other computers will continue to share information and other resources with other connected computers. Disadvantages of Bus Network Topology 1. Only small number of computers can be connected in a bus network . 2. Network speed slows down as the number of computer increases in b...

Perfect Computer Notes

Search This Blog