Bloomington-Normal, IL_ Strong Towns Finance Decoder Worksheet - US 1.0.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1					❗ Find resources and instructions for how to use the Decoder here.
2					❗ Here's a good place for you to put a link to the ACFR Report.
3					❗ Select how the values are rounded in the report here (Some cities round to the nearest thousand, some to the nearest million).		millions
4		ACFR Section	Report	Line item(s)	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025

5	Current Assets	MD&A	Net position	Current and Other Assets	59	75	96	99	112	124	119	127	136	138	146	156	120	161	196	185	179
6	Capital Assets	MD&A	Net position	Capital Assets	389	384	368	365	379	373	365	362	356	358	353	346	148	151	166	184	195
7	Total Assets				448	459	464	464	491	497	484	488	493	496	499	502	268	312	362	370	374
8	Deferred outflows	MD&A	Net position	Deferred outflows	2	2	2	2	0	0	1	28	28	13	28	31	18	13	47	40	36
9	Liabilities	MD&A	Net position	Total Liabilities	131	118	145	156	147	151	143	282	277	253	282	283	188	199	236	261	258
10	Deferred inflows	MD&A	Net position	Deferred inflows	23	27	23	26	23	23	24	24	30	41	31	38	68	59	39	40	41
11	Total liabilities				154	145	168	182	170	174	167	306	308	294	313	320	256	258	276	301	298
12	Net position				296	316	299	284	321	323	317	210	213	215	214	213	29	67	134	108	111
13	Total Revenues	MD&A	Changes in net position	Total revenues	132	127	132	134	142	138	138	151	155	158	161	162	127	145	167	174	172
14	Operating Grants & Conributions	MD&A	Changes in net position	Operating Grants & Contributions	5	6	5	4	4	4	5	4	4	4	4	5	11	7	11	10	10
15	Capital Grants & Contributions	MD&A	Changes in net position	Capital Grants & Contributions	2	12	3	4	5	3	2	1	1	2	-	0	0	1	3	7	2
16	Total Government Transfers				6	18	8	8	9	7	6	6	5	6	4	5	12	9	14	17	11
17	Interest Charges	MD&A	Changes in net position	Debt service / interest	4	3	3	1	3	3	3	2	2	2	2	2	2	1	2	2	2
18	Net Book TCA	MD&A	Capital assets (net of depreciation/amortization)	Total	380	375	368	365	379	373	365	362	356	358	353	346	342	341	364	386	421
19	Govt assets not depreciated	Notes to the Financial Statements	Governmental activities	Total capital assets not being depreciated	44	45	28	25	27	23	23	25	27	33	33	30	30	32	53	69	65
20	Govt assets being depreciated	Notes to the Financial Statements	Governmental activities	Total capital assets being depreciated	322	328	337	338	358	363	367	369	372	376	380	387	391	394	398	407	427
21	Govt other assets	Notes to the Financial Statements	Governmental activities
22	Bus assets not depreciated	Notes to the Financial Statements	Business-type activites	Total capital assets not being depreciated	21	19	15	17	22	12	14	13	14	15	18	16	16	22	29	27	53
23	Bus assets being depreciated	Notes to the Financial Statements	Business-type activites	Total capital assets being depreciated	224	229	248	250	250	265	266	273	275	279	281	286	291	293	295	304	307
24	Bus other assets	Notes to the Financial Statements	Business-type activites
25	Total Cost of TCA		Capital Assets		612	621	628	629	657	663	669	680	689	703	712	719	728	740	776	807	852
26
27	Sustainability Indicators
28	Net Financial Position				-95.50	-70.50	-71.50	-83.40	-58.20	-50.10	-48.20	-178.90	-171.20	-155.40	-167.10	-164.10	-136.40	-96.60	-79.60	-116.00	-118.90
29	Financial Assets-to-Liabilities				0.3810758263	0.5147969718	0.5741512805	0.5417582418	0.6578483245	0.7120689655	0.711204314	0.4145942408	0.4432520325	0.4710687543	0.4656220019	0.4875078076	0.4678111588	0.625	0.7110707804	0.614873838	0.6014079785
30	Assets-to-Liabilities				2.918340894	3.174122505	2.778439547	2.561538462	2.886537331	2.854022989	2.901138406	1.68815445	1.69203252	1.731449966	1.684042213	1.665209244	1.114319157	1.261645963	1.486751361	1.358897742	1.373114314
31	Net Debt-to-Total Revenues				0.7218442933	0.5555555556	0.5408472012	0.624251497	0.4101479915	0.3627805938	0.3497822932	1.182419035	1.103803997	0.9860406091	1.036600496	1.015470297	1.073170732	0.6657477602	0.4766467066	0.6678180771	0.6932944606
32
33	Flexibility Indicators
34	Interest-to-Total Revenues				0.02872260015	0.024428684	0.02269288956	0.005988023952	0.02043692741	0.02172338885	0.02177068215	0.01321877065	0.01289490651	0.01205583756	0.0111662531	0.009900990099	0.01180173092	0.008270158511	0.01437125749	0.01093839954	0.01183673469
35	Net Book-to-Cost of TCA				0.6208530806	0.6035426731	0.585762064	0.5804862546	0.5763614238	0.5620757279	0.5455904335	0.5319305474	0.5173565723	0.5083902162	0.4957168937	0.4810179391	0.4691663233	0.460197324	0.4686170898	0.4788104089	0.4934229826
36
37	Vulnerability Indicator
38	Govt Transfers-to-Total Revenues				0.04535147392	0.1402679275	0.06202723147	0.05988023952	0.06272022551	0.04851556843	0.04499274311	0.0363516193	0.03288201161	0.03934010152	0.02419354839	0.03032178218	0.09047993706	0.05926946933	0.08502994012	0.09556706966	0.06647230321
39
40
41	[HIDDEN] Net Financial Position rounded to $1000 for chart			millions	-95,500.0	-70,500.0	-71,500.0	-83,400.0	-58,200.0	-50,100.0	-48,200.0	-178,900.0	-171,200.0	-155,400.0	-167,100.0	-164,100.0	-136,400.0	-96,600.0	-79,600.0	-116,000.0
42
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