formula97.xlsx

	A	B	C	D	E	F	G	H
1	ID	Name	Address	Frequency Payments	Annual Salary	Tax	Insurance	Pension Fund
2	154	John Smith	123 Elm St, Springfield, IL	26	$ 75 000,00	17%	$ 3 000,00	7%
3	240	Emily Johnson	456 Oak St, Austin, TX	26	$ 82 000,00	17%	$ 2 800,00	8%
4	319	Michael Brown	789 Pine St, Denver, CO	52	$ 65 000,00	16%	$ 3 500,00	8%
5	331	Sarah Williams	321 Maple Ave, Boston, MA	12	$ 90 000,00	18%	$ 4 000,00	8%
6	428	David Jones	654 Cedar Rd, Miami, FL	26	$ 58 000,00	16%	$ 2 700,00	7%
7	451	Olivia Garcia	987 Birch Ln, Seattle, WA	12	$ 105 000,00	18%	$ 5 000,00	7%
8	527	James Martinez	222 Palm Dr, San Diego, CA	12	$ 72 000,00	16%	$ 3 200,00	7%
9	540	Sophia Davis	555 Willow St, New York, NY	52	$ 95 000,00	18%	$ 4 500,00	7%
10	665	Benjamin Wilson	888 Aspen Ct, Chicago, IL	26	$ 68 000,00	16%	$ 3 400,00	7%
11	981	Isabella Anderson	333 Fir St, Los Angeles, CA	52	$ 110 000,00	18%	$ 5 500,00	7%
12
13		Employee ID	Name		Form Number	Payout
14		154	John Smith		164	$ 2 076,92
15		Address:	123 Elm St, Springfield, IL
16		Purpose of Payment	Gross Payout		Deductions
17			$ 2 884,62		Tax:	$ 480,77
18					Insurance:	$ 115,38
19					Pension Fund:	$ 211,54
20					TOTAL:	$ 807,69
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100