I need the PDF and the excel Sheet as well
SAMPLE SOLUTION TAXPAYER INFORMATION Marital status Single Ordinary income before capital gains (losses) 15,000 For AGI deductions None Itemized deductions None Standard deduction 12,400 QBID None Tax credits None SALES DATA CHARACTER CHECK TOTALS Description Date Purchased Date Sold Adjusted Basis Amount Realized Holding Type Gain (Loss) Stock A 1/1/2001 12/31/2020 3,000 1,000 LT 15 (2,000) ST 15 (3,000) - Stock B 1/1/2001 12/31/2020 10,000 60,000 LT 15 50,000 LT 28 - - Stock C 1/2/2020 12/31/2020 2,000 1,000 ST 15 (1,000) LT 25 - - Stock D 1/2/2020 12/31/2020 3,000 1,000 ST 15 (2,000) LT 15 48,000 - Antiques 1/1/2001 12/31/2020 1,000 1,000 LT 28 - Rental property 1/1/2001 12/31/2020 50,000 50,000 LT 25 - NETTING ST LT LT LT 28 25 15 Long-Term Description Short-Term 28-Percent 25-Percent 0/15/20-Percent Stock A - - - (2,000) Stock B - - - 50,000 Stock C (1,000) - - - Stock D (2,000) - - - Antiques - - - - Rental property - - - - Subtotal (3,000) - - 48,000 Netting: ST -> 28 - - ST -> 25 - - ST ->0/15/20 3,000 (3,000) Total - - - 45,000 TAX FORMULA AND CHARACTER SUMMARY INCOME: Ordinary income 15,000 Short-term capital gains (losses) - Long-term capital gains (losses) 28-percent - 25-percent - 0/15/20-percent 45,000 TOTAL INCOME 60,000 DEDUCTIONS FOR AGI - AGI 60,000 DEDUCTIONS FROM AGI: Standard deduction 12,400 QBID - TOTAL DEDUCTIONS FROM AGI 12,400 TAXABLE INCOME 47,600 TAXABLE INCOME BY CHARACTER: Ordinary 2,600 Net capital gain: 28-percent - 25-percent - 0/15/20-percent 45,000 TOTAL TAXABLE INCOME BY CHARACTER 47,600 TAX BASE TAX Ordinary income 2,600 260.00