Calculating daily weekly hourly yearly salary in excel sheet

Why choose wikiHow?
When you see the green expert checkmark on a wikiHow article, you know that the article has received careful review by a qualified expert. If you are on a medical article, that means that an actual doctor, nurse or other medical professional from our medical review board reviewed and approved it. Similarly, veterinarians review our pet articles, lawyers review our legal articles, and other experts review articles based on their specific areas of expertise.

How to Figure Out Your Yearly Salary

Three Methods:

If you are paid by the hour as an employee or contract worker, calculating your hourly income as an annual salary can be useful. You'll often need to provide your annual salary on applications. Or, you may want to compare salaries between new job opportunities. Either way, you can figure out your yearly salary using simple formulas and basic math.


If You Work the Same Number of Hours Each Week

  1. Find out your hourly wage.You probably already know how much you make per hour. For example, you might make /hour. But if you don't, you'll need to find this information.
    • Your hourly wage should be listed on your pay stub, if your employer provided one.
    • If you aren't sure, you can also ask a manager, or someone in the personnel/human resources department.
  2. Calculate the total hours you work each year.Multiply the number of hours you work each week by 52, the number of weeks in a year.
    • Remember, too that you should include any vacation hours earned or paid in a year. For instance, if you work 50 weeks out of the year, but you earn a two-week paid vacation, then your total weeks paid is 52. If you take unpaid vacations, then take this into account as well.
    • For instance, if you work 40 hours a week, your math would look like this: 40 hours * 52 weeks = 2080 hours a year.
  3. Multiply your hourly wage by the number of hours you work each year.Now, all you have to do is multiply your hours by your wage.
    • Following the example above, * 2080 = ,200. This is your annual salary.

Method 1 Quiz

How can you find out how much money you make an hour?

If You Work a Different Number of Hours Each Week

  1. Keep track of your hours.Write down the number of hours you work each day. At the end of the week, calculate how many hours total you worked.
    • You can use a variety of electronic applications, online software, or even just write it in a notebook.
    • If your hours vary from week to week, you will want to keep track of your hours for a longer period of time. Then, you can average the numbers.
    • For example, if you work 10 hours one week, 25 the next, 15 the following, and 30 the last week, you end up with 80 hours for the month. Divide this by 4 weeks and you get an average 20 hours a week.
    • If your hours vary a great deal between different times of the year, you may need to track an even longer period. For example, imagine you work 50 hours a week for a couple of weeks around the holidays, but only 20 hours a week during the summer. This is going to affect your calculations a lot. In the case of large variations, you might even have to track your hours over a whole year to get an accurate figure.
  2. Determine how many overtime hours you worked.If you work more than 40 hours in a 7-day period, your employer must pay you at one and a half times your regular wage. In other words, you should receive a half-hour credit for every hour you worked over 40 hours in a week.
    • The formula for this calculation is: Total weekly payroll hours = Actual hrs worked + [.5 * (actual hrs worked - 40)]
    • For example, say you work 45 hours one week. This is 5 hours of overtime. Multiply 5 by .5. This gives 2.5 extra hours.. Add this to the 45 regular hours. For this calculation, your hours for the week are then 47.5, rather than 45.
  3. Calculate how many hours you work in a year.To figure this out, multiply the average weekly payroll hours by 52.For example, if you usually work about 45 hours a week, multiply 47.5 hours (adjusted for overtime) by 52. This equals 2,470 hours a year.
    • If you track your hours for a whole year, you can simply add them up, rather than multiplying a weekly average by the number of weeks worked.
  4. Calculate your salary.Multiply the number of hours by your hourly wage.
    • For example, if you make /hour multiply 2,470 by . This equals an annual salary of ,050.

Method 2 Quiz

If you work more than 40 hours a week, what changes should you make to calculate your annual salary?

Additional Considerations

  1. Include bonuses.Add any bonuses, commissions or incentive payments you got to the annual salary figure. Many hourly positions have incentive arrangements that add to the hourly wage. For example, you might receive bonuses based on productivity, leadership, or tenure (length of time at the job).
    • Some employers provide a holiday bonus to all employees each year. Sticking with the example in Part 1, imagine you get 0 bonus every year. Your math would look like this: ,200 + 0 = ,400.
    • If you receive a commission or other variable bonuses, you'll need to keep track of them over the course of a year to include them here. For example, imagine you get a bonus every time you reach a certain level of sales. If you get this bonus 12 times over the course of a year, you multiply time 12, getting 0. Sticking with the above example, you would then add ,400 + 0 to get ,000.
  2. Deduct benefits and payments.If you're paying into your health care or a 401(k), you may want to subtract these costs to get a measure of your "take-home pay."
    • These amounts are still technically a part of your income. But, they represent money that does not increase your purchasing power.
    • Look at your pay stub to find out how much is deducted for these expenses each month. To get an annual figure, multiply the monthly payment by 12. Subtract it from your annual income.
    • For example, if health care costs you 0 a month and you're putting 0 into a 401(k), that adds up to 0. 0 x 12 = 00. Subtract this from your annual salary.
  3. Determine how much you pay in taxes.This will let you figure out your salary before or after taxes.
    • You'll need to look up where you fall in the federal tax bracket to determine how much you'll pay in federal income tax. Your annual income will determine how much you are taxed. There are online tax bracket calculators that can help you figure this out if you don't know which bracket you are in.
    • Your state tax will depend on where you live. Some states have no income tax. For those that do, it will probably be about 5-6%. You can find your state's income tax rate online.
    • Subtract your income tax percentage from 100%. For example, if you're in the 20% bracket, you'd end up with 80%.
    • Change this percentage to a decimal by moving the decimal point two places to the left. For example, if you keep 80% of your income, the decimal equivalent would be .80 (or just .8).
    • Multiply your monthly income by the decimal to get your pay after taxes. You can calculate either your monthly or annual pay in this way.
    • If you make 00 a month and fall in the 30% tax bracket, your decimal equivalent is .7. Multiply 00 x 0.7 to get 60 a month. This is the amount you receive after taxes are taken out.

