It's mid-December and Marie is finalizing her divorce. Generally, she and her soon to be ex-spouse...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It's mid-December and Marie is finalizing her divorce. Generally, she and her soon to be ex-spouse have been amicable, and Marie is looking forward to being single. The divorce attorneys will be ready to complete the proceedings before December 31, but Marie is concerned about tax implications. Marie has asked for your help in determining whether to wait until the beginning of next year in order to minimize taxes. The couple has two children and expect each will take custody of one child maintaining their own households. Marie's taxable income is $90,000 while he soon-to-be ex-spouse's taxable income is $40,000. Ignore any tax credits in your analysis. Required: 1. Complete the "The tax is:" column for each filing status table using a formula 2. Prepare a comparison for Marie using VLOOKUP formulas to the 2022 tax brackets. (HINT: Use the TRUE logical value) If taxable income is over: $ $ $ $ $ $ $ $ - S 10,275.00 S 41,775.00 S 89,075.00 $ If taxable income is over: $ $ $ $ $ Ś 170,050.00 $ 215,950.00 $ 539,900.00 $ -5 20,550.00 $ 83,550.00 $ 178,150.00 $ 340,100.00 $ 431,900.00 $ 647,850.00 $ Option 1 Filing Status: Taxable income: If taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: Grand Total Tax: F Schedule Y-1-Married Filing Jointly or Qualifying Widow(er) S $ Schedule X-Single But not over: 10,275.00 $ 41.775.00 89,075.00 170,050.00 215,950.00 539,900.00 But not over: 20,550.00 $ 83,550.00 178,150.00 340,100.00 431,900.00 647,850.00 Marie The tax is: 90,000 $ The tax is: Ex-Spouse 40,000 Plus: Plus: 10% 12% 22% 24% 32% 35% 37% 10% 12% 22% 24% 32% 35% 37% If taxable income is over: $ $ $ S $ $ $ If taxable income is over: $ $ $ S $ S $ 14,650.00 $ 55,900.00 $ 89,050.00 S 170,050.00 S 215,950.00 5 539,900.00 $ $ $ 10,275.00 $ 41,775.00 $ 89,075.00 S 170,050.00 $ 215,950.00 S 323,925.00 $ Option 2 Filing Status: Taxable income: if taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: P Schedule Z-Head of Household But not over: 14,650.00 $ 55,900.00 89,050.00 170,050.00 215,950.00 539,900.00 Schedule Y-2-Married Filing Separately But not over: 10,275.00 S 41,775.00 89,075.00 170,050.00 215,950.00 323,925.00 The tax is: Marie & Ex-Spouse The tax is: Plus: Plus: 10% 12% 22% 24% 32% 35% 37% 10% 12% 22% 24% 32% 35% 37% It's mid-December and Marie is finalizing her divorce. Generally, she and her soon to be ex-spouse have been amicable, and Marie is looking forward to being single. The divorce attorneys will be ready to complete the proceedings before December 31, but Marie is concerned about tax implications. Marie has asked for your help in determining whether to wait until the beginning of next year in order to minimize taxes. The couple has two children and expect each will take custody of one child maintaining their own households. Marie's taxable income is $90,000 while he soon-to-be ex-spouse's taxable income is $40,000. Ignore any tax credits in your analysis. Required: 1. Complete the "The tax is:" column for each filing status table using a formula 2. Prepare a comparison for Marie using VLOOKUP formulas to the 2022 tax brackets. (HINT: Use the TRUE logical value) If taxable income is over: $ $ $ $ $ $ $ $ - S 10,275.00 S 41,775.00 S 89,075.00 $ If taxable income is over: $ $ $ $ $ Ś 170,050.00 $ 215,950.00 $ 539,900.00 $ -5 20,550.00 $ 83,550.00 $ 178,150.00 $ 340,100.00 $ 431,900.00 $ 647,850.00 $ Option 1 Filing Status: Taxable income: If taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: Grand Total Tax: F Schedule Y-1-Married Filing Jointly or Qualifying Widow(er) S $ Schedule X-Single But not over: 10,275.00 $ 41.775.00 89,075.00 170,050.00 215,950.00 539,900.00 But not over: 20,550.00 $ 83,550.00 178,150.00 340,100.00 431,900.00 647,850.00 Marie The tax is: 90,000 $ The tax is: Ex-Spouse 40,000 Plus: Plus: 10% 12% 22% 24% 32% 35% 37% 10% 12% 22% 24% 32% 35% 37% If taxable income is over: $ $ $ S $ $ $ If taxable income is over: $ $ $ S $ S $ 14,650.00 $ 55,900.00 $ 89,050.00 S 170,050.00 S 215,950.00 5 539,900.00 $ $ $ 10,275.00 $ 41,775.00 $ 89,075.00 S 170,050.00 $ 215,950.00 S 323,925.00 $ Option 2 Filing Status: Taxable income: if taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: P Schedule Z-Head of Household But not over: 14,650.00 $ 55,900.00 89,050.00 170,050.00 215,950.00 539,900.00 Schedule Y-2-Married Filing Separately But not over: 10,275.00 S 41,775.00 89,075.00 170,050.00 215,950.00 323,925.00 The tax is: Marie & Ex-Spouse The tax is: Plus: Plus: 10% 12% 22% 24% 32% 35% 37% 10% 12% 22% 24% 32% 35% 37%
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Schedule X Single If taxable income is over But not over The tax is Plus 1027500 10 1027500 4177500 102750 12 4177500 8907500 480750 22 8907500 17005000 1521350 24 17005000 21595000 3464750 3... View the full answer
Related Book For
Personal Finance An Integrated Planning Approach
ISBN: 978-0136063032
8th edition
Authors: Ralph R Frasca
Posted Date:
Students also viewed these databases questions
-
A family friend has asked for your help in analyzing the operations of three companies operating in the same service sector industry. Supply the missing data in the following table: Company B Sales...
-
The company controller, Barry Melrose, has asked for your help in interpreting the authoritative accounting literature that addresses the recognition and measurement of impairment losses for...
-
The University of Tennessee has asked for your help with implementing an activity-based costing system for the admissions office. The following activities and cost drivers were identified by the...
-
Which of the following statements is correct regarding a work sheet and the adjustment process? Adjusting journal entries are prepared from the Adjusted Trial Balance columns. Adjusting journal...
-
Solve the following trigonometric equations in [0, 2] (a) sin2x + sin x = cos2 x (b) sin2x cos x + cos2x sin x = 1
-
What is statistical discrimination? Why do employers use group membership as an indicator of a workers productivity? What is the impact of statistical discrimination on the wage of the affected...
-
A public accounting firm has been engaged to perform the audit of a local, federally funded Housing Allowance Program. The objective of the program is to increase the housing standards of Agana...
-
Brilliant Travel Agency specializes in flights between Toronto and Jamaica. It books passengers on Ontario Air. Brilliants fixed costs are $ 36,000 per month. Ontario Air charges passengers $ 1,300...
-
Delph Company uses a job-order costing system with a plantwide predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that 54,000 machine-hours would...
-
When possible, compute the truth values of the simple components in the following compound propositions. If no truth value can be computed, write a question mark (?) under the letter or letters with...
-
The balance sheet data of Brown Company at the end of 2015 and 2014 follow: 2015 2014 Cash $30,000 $35,000 Accounts receivable (net) 55,000 45,000 Inventory 65,000 45,000 Prepaid expenses 15,000...
-
What are your thoughts on reduction to restructure the organization? Can this be good or bad? Explain in details.
-
List and Explain two different legislation relevant to detailed designs of motorways and interchanges ?
-
On 1 April 2 0 X 3 , Warminster entered into a lease agreement. The payment terms comprise $ 6 0 , 0 0 0 payable on 1 April 2 0 X 3 followed by three further payments of $ 6 0 , 0 0 0 payable on 3 1...
-
Discuss the principles of process intensification (PI) and its role in achieving sustainable and efficient chemical processing, focusing on the reduction of equipment size, energy consumption, and...
-
The following terms will be used interchangeably: minimum rate of return, desired rate of return, required rate of return, hurdle rate, cutoff rate, discount rate, cost of capital. Let us assume that...
-
Provide detailed information regarding KFC's health and nutritional concerns. Are there any examples of incidents that happened in the recent years considering the issue of health and nutrition?
-
In a large midwestern university, 30% of the students live in apartments. If 200 students are randomly selected, find the probability that the number of them living in apartments will be between 55...
-
An engine fire destroys your car. Which coverage would reimburse you for the dam age? What is the maximum amount you could collect under your auto policy?
-
1. If Sue died today, how much would the Wrights need in the family maintenance fund? Explain the reasons behind your calculations. 2. Suppose the Wrights found that Sue and Tom each had a life...
-
Why do the ages 5912 and 7012 have special significance for qualified retirement plans?
-
In an ideal gas mixture consisting of components \(A\) and \(B\), the mole fraction of component \(A\) is equal to (a) \(n_{\mathrm{A}}=\frac{p_{\mathrm{A}}+p_{\mathrm{B}}}{P}\) (b)...
-
In an absorption refrigeration system, the heat energy \(Q_{1}\) is supplied at temperature \(T_{1}\) while the system absorbs heat energy \(Q_{3}\) from a cold space at temperature \(T_{3}\). If the...
-
The availability of a system (a) Depends upon the conditions of the system only (b) Is independent of the conditions of the surroundings (c) Does not depend upon the conditions of the system (d)...
Study smarter with the SolutionInn App