Qualified Business Income Deduction Spreadsheet. It has two tabs: one for if you have a specified business and one if you do not. See Jan 27 blog for info. Assumptions: $375,000 in taxable income, $315,000 in income for one business. There is a second trade or business. Other assumptions and required input areas are highlighted yellow. The author makes no representations or warranties regarding the accuracy of the spreadsheet. Please contact author for corrections or suggested improvements.