Calculating Metrics Activity.xlsx

	B	C	D	F	H	J	L
1
2
3		Calculating Metrics Activity
4
5
6
7		Using the sample financials below, calculate the following: LUNA (Liquid Unrestricted Net Assets) Months of Cash Operating Results
8
9
10	Community Arts Organization, Inc. Statement of Financial Position As of June 30, 2019 and 2018
11
12		ASSETS		2019	2018
13		Current Assets
14			Cash	$ 257,590	$ 286,052
15			Accounts Receivable	82,482	67,697
16			Prepaid Expenses	21,200	17,259
17		Total Current Assets		361,272	371,008
18
19		Non-Current Assets
20			Property and Equipment, Net	1,506,326	1,545,689
21
22		TOTAL ASSETS		$ 1,867,598	$ 1,916,697
23
24		LIABILITIES AND NET ASSETS
25
26		LIABILITIES
27		Current Liabilities
28			Accounts Payable	$ 104,434	$ 101,369
29			Current Portion of Mortgage Payable	36,442	31,573
30			Deferred Revenue	917	1,084
31		Total Current Liabilities		141,793	134,026
32
33		Non-Current Liabilities
34			Long-Term Mortgage Payable	1,028,713	1,065,155
35
36		TOTAL LIABILITIES		$ 1,170,506	$ 1,199,181
37
38		NET ASSETS
39			Net Assets without Donor Restriction	492,947	576,734
40			Net Assets with Donor Restriction	204,145	140,782
41
42		TOTAL NET ASSETS		$ 697,092	$ 717,516
43
44		TOTAL LIABILITIES AND NET ASSETS		$ 1,867,598	$ 1,916,697
45
46
47
48	Community Arts Organization, Inc. Statement of Activities For The Year Ended June 30, 2019 With Comparative Totals for 2018
49
50				2019			2018
51				Without Donor Restriction	With Donor Restriction	Total	Total
52
53		REVENUES
54
55		Government Grants & Contracts		$ 978,042	$ 77,162	$ 1,055,204	$ 1,108,731
56		Foundations and Corporations		389,319	272,500	661,819	569,379
57		Individuals		98,389	2,048	100,437	43,885
58		Fundraising Events (Net of Expenses)		80,978	3,868	84,846	100,061
59		Interest		220	-	220	34
60		Miscellaneous Earned Revenue		32,473	-	32,473	10,100
61		In-Kind		21,785	-	21,785	37,366
62		Net Assets Released from Restrictions		292,215	(292,215)	-	-
63
64		TOTAL REVENUES AND PUBLIC SUPPORT		$ 1,893,421	$ 63,363	$ 1,956,784	$ 1,869,556
65
66		EXPENSES
67
68		Program Services		$ 1,419,559	$ -	$ 1,419,559	$ 1,396,897
69		Management & General		339,190		339,190	221,264
70		Development		218,459		218,459	162,946
71
72		TOTAL EXPENSES		$ 1,977,208	$ -	$ 1,977,208	$ 1,781,107
73
74		CHANGE IN NET ASSETS		$ (83,787)	$ 63,363	$ (20,424)	$ 88,449
75
76		NET ASSETS AT BEGINNING OF YEAR		576,734	140,782	717,516	629,067
77
78		NET ASSETS AT END OF YEAR		$ 492,947	$ 204,145	$ 697,092	$ 717,516
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100