Footnote: Family Income Spreadsheet

Year	Age	inc_me	incwif	incdla	incwel	inc_cb	inctot	taxinc	taxni4	taxni1	tax_cc	taxwat	taxtot	fixmor	fixend	fixhse	fixcon	fixtot	elekwh	utelec	gaskwh	utgas	utmai	utpho	uttv	uttot	cartax	carins	carpet	carmai	carpkg	carpch	cartot	sp_tax	sp_fix	sp_uti	sp_car	budsur	buddeg	surp1	surp2	surp3	surp4	pppy	pppd
1966	24	990	0	0	0	0	990	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1967	25	980	0	0	0	0	980	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1968	26	1125	0	0	0	0	1125	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1969	27	1850	0	0	0	0	1850	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1970	28	2000	0	0	0	0	2000	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1971	29	2250	0	0	0	0	2250	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1972	30	2550	0	0	0	0	2550	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1973	31	3000	0	0	0	0	3000	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1974	32	3350	0	0	0	0	3350	0	0	0	0	0	0.00	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1975	33	3750	0	0	0	0	3750	0.00	0.00	0	151.67	0	151.67	0	0	0	0	0.00	0	0	0	0	0	0	0	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1976	34	4250	0	0	0	0	4250	83.48	15.76	57.84	188.08	15.66	360.82	630.09	194.64	7.19	0	831.92	0	0	0	115.60	0	85.77	0	201.37	40.00	32.22	189.03	309.51	0	0	570.76	3889.18	3057.26	2855.89	2285.13	1482.65	1103.19	1373.24	1752.70	802.48	1181.94	761.71	2.09
1977	35	2280	777	0	0	0	3057	0.00	6.80	139.73	207.93	17.68	372.14	651.37	194.64	18.88	0	864.89	3303	93.82	0	100.56	0	115.56	0	309.94	50.00	37.05	209.07	122.50	0	0	418.62	2684.86	1819.97	1510.03	1091.41	1707.09	1270.19	-197.06	239.84	-615.68	-178.78	363.80	1.00
1978	36	2908	929	0	0	0	3837	69.24	25.00	101.84	212.28	42.28	450.64	537.44	194.64	20.63	0	752.71	4080	122.96	0	107.01	0	178.21	0	408.18	68.35	85.23	320.50	86.28	0	1550.00	2110.36	3386.36	2633.65	2225.47	115.11	1915.53	1425.28	309.94	800.19	-1800.42	-1310.17	38.37	0.11
1979	37	5543	1011	0	0	0	6554	0.00	0.00	108.40	244.76	44.02	397.18	689.67	163.40	24.75	0	877.82	4420	145.15	0	175.00	0	219.78	0	539.93	50.00	90.98	418.46	229.40	0	0	788.84	6156.82	5279.00	4739.07	3950.23	2075.75	1544.49	2663.32	3194.58	1874.48	2405.74	1316.74	3.61
1980	38	8173	1100	0	0	0	9273	37.50	10.75	115.90	300.15	53.74	518.04	876.59	160.56	29.63	0	1066.78	3725	156.71	15377	124.43	0	295.19	0	576.33	60.00	107.35	351.31	432.07	0	5000.00	5950.73	8754.96	7688.18	7111.85	1161.12	2432.47	1809.92	4679.38	5301.93	-1271.35	-648.80	290.28	0.79
1981	39	6592	1375	0	0	0	7967	1539.30	287.16	182.30	338.43	64.70	2411.89	790.19	165.07	31.88	0	987.14	2247	118.70	27707	265.67	0	376.50	0	760.87	70.00	101.56	518.03	103.01	1.50	0	794.10	5555.11	4567.97	3807.10	3013.00	2801.02	2084.14	1006.08	1722.96	211.98	928.86	602.60	1.65
1982	40	3501	1534	0	0	0	5035	1224.30	210.30	190.37	393.24	68.40	2086.61	781.38	165.48	34.75	0	981.61	2920	163.02	23215	278.27	20.24	429.24	0	890.77	80.00	101.56	509.57	9.36	7.00	0	707.49	2948.39	1966.78	1076.01	368.52	3137.68	2334.64	-2061.67	-1258.63	-2769.16	-1966.12	73.70	0.20
1983	41	8059	1664	0	0	0	9723	55.50	0.00	0.00	416.15	68.24	539.89	459.78	165.48	37.00	0	662.26	3243	182.11	23678	310.29	23.00	331.23	46.00	892.63	85.00	163.77	524.43	251.81	7.50	0	1032.51	9183.11	8520.85	7628.22	6595.71	3306.01	2459.89	4322.21	5168.33	3289.70	4135.82	1319.14	3.61
1984	42	10948	1768	0	0	0	12716	913.50	129.15	238.40	438.48	73.02	1792.55	484.43	165.48	39.13	0	689.04	3991	221.24	25697	348.30	24.28	386.06	46.00	1025.88	90.00	146.03	524.67	213.43	1.00	0	975.13	10923.45	10234.41	9208.53	8233.40	3482.34	2591.09	5726.19	6617.44	4751.06	5642.31	1646.68	4.51
1985	43	15028	1820	0	0	0	16848	2343.90	364.14	218.90	581.22	78.81	3586.97	520.94	165.48	68.25	15.00	769.67	3595	208.16	28623	331.43	25.50	563.79	58.00	1186.88	100.00	107.00	800.36	350.19	20.20	0	1377.75	13261.03	12491.36	11304.48	9926.73	3642.56	2710.30	7661.92	8594.18	6284.17	7216.43	1985.35	5.44
1986	44	15516	1976	0	0	0	17492	3387.20	653.31	194.00	709.03	95.80	5039.34	465.31	165.48	78.68	17.40	726.87	4117	238.68	32054	448.02	27.00	491.44	58.00	1263.14	100.00	123.00	442.13	82.21	0	0	747.34	12452.66	11725.79	10462.65	9715.31	3846.95	2862.38	6615.70	7600.27	5868.36	6852.93	1943.06	5.32
1987	45	10171	2425	0	0	0	12596	4194.45	677.25	199.70	752.10	100.86	5924.36	466.64	165.48	89.85	17.40	739.37	4650	265.42	28697	397.60	29.00	343.07	58.00	1093.09	100.00	143.00	577.41	338.69	0.40	0	1159.50	6671.64	5932.27	4839.18	3679.68	3991.28	2969.77	847.90	1869.41	-311.60	709.91	735.94	2.01
1988	46	6708	2132	0	0	0	8840	642.00	140.74	213.65	887.45	110.52	1994.36	444.77	165.48	110.42	32.50	753.17	4507	275.25	26572	379.73	33.00	610.67	62.50	1361.15	100.00	143.00	536.45	236.08	0.00	670.50	1686.03	6845.64	6092.47	4731.32	3045.29	4139.56	3080.10	591.76	1651.22	-1094.27	-34.81	609.06	1.67
1989	47	9754	2236	0	0	0	11990	678.00	132.55	220.20	933.04	113.93	2077.72	559.11	169.99	121.62	34.77	885.49	4409	286.61	28628	420.04	37.00	784.71	66.00	1594.36	100.00	257.00	415.07	324.26	5.00	2682.00	3783.33	9912.28	9026.79	7432.43	3649.10	4420.00	3288.77	3012.43	4143.66	-770.90	360.33	729.82	2.00
1990	48	9029	2392	0	0	0	11421	1242.50	276.19	235.40	830.96	155.29	2740.34	626.85	170.40	127.75	35.70	960.70	4450	313.80	27668	435.46	41.00	735.74	71.00	1597.00	100.00	285.00	676.28	157.98	12.60	2682.00	3913.86	8680.66	7719.96	6122.96	2209.10	4760.61	3542.20	1362.35	2580.76	-2551.51	-1333.10	441.82	1.21
1991	49	-1646	225	0	4427.22	809	3815	0.00	0.00	131.50	92.42	180.28	404.20	425.05	79.32	150.20	61.90	716.47	3691	294.56	31000	518.55	35.25	613.41	77.00	1538.77	100.00	265.00	561.61	366.50	0	4838.00	6131.11	3411.02	2694.55	1155.78	-4975.33	5205.43	3873.18	-4049.65	-2717.40	-10180.76	-8848.51	-1243.83	-3.41
1992	50	-1969	0	0	4949.70	902	3883	0.00	0.00	0.00	104.52	199.20	303.72	263.70	71.04	188.00	78.20	600.94	3682	307.36	21011	357.44	37.97	899.07	80.00	1681.84	110.00	397.00	612.75	548.95	5.11	0	1673.81	3578.98	2978.04	1296.20	-377.61	5437.88	4046.13	-4141.68	-2749.93	-5815.49	-4423.74	-94.40	-0.26
1993	51	-806	0	0	5593.55	963	5751	0.00	0.00	0.00	0.00	211.87	211.87	187.86	71.04	188.25	44.45	491.60	3704	301.23	22455	362.84	52.44	548.72	83.00	1348.23	130.00	258.00	639.30	190.21	6.29	0	1223.80	5538.68	5047.08	3698.85	2475.05	5578.15	4150.51	-1879.30	-451.66	-3103.10	-1675.46	618.76	1.69
1994	52	-83	0	0	5881.29	984	6782	0.00	0.00	0.00	0.00	223.51	223.51	191.64	71.04	231.54	45.85	540.07	3644	295.52	21297	373.51	54.42	270.82	84.50	1078.77	135.00	282.90	573.21	130.74	0	0	1121.85	6558.78	6018.71	4939.94	3818.09	5686.32	4230.99	-746.38	708.95	-1868.23	-412.90	954.52	2.61
1995	53	-200	0	0	5836.08	984	6620	0.00	0.00	0.00	0.00	242.69	242.69	206.88	71.04	231.54	0	509.46	3646	263.01	18241	334.95	56.40	260.87	86.50	1001.73	140.00	211.15	489.45	90.80	0	0	931.40	6377.39	5867.93	4866.20	3934.80	5850.59	4353.22	-984.39	512.98	-1915.79	-418.42	983.70	2.69
1996	54	317	0	0	6121.00	1023	7461	0.00	0.00	0.00	0.00	256.88	256.88	223.37	41.44	0	0	264.81	4039	344.63	19341	371.11	58.20	345.07	89.50	1208.51	145.00	206.02	401.91	42.37	0	0	795.30	7204.12	6939.31	5730.80	4935.50	6039.77	4493.98	-308.97	1236.82	-1104.27	441.52	1233.88	3.38
1997	55	-1366	0	0	6347.10	1023	6004	0.00	0.00	0.00	0.00	269.32	269.32	0	0	0	0	0.00	3985	324.75	23168	350.28	62.99	293.68	91.50	1123.20	150.00	194.68	387.25	389.87	0	0	1121.80	5734.78	5734.78	4611.58	3489.78	6187.14	4603.63	-1575.56	7.95	-2697.36	-1113.85	872.45	2.39
1998	56	0	0	1461	8365.80	1046	10873	0.00	0.00	0.00	0.00	286.30	286.30	0	0	0	0	0.00	3554	273.38	22011	355.07	0.00	352.40	97.50	1078.35	150.00	225.68	415.03	773.64	0	0	1564.35	10586.70	10586.70	9508.35	7944.00	6411.58	4770.63	3096.77	4737.72	1532.42	3173.37	1986.00	5.44
1999	57	0	0	1461	7632.75	751	9845	0.00	0.00	0.00	0.00	304.30	304.30	0.00	0.00	0.00	0.00	0.00	3552	260.30	22322	345.05	0.00	439.20	101.00	1145.55	155.00	166.83	511.86	161.55	0.00	0.00	995.24	9540.45	9540.45	8394.90	7399.66	6587.92	4901.84	1806.98	3493.06	811.74	2497.82	2466.55	6.75

