Question: Use the VLOOKUP function to determine your state tax due for 2020 if your income was 100,000. Following is the tax table. Taxable Income>= Margin

Use the VLOOKUP function to determine your state tax due for 2020 if your income was 100,000. Following is the tax table.

Taxable Income>=              Margin Tax Rate                 Base Tax

               0                                      0%                                    0

              10000                              2                                       0

               20000                             3                                       200

               60000                             4                                       1400

               120000                           5                                       3800

               200000                           6                                       7800

Step by Step Solution

★★★★★

3.47 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Tax liability999... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Objective: Learn how to use the VLOOKUP function for payroll calculations. a. Read the section titled Data in Different Places and create the spreadsheet illustrated in Exhibit 6. Print a screen shot...

Q:

Develop a spreadsheet using the VLOOKUP function to simulate 50 rolls of a pair of dice using the approach described in this chapter Construct a histogram of the outcomes and compare it to the...

Q:

Table 6 shows a recent state income tax schedule for individuals filing a return in Kansas. (A) Write a piecewise definition for the tax due T(x)on an income of x dollars. (B) Graph T(x). (C) Find...

Q:

4. The Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings account balances, number of...

Q:

Telephone calls come into an airline reservations office randomly at the mean rate of 15 calls per hour. The time between calls follows an exponential distribution with a mean of 4 minutes. When the...

Q:

Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet, part of which...

Q:

Develop a procedure to sample from the probability distribution of two card Consider the experiment of drawing two cards with-out replacement from a deck consisting of only the ace through 10 of a...

Q:

Sparkle Pool Toys Corporation manufactures a variety of pool toys. Sparkle has just received a special order for a large volume of pool toys at reduced special order prices. The following is a...

Q:

Develop a procedure to sample from the probability distribution of two-card hands in Problem 2. Implement your procedure on a spreadsheet and use the VLOOKUP function to sample 20 outcomes from the...

Q:

Telephone calls come into an airline reservations office randomly at the mean rate of 15 calls per hour. The time between calls follows an exponential distribution with a mean of four minutes. When...

Q:

Suppose that a bank faces the following cash inflows and outflows during the coming week: (a) Deposit withdrawals are expected to total $33 million, (b) Customer loan repayments are expected to...

Q:

How is the Basel Agreement likely to affect a bank's choices among assets it would like to acquire?

Q:

Evaluate the integral. 6 7 1 x 2 - 1 d x

Q:

Still working on the publication you have been asked to calculate the small business deduction and then explain how it works 1. What is the purpose behind the small business deduction 2. Is this...

Q:

A plot of Vo vs. Vo/[S] is shown below for a sample enzyme-catalyzed reaction. The green line was obtained in the absence of inhibitor. Which of the other curves (A, B, or C) shows the enzyme's...

Q:

The equilibrium constant Ke for the reaction Na + 3H2 = 2NH, is 0.159 at 450C. Calculate the equilibrium composition when 2.00 mol N2 is mixed with 6.00 mol H2 in a 5.00 L vessel. [N2] = M %3D [H2] =...

Q:

A government has $10 million of 20-year general obligation bonds outstanding. The bonds bear interest of 8% per year, payable semiannually each April 1 and September 1. In addition, principal...

Q:

Outgassing depends is a major consideration when designing vacuum systems. Which of the following is an example of a practical material for building a vacuum chamber? silicone elastomer stainless...

Q:

Classify each of the following traits to distinguish between a genetically modified organism and natural breeding organisms. a. Organisms in which the genetic material has been altered in a way that...

Q:

The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate information about the bond assuming two different market...

Q:

PLEASE ANSWER THESE QUESTIONS IN EXCEL FORMULAS!!!! (Give me answers for yellow and grey boxes in the sheet. I don't need numbers. I need formulas to type in!!) The sheet provided above was provided...

Q:

answer the all question please equired Homework Questions The concept of earnings power is the long-term (3 to 5 year) expectation of the company's earnings after any near-term anomalous behavior has...

Q:

answer the all question please equired Homework Questions The concept of earnings power is the long-term (3 to 5 year) expectation of the company's earnings after any near-term anomalous behavior has...

Q:

The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate Information about the bond assuming two different market...

Q:

2 The DataTables worksheet contains 4 tables listing the various prices and fees that Fiddlers charges their clients. It is common practice to have all pricing tables on one worksheet. Creating named...