Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please help me with the formula for my assignment. I have included the exact row and column number. Please be specific and clear,

Can you please help me with the formula for my assignment. I have included the exact row and column number. Please be specific and clear, For example I would like a clear explanation and formula of C20 and so on. Thank you.

image text in transcribed @ McGraw Hill Excel Question - Saved Search for tools, help, and more (Option + Q) Fle Home Insert Share Formulas Data Review View Help Draw Dv Ay & 1 B I U D iH = = Accounting fl Conditional Formatting v 57 Cell Stylesc20 " S4 A B c D E F G H I J12 It's mid-December and Marie is finalizing her divorce. Generally, she and her soon to be ex-spouse have been3 amicable, and Marie is looking forward to being single. The divorce attorneys will be ready to complete the4c proceedings before December 31, but Marie is concerned about tax implications. Marie has asked for your help in6 determining whether to wait until the beginning of next year in order to minimize taxes. The couple has two7 children and expect each will take custody of one child maintaining their own households. Marie's taxable income891011 Required:12 1. Complete the "The tax is:" column for each filing status table using a formula13 2. Prepare a comparison for Marie using VLOOKUP formulas to the 2022 tax brackets.1415 (HINT: Use the TRUE logical value)16v Schedule 2 Head of Householde If taxable income is If taxable income isover: But not over: The tax is: Plus: over: But not over: The tax is: Plus:19 g -8 10,275.00 - 10% s - 3 14,650.00 '.*: 10%20 I $ 10,275.00 $ 41,775.00 . 12% $ 14,650.00 $ 55,900.00 = 12%2| s 41,775.00 § 89,075.00 2 22% $ 55,900.00 § 89,050.00 5 22%22 $ 89,075.00 $ 170,050.00 = 24% 5 89,050.00 $ 170,050.00 5 24%23 $ 170,050.00 $ 215,950.00 . 32% 5 170,050.00 $ 215,950.00 s 32%4 3 21595000 $ 539,900.00 35% $ 21595000 $ 539,900.00 35%58 539,900.00 $ 37% $ 539,900.00 $ 37%2627 G Married LIRS Schedule Y-2 - Married Filing Separately7 If taxable income is If taxable income isover: But not over: The tax is: Plus: over: But not over: The tax is: Plus:3 s -8 20,550.00 $ . 10% $ -8 10,275.00 $ - 10%30 ¢ 20,550.00 $ 83,550.00 " 12% s 10,275.00 § 41,775.00 12%3 $ 83,550.00 $ 178,150.00 X 22% $ 41,775.00 § 89,075.00 B 2%32 $ 178,150.00 $ 340,100.00 E 24% $ 89,075.00 $ 170,050.00 E 24%33 $ 340,100.00 $ 431,900.00 E 32% 5 170,050.00 § 215,950.00 E 32%34 s 431,900.00 $ 647,850.00 v 35% s 215,950.00 $ 323,925.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Loren A. Nikolai, John D. Bazley, Jefferson P. Jones

11th edition

978-0538467087, 9781111781262, 538467088, 1111781265, 978-0324659139

Students also viewed these Accounting questions

Question

3. Find the solution by Substitution method 2x - y = 4 6x-3y = 12

Answered: 1 week ago