Key To Column Headings

inc_me	my income as an employee or my profit as a self-employed artisan.
incwif	my wife's earnings as an assistant to me in my business.
incdla	my wife's Disability Living Allowance.
incwel	Welfare received (Income Support or Jobseeker's Allowance).
inc_cb	Child Benefit: a fixed amount paid to a family for each child.
inctot	Total family income: the sum of the above 5 items.
taxinc	Income Tax: earnings tax on my salary or self-employment profit.
taxni4	Class 4 National Insurance Contributions levied on the above.
taxni1	Class 1 National Insurance Contributions levied on the above.
tax_cc	Local Authority tax (domestic rates/comunity charge/council tax).
taxwat	Water Rates: charge for water/sewage based on 'value' of house.
taxtot	Total direct taxation: sum of the above 5 items.
fixmor	Mortgage interest on the purchase of our house.
fixend	Endowment Insurance which pays off capital on house.
fixhse	House Insurance for the house itself as a building.
fixcon	Contents Insurance for furniture and other things in the house.
fixtot	Total Fixed Costs: sum of the above 4 items.
elekwh	Electricity consumption for the year in kilowatt-hours.
utelec	Cost of the year's electricity.
gaskwh	Thermal energy of gas consumption in kilowatt-hours.
utgas	Cost of the year's gas.
utmai	Cost of gas boiler maintenance contract.
utpho	Annual cost of telephone service.
uttv	Annual cost of television licence.
uttot	Total utilities costs: the above 5 items.
cartax	Car tax: the road fund licence.
carins	Car insurance.
carpet	Petrol (fuel) costs.
carmai	Car maintenance costs.
carpkg	Car parking costs.
carpch	Capital cost of the car: hire purchase costs.
cartot	Total car costs: sum of the above 6 items.
sp_tax	Gross income minus all direct taxes (see above).
sp_fix	The above minus total fixed costs (house etc).
sp_uti	The above miunus total utilities costs (gas electricity etc).
sp_car	The above minus the cost of running our car.
budsur	Our Survival Budget (see tables in Chapter 5).
buddeg	Our Degradation Budget (see tables in Chapter 5).
surp1	Surplus of income over expenditure on our Survival Budget.
surp2	What the above would be if we had no car.
surp3	Surplus of income over expenditure on our Degdadation Budget.
surp4	What the above would be if we had no car.
pppy	What each family member has left to live on per year.
pppd	What each family member has left to live on per day.

---

Parent Page | © July 1999 Robert John Morton