taxes

Trying to write a sheet to track employee pay for about 10 employees. I can figure out the hours worked easily enough. What is the simplest way to figue the employee share of fed and state taxes? All of our employees will earn less than 100k per year, but may have different with holding numbers...

I'm having a lot of trouble starting this sub in vba. Here is what I have already, but I'm not sure if I'm taking to right angle. Sub tax()Dim income As Double Dim tax As Double income = InputBox("enter your income") If income >= 200000 Then tax = ".35/income" else if income End Sub Assume...

I am building a cash flow model. Standard income and expenses. the model has months 1-60. I need the expenses to me put in by range. for example taxes will be in month 13 to 33 and insurance will be in months 19 - 44. I am looking for a formula that will look up the ranges and return data in the...

I would like to be able to include my income (various sources), deductions, taxable income, federal tax paid, state tax paid, tax percentage, etc for the past 20 years. I have the data from my income tax returns but am not very good at setting up an excel spreadsheet. I don't mind entering it...

Good afternoon, I'm trying to find out if I can set up a query to pull data based on two criteria on a single field. I have a table containing all the properties in the county and taxes owing back to the mid 90's. What I would like to do is query all the properties where they have taxes...

I have sumif formulas calculating the net for the month; all of them work except January. January also counts cells that don't have a date at all. The users want to calculate their net before taxes, so the taxes date is left blank so they don't factor into any month. However, January then...

I'm afraid to even ask this because I know someone is going to answer in a coding language that I don't understand. I have built a pretty intricate retirement calculator in excel with lots of =IF, =VLOOKUP, =SUMIF, etc. formulas. I don't know anything about macro or VGA, etc. I'm gonna try to...

I need some help :-) (don't worry about the dutch words, not important for the question) So I'm making a sheet that can keep my income and costs every month and calculate my taxes etc automaticly. Fot taxes and other stuff in Belgium we use a system based on net income according to the...

I'm struggling with the below formula in Column C. I'm trying to return only the first instance of the data in Column A while maintaining the if statement to column D. <tbody> A B C D 1 GL Recon '=ROUND(IF(D4="Y",SUMIFS($B$13:$B$17,$A$13:$A$17,$A4),IF(D4="N",0)),2) 2 Invoice# Amount...

If net income is at least $15,000 and at most $35,000, taxes paid are 28% of income above $15,000, else, If net income is less than $15,000 then taxes paid are 15% of income above $8,000. else, If net income is greater than $35,000, taxes paid are 33% of income above $35,000 B22 is cell...

I'm trying to figure out this guy's federal tax withholding calculator, but aside from the marginal tax rate, I don't understand where he's getting the numbers for the Base Tax or whatever the column to the left of it is. He's using 2008 tables, and here's the current tables (page #44) to...

Hi, I have to calculate taxes on an amount of 283000 euro and for furter use as template 3% on the first 50.000 euro 9% till 250.000 euro 27% above 250.000 euro What is the best formula to use for this. Thanks in advance Kind reagrds Al