integrated Excel $-$ Tax Problem $-$ Entity Choice $($Algo$)$

Blue Eyed Beauty Supply is the talk of the town. When Elaine started her business, she had no idea it would evolve to be the number one supplier of cosmetology supply in the region. While her business has been successfully operating as a sole proprietorship for many years, her legal counsel has urged her to form a separate legal entity for a variety of nontax reasons. Elaine will form an LLC but has come to you for advice as to which tax classification is best positioned to pay the least overall tax. She has provided you with her $2024$ tax data and the following assumptions to develop an Excel model:

$$ As a C Corporation, the business will dividend out all earnings after taxes are paid to Elaine

$$ Elaine is Single and her sole source of income is from her business activities

$$ It is expected that her business meets the definition of a trade or business for Qualified Business Income deduction purposes

$$ The business net income before contemplating any taxes: $$140,000$

$$ Elaine is assuming a reasonable compensation amount of: $$50,000$

Required:

$1.$ Complete the "The tax is:$"$ column for the filing status table using a formula.

$2.$ Complete the Schedule C tax calculations using VLOOKUP formulas to the $2024$ tax brackets.

$3.$ Complete the S Corporation tax calculations using VLOOKUP formulas to the $2024$ tax brackets.

$4.$ Complete the C Corporation tax calculations using VLOOKUP formulas to the $2024$ tax brackets.

Note: Use the TRUE logical value for VLOOKUP formulas; link to cells C$10$ and C$11$ as appropriate.

Navigation:

$1.$ Use the Open Excel in New Tab button to launch this question.

$2.$ When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.

If taxable income is over: But not over: The tax is: Plus:

$$-$ $$11,600\mathrm{.}00$ $$-10\%$

$$11,600\mathrm{.}00$ $$47,150\mathrm{.}00$ $$1,160\mathrm{.}0012\%$

$$47,150\mathrm{.}00$ $$100,525\mathrm{.}00$ $$4,266\mathrm{.}0022\%$

$$100,525\mathrm{.}00$ $$191,950\mathrm{.}00$ $$11,742\mathrm{.}5024\%$

$$191,950\mathrm{.}00$ $$243,725\mathrm{.}0032\%$

$$243,725\mathrm{.}00$ $$609,350\mathrm{.}0035\%$

$$609,350\mathrm{.}00$ $$-37\%$

Schedule C

Schedule C Income

Self$-$Employment Tax

Less: $50\%$ Self$-$Employment Tax

AGI

Less: Standard Deduction $$13,850\mathrm{.}00$

Less: QBI $($HINT: Use a MIN function to apply the taxable income limitation$)$

Taxable Income:

If taxable income is over:

But not over:

The tax is:

Plus tax percentage:

Plus tax amount:

Ordinary Personal Income Tax

Overall Total Tax

Overall Tax Rate

S Corporation

W$-2$ Income

Less: Employee Share of Payroll Taxes

Net W$-2$ Compensation

S Corporation Income Before Payroll Tax

Less: S Corporation Payroll Tax

Other Income $-$ S Corp K$-1$

AGI

Less: Standard Deduction $$13,850\mathrm{.}00$

Less: QBI $($HINT: Use a MIN function to apply the taxable income limitation$)$

Taxable Income:

If taxable income is over:

But not over:

The tax is:

Plus tax percentage:

Plus tax amount:

Ordinary Personal Income Tax

Overall Total Tax

Overall Tax Rate

C Corporation

W$-2$ Income

Less: Employee Share of Payroll Taxes

Net W$-2$ Compensation

C Corporation Income Before Payroll Tax

Less: C Corporation Payroll Tax

C Corporation Taxable Income

C Corporation Income Tax

AGI

Less: Standard Deduction $$13,850\mathrm{.}00$

Taxable Income

If taxable income is over:

But not over:

The tax is:

Plus tax percentage:

Plus tax amount:

Ordinary Personal Income Tax

Dividend From C Corporation

Qualified Dividends Tax $($HINT: Some dividends may be taxed at $0\%)$

Total Personal Tax

Overall Total Tax

Overall Tax Rate