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 Application Software? Users can use Appli

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures, or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2) Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and other facilities in the

Advantages and Disadvantages of Ring Network Topology

Topic: Advantages and Disadvantages of Ring Network Topology alongwith detailed working of Ring topology What Do You Mean by Ring Topology? In Ring topology, each computer is connected to the next computer such that last computer is connected to the first. Every computer is connected to next computer in the ring. Each computer retransmits what it receives from the previous computer. Suppose, computer A needs to send data to computer D. Now the computer A sends data to computer B. As computer B is not the destination computer, so it will retransmit data to computer C. Finally, Computer C will transfer data to computer D, the destination computer. When a node sends a message, the message is processed by each computer in the ring. If a computer is not the destination node, it will pass the message to the next node, until the message arrives at its destination. Advantages of Ring Network Topology 1. It is relatively less expensive than a star topology network. 2. In a Rin

Perfect Computer Notes

Search This Blog