EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Finance Finance Resources Finance Formula Salary Formula

Salary Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated August 3, 2023

Salary Formula

Salary Formula (Table of Contents)
  • Salary Formula
  • Examples of Salary Formula (With Excel Template)
  • Case Study
  • Relevance and Uses
  • Salary Formula Calculator

Salary Formula

The term “salary” has its roots in ancient times when Roman soldiers received an additional payment known as “Salarium” on top of their regular wages. Fast forward to today, and we have the salary formula calculator, a valuable tool for employees to know their growth and estimate various additions and deductions in their salary.

There are several components to consider regarding salaries, and it’s essential to differentiate between gross and net salaries. Let’s take a closer look at the components included in an employee’s salary formula:

ADVERTISEMENT
Popular Course in this category
HR Generalist and Human Resource Management Course Bundle - 26 Courses in 1 | 4 Mock Tests
  • Basic Salary
  • House Rent Allowance
  • Transport Allowance
  • Leave Travel Allowance
  • Statutory Bonus
  • Provident Fund
  • Income Tax
  • Insurance

The salary formula for calculating salary is as follows:

Salary = Basic + HRA + Transport Allowance + FBP Allowance + Bonus – Provident Fund – Income Tax – Insurance

The salary structure can vary significantly between countries due to cultural norms, economic factors, industry practices, job market conditions, cost of living, and local labor laws. Additionally, individual companies may have their policies regarding salary components. Some companies might include additional deductions not mentioned above, while others may have fewer deductions.

In India, for instance, companies often operate under a cost-to-company (CTC) model, which means that formal sector employees experience several deductions from their salary. On the other hand, employees in the informal sector typically receive their full salary amount. In the United States, salaries are often defined by pay scales or hourly wages.

Basic Salary vs. Gross Salary vs. Net Salary

Before we delve into using the salary formula to calculate various types of salaries, we must understand the distinctions between salary computation format. The table below provides an overview of the differences:

Salary Component What is the Basic Salary? What is Gross Salary? What is Net Salary?
Definition The fixed amount of salary before any addition of allowances and deductions of taxes. The amount of salary after adding all benefits and allowances to basic pay but before deducting any taxes. The amount of salary that is credited to your bank account after all deductions.
Salary Formula Basic Salary = Gross Salary – Total Allowances (DA + HRA + Medical Insurance + Other Allowances)

or

Basic salary = CTC x Percentage

Gross salary = Basic Salary + HRA + Other Allowances Net salary = Gross Salary – Income Tax – Professional Tax – TDS – EPF – ESIC
Components – Allowances (DA, HRA, LTA, Conveyance, Medical, Special, etc.)

Perquisites (e.g., car for personal use, rent-free accommodation, phone, internet services, etc.)

Income Tax, Professional Tax, TDS, EPF, ESIC, etc.
Taxable Yes Depending on the Income Tax Act of 1961 provisions, some allowances may be fully or partially exempt from tax, while others may be taxable. Yes
Affected by Income Tax No No Yes

Examples of Salary Formula (With Excel Template)

Let’s learn the salary formula with the following examples by creating a salary sheet in excel with formula.

You can download this Salary Excel Template here – Salary Excel Template

Example #1: How to Calculate Basic Salary?

Let’s consider the below salary structure of Mr. X. Here, we have to find the basic salary.
salary formula-Example 1

Solution:
The formula for calculating basic salary from gross salary is as follows:

Basic Salary = Gross Salary – Total Allowances

According to the above data:
Basic Salary = 50,000–(2,000+1,500+1,000)
= 45,500

Result: The basic salary of Mr. X is ₹45, 500, as shown below.

Example 1 Solution

Example #2: How to Calculate Gross Salary?

Let’s consider the below salary structure of Mr. X. We have to find the gross salary from the basic salary.
salary formula-Example 2

Solution:
The formula for calculating gross salary from basic salary is:

Gross salary = Basic Salary + HRA (House Rent Allowance) + Other Allowances.

According to the above data:
Gross Salary = 45,000+2,000+1,500+1,000
= 50,000

Result: The gross salary of Mr. X is ₹50,000, as shown below.

Example 2 Solution

Example #3: How to Calculate Net Salary?

Let’s consider the below salary structure of Mr. X. We will calculate the net salary from the gross salary.
salary formula-Example 3

Solution:
The formula for calculating net salary from gross salary is as follows:

Net salary =Gross Salary-Total Deductions

According to the above data:
Gross Salary=50,000-(2,000+1,000)
= 47,000

Result: The net salary of Mr. X is ₹47, 000, as shown below.

Example 3 Solution

Example #4: How to Calculate Annual Salary?

Let’s calculate the annual salary of Mr. X from his gross salary.

Solution:
The formula for calculating annual salary from gross salary is as follows:

Annual salary = Net Salary X 12

According to the data of the previous example:
Annual Salary = 47,000 x 12
= 5,64,000

Result: The Annual Salary of Mr. X is ₹5,64,000, as shown below.

salary formula-Example 4

