Federal Income Tax II

Please show work by EXCEL

Tristan, who is single, operates three sole proprietorships that generate the following information in 2023 (none are "specified services" businesses). (LO.4)

Tristan chooses not to aggregate the businesses. She also earns $150,000 of wages from an unrelated business, and her modified taxable income (before any QBI deduction) is $380,000.

a. What is Tristan's QBI deduction?

b. Assume that Tristan can aggregate these businesses. Determine her QBI deduction if she decides to aggregate the businesses.

\begin{tabular}{|c|c|c|c|} \hline Business & QBI & W-2 Wages & Capital Investment \\ \hline A & $300,000 & $90,000 & $0 \\ \hline B & (135,000) & 60,000 & 0 \\ \hline C & 150,000 & 0 & 0 \\ \hline \end{tabular}