JJSE-Omnibux-Tax-Implications
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKL
1
Net Profit Margin15%
2
Revenue Growth Rate20%
3
Before Corp Tax Rate25%
4
After Corp Tax Rate15%
5
Before Omnibus BillAfter Omnibus Bill
6
YearRevenueProfitTaxesYearRevenueProfitTaxes
7
10$500,000,000.00$75,000,000.00$18,750,000.0010$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.0011$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.0012$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.0013$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.0014$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.0015$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.0016$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.0017$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.0018$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.6019$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.9220$3,095,868,211.20$464,380,231.68$69,657,034.75
18
19
Total Taxes (11 - 20)$584,070,347.52Total Taxes (11 - 20)$350,442,208.51
20
21
Difference$233,628,139.01
Loading...
 
 
 
Sheet1
Sheet2
Sheet3