Calculate The Tax On Any Income

Apr 21, 2009

I'm trying to write a function that takes a single argument grossIncome of type Currency. It should calculate the tax on any income using the following tax schedule

1) If income is less than or equal to $15000 there is no tax.
2) If income is greater than $15000 and less than or equal to $75000 the tax is 15% of all income greater than $15000
3) If income is greater than $75000 the tax is 15% of all income between $15000 and $75000 plus 20% of all income greater than $75000

Then I want to write a sub that asks for the user's income and have the above function calculate the tax on the income and say the tax in a message box.

View 2 Replies


ADVERTISEMENT

Calculate Tax Based On Income

Jan 26, 2008

I am working on a tax deduction formula for payroll. I need 3 formulas. The first formula needs to find two cells that are on the same row based off the employees status and gross income.

View 5 Replies View Related

Calculate Average Weekly Income For Business?

Mar 3, 2014

I have created a table for a business to monitor all income and expenses within a financial year of that business. This table contains raw data for example, date, income/expense, wholesale amount, retail amount etc. So when the business makes a sale for example I enter in the date of the sale, type of sale, wholesale and retail amounts etc, and i do this for every sale I make.

What i need to do is figure out a way to calculate the average monthly and weekly income to date so as the financial year continues and i make more sales i will continue to enter more data into this table and it will automatically adjust to the new weekly or monthly average income. This way i always have an actual and live average for every cent the business has made as the year progresses and i can use this to budget for the business. I would also like to know what the income is for the current week or month. that way i can say for example on average the business makes $4000 a week and in this week it has made say $5000.

View 13 Replies View Related

Find Median Of Large Set Of Numbers To Calculate Median Income?

Mar 6, 2014

We are trying to find the median of a large set of numbers to calculate the median income in 2010. For an example we have 8,379k people with $2500 average income, 9,783k with $7500 average income and so on. How can I calculate the median average income of such a large amount of entries?

View 8 Replies View Related

Sum Of Income By Month

Jun 26, 2009

I have a spreadsheet that contains entries for each order of a product and the product amount. What I want to do is have a summary of this for income. So, if there is a date completed for the order, I want a sum of this for the month.

Order No. Order Amount £ Date Ordered Date Complete
A2 B2 C2 D2

View 9 Replies View Related

Add Income Only Between 1st And 15th Of Each Month

Dec 7, 2008

I am a car salesman and made a sheet to track my sales from month to month. I would like to make a formula to only add the entries that fall between the 1st and 15th of each month to show me what my check will be for the first half of the month. Column A has the dates and column J has the amount. I need to calculate only the first half of the month in J24 to know what my mid month check will be......

View 3 Replies View Related

VLookup On Income Overview Statement

Jul 27, 2013

I am trying to use vlookup on the the income statements I am using. I have a workbook called overview with all the months and need the "total" of each month to appear automatically. The previous vlookup formula does not seem to be working.

View 13 Replies View Related

Macro To Submit A New Income Into A Table

Mar 8, 2007

I m making a spreadsheet for Income and Expenditure Calculations. The problem i'm having is creating the macro to submit a new income into a table.

As you can see from the above image ive got a cell to type in the income amount and a combo box to select the month that it applies to, my problem is the VBA code for the "GO" button.

I started by trying to name the value from the combobox as something e.g. selectedincomemonth = ComboBox1.Value

However this wouldnt recognise as an object, what do i have to do to get VBA to recognise what has been selected from the ComboBox, and could somebody help me with the code to search what has been selected in a list.

View 9 Replies View Related

Estimate Total Income Of Values

Mar 27, 2007

i wanted to ask that in excel i have different values, if i post on ere its so long actually i cant post it coz it will tke ages to do so; so wot i wanted to no that how to estimate total income of values? and how to estimate annual profit/loss?; i mean the formula to find these terms.

View 9 Replies View Related

Excel Formulas For Calculating Yearly Rental Income

Jul 18, 2011

I am trying to get the formula for calculating yearly rental imcome. The range is 10 years and the interest is 34%. The first year payment is 42,000 and the 10th year payment is 56,000. I can't figure out how to do the other years. The principal is 325,000 and the sale value is 425,000.

View 4 Replies View Related

Calculate The Value In The NPV

Aug 29, 2008

I have two columns in a payment schedule (which adjusts according to certain user inputs) that I need to use in my NPV calculation.

The first column is the Total Payment and the second is Inducements.

Therefore each value in the NPV calc. needs to be the sum of a given period's payment and inducement (but i don't want/have a separate column which calculates the sums). The number of periods adjusts with the users input of Term. There also may be periods where there is a payment but no inducement.

View 14 Replies View Related

Calculate Down To Last Row

Dec 22, 2011

The formula below calculates between rows 2 and 109. How can I change it to calculate between row 2 and the last used row in the sheet.

Code:
Range("D2").Select
ActiveCell.FormulaR1C1 = _
"=(RC[-1]-MIN(R1C[-1]:R109C[-1]))/(MAX(R1C[-1]:R109C[-1])-MIN(R1C[-1]:R109C[-1]))"

View 2 Replies View Related

Calculate IRR & NPV

Jan 10, 2007

i got a problem to calculate IRR and NPV for my company cash flow. i so confuse how to calculate cos the initial investment (expense) is pay in installment by yearly basis. i hope anyone can help me to solve this problem.

I m not sure whether what i'm doing is correct or not. thanx

http://spreadsheets.google.com/ccc?k...Hd2JSrIj7H-Pew

View 9 Replies View Related

Calculate How Many Of The Same Value In A Row?

Feb 17, 2007

If I have this serie of values in the A column:

