Exercise 5

profilekrisGG
Exercise5Part2Worksheet.xlsx

Sheet1

Worksheet for Use in Part 2
of Essay/Exercise # 5
PA 615
Couple A Couple B Couple B Fed. Itemized Deductions
Adjusted Gross Income Deductible Mtg Exp
Deduct: State Income Taxes
Standard Deduction SDI
Itemized Deductions - Motor Vehicle Fees
Taxable Income - - Charitable Contrib.
Rent Paid in Excess of Total Itemized Ded. 0
Standard Deduction N/A Instructions:
Adjusted Income for Only fill in the yellow areas. The
Comparison Purposes - - gray areas are pre-calculated cells.
Taxes Paid: Do not try to adjust for the state
Federal Income Tax income taxes which disallow an
California Income Tax itemized deduction for state income
State Gas Taxes/Fees taxes - effect is entered in Row 26:C
Sales taxes
Total Taxes Paid - -
Total Taxes Paid as a %
of Adjusted Income for
Comparison Purposes ERROR:#DIV/0! ERROR:#DIV/0!
Adjustment for State
Taxes which do not
Allow State Tax Deduct. 0.34%
Adjusted Total Tax Rate ERROR:#DIV/0!