Ryan, who is single, has the following income and expenses for 2019:

Gross income from sole proprietorship $148,500

Cash operating expenses for sole proprietorship 24,250

Interest income 1,400

Dividend income (qualified) 1,200

Contribution to solo-(k) plan 4,000

Medical insurance for self-employed individual 6,600

Medical expenses before floor 2,600

Acquisition residence insurance 6,800

Home equity residence interest 2,233

Real property taxes 5,200

Car tax (amount based on value) 550

State income tax paid 4,440

Cash charitable contributions 75

Contribution of appreciated stock,

fmv = $6,000, basis = 780

Miscellaneous itemized deductions 555

Standard Deduction 12,200

Prepare an Excel spreadsheet to calculate Ryans gross federal income tax. You may assume that Ryans taxable income before the QBI deduction is less than $160,700.

The spreadsheet should be structured such that the grader can change any of the numbers (for example, gross income is increased to $150,500) and the end resulting federal income tax is updated.