Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 8R
To determine
Compute the net pay by entering the updated tax information for the current year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Download the spreadsheet here which includes a tax table
in each tab. Edit the spreadsheet so you can use it to answer
the following questions. Then upload images of your
spreadsheet in the last part of the question.
Hint: create a spreadsheet with a tax table you have already
used (in a practice), use it to answer questions that you
answered in that practice for which you have correct
answers. That will help you be sure that your ideas here
work.
a. Suppose Erick has a total taxable income of $181,860.
They are taxed at the Married Jointly rates. What is
Erick's total tax bill?
$ 39,913.3
Erick pays taxes at the following tax brackets (pick all
that apply).
10%
15%
25%
28%
33%
35%
. Download Target’s 2021 annual report. Do this in one of two ways:
Go to the Target.com website: Annual Reports and Archive (target.com). Make sure you use the 2021 report.
Or use the Mergent Online library database: https://guides.rasmussen.edu/mergent.
2. Using Target’s annual report, record your findings in a written report.
Use complete sentences in a report format.
Double-space your report.
The report should be 5 paragraphs. Include a brief introduction, report the requested information from the three paragraphs below, and write a summary paragraph.
Include in-text citations and an APA format reference page. There should be at least one reference given for the 2021 annual report. FAQ citing an annual report from Mergent Online FAQ citing an annual report from a website.
Paragraph one: The statements start on about page 38. Use the 2021 numbers. Using a table, record the total revenue, operating income, and net earnings for 2021. Using sentences, explain what these numbers…
Using the search terms, “What do I need to know before I file my taxes” or “Tax changes to know before filing my taxes”, share your findings with your classmates. In your response, summarize your findings and include the following:
Search term(s) used.
Note one thing you found interesting or learned about for the first time involving Individual Taxes — Income, Exclusions, and Filing Status from your research.
Include a link to the reference used.
Chapter 10 Solutions
Excel Applications for Accounting Principles
Ch. 10 - Based on 2011 tax rates provided, use a calculator...Ch. 10 - You have been asked to record the November payroll...Ch. 10 - To make the worksheet reusable each month, the...Ch. 10 - Prob. 4RCh. 10 - Prob. 5RCh. 10 - In the space provided below, prepare the journal...Ch. 10 - In the space provided below, prepare the journal...Ch. 10 - Prob. 8RCh. 10 - Click the Chart sheet tab. On the screen is a...
Knowledge Booster
Similar questions
- To make the worksheet reusable each month, the Social Security tax formulas should be designed to automatically compute whether (1) full tax is due. (2) no tax is due (e g., cumulative gross pay is over the ceiling), or (3) some tax is due. =IF statements will be required. The =ROUND function should be used for FORMULAS 1 through 3 to eliminate rounding errors. FORMULAS 4 and 5 should also use the =IF function. FORMULA2 has been provided for you below. Review Appendix A of Excel Quick and explain the meaning of each part of the formula. a. b. c. d. e.arrow_forwardThe EFILE allows an individual to file their own personal income tax return directly to the CRA online through the use of a CRA certified tax software prockram. a. TRUE b. FALSEarrow_forwardWhich of the following is NOT an option to file a federal tax return? Fill out the paper version of the IRS tax form and mail it in. File taxes online using tax program. Hire a human tax preparer to complete the return and assist with filing. Fill out a paper version of the IRS tax form and fax it in. Next Mark For Reviewarrow_forward
- Mf1. One way to select the input screen for interest income reported on Form 1099-INT is for the Tax Professional to: Select Add Forms and Schedules and choose the Income tab, and then check the box for other income. Choose the Info Docs tab on the Add Forms and Schedules screen, and then select Yes from the dropdown field for interest income. Type "1099" in the first field on the Common tab of the Add Forms and Schedules screen. Choose Yes or type "1" next to the Interest field on the Common tab on the Add Forms and Schedules screen.arrow_forwardWrite a 2-3 paragraphs on the following topics, using 12-point Times New Roman font. What is the difference between individual income tax and corporate taxarrow_forwardnot use ai pleasearrow_forward
- Eaton Enterprises uses the wage-bracket method to determine federal income tax withholding on its employees. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Find the amount to withhold from the wages paid each employee. Enter all amounts as positive numbers. If an amount is zero, enter "0". Round interim calculations to two decimals and use in subsequent computations. Round final answer to two decimal places. As we go to press, the federal income tax rates for 2022 are being determined by budget talks in Washington and not available for publication. For this edition, the 2021 federal income tax tables for Manual Systems with Forms W-4 from 2020 or later with Standard Withholding and 2020 FICA rates have been used. Click here to access the Wage-Bracket Method Tables. Employee FilingStatus No. ofWithholdingAllowances Payroll…arrow_forwardPrepare journal entries for each sale, including sales tax, and the remittance of all sales tax to the tax board on October 23, Round your answers to two decimal places. If an amount box does not require an entry, leave it blank.arrow_forwardPerformance standards: Accomplish the BIR (Bureau of Internal Revenue) forms MELCS: Explain the procedure in the computation of gross taxable income and tax due. Mr. Sabado need to pay his tax. You are an agent hired by Mr. Sabado to compute his taxable income and tax due. The BIR agent will check and evaluate based on accuracy of the information prepared. Instructions: From the given information below compute the total taxable income and total income tax due on each scenario. Mr. Sabado, Production Manager of M.A.R Corp., earned annual compensation in 2020 of P 2,333,000, exclusive the 13h month and other benefits in the amount of P250,000 but net of mandatory contributions to SSS and Philhealth. Aside from employment income, he owns a convenience store, with gross sales of P3,555,000. His cost of sales and operating expenses are P1,500,000 and 800,000, respectively, and with non-operating income of P250,000. а. Mr. Sabado signified his intention to be taxed at 8% income tax rate on…arrow_forward
- write me a summer describing federal tax code 102 and provide an example situation involving the codearrow_forward1. Internet users can go to http://www.irs.gov/ and: a.Use a search function to find forms and publications. b.Find links to other useful IRS pages. c.Download tax forms and publications. d.All of these choices are correct. 2. Electronically filed tax returns: a.Have error rates similar to paper returns. b.Offer faster refunds than paper returns. c.May not be transmitted from a taxpayer's home computer. d.Constitute less than 50 percent of the returns filed with the IRS. 3. John, age 25, is a full-time student at a state university. John lives with his unmarried sister, Ann, who provides over half of his support. His only income is $4,400 of wages from a part-time job at the college book store. What is Ann's filing status for 2021? a.Married, filing separately b.Head of household c.Qualifying widow(er) d.Single e.None of these choices are correct.arrow_forwardGo to https://taxfoundation.orgLinks to an external site. . Find a current article published in the Tax Foundation website on the current issues in taxation and tell us about it. How does this impact the future of tax? Has your perception of tax accounting changed after taking this course? Explain your answer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning