Sahr spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Table 7.1—FEDERAL DEBT AT THE END OF YEAR: 1940–estimated 2017
2	End of Fiscal Year	In Millions of Dollars											As Percentages of GDP
3	End of Fiscal Year				Equals: Held by the Public									Less: Held by Federal Government Accounts	Equals: Held by the Public
4		Gross Federal Debt	Gross Federal Debt billions	Less: Held by Federal Government Accounts (millions)	Total Held by the Public (millions)	Debt held by the public billions	Federal Reserve System	Public excl Fed Reserve	Public excl Fed Reserve (billions)	Public excl Fed Reserve (billions 2011$)	Real change in public excl Fed Reserve %	Real change in public excl Fed Reserve % by pres term	Gross federal debt percent GDP	Less: Held by Federal Government Accounts	Total	Federal Reserve System	Other	2011$ CF	Gross debt billions 2011$	Change gross debt billions 2011$	Change gross debt percent	Percent change gross debt by presidential term	Public debt billions 2011$	Change public debt billions 2011$	Change public debt percent	Percent change public debt by presidential term
5	1940	50,696	51	7,924	42,772	43	2,458	40,314	40.3	650.2			52.4	8.2	44.2	2.5	41.7	0.062	817.68				689.87
6	1941	57,531	58	9,308	48,223	48	2,180	46,043	46.0	708.4	8.9		50.5	8.2	42.3	1.9	40.4	0.065	885.09	67.41	8.2		741.89	52.02	7.5
7	1942	79,200	79	11,447	67,753	68	2,640	65,113	65.1	904.3	27.7		54.9	7.9	47.0	1.8	45.2	0.072	1,100.00	214.91	24.3		941.01	199.12	26.8
8	1943	142,648	143	14,882	127,766	128	7,149	120,617	120.6	1,566.5	73.2		79.2	8.3	70.9	4.0	67.0	0.077	1,852.57	752.57	68.4		1,659.30	718.28	76.3
9	1944	204,079	204	19,283	184,796	185	14,899	169,897	169.9	2,178.2	39.1	235.0	97.6	9.2	88.4	7.1	81.3	0.078	2,616.40	763.83	41.2	220.0	2,369.18	709.88	42.8	243.4
10	1945	260,123	260	24,941	235,182	235	21,792	213,390	213.4	2,667.4	22.5		117.5	11.3	106.3	9.8	96.4	0.080	3,251.54	635.14	24.3		2,939.78	570.60	24.1
11	1946	270,991	271	29,130	241,861	242	23,783	218,078	218.1	2,506.6	-6.0		121.7	13.1	108.6	10.7	97.9	0.087	3,114.84	(136.70)	-4.2		2,780.01	(159.76)	-5.4
12	1947	257,149	257	32,810	224,339	224	21,872	202,467	202.5	2,045.1	-18.4		109.6	14.0	95.6	9.3	86.3	0.099	2,597.46	(517.37)	-16.6		2,266.05	(513.96)	-18.5
13	1948	252,031	252	35,761	216,270	216	21,366	194,904	194.9	1,821.5	-10.9	-16.4	98.3	13.9	84.3	8.3	76.0	0.107	2,355.43	(242.03)	-9.3	-10.0	2,021.21	(244.84)	-10.8	-14.7
14	1949	252,610	253	38,288	214,322	214	19,343	194,979	195.0	1,839.4	1.0		93.0	14.1	78.9	7.1	71.8	0.106	2,383.11	27.68	1.2		2,021.91	0.69	0.0
15	1950	256,853	257	37,830	219,023	219	18,331	200,692	200.7	1,875.6	2.0		93.9	13.8	80.1	6.7	73.4	0.107	2,400.50	17.38	0.7		2,046.94	25.04	1.2
16	1951	255,288	255	40,962	214,326	214	22,982	191,344	191.3	1,649.5	-12.1		79.5	12.8	66.8	7.2	59.6	0.116	2,200.76	(199.74)	-8.3		1,847.64	(199.31)	-9.7
17	1952	259,097	259	44,339	214,758	215	22,906	191,852	191.9	1,625.9	-1.4	-10.7	74.3	12.7	61.6	6.6	55.0	0.118	2,195.74	(5.02)	-0.2	-6.8	1,819.98	(27.65)	-1.5	-10.0
18	1953	265,963	266	47,580	218,383	218	24,746	193,637	193.6	1,627.2	0.1		71.2	12.7	58.5	6.6	51.9	0.119	2,234.98	39.25	1.8		1,835.15	15.17	0.8
19	1954	270,812	271	46,313	224,499	224	25,037	199,462	199.5	1,662.2	2.1		71.6	12.3	59.4	6.6	52.8	0.120	2,256.77	21.78	1.0		1,870.83	35.67	1.9
20	1955	274,366	274	47,751	226,616	227	23,607	203,009	203.0	1,706.0	2.6		69.4	12.1	57.3	6.0	51.4	0.119	2,305.60	48.83	2.2		1,904.34	33.51	1.8
21	1956	272,693	273	50,537	222,156	222	23,758	198,398	198.4	1,639.7	-3.9	0.8	63.8	11.8	51.9	5.6	46.4	0.121	2,253.66	(51.94)	-2.3	2.6	1,836.00	(68.34)	-3.6	0.9
22	1957	272,252	272	52,931	219,320	219	23,035	196,285	196.3	1,570.3	-4.2		60.4	11.7	48.7	5.1	43.6	0.125	2,178.02	(75.65)	-3.4		1,754.56	(81.44)	-4.4
23	1958	279,666	280	53,329	226,336	226	25,438	200,898	200.9	1,569.5	0.0		60.7	11.6	49.1	5.5	43.6	0.128	2,184.89	6.87	0.3		1,768.25	13.69	0.8
24	1959	287,465	287	52,764	234,701	235	26,044	208,657	208.7	1,617.5	3.1		58.4	10.7	47.7	5.3	42.4	0.129	2,228.41	43.52	2.0		1,819.39	51.14	2.9
25	1960	290,525	291	53,686	236,840	237	26,523	210,317	210.3	1,593.3	-1.5	-2.8	56.0	10.3	45.6	5.1	40.5	0.132	2,200.95	(27.46)	-1.2	-2.3	1,794.24	(25.15)	-1.4	-2.3
26	1961	292,648	293	54,291	238,357	238	27,253	211,104	211.1	1,587.2	-0.4		55.0	10.2	44.8	5.1	39.7	0.133	2,200.36	(0.59)	0.0		1,792.16	(2.08)	-0.1
27	1962	302,928	303	54,918	248,010	248	29,663	218,347	218.3	1,629.5	2.7		53.3	9.7	43.6	5.2	38.4	0.134	2,260.66	60.30	2.7		1,850.82	58.66	3.3
28	1963	310,324	310	56,345	253,978	254	32,027	221,951	222.0	1,632.0	0.2		51.7	9.4	42.4	5.3	37.0	0.136	2,281.79	21.14	0.9		1,867.49	16.66	0.9
29	1964	316,059	316	59,210	256,849	257	34,794	222,055	222.1	1,609.1	-1.4	1.0	49.3	9.2	40.1	5.4	34.6	0.138	2,290.28	8.49	0.4	4.1	1,861.22	(6.26)	-0.3	3.7
30	1965	322,318	322	61,540	260,778	261	39,100	221,678	221.7	1,583.4	-1.6		46.9	8.9	37.9	5.7	32.2	0.140	2,302.27	11.99	0.5		1,862.70	1.48	0.1
31	1966	328,498	328	64,784	263,714	264	42,169	221,545	221.5	1,538.5	-2.8		43.6	8.6	35.0	5.6	29.4	0.144	2,281.24	(21.04)	-0.9		1,831.35	(31.35)	-1.7
32	1967	340,445	340	73,819	266,626	267	46,719	219,907	219.9	1,485.9	-3.4		41.8	9.1	32.8	5.7	27.0	0.148	2,300.30	19.07	0.8		1,801.53	(29.82)	-1.6
33	1968	368,685	369	79,140	289,545	290	52,230	237,315	237.3	1,531.1	3.0	-4.8	42.5	9.1	33.3	6.0	27.3	0.155	2,378.61	78.31	3.4	3.9	1,868.03	66.51	3.7	0.4
34	1969	365,769	366	87,661	278,108	278	54,095	224,013	224.0	1,374.3	-10.2		38.5	9.2	29.3	5.7	23.6	0.163	2,243.98	(134.63)	-5.7		1,706.18	(161.85)	-8.7
35	1970	380,921	381	97,723	283,198	283	57,714	225,484	225.5	1,311.0	-4.6		37.6	9.6	28.0	5.7	22.3	0.172	2,214.66	(29.32)	-1.3		1,646.50	(59.68)	-3.5
36	1971	408,176	408	105,140	303,037	303	65,518	237,519	237.5	1,319.6	0.7		37.7	9.7	28.0	6.1	22.0	0.180	2,267.64	52.99	2.4		1,683.54	37.04	2.2
37	1972	435,936	436	113,559	322,377	322	71,426	250,951	251.0	1,349.2	2.2	-11.9	36.9	9.6	27.3	6.0	21.2	0.186	2,343.74	76.10	3.4	-1.5	1,733.21	49.67	3.0	-7.2
38	1973	466,291	466	125,381	340,910	341	75,181	265,729	265.7	1,348.9	0.0		35.6	9.6	26.1	5.7	20.3	0.197	2,366.96	23.22	1.0		1,730.51	(2.70)	-0.2
39	1974	483,893	484	140,194	343,699	344	80,648	263,051	263.1	1,201.1	-11.0		33.6	9.7	23.8	5.6	18.2	0.219	2,209.56	(157.40)	-6.6		1,569.40	(161.11)	-9.3
40	1975	541,925	542	147,225	394,700	395	84,993	309,707	309.7	1,295.8	7.9		34.7	9.4	25.3	5.4	19.9	0.239	2,267.47	57.91	2.6		1,651.46	82.06	5.2
41	1976	628,970	629	151,566	477,404	477	94,714	382,690	382.7	1,512.6	16.7	12.1	36.2	8.7	27.5	5.5	22.0	0.253	2,486.05	218.58	9.6	6.1	1,886.97	235.51	14.3	8.9
42	1977	706,398	706	157,294	549,104	549	105,004	444,100	444.1	1,650.9	9.1		35.8	8.0	27.9	5.3	22.5	0.269	2,626.01	139.97	5.6		2,041.28	154.31	8.2
43	1978	776,602	777	169,476	607,126	607	115,480	491,646	491.6	1,695.3	2.7		35.0	7.6	27.4	5.2	22.2	0.290	2,677.94	51.92	2.0		2,093.54	52.26	2.6
44	1979	829,467	829	189,161	640,306	640	115,594	524,712	524.7	1,624.5	-4.2		33.1	7.6	25.6	4.6	21.0	0.323	2,568.01	(109.93)	-4.1		1,982.37	(111.17)	-5.3
45	1980	909,041	909	197,118	711,923	712	120,846	591,077	591.1	1,615.0	-0.6	6.8	33.3	7.2	26.1	4.4	21.6	0.366	2,483.72	(84.29)	-3.3	-0.1	1,945.14	(37.23)	-1.9	3.1
46	1981	994,828	995	205,418	789,410	789	124,466	664,944	664.9	1,645.9	1.9		32.5	6.7	25.8	4.1	21.7	0.404	2,462.45	(21.27)	-0.9		1,953.99	8.84	0.5
47	1982	1,137,315	1,137	212,740	924,575	925	134,497	790,078	790.1	1,841.7	11.9		35.2	6.6	28.6	4.2	24.5	0.429	2,651.08	188.64	7.7		2,155.19	201.20	10.3
48	1983	1,371,660	1,372	234,392	1,137,268	1,137	155,527	981,741	981.7	2,216.1	20.3		39.9	6.8	33.1	4.5	28.5	0.443	3,096.30	445.21	16.8		2,567.20	412.01	19.1
49	1984	1,564,586	1,565	257,611	1,306,975	1,307	155,122	1,151,853	1,151.9	2,493.2	12.5	54.4	40.8	6.7	34.0	4.0	30.0	0.462	3,386.55	290.25	9.4	36.3	2,828.95	261.75	10.2	45.4
50	1985	1,817,423	1,817	310,163	1,507,260	1,507	169,806	1,337,454	1,337.5	2,798.0	12.2		43.9	7.5	36.4	4.1	32.3	0.478	3,802.14	415.59	12.3		3,153.26	324.31	11.5
51	1986	2,120,501	2,121	379,878	1,740,623	1,741	190,855	1,549,767	1,549.8	3,182.3	13.7		48.2	8.6	39.5	4.3	35.2	0.487	4,354.21	552.07	14.5		3,574.17	420.91	13.3
52	1987	2,345,956	2,346	456,203	1,889,753	1,890	212,040	1,677,713	1,677.7	3,322.2	4.4		50.5	9.8	40.7	4.6	36.1	0.505	4,645.46	291.25	6.7		3,742.09	167.91	4.7
53	1988	2,601,104	2,601	549,487	2,051,616	2,052	229,218	1,822,398	1,822.4	3,464.6	4.3	39.0	51.9	11.0	40.9	4.6	36.3	0.526	4,945.06	299.61	6.4	46.0	3,900.41	158.33	4.2	37.9
54	1989	2,867,800	2,868	677,084	2,190,716	2,191	220,088	1,970,628	1,970.6	3,576.5	3.2		53.1	12.5	40.5	4.1	36.5	0.551	5,204.72	259.65	5.3		3,975.89	75.48	1.9
55	1990	3,206,290	3,206	794,733	2,411,558	2,412	234,410	2,177,147	2,177.1	3,747.2	4.8		55.9	13.9	42.0	4.1	37.9	0.581	5,518.57	313.85	6.0		4,150.70	174.81	4.4
56	1991	3,598,178	3,598	909,179	2,688,999	2,689	258,591	2,430,408	2,430.4	4,017.2	7.2		60.6	15.3	45.3	4.4	41.0	0.605	5,947.40	428.83	7.8		4,444.63	293.92	7.1
57	1992	4,001,787	4,002	1,002,050	2,999,737	3,000	296,397	2,703,341	2,703.3	4,332.3	7.8	25.0	64.1	16.1	48.1	4.8	43.3	0.624	6,413.12	465.72	7.8	29.7	4,807.27	362.64	8.2	23.3
58	1993	4,351,044	4,351	1,102,647	3,248,396	3,248	325,653	2,922,744	2,922.7	4,552.6	5.1		66.1	16.8	49.4	5.0	44.4	0.642	6,777.33	364.21	5.7		5,059.81	252.54	5.3
59	1994	4,643,307	4,643	1,210,242	3,433,065	3,433	355,150	3,077,915	3,077.9	4,670.6	2.6		66.7	17.4	49.3	5.1	44.2	0.659	7,045.99	268.66	4.0		5,209.51	149.70	3.0
60	1995	4,920,586	4,921	1,316,208	3,604,378	3,604	374,114	3,230,264	3,230.3	4,764.4	2.0		67.2	18.0	49.2	5.1	44.1	0.678	7,257.50	211.51	3.0		5,316.19	106.68	2.0
61	1996	5,181,465	5,181	1,447,392	3,734,073	3,734	390,924	3,343,149	3,343.1	4,789.6	0.5	10.6	67.3	18.8	48.5	5.1	43.4	0.698	7,423.30	165.80	2.3	15.8	5,349.67	33.48	0.6	11.3
62	1997	5,369,206	5,369	1,596,862	3,772,344	3,772	424,518	3,347,826	3,347.8	4,688.8	-2.1		65.6	19.5	46.1	5.2	40.9	0.714	7,519.90	96.59	1.3		5,283.39	(66.28)	-1.2
63	1998	5,478,189	5,478	1,757,090	3,721,099	3,721	458,182	3,262,917	3,262.9	4,500.6	-4.0		63.5	20.4	43.1	5.3	37.8	0.725	7,556.12	36.23	0.5		5,132.55	(150.84)	-2.9
64	1999	5,605,523	5,606	1,973,160	3,632,363	3,632	496,644	3,135,719	3,135.7	4,231.7	-6.0		61.4	21.6	39.8	5.4	34.4	0.741	7,564.81	8.69	0.1		4,901.97	(230.58)	-4.5
65	2000	5,628,700	5,629	2,218,896	3,409,804	3,410	511,413	2,898,391	2,898.4	3,783.8	-10.6	-21.0	57.3	22.6	34.7	5.2	29.5	0.766	7,348.17	(216.64)	-2.9	-1.0	4,451.44	(450.53)	-9.2	-16.8
66	2001	5,769,881	5,770	2,450,266	3,319,615	3,320	534,135	2,785,480	2,785.5	3,539.4	-6.5		56.4	24.0	32.5	5.2	27.2	0.787	7,331.49	(16.68)	-0.2		4,218.06	(233.38)	-5.2
67	2002	6,198,401	6,198	2,657,974	3,540,427	3,540	604,191	2,936,235	2,936.2	3,670.3	3.7		58.8	25.2	33.6	5.7	27.8	0.800	7,748.00	416.51	5.7		4,425.53	207.47	4.9
68	2003	6,760,014	6,760	2,846,570	3,913,443	3,913	656,116	3,257,327	3,257.3	3,982.1	8.5		61.6	25.9	35.6	6.0	29.7	0.818	8,264.08	516.07	6.7		4,784.16	358.63	8.1
69	2004	7,354,657	7,355	3,059,113	4,295,544	4,296	700,341	3,595,203	3,595.2	4,280.0	7.5	13.1	62.9	26.2	36.8	6.0	30.8	0.840	8,755.54	491.47	5.9	19.2	5,113.74	329.58	6.9	14.9
70	2005	7,905,300	7,905	3,313,088	4,592,212	4,592	736,360	3,855,852	3,855.9	4,442.2	3.8		63.5	26.6	36.9	5.9	31.0	0.868	9,107.49	351.94	4.0		5,290.57	176.82	3.5
71	2006	8,451,350	8,451	3,622,378	4,828,972	4,829	768,924	4,060,048	4,060.0	4,531.3	2.0		63.9	27.4	36.5	5.8	30.7	0.896	9,432.31	324.82	3.6		5,389.48	98.91	1.9
72	2007	8,950,744	8,951	3,915,615	5,035,129	5,035	779,632	4,255,497	4,255.5	4,615.5	1.9		64.4	28.2	36.2	5.6	30.6	0.922	9,707.97	275.66	2.9		5,461.09	71.62	1.3
73	2008	9,986,082	9,986	4,183,032	5,803,050	5,803	491,127	5,311,923	5,311.9	5,550.6	20.3	29.7	69.2	29.0	40.2	3.4	36.8	0.957	10,434.78	726.81	7.5	19.2	6,063.79	602.70	11.0	18.6
74	2009	11,875,851	11,876	4,331,144	7,544,707	7,545	769,160	6,775,547	6,775.5	7,102.3	28.0		84.2	30.7	53.5	5.5	48.1	0.954	12,448.48	2,013.70	19.3		7,908.50	1,844.70	30.4
75	2010	13,528,807	13,529	4,509,867	9,018,941	9,019	811,669	8,207,272	8,207.3	8,469.8	19.3		93.2	31.1	62.2	5.6	56.6	0.969	13,961.62	1,513.14	12.2		9,307.47	1,398.97	17.7
76	2011	14,764,222	14,764	4,636,016	10,128,206	10,128	1,664,660	8,463,546	8,463.5	8,463.5	-0.1		98.7	31.0	67.7	11.1	56.6	1.000	14,764.22	802.60	5.7		10,128.21	820.73	8.8
77	2012 est.	16,350,885	16,351	4,772,802	11,578,083	11,578	N/A	N/A					104.8	30.6	74.2	N/A	N/A	1.019	16,046.01	1,281.79	8.7	53.8	11,362.20	1,234.00	12.2	87.4
78	2013 est	17,547,936	17,548	4,911,247	12,636,689	12,637	N/A	N/A					107.4	30.1	77.4	N/A	N/A	1.037	16,921.83	875.82	5.5		12,185.81	823.61	7.2
79	2014 est	18,499,909	18,500	5,054,691	13,445,219	13,445	N/A	N/A					107.8	29.5	78.4	N/A	N/A	1.055	17,535.46	613.63	3.6		12,744.28	558.47	4.6
80	2015 est.	19,426,503	19,427	5,229,139	14,197,365	14,197	N/A	N/A					106.9	28.8	78.1	N/A	N/A	1.075	18,071.17	535.71	3.1		13,206.85	462.57	3.6
81	2016 est.	20,391,198	20,391	5,411,441	14,979,757	14,980	N/A	N/A					105.9	28.1	77.8	N/A	N/A	1.097	18,588.15	516.98	2.9	15.8	13,655.20	448.35	3.4	20.2
82	2017 est.	21,325,493	21,325	5,612,836	15,712,657	15,713							104.7	27.6	77.1	N/A	N/A	1.120	19,040.62	452.47	2.4		14,029.16	373.96	2.7
83
84		2010 and following from Budget 2013 Historical Tables, Table 7-1
85		N/A: Not available.
86												Change										Percent change in gross debt by presidential term				Percent change in debt owned by the public by presidential term
87	TQ	643,561		148,052	495,509		96,702	398,807					35.4	8.1	27.2	5.3	21.9				FDR	220.0			FDR	243.4
88																					FDR-Truman	-10.0			FDR-Truman	-14.7
89												Real change in public excl Fed Reserve % by pres term									Truman	-6.8			Truman	-10.0
90											FDR	235.0									Ike I	2.6			Ike I	0.9
91											FDR-Truman	-16.4									Ike II	-2.3			Ike II	-2.3
92											Truman	-10.7									JFK-Johnson	4.1			JFK-Johnson	3.7
93											Ike I	0.8									Johnson	3.9			Johnson	0.4
94											Ike II	-2.8									Nixon	-1.5			Nixon	-7.2
95											JFK-LBJ	1.0									Nixon-Ford	6.1			Nixon-Ford	8.9
96											Johnson	-4.8									Carter	-0.1			Carter	3.1
97											Nixon I	-11.9									Reagan I	36.3			Reagan I	45.4
98											Nixon-Ford	12.1									Reagan II	46.0			Reagan II	37.9
99											Carter	6.8									GHW Bush	29.7			GHW Bush	23.3
100											Reagan I	54.4									Clinton I	15.8			Clinton I	11.3