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:

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 D$10.)$

Form $1040$ Line $11-$ Adjusted Gross Income: $,86,000$

SCHEDULE A

Itemized Deductions

$2021$