Sheet1
Payer Name Payer Address(1) Payer Address(2) Payer City Payer State Paye
r Zip Code Payer EIN Payer TCC Recipient Name Address (1) Address (2) Addr
ess (3) City State Zip Code Foreign Country Recipient TIN Customer Account Number 1099
Type Taxable Amount Box 3 (other Income) Federal Tax Withheld (Box 4) Nonemployee Compensa
tion (Box 7) State Tax Witheld(Boxl6) State Income (Box 18) State of Domicile Memb
ership Value Higest State Marginal Tax Rate State Income Tax Itemized Deduction Limit
Itemized Deduction for State Tax Taxable Federal Income Highest Federal Tax Rate Fede
ral Income Tax Total Tax Reported Income Highest State Marginal Tax Rate State Income Tax
Itemized Deduction Limit Itemized Deduction for State Tax Taxable Federal Income High
est Federal Tax Rate Federal Income Tax Witheld
AK2=1912.8306251222298 AR2=744.1189639864492 AM2=168.71166113578067 AK2=1912.8306251222298 NY
1000 (VLO0KUP(AA2,Sheet2!$A$2:$B$35,2,FALSE))=0.0882 (AB2*AC2)=88.20 0.20 (AD2*AE2)=17.64 AB2-
AF2=982.36 0.396 (AG2*AH2)=389.01456 (AD2+A12)=477.21456 (+AB2/(1000-A.72))*1000=1912.
8306251222298 AC2=0.0882 (AK2*AL2)=168.71166113578067 0.20 (AM2*AN2)=33.74233222715613
(AK2-AO2)=1879.0882928950737 0.396 (AP2*AQ2)=744.1189639864492
For internal use only
EFTA01479213
Sheet2
State of Domicile Higest State Marginal Tax Rate
NY 0.0882
WA
For internal use only
EFTA01479214
Sheet3
Highest Federal Tax Rate
0.396
For internal use only
EFTA01479215