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

Fantastic news! We've Found the answer you've been seeking!

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 Tax Rate Base Tax

0 0% 0

10000 2 0

20000 3 200

60000 4 1400

120000 5 3800

200000 6 7800

Related Book For answer-question

Accounting Information Systems

ISBN: 978-0133428537

13th edition

Authors: Marshall B. Romney, Paul J. Steinbart

See More Books

Posted Date: Nov 13, 2020 10:30 AM

See More Questions

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...
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...
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...
Find keys K such that DESK (DESK (x)) = x, for all x Such a key is sometimes called a weak key. How many weak keys can you find? To solve this problem you need to look up the exact key schedule...
What is the difference in energy between the two levels responsible for the ultraviolet emission line of the magnesium atom at 285.2 nm? de Broglie Waves Masses of the electron, proton, and neutron...
How can managers use capital budgeting to achieve strategic goals?
P 46 Use the Standard Normal Table or technology to find the z-score that corresponds to the cumulative area or percentile. Table 4-Standard Normal Distribution Arca 0 z Z .09 .08 .07 .06 .05 .04...
During its fiscal year ending August 31, 2012, the Eaton School District engaged in the following transactions: It established a purchasing department, to be accounted for in a new internal service...
The purpose of trend analysis is to: compare changes in one variable to changes in another variable. understand multiyear changes to improve decision-making and planning. identify areas with high...
Use PSpice to find V1, V2, and V3 in the network of Fig. 10.128. 8 V. j1012 V, jlOS2 4/0 A
The formal charge is the "charge" an element would have in a molecule or ion if all of the bonding electrons were shared equally between atoms We can draw three inequivalent Lewis structures for the...
When a trust terminates, there are, in most instances, terminating commissions that are charged by the fiduciary. The allocation of such expenses with respect to character of the income has spawned...
In January 2019, Leon McLeod received a gift of a beach cottage valued at $250,000 from his great-uncle who owned a number of such buildings. The cottage was rented each year to college students who...
What is the adjustment that must be made to taxable income in computing alternative minimum taxable income for 2019, assuming that an individual purchased an office building on January 8 for $400,000?
Steven Spokesman, a high school teacher in - a local school district, was fired for publicly criticizing the local school district. The court ruled that Steven's freedom of speech had been violated...
On September 23, 2019, Mary Jones bought an annuity contract for $22,050 that will give her $125 a month for life, beginning October 30. Mary is 61 years old. Determine the exclusion ratio and the...
Do you think performance management is future orientated? substantiate your answer by referring your answer by referring to specific methods of performance appraisal.
The swap spread is the difference between the swap rate and the equivalent-maturity Treasury bond yield. Explain why a widening swap spread may be a signal of deteriorating economic conditions. Plot...
1. Discuss the criteria to consider in specifying the structure and features of CGCs new system. 2. Identify the data that should be incorporated into CGCs new system to provide adequate planning...
How are the similarities and differences between the purchase of services, such as telephone service, and the purchase of raw materials reflected in an REA data model?
Sues Gallery only purchases finished paintings (it never commissions artists). It pays each artist 50% of the agreed price at the time of purchase, and the remainder after the painting is sold. All...
Discuss why the cash received from providing a service is revenue, yet the cash contributed by the owner is not revenue.
Today's world is data driven with businesses having a deluge of available information available for decision making. Data needs to be given the appropriate place in a companys strategy, but decision...
Discuss whether an asset needs to be legally owned to be recorded as an asset on the statement of financial position.

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

Question:

Expert Answer:

Tax liability999... View the full answer

Accounting Information Systems

Students also viewed these mathematics questions