Example #5: How to Calculate Hourly Wage?

Suppose Mr. Y’s gross pay is $500 a week, and he has worked 25 hours a week. Now, we want to calculate his hourly wages.

Solution:
The formula to calculate hourly wages is

Hourly wages=Gross Pay/ Working Hours

According to our data,
Hourly wages = 500/25
                            = 20

Result: The hourly wage of Mr. Y is $20 per hour, as shown below.

Example 5

Example #6: How to Calculate Commission-Based Pay

Let’s consider a scenario in which you are a salesperson of XYZ company. You made $25,000 worth of sales on Product A, and your commission rate is 5%. Here, you want to know your gross commission on Product A.

Solution: Here,
Commission Base (Sales Amount) =$25,000
Commission rate = 5%

The following is the formula for calculating Gross Commission:

Gross Commission = Commission Base X Commission Rate

According to the data,
Gross Commission = 25,000 x 0.05 (5%)
=1250

Result: Your gross commission for product A sale would be $1,250.

salary formula-Example 6

Example #7: How to Calculate Salary with Overtime?

According to the FLSA (Fair Labor Standards Act), companies must provide overtime, also known as premium pay, to nonexempt employees who work over 40 hours a week.

The formula for calculating overtime payment as per FLSA is

Overtime pay = Hourly Pay Rate x 1.5 x Extra Hours Worked.

Let’s consider a scenario of a nonexempt employee who worked 45 hours in a  workweek beyond the regular working hours of 40 hours. He earns $20 per hour. We have to calculate the total pay, including the overtime premium for that week.

Solution:
Base Pay/Regular Pay = $20 x 40 hours
=$800
Example 7

Overtime Hours=  5 hours

Overtime payment($) =Hourly Pay Rate x 1.5 x Extra Hours worked.

= $20 x 1.5 x 5
= $150
salary formula-Example 7-2

So,
Total Due Pay = $800 + $150
= $950

Result: The employee’s total pay for that week would be $950.

Example 7-3

Case Study

A company has recently hired Jane. She is eager to understand how her gross salary is calculated and what deductions will be made to arrive at her net salary. In this case study, we will analyze the components of Jane’s salary and the applicable deductions and provide a step-by-step solution to calculating her net salary.

The following infographic shows her conversation with HR team members. Take a look at the conversation to understand the process of the interview. After that, you can find the solution for calculating Jane’s net salary.

Salary Formula Infographic

Given:

  1. Gross salary: $45,000 per year
  2. Deductions:
    • Tax Deduction: 20% of Gross Salary
    • Health Insurance: $700 per year
    • Retirement contributions: $300 per year

Solution:

Step 1: Calculate the total deductions
Tax Deduction = 20% of Gross Salary
= 20/100 * $45,000
= $9,000

Health Insurance: $700 per year
Retirement Contribution: $300 per year
Total Deductions = $9,000 + $700 + $300 = $9,000 + $1,000
= $10,000

Step 2: Calculate the net annual salary

Net Salary = Gross Salary – Total Deductions

= $45,000 – $10,000
= $35,000

Step 3: Calculate the net monthly salary
To find the net salary per month, we will divide the net annual salary by 12.
Net Salary per Month = $35,000 / 12
= $2,916.67

Result:
Using the monthly salary calculation formula, we find that Jane’s monthly net salary would be approximately $2,916.67. Employees like Jane must clearly understand how their net salary is calculated after accounting for all the deductions. This case study provides a comprehensive solution for job seekers to better understand their salary structure before accepting a job offer.

Relevance and Uses of Salary Formula

The salary formula calculator can be of the following use:-

  • The salary formula calculator tells the employee about their growth. And if any deduction is unclear to the employee, they can seek the help of the human resource department to clarify it.
  • The salary calculation formula also tells the employee about their standing in the company and determines whether they are underpaid or overpaid.
  • The salary formula is useful when the company plans and implements the initiative for reducing human resource costs. Moreover, the calculator can be helpful in computing salaries and the compensation paid to the staff and top management and can help identify the roles that are overpaid or redundant.
  • The salary calculation formula in Excel also reduces the workload of the human resource department, which needs to compute the salaries of different individuals on payday.

Salary Formula Calculator

Basic
HRA
Transport Allowance
FBP Allowance
Bonus
Provident Fund
Income Tax
Insurance
Salary Formula
 

Salary Formula = Basic + HRA + Transport Allowance + FBP Allowance + Bonus - Provident Fund - Income Tax - Insurance
0 + 0 + 0 + 0 + 0 - 0 - 0 - 0 = 0

Recommended Articles

This article has been a guide to the Salary Formula. Here we discuss how to calculate the salary along with practical examples. We have also provided Salary Calculator with a downloadable Excel template. You may also look at the following articles to learn more:

  1. How to Calculate Opportunity Cost?
  2. Contribution Margin Formula
  3. Calculation of Variable Costing
  4. Retained Earnings Formula
  5. Contribution Margin Income Statement
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Salary Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Salary Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW