Question: Your manager has asked you to construct an Excel spreadsheet that will allow you to compare the total federal income tax and payrollfself-employment tax liability

Your manager has asked you to construct an Excel
Your manager has asked you to construct an Excel spreadsheet that will allow you to compare the total federal income tax and payrollfself-employment tax liability due when operating a business as a sole proprietorship as opposed to an S corporation. Use this spreadsheet to calculate the tax consequences to Ms. Macchiato of incorporating No Doze Cafe as an S corporation, assuming the business alternatively earns annual taxable income of 525,000, $150,000, or $225,000 [before considering any salary payments to Ms. Macchiato and associated payroll tax expenses}. lmportantly, your spreadsheet should produce the "correct answer" simply by entering a particular level of business income. That is, the formulas in your spreadsheet must be flexible enough to accommodate the different tax provisions that apply at varying income levels without editing any cells besides the income itself. Use 2020 tax rates and taw law as discussed in class, including the Qualified Business Income deduction. in your analysis [you may assume that Ms. Macchiato qualifies for the full 20% QBI deduction on eligible income without limitation}. Be sure that your analysis incorporates self-employment and payroll taxes, notjust federal income taxes. You may ignore any state tax implications. Ms. Macchiato is married and files jointly with her spouse. Assume that the couple does not have enough itemized deductions to itemize, and that they have other sources of income exactly equal to the standard deduction [so you may ignore any other income and deductions besides those arising from No Doze Cafe}. The couple does not have children or other dependents. The primary basis for your grade for Task #1 will be your spreadsheet's ability to produce the correct tax liability for each type of entity at differing income levels. Additionally, your grade will depend on the clarity of your spreadsheet. That is, the steps in your spreadsheet calculations should flow logically and be labeled clearly such that someone who did not construct the spreadsheet {e.g., your manager or your professor} can review it easily. Use of notes, lines, colors, and other formatting changes can help to achieve this goal

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Accounting Questions!