Dallas Strong Towns Finance Decoder Worksheet - US 1.0.1

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1					❗ Find resources and instructions for how to use the Decoder here.
2					https://dallascityhall.com/departments/budget/financialtransparency/Pages/annualreport.aspx
3					❗ Select how the values are rounded in the report here (Some cities round to the nearest thousand, some to the nearest million).		thousands
4		ACFR Section	Report	Line item(s)	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024

5
6	Current Assets	MD&A	Net position	Current and Other Assets	2,526,766	2,317,712	2,338,070	2,382,583	2,362,322	2,327,131	2,327,992	2,419,093	2,581,895	2,901,746	3,204,172	3,412,001	3,840,468	4,202,024	4,914,195	5,766,480
7	Capital Assets	MD&A	Net position	Capital Assets	7,160,928	7,776,653	8,214,321	8,571,343	9,005,511	9,403,372	9,792,453	10,297,339	10,597,552	10,974,218	11,347,973	11,639,453	12,108,191	12,482,369	13,053,836	13,586,063
8	Total Assets				9,687,694	10,094,365	10,552,391	10,953,926	11,367,833	11,730,503	12,120,445	12,716,432	13,179,447	13,875,964	14,552,145	15,051,454	15,948,659	16,684,393	17,968,031	19,352,543
9	Deferred outflows	MD&A	Net position	Deferred outflows			44,403	48,527	56,915	47,209	788,902	3,247,351	2,335,372	1,422,873	1,912,968	1,089,462	1,583,309	974,718	2,247,516	1,561,561
10	Liabilities	MD&A	Net position	Total Liabilities	5,304,952	5,244,638	5,501,127	5,797,563	6,017,849	6,176,073	12,287,920	16,073,941	14,423,265	10,556,890	12,887,070	12,969,622	14,146,662	12,429,788	15,378,526	15,746,084
11	Deferred inflows	MD&A	Net position	Deferred inflows							20,432	34,855	1,619,240	3,717,505	2,819,306	1,949,562	1,219,526	2,252,027	1,100,654	817,877
12	Total liabilities				5,304,952	5,244,638	5,501,127	5,797,563	6,017,849	6,176,073	12,308,352	16,108,796	16,042,505	14,274,395	15,706,376	14,919,184	15,366,188	14,681,815	16,479,180	16,563,961
13	Net position				4,382,742	4,849,727	5,095,667	5,204,890	5,406,899	5,601,639	600,995	(145,013)	(527,686)	1,024,442	758,737	1,221,732	2,165,780	2,977,296	3,736,367	4,350,143
14	Total Revenues	MD&A	Changes in net position	Total revenues	2,091,519	2,414,347	2,221,651	2,181,433	2,284,584	2,345,269	2,496,184	2,650,703	2,802,821	2,989,172	3,108,059	3,181,977	3,440,643	3,660,182	4,129,864	4,603,998
15	Operating Grants & Conributions	MD&A	Changes in net position	Operating Grants & Contributions	79,204	104,839	118,369	116,683	82,726	76,634	82,975	81,903	79,989	79,163	78,039	233,854	269,411	228,428	256,178	353,269
16	Capital Grants & Contributions	MD&A	Changes in net position	Capital Grants & Contributions	31,181	372,550	66,021	35,557	93,012	102,304	80,847	68,409	86,908	87,159	107,819	70,352	111,859	95,922	123,201	187,569
17	Total Government Transfers				110,385	477,389	184,390	152,240	175,738	178,938	163,822	150,312	166,897	166,322	185,858	304,206	381,270	324,350	379,379	540,838
18	Interest Charges	MD&A	Changes in net position	Debt service / interest	93,412	90,822	105,350	84,824	74,193	75,133	63,404	80,890	70,676	70,693	78,124	76,948	58,792	69,798	72,606	107,728
19	Net Book TCA	MD&A	Capital assets (net of depreciation/amortization)	Total	7,160,928	7,776,653	8,214,321	8,571,343	9,005,511	9,403,372	9,792,453	10,297,339	10,597,552	10,974,218	11,347,973	11,639,453	12,107,811	12,482,369	13,053,836	13,586,063
20	Govt assets not depreciated	Notes to the Financial Statements	Governmental activities	Total capital assets not being depreciated	759,197	777,537	872,737	889,069	868,340	815,196	789,232	884,770	874,245	915,072	991,087	1,107,781	1,129,237	1,216,163	1,152,084	1,194,872
21	Govt assets being depreciated	Notes to the Financial Statements	Governmental activities	Total capital assets being depreciated	3,401,441	3,944,755	4,028,931	4,176,474	4,407,177	4,741,073	4,959,304	5,092,230	5,304,074	5,541,296	5,774,862	5,953,722	6,304,349	6,524,167	7,031,312	7,328,154
22	Govt other assets	Notes to the Financial Statements	Governmental activities
23	Bus assets not depreciated	Notes to the Financial Statements	Business-type activites	Total capital assets not being depreciated	687,659	607,680	862,056	1,085,552	866,631	858,263	964,968	1,354,408	1,480,220	1,427,174	1,581,872	1,529,972	1,570,177	1,750,709	1,941,253	2,166,000
24	Bus assets being depreciated	Notes to the Financial Statements	Business-type activites	Total capital assets being depreciated	5,601,612	5,959,728	6,164,418	6,309,515	6,909,840	7,272,062	7,622,558	7,779,465	8,023,940	8,462,021	8,665,300	9,019,618	9,286,189	9,502,162	9,989,154	10,372,150
25	Bus other assets	Notes to the Financial Statements	Business-type activites
26	Total Cost of TCA		Capital Assets		10,449,909	11,289,700	11,928,142	12,460,610	13,051,988	13,686,594	14,336,062	15,110,873	15,682,479	16,345,563	17,013,121	17,611,093	18,289,952	18,993,201	20,113,803	21,061,176
27
28	Sustainability Indicators
29	Net Financial Position				-2,778,186.00	-2,926,926.00	-3,163,057.00	-3,414,980.00	-3,655,527.00	-3,848,942.00	-9,980,360.00	-13,689,703.00	-13,460,610.00	-11,372,649.00	-12,502,204.00	-11,507,183.00	-11,525,720.00	-10,479,791.00	-11,564,985.00	-10,797,481.00
30	Financial Assets-to-Liabilities				0.4763032729	0.4419203003	0.4250165466	0.4109628477	0.3925525549	0.3767978455	0.1891392121	0.1501721792	0.160940888	0.2032832915	0.2040045393	0.228698902	0.2499297809	0.2862060311	0.2982062821	0.3481341208
31	Assets-to-Liabilities				1.826160538	1.924701953	1.926295103	1.897772047	1.898477014	1.906990413	1.048828227	0.9909978995	0.9671070073	1.071767805	1.048307579	1.081890001	1.140944521	1.202788007	1.22673258	1.262626977
32	Net Debt-to-Total Revenues				1.32831019	1.212305439	1.423741623	1.565475538	1.600084304	1.641151612	3.998246924	5.164555591	4.802522173	3.804615124	4.022511799	3.61636272	3.349873846	2.863188497	2.800330713	2.345240159
33
34	Flexibility Indicators
35	Interest-to-Total Revenues				0.04466227656	0.03761762497	0.04741968923	0.03888453141	0.03247549663	0.03203598393	0.02540037113	0.03051643281	0.02521602343	0.02364969296	0.02513594497	0.02418245009	0.0170875037	0.01906954354	0.01758072421	0.02339879383
36	Net Book-to-Cost of TCA				0.6852622353	0.6888272496	0.688650504	0.6878750719	0.6899723628	0.6870498241	0.683064359	0.6814522894	0.6757574488	0.6713881926	0.6670130072	0.660915992	0.6619924973	0.657201964	0.6489988989	0.6450761819
37
38	Vulnerability Indicator
39	Govt Transfers-to-Total Revenues				0.05277743114	0.1977300695	0.08299683434	0.06978898733	0.07692341363	0.07629743113	0.06562897607	0.05670646617	0.05954607875	0.05564149537	0.05979873612	0.09560282805	0.1108135892	0.088615812	0.09186234704	0.1174713803
40
41
42	[HIDDEN] Net Financial Position rounded to $1000 for chart			thousands	-2,778,186.0	-2,926,926.0	-3,163,057.0	-3,414,980.0	-3,655,527.0	-3,848,942.0	-9,980,360.0	-13,689,703.0	-13,460,610.0	-11,372,649.0	-12,502,204.0	-11,507,183.0	-11,525,720.0	-10,479,791.0	-11,564,985.0	-10,797,481.0
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100