34
33
33
33
30
29
26
26
20
19
17
17

And want this results in the B column:

1
3
3
3
1
1
2
2
1
1
2
2

Those numbers will indicate how many of the same are in a row.

What's the easiest way to accomplish this?

View 7 Replies View Related

How To Calculate Age

May 13, 2009

to calculate the age from the format date of birth shown below.

SQL Data  S1Date of Birth2Jun  9 1947 12:00AM3Jan  1 1957 12:00AM4Jan  1 1958 12:00AM5Jan  1 1956 12:00AM6Jun  4 1951 12:00AM7Dec 10 1963 12:00AM8Jun 17 1958 12:00AM Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies View Related

Sub Calculate

Feb 24, 2010

I am trying to call a sub calculate but I keep getting errors, is calculate a reserved sub name?

View 9 Replies View Related

Calculate Net Pay After Tax

Feb 18, 2008

building a spreadsheet. I have the total price in cell f6. In cell C6 I need price with no taxes. D6 should be the pst of 8% and E6 should be the gst of 5%.

View 3 Replies View Related

Formula To Calculate GST

May 6, 2013

Formula to calculate GST? I have a Non-capital and a Capital column, then a Claimable GST column.

I currently have '=SUM(E5/11)' in the Claimable GST column (G5).

If E5 is a zero value I need the sum of F5/11 in G5.

View 2 Replies View Related

If Blank Do Not Calculate

May 16, 2014

I have the following scenario on the attached worksheet: I need b45 to say 0% if b42 and b43 are left blank.

View 3 Replies View Related

Calculate Percentage Of Value

Jun 21, 2014

I have a simple issue i cannot figure out how to write a formula for.

In A2 i have the number of operations.

In A4 i have the percentage of CPU usage it requires to complete those operations.

I need an output somewhere that will tell me how may operations I can get per 0.1% of CPU usage.

View 5 Replies View Related

Calculate Until Difference Is Zero

Jul 24, 2014

I'm trying to automate the attached schedule so that the formulas in H stop increasing once the amount in column J equals zero. So far everything I've tried either gives me a circular reference error or ends up giving me the same result as if I depreciated the asset an additional month.

View 3 Replies View Related

Formula To Calculate TAT?

Feb 22, 2014

I need to calculate a TAT formula for the below case

P1 -- 1 Hour
P2 -- 2 Hour
P3 -- 4 Hour
P4 -- 8 Hour

Shift Start time : 6:30pm
Shift End Time : 3:30am

Suppose a request comes at 9:30pm and it is Priority 1 (P1) then it should be completed at 9:30pm + 1 hour = 10:30pm. I have given the below formula to execute this

=IF(A2="P1",1,IF(A2="P2",2,IF(A2="P3",4,IF(A2="P4",8,0))))

=B2+(TIME(D2,0,0))

The problem here is if the request is P4 then its 8 hr TAT and the formula will calculate the time as 5:30am. Since the shift time end at 3:30am itself the actual TAT should be the next day 8:30pm.

formula to calculate the TAT which includes the start time and end time and also excludes the weekends and holidays.

View 14 Replies View Related

How To Calculate Overtime

Sep 5, 2008

I am trying to formulate a formula that will calculate overtime hours worked.
Now standard hours are 17:30pm - 20:45pm. Anything outside these hours are overtime. If the start time is 18:00pm then the person is still paid from 17:30pm @ standard rate regardless.

Now I am trying to work out a formula that will cover hrs outside of the standard hrs AND hrs unworked but paid for.

see attached! September tab {blue highlighted cells}

View 9 Replies View Related

Calculate The Date..

Feb 23, 2009

Is there a formula for calculating date for every 2nd thursday of the month excluding holidays?

View 4 Replies View Related

Calculate Variances

May 14, 2009

Just wanted to find out if the formulas in the attached apreadsheet are correct. Formulas from E6 to E10.

Also, if you multiply the "new daily target" with "working days" should'nt this give you the "remaining" figure? Currently it's not doing this

View 11 Replies View Related

Calculate The Hours

Jun 16, 2009

How to calculate the Hours
Check the attached file

View 5 Replies View Related

Calculate Retrospectively

Jul 14, 2009

I need to create a formula to work backwards from a closing balance to establish an inventory value on First In, First Out principles. The attached spreadsheet probably explains it better.

View 2 Replies View Related

Calculate Total

Aug 13, 2009

I need a formula that will calculate the total of the items in column "W" when the row directly below it contains a "1" in column "V". It will need to calculate the totals from that row all the way up to the next row that contains a "1" in column V.

Example:

In X14 (where I will put the formula) it would total W9 through W14. However the formula still needs to be able to calculate the total if there are more or less cells to sum. So that the same formula could calculate that in X8 it will total W5 through W8.

View 14 Replies View Related

Calculate A Certain Weekday

Oct 28, 2009

I need to set up something that "calculates" an orders next delivery date. We deliver on Tuesdays, Wednesdays, and Thursdays for different stores. IE.

Store 1 - Today's Date-Wednesday 10/28/09 = Next delivery date is Tuesday 11/3/09.
Store 2 - Today's Date-Wednesday 10/28/09 = Next delivery date is Wednesday 11/4/09.
Store 3 - Today's Date-Wednesday 10/28/09 = Next delivery date is Thursday 10/29/09.

View 3 Replies View Related

Formula To Calculate A %

Nov 2, 2009

I use this formula to calculate a %, but naturally when there is a 0 excel returns the #DIV/0! error. Can someone fix my formula so the error gets replaced with a 0
in the formula the 0 would be in cell W2 =IF(N2="yes",BN2/W2,0.5).

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved