ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
NOTE: IT IS VITAL THAT NO CALCULUS, POPULATION NUMBERS OR MULTIPLIERS ARE TOUCHED IN THIS, IT WILL POTANTIALLY DESTROY THE WHOLE SPREADSHEET.
HOWEVER THE AREAS MARKED GREEN ARE ABLE TO BE AMENDED IN ORDER TO AFFECT THE CHANGES THAT GOVERNMENTS AND POLICIES PLACE ON THE ECONOMY.
2
Government AccountsExpenditureIncome TaxationCorp Taxation
3
TOTAL REVENUE£631,633,950,654.70PolicyCostMultiplierPeopleTotal CostActual IncomeTax freeEligible Lower IncomeRate Paid on Lo In.Higher IncomeRate Paid on Hi In.Additional IncomeRate Paid on Ad In.tax payablePercentage of populationPeopleRevenueUBICorp TypeGross IncomeTaxTax PaidNumberRevenue
4
TOTAL EXPENDITURE£654,842,420,336.65Welfare£5,000.00£5,000.00£0.0030.00%£0.0045.00%£0.0050.00%03.738%1,472,060£0.00£27,969,133,694.11Coop£90,000.0015%£13,500.00536,678£7,245,158,400.00
5
SURPLUS(+) / DEFICIT(-)-£23,208,469,681.94State Pension£148.405213,198,086£101,846,988,925.35£10,000.00£10,000.00£0.0030.00%£0.0045.00%£0.0050.00%03.816%1,502,777£0.00£21,038,875,256.60Regular£90,000.0020%£18,000.001,463,637£26,345,458,800.00
6
DEBT£1,513,205,000,000.00Winter Fuel Allowance£300.0014,800,000£1,440,000,000.00£11,500.00£11,500.00£0.0030.00%£0.0045.00%£0.0050.00%04.230%1,665,814£0.00£20,822,673,876.77Coop£150,000.0015%£22,500.00369,665£8,317,467,000.00
7
(ALL PER ANNUM)Child Benefit£36.90521,200,000£2,302,560,000.00£12,500.00£12,000.00£500.0030.00%£0.0045.00%£0.0050.00%1509.706%3,822,314£573,347,156.45£43,956,615,327.68Regular£150,000.0020%£30,000.001,089,080£32,672,394,000.00
8
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Job Seekers AllowenceCalculated521,284,100£4,477,876,222.13£15,500.00£12,000.00£3,500.0030.00%£0.0045.00%£0.0050.00%1,0509.081%3,576,262£3,755,075,353.38£30,398,229,051.21Coop£300,000.0015%£45,000.005,311£238,989,600.00
9
RevenueBereavment Allowence£2,000.0017500£15,000,000.00£18,000.00£12,000.00£6,000.0030.00%£0.0045.00%£0.0050.00%1,80012.009%4,729,258£8,512,663,509.32£28,375,545,031.05Regular£300,000.0020%£60,000.0011,076£664,558,800.00
10
TaxGDPGDP MultiplierRevenueCommunity Care Grant£600.001500,000£300,000,000.00£22,000.00£12,000.00£10,000.0030.00%£0.0045.00%£0.0050.00%3,00013.286%5,232,152£15,696,456,461.09£10,464,304,307.40Coop£1,000,000.0015%£150,000.003,354£503,136,000.00
11
Income Tax£1,823,519,238,452.77SUM(N20)£263,448,023,243.80Crisis Loan£600.001150,000£90,000,000.00£30,000.00£12,000.00£18,000.0030.00%£0.0045.00%£0.0050.00%5,40012.222%4,812,962£25,989,994,033.810Regular£1,000,000.0020%£200,000.007,477£1,495,432,000.00
12
Petrol Revenue Duty£1,823,519,238,452.77Calculated£6,719,011,250.00Employment & Support Allowence£55.0052900,000£2,574,000,000.00£37,500.00£12,000.00£25,500.0030.00%£0.0045.00%£0.0050.00%7,65010.520%4,142,954£31,693,598,240.11Coop£10,000,000.0015%£1,500,000.001,677£2,515,680,000.00
13
VAT£1,823,519,238,452.775.80%£105,764,115,830.26Funeral Payments£600.00114,000£8,400,000.00£48,000.00£12,000.00£28,000.0030.00%£8,000.0045.00%£0.0050.00%12,0009.409%3,705,353£44,464,235,689.43£69,830,682,827.48Regular£10,000,000.0020%£2,000,000.004,333£8,665,120,000.00
14
Mansion/Wealth Tax£1,823,519,238,452.77SUM(S38)£5,960,000,000.00Guardian's Allowence£20.0052600,000£624,000,000.00£60,000.00£12,000.00£28,000.0030.00%£20,000.0045.00%£0.0050.00%17,4006.133%2,415,233£42,025,058,810.79Coop£50,000,000.0015%£7,500,000.005£36,595,967.50
15
Corporation Tax£1,823,519,238,452.77SUM(U15)£103,166,720,283.82Housing Benefit£100.00524,880,000£25,376,000,000.00£65,000.00£12,000.00£28,000.0030.00%£25,000.0045.00%£0.0050.00%19,6501.610%634,033£12,458,752,191.06Regular£50,000,000.0020%£10,000,000.001,551£15,508,817,800.00
16
Cigarette Duty£1,823,519,238,452.770.55%£10,029,355,811.49Income Support£57.3552471,000£1,404,616,200.00£70,000.00£12,000.00£28,000.0030.00%£30,000.0045.00%£0.0050.00%21,9001.210%476,509£10,435,556,218.64Total3,493,844£104,208,808,367.50
17
Fuel Duty£1,823,519,238,452.771.45%£26,441,028,957.57Industrial Injuries Disablment£85.0052500,000£2,210,000,000.00£75,000.00£12,000.00£28,000.0030.00%£35,000.0045.00%£0.0050.00%24,1500.949%373,725£9,025,462,465.13Total Coops916,691
18
Capital Gains Tax£1,823,519,238,452.770.30%£5,470,557,715.36Maternity Allowence£138.1926650,000£2,335,411,000.00£85,000.00£12,000.00£28,000.0030.00%£45,000.0045.00%£0.0050.00%28,6500.241%94,908£2,719,116,315.52Total Private2,577,153
19
Stamp Duty Land Tax£1,823,519,238,452.770.71%£12,874,045,823.48Over 80's Pension£35.00521,000,000£1,820,000,000.00£95,000.00£12,000.00£28,000.0030.00%£55,000.0045.00%£0.0050.00%33,1500.259%101,997£3,381,188,737.68
20
Drug Tax£1,823,519,238,452.770.70%0 - not active tax yetPension Credit£187.00122,710,000£6,081,240,000.00£110,000.00£7,000.00£33,000.0030.00%£70,000.0045.00%£0.0050.00%41,4000.305%120,112£4,972,631,736.02
21
Inheritance Tax£1,823,519,238,452.770.22%£3,957,036,747.44Statuatory Adoption Pay£138.195269,000£495,825,720.00£135,000.00£0.00£40,000.0030.00%£95,000.0045.00%£0.0050.00%54,7500.355%139,802£7,654,178,631.44
22
Alcohol Duty£1,823,519,238,452.770.60%£10,941,115,430.72Statuatory Paternity Pay £138.182150,000£41,454,000.00£160,000.00£0.00£40,000.0030.00%£110,000.0045.00%£10,000.0050.00%66,5000.313%123,262£8,196,946,485.26
23
Customs Duty£1,823,519,238,452.770.16%£2,844,690,011.99Training Premium£15.005230,000£23,400,000.00£200,000.00£0.00£40,000.0030.00%£110,000.0045.00%£50,000.0050.00%86,5000.235%92,545£8,005,161,290.40Unemployment ClaimantsNo. UnemployedUnclaiming Pop.No. Claimants
24
Aggregates Levy£1,823,519,238,452.770.02%£309,998,270.54Widowed Parent Allowence£111.205215,000£86,736,000.00£220,000.00£0.00£40,000.0030.00%£110,000.0045.00%£70,000.0050.00%96,5000.162%63,600£6,137,421,592.45Youth Unemployed911,07550%455,53810932900029
25
Insurance Premium Tax£1,823,519,238,452.770.18%£3,245,864,244.45Financial Marriage Incentive£565.0052131,000£3,848,780,000.00£275,000.00£0.00£40,000.0030.00%£110,000.0045.00%£125,000.0050.00%124,0000.121%47,730£5,918,483,237.0525+ Unemployed1,380,93840%828,56316571250988
26
Air Passenger Duty£1,823,519,238,452.770.19%£3,464,686,553.06Northern Ireland Housing Insen...£100,000,000.0011£100,000,000.00£620,000.00£0.00£40,000.0030.00%£110,000.0045.00%£470,000.0050.00%296,5000.040%15,910£4,717,285,698.35Total1,284,10027504151017
27
Vehicle Excise Duty£1,823,519,238,452.770.33%£6,017,613,486.89Severe Disablement Allowence£52.005240,000£108,160,000.00£850,000.00£0.00£40,000.0030.00%£110,000.0045.00%£700,000.0050.00%411,5000.032%12,699£5,225,482,754.63JSA
28
Betting and Gaming Duties£1,823,519,238,452.770.15%£2,644,102,895.76Survivors of War£1,200,000,000.0011£1,200,000,000.00£1,200,000.00£0.00£40,000.0030.00%£110,000.0045.00%£1,050,000.0050.00%586,5000.020%7,760£4,551,017,779.65AgePaymentMultiplierMultiplier CostNo. ClaimantsCost
29
Landfill Tax£1,823,519,238,452.770.07%£1,331,169,044.0711£0.00Total100.00%39,381,731£266,109,114,387.6718-24£57.3552£2,982.20455,538£1,358,503,936.15
30
Climate Change Levy£1,823,519,238,452.770.12%£2,115,282,316.61Subtotal£158,810,448,067.48WelfarePersonal Allowance£12,000.00Lower30%25+£72.4052£3,764.80828,563£3,119,372,285.98
31
Stamp Duty on Shares£1,823,519,238,452.770.17%£3,154,688,282.52HealthHigher rate start£40,000.00Higher45%Total1,284,100£4,477,876,222.13
32
Bank Levy£1,823,519,238,452.770.15%£2,735,278,857.68NHS Running Costs£100,000,000,000.0011£100,000,000,000.00
Additional rate start
£150,000.00Additional50%
33
Intrest and Dividends£1,823,519,238,452.771.07%£19,548,126,236.21Adult Social Care£370,000,000.0011£370,000,000.00Income limit
£100,000.00
34
Land Value Tax£1,823,519,238,452.77LOCAL GOVT TAX0 - No Money goes to Cent GovAttendence Allowence£71.40522,000,000£7,425,600,000.00Bereavment Allowence
35
Other Taxes and Royalties£1,823,519,238,452.77Calculated£29,400,000,000.00Constant Attendence Allowence£83.0052900,000£3,884,400,000.00Deaths p/a on averagePartnershipsNo. of PartnersClaimantsNo. Claimants
36
Penalty Payments (Laws Broken)£1,823,519,238,452.77Calculated£51,439,361.00Healthcare Travel Costs Scheme£80.001500,000£40,000,000.002500060.00%1500050.00%7500
37
?????£1,823,519,238,452.77£0.00Health Costs Allowence£250.001300,000£75,000,000.00
People Below the Personal Allowence
12,039,227
38
?????£1,823,519,238,452.77£0.00Health In Pregrancy Allowence£500.001200,000£100,000,000.00
39
?????£1,823,519,238,452.77£0.00Incapacity Benefit£101.0052162,000£850,824,000.00<---- Tax cut but
Wealth/Mansion Tax
40
?????£1,823,519,238,452.77£0.00Disability Allowance£52.43523,000,000£8,179,080,000.00represented asValue% PaidTax PaidNumberRevenueUBI
41
?????£1,823,519,238,452.77£0.00Carer's Allowence£61.3552250,000£797,550,000.00a payment£1,000,000.000.50%£5,000.00484,000£2,420,000,000.0012000
42
?????£1,823,519,238,452.77£0.00Statuatory Sick Pay £87.5528300,000£735,420,000.00£2,000,000.001%£20,000.00118,000£2,360,000,000.009000
43
?????£1,823,519,238,452.77£0.00Sure Start Maternity Grant£500.001200,000£100,000,000.00£2,500,000.001%£25,000.0047,200£1,180,000,000.006000
44
?????£1,823,519,238,452.77£0.00War Disablement Pension£3,785.8912170,000£7,723,215,600.00Total£5,960,000,000.00
45
Public Health Services£5,300,000,000.0011£5,300,000,000.00
46
~~~~~~ OPERATIONS CONSOLE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Subtotal£135,581,089,600.00Health
47
Housing Market Sim
48
Employment Statistics:NumbersPercentageCalculus - IgnoreEducationValue% of No. B/YNo. B/Y
49
Total National Population65,990,4290.7% p/a = 0.583% p/mPrimary Education Cost£700,000,000.0011£700,000,000.00£10,000.00
50
Labour Force Participation41,672,95663.15%Secondary Education Cost£25,600,000,000.0011£25,600,000,000.00£20,000.00
51
Employed Population 39,380,94494.50%100%Further Education Cost£12,800,000,000.0011£12,800,000,000.00£30,000.00
52
Unemployed 16-24911,07539.75%School Meals£6,000,000,000.0011£6,000,000,000.00£50,000.00
53
Unemployed 25+ 1,380,93860.25%Academies Fund£2,800,000,000.0011£2,800,000,000.00£80,000.00
54
Total Unemployed Population2,292,0135.50%Education N.E.C£2,500,000,000.0011£2,500,000,000.00£100,000.00
55
Pensioners13198085.8520.00%Pr-Primary Education Cost£100,000,000.0011£100,000,000.00£120,000.00
56
Other Costs£800,000,000.0011£800,000,000.00£150,000.00
57
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
11£0.00£180,000.00
58
Subtotal£51,300,000,000.00Education£200,000.00
59
Transport and Infrastructure£220,000.00
60
Research & Development£4,500,000,000.0011£4,500,000,000.00£250,000.00
61
Rail Investment£3,500,000,000.0011£3,500,000,000.00£280,000.00
62
Offshore Wind Industry£95,000,000.0011£95,000,000.00£300,000.00
63
Wave/Tidal Tech Fund£48,000,000.0011£48,000,000.00£350,000.00
64
Nuclear Tech Fund Advancement£37,000,000.0011£37,000,000.00£400,000.00
65
Other Transport£1,800,000,000.0011£1,800,000,000.00£450,000.00
66
NI Transport Holding£100,000,000.0011£100,000,000.00£500,000.00
67
Local Public Transport£400,000,000.0011£400,000,000.00£550,000.00
68
National Roads £3,200,000,000.0011£3,200,000,000.00£600,000.00
69
Local Roads£400,000,000.0011£400,000,000.00£650,000.00
70
LKTRA Transport£2,000,000,000.0011£2,000,000,000.00£700,000.00
71
HS2£188,248,000.0011£188,248,000.00£800,000.00
72
11£0.00£900,000.00
73
Subtotal£16,268,248,000.00
Transport and Infrastructure
£1,000,000.00
74
Defence£1,250,000.00
75
Military Defence£29,100,000,000.0011£29,100,000,000.00£1,500,000.00
76
Trident£2,400,000,000.0011£2,400,000,000.00£1,750,000.00
77
Research & Development£3,200,000,000.0011£3,200,000,000.00£2,000,000.00
78
Defence N.E.C£100,000,000.0011£100,000,000.00£2,500,000.00
79
Nuclear Decom Authority£7,000,000.0011£7,000,000.00Total
80
11£0.00Govt Aim100000
81
Subtotal£34,807,000,000.00Defence
82
Home Office and justice
83
Police Costs£5,600,000,000.0011£5,600,000,000.00
84
UK Border agency£1,200,000,000.0011£1,200,000,000.00
85
Fire Services£500,000,000.0011£500,000,000.00
86
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Courts£1,200,000,000.0011£1,200,000,000.00
87
Prisons£4,000,000,000.0011£4,000,000,000.00
88
UK DEBTLegal aid£2,200,000,000.0011£2,200,000,000.00
89
Current Debt Level£1,520,774,388,862.7611£0.00
90
Interest Rate1.62%11£0.00
91
Deficit (+) / Surplus (-)£23,208,469,681.94Subtotal£14,700,000,000.00Home Office + Jusice
92
Debt in 1 month£1,524,764,084,380.73Treasury + General Govt
93
Debt in 12 Months£1,568,619,403,644.28Agriculture Industry£4,900,000,000.0011£4,900,000,000.00
94
Credit RatingAAAGeneral Economic Costs£6,200,000,000.0011£6,200,000,000.00
95
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Fuel and Energy Industry£900,000,000.0011£900,000,000.00
96
Communications Industry£400,000,000.0011£400,000,000.00
97
GDP GROWTHOther Industries£100,000,000.0011£100,000,000.00
98
Current GDP£1,823,519,238,452.77R&D Economic Affairs£7,600,000,000.0011£7,600,000,000.00
99
Predicted GDP Growth0.20%11£0.00
100
Actual GDP Growth0.15%11£0.00