COMPRE RATER - EMCOR (1).xls

	A	B	C	D	E
1	GOVERNMENT DEALS COMPUTATION -CITP
2
3	Cost w/ VAT	15,796,620
4
5	Inventory cost net of IV	14,104,064.55		Net Sales	16,521,428.57
6	multiply by 12%	12%		multiply by 7%	7%
7	Input Vat	1,692,487.75		Standard Input Tax	1,156,500.00
8
9	Cost of the unit	14,104,064.55		Net Sales	16,521,428.57
10	Add: Input Vat 12%	1,692,487.75		multiply by 5%	5%
11	Cost inclusive of Input Vat	15,796,552.30		Final W/holding	826,071.43
12	Divided by	85%
13	LCP	18,504,000.00		Input Vat	1,692,487.75
14	Add: Misc. (freight & handling)	0.00		Less: 7% Standard IT	1,156,500.00
15	Total Price (gross sales)	18,504,000.00		Input Tax Expense	535,987.74
16	Less: Output Vat	1,982,571.43
17	Net Sales	16,521,428.57		Output Vat Payable	1,982,571.43
18	Less: Cost	14,104,064.55		Less: 7% standard Input Tax	1,156,500.00
19	GP	2,417,364.02	14.63%	5% Final W/holding	826,071.43
20	Less: Input Tax Exp.	535,987.74		Output Vat Payable	0.00
21	F/H Expense	0.00
22	Other expenses
23	Bid Docs/Perf. Bond	25,000.00
24	Income	1,856,376.28	11.24%	Commission Payable	0.00
25	Less: CWT	826,071.43		Less: Vat	0.00
26	Total	1,030,304.86		Total	0.00
27	Less: Tax to be paid	464,094.07		CWT 10%	0.00
28	NET INCOME	566,210.78	3.43%	Net Payable	0.00
29	+ CWT	826,071.43
30	TOTAL	1,392,282.21	7.52%
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