SuperCalc ver.  1.00
City of Detroit Non Resident Income Tax - 1986
"City of Detroit Non Resident Income Tax - 1986
0,(1-(
"Exemptions
"Soc Sec #
"   Yours
" Spouse's
491501955
666554444
"Detroit
"Social Security No.
"Employer
"Wages
"Inc Tax
491501955
"SSI Medical Service Inc
Q 47923.43
cal S
Q 718.76
999887777
"ABC Company
666554444
"Green & Sons
666554444
"Williams Inc.
y No.
666554444
"Williams Inc.
y No.
"Schedule N
"1.  Actual number of days worked - everywhere
0,(1-(
"2.  Actual Number of days worked in Detroit
"3.  Percentage of days worked in Detroit
F13/F12
"4.  Total wages from W-2
SUM(E5:E9)
"5.  Wages earned in Detroit
ROUND(F14*F15,2)
"Schedule M
"Amt on Federal
"1.  Employee Business Expenses
n Detr
ROUND(D19*E19,2)
"2.  Moving Expenses
ROUND(D20*E19,2)
"3.  Individual Retirement Account
ROUND(D21*E19,2)
"4.  Alimony
ROUND(D22*E19,2)
"5. Enter Detroit Gross Income
"Detroit
 Detr
"Wages Etc.
"5.  Total Adjustments
 Income
SUM(F19:F22)
"Employers Name     Where employed (city & state)
(1-(	
"Income Tax
"Earned in
"Withheld
"Detroit
"SSI Medical Service Inc        Charleston SC
"6.       TOTALS
pany 	
SUM(J26:J28)
SUM(K26:K28)
"7. a. Rental Income (loss) Detroit  . . . . . . . . . . . .
"   b. Income (loss) from Detroit Partnership  . . . . . . .
"   c. Gain (loss) from sale of property . . . . . . . . . .
"   d.  Totals of Lines 7a, b, and c . . . . . . . . . . . .
(	 ! ". . . . . .
SUM(J30:J32)
"8.  Net profit (loss) from business . . . . . . . . . . . .
(	!! ". . . . . .
"9.  Totals add Lines 6, 7d, and 8 . . . . . . . . . . . . .
(	"! ". . . . . .
K29+K33+K34
"10. Less Deductions from Schedule M . . . . . . . . . . . .
(	#! ". . . . . .
"11.      Total (line 9 less line 10)  . . . . . . . . . . .
(	$! ". . . . . .
K35-K36
"12. Less Amount for Exemptions  . . . . . . . . . . . . . .
(	%! ". . . . . .
G1*600
"13.     TOTAL INCOME SUBJECT TO TAX . . . . . . . . . . . .
(	&! ". . . . . .
IF(K37>K38,K37-K38,0)
c     
"14. CITY OF DETROIT TAX . . . . . . . . . . . . . . . . . .
(	'! ". . . . . .
ROUND(1.5%K39,2)
"PAYMENTS AND CREDITS
"15. a. Tax withheld by employers  . . . . . . . . . . . . . . . . . . .
000))
"    b. Payments and credits on 86 estimated tax . . . . . . . . . . . .
000))
"    c. Other credits  . . . . . . . . . . . . . . . . . . . . . . . . .
000))
"16.      TOTAL - Add lines 15a, b, and c  . . . . . . . . . . . . . . .
000))
SUM(K43:K45)
"REFUND OR TAX DUE
"17. OVERPAYMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . .
000))
IF(K46>K40,K46-K40,0)
c     
"18. Check box for refund or credit
"19. TAX DUE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
000))
IF(K40>K46,K40-K46,0)
c