Method 3 Quiz

True or False: "Take-Home" pay represents your entire paycheck.

Community Q&A

  • Question
    How do I calculate my yearly salary if I am paid every two weeks?
    wikiHow Contributor
    Community Answer
    Multiply your biweekly salary by 26. There are 52 weeks in a year, so you will get paid that salary 26 times in a year.
  • Question
    How can I calculate my monthly salary?
    wikiHow Contributor
    Community Answer
    Divide your yearly salary by twelve.
  • Question
    How would I determine the monthly increase when the increase was 5%?
    Top Answerer
    Monthly increase is one-twelfth of the annual increase.
  • Question
    Can a raise be taken away do to change position?
    wikiHow Contributor
    Community Answer
    Probably. It depends on the employer and job.
  • Question
    I have been given a job offer in the UK with a basic salary of 13000.00 per year. My contract is for a 9 month fixed-term. What is my monthly salary? Am I going to get 13000.00/9=1444 per month for 9 months, or is it going to be 13000.00/12=1083 per month for 9 months?
    Top Answerer
    Only your employer knows the answer to that question.
  • Question
    If my salary is ,000.00 a year, how much is that hourly?
    Top Answerer
    Roughly an hour.
  • Question
    How can I figure my hourly rate if I know my yearly salary?
    Top Answerer
    You can find an approximation of your hourly rate. You would have to know exactly how many hours you worked during the year and whether you earned any money at special rates such as overtime, night differential, holiday pay, etc.
Unanswered Questions
  • What is the average yearly salary for a civil engineer?
  • How do I find my yearly income from my 1099?
  • What are the required number of hours laid down by the department of labor in the Basic Conditions of Employment act?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Quick Summary

To figure out your yearly salary, start by finding out your hourly wage and calculating the total hours you work each year. Next, multiply the number of hours you work each week by 52 to determine how many hours you work a year. Make sure to deduct any unpaid time off. So, if you have a 2 week unpaid vacation, multiply the number of hours you work each week by 50 instead. Once you figure out your yearly hours, multiply this number by your hourly wage to find your annual salary.

Did this summary help you?
  • According to the Fair Labor and Standards Act, an hourly worker must be paid for waiting time. This is time in which the employer requires an employee to be present, even if there is no work to do. You should also receive pay for on-call time, in which you must stay on the premises to potentially work. You are also entitled to pay for rest and meal periods. Rest periods are usually less than 20 minutes; you should receive pay for meal periods if you have to be available to work.
  • You can easily reverse the calculations, using annual income to find the equivalent hourly wage. Divide the total annual compensation by your hours worked. If you work full time, this will be 2080 hours (52 weeks of 40 hour work weeks). For example, someone with an annual salary of ,500 would make .51 when the salary is divided by 2080.
  • If you get paid vacation or sick time and didn't work for a few weeks, don't adjust the number of weeks you were paid for (52). If you took a few weeks of unpaid vacation time, subtract the number of weeks from 52.

Related wikiHows

Sources and Citations

Article Info

Featured Article

Categories: | |

In other languages:

Deutsch: , Português: , Español: , Italiano: , Français: , Русский: , Bahasa Indonesia: , Tiếng Việt: , 日本語: , العربية: , 한국어: , ไทย: 

Thanks to all authors for creating a page that has been read 527,928 times.

Video: How To Turn Your Yearly Income Into Your Monthly Income - Bob Proctor [ The Law of Compensation ]

How to Figure Out Your Yearly Salary
How to Figure Out Your Yearly Salary images

2019 year
2019 year - How to Figure Out Your Yearly Salary pictures

How to Figure Out Your Yearly Salary forecast
How to Figure Out Your Yearly Salary forecast photo

How to Figure Out Your Yearly Salary photo
How to Figure Out Your Yearly Salary photo

How to Figure Out Your Yearly Salary How to Figure Out Your Yearly Salary new pics
How to Figure Out Your Yearly Salary new pictures

photo How to Figure Out Your Yearly Salary
pics How to Figure Out Your Yearly Salary

Watch How to Figure Out Your Yearly Salary video
Watch How to Figure Out Your Yearly Salary video

Forum on this topic: How to Figure Out Your Yearly Salary, how-to-figure-out-your-yearly-salary/
Discussion on this topic: How to Figure Out Your Yearly Salary, how-to-figure-out-your-yearly-salary/ , how-to-figure-out-your-yearly-salary/

Related News

15 Healthy Lunch Recipes for When Youre So Busy You Cant Even
Unbelievably Easy Fixes for Winter Hair Problems
35 Gorgeous Prom Updos
The One Thing: Korres Quince LipButter
17 Tactics to Drastically Improve Communication in Relationships
Milly Dawson
How to Focus on Studying
Outfits with Jeans-50 Best Looks with Jeans You can Have Now
How to Apply Wall Decals
How to Stay up All Night Without Your Parents Knowing
How to Make Your Self Worth About More than Your Career
The Complete Guide To Sunglasses Styles
How to Solder Aluminum
There’s a New Shopping Site That Offers Insane Deals In the Form of an AddictiveGame

Date: 12.12.2018, 09:42 / Views: 72491