Please calculate the 2022 tax liability for a single taxpayer who is 40 years old with $222,950 of wages, $20,000 of qualified dividends, $30,000 of LT capital gains and $40,000 of ST capital gains. Please make sure to consider all possible taxes in your calculation, prepare your calculation in Excel and show all work.

The taxpayer will not be subject to AMT so that calculation is not necessary.