The Client wants to better understand how floors and ceilings work with respect to itemized deductions. As such, you have been asked to prepare a functional spreadsheet emulating Schedule A to demonstrate the calculations using formulas. Required: 1. Complete Schedule A using formulas to calculate applicable lines. Itemized deduction amounts have already been entered. (Hint: use a Cell Reference the Adjusted Gross Income amount provided below in Cell D10.) Form 1040 Line 11 - Adjusted Gross Income: 86,000 SCHEDULE A Itemized Deductions 2021 Medical Caution: Do no include expenses reimbursed or paid by others. and 1 Medical and Dental Expenses 4,000 Dental 2 Enter amount from Form 1040 or 1040-SR Line 11 86,000 Expenses 3 Multiply Line 2 by 7.5% (0.075) 6,450 4 Subtract line 3 from line 1. If line 3 is more than line 1, enter -0- Taxes You 5 State and local taxes. Paid a State and local income taxes or general sales taxes. You may include either income taxes or general sales taxes on line 5a, but not both. If you elect to include general sales taxes instead of income states, check this box. 3,870 b State and local real estate taxes (see instructions) 8,000 c