| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Net Profit Margin | 15% | ||||||||||
2 | Revenue Growth Rate | 20% | ||||||||||
3 | Before Corp Tax Rate | 25% | ||||||||||
4 | After Corp Tax Rate | 15% | ||||||||||
5 | Before Omnibus Bill | After Omnibus Bill | ||||||||||
6 | Year | Revenue | Profit | Taxes | Year | Revenue | Profit | Taxes | ||||
7 | 10 | $500,000,000.00 | $75,000,000.00 | $18,750,000.00 | 10 | $500,000,000.00 | $75,000,000.00 | $11,250,000.00 | ||||
8 | 11 | $600,000,000.00 | $90,000,000.00 | $22,500,000.00 | 11 | $600,000,000.00 | $90,000,000.00 | $13,500,000.00 | ||||
9 | 12 | $720,000,000.00 | $108,000,000.00 | $27,000,000.00 | 12 | $720,000,000.00 | $108,000,000.00 | $16,200,000.00 | ||||
10 | 13 | $864,000,000.00 | $129,600,000.00 | $32,400,000.00 | 13 | $864,000,000.00 | $129,600,000.00 | $19,440,000.00 | ||||
11 | 14 | $1,036,800,000.00 | $155,520,000.00 | $38,880,000.00 | 14 | $1,036,800,000.00 | $155,520,000.00 | $23,328,000.00 | ||||
12 | 15 | $1,244,160,000.00 | $186,624,000.00 | $46,656,000.00 | 15 | $1,244,160,000.00 | $186,624,000.00 | $27,993,600.00 | ||||
13 | 16 | $1,492,992,000.00 | $223,948,800.00 | $55,987,200.00 | 16 | $1,492,992,000.00 | $223,948,800.00 | $33,592,320.00 | ||||
14 | 17 | $1,791,590,400.00 | $268,738,560.00 | $67,184,640.00 | 17 | $1,791,590,400.00 | $268,738,560.00 | $40,310,784.00 | ||||
15 | 18 | $2,149,908,480.00 | $322,486,272.00 | $80,621,568.00 | 18 | $2,149,908,480.00 | $322,486,272.00 | $48,372,940.80 | ||||
16 | 19 | $2,579,890,176.00 | $386,983,526.40 | $96,745,881.60 | 19 | $2,579,890,176.00 | $386,983,526.40 | $58,047,528.96 | ||||
17 | 20 | $3,095,868,211.20 | $464,380,231.68 | $116,095,057.92 | 20 | $3,095,868,211.20 | $464,380,231.68 | $69,657,034.75 | ||||
18 | ||||||||||||
19 | Total Taxes (11 - 20) | $584,070,347.52 | Total Taxes (11 - 20) | $350,442,208.51 | ||||||||
20 | ||||||||||||
21 | Difference | $233,628,139.01 | ||||||||||