ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Dashboard
2
Girls Global Academy
3
July 2023 through January 2024
4
5
Key Performance Indicators
6
10
Days of CashGross Margin
Grants Invoiced
FAR
11
(At Year End)MarginInvoiced(At Year End)
12
48-5%23%83
13
Target > 45 daysTarget > -5.0%Target > 33%Target > 75
14
15
Cash Forecast
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Financial Snapshot
Year-To-Date Financials
Annual Forecast
36
ActualBudgetVarianceForecastBudgetVarianceRemaining
37
Revenue
38
Per-Pupil Funding Revenue
3,402,369 3,478,580 (76,211) 5,855,850 5,903,073 (47,222) 2,453,481
39
Other Local Revenue
263,735 3,453 260,281 304,939 6,721 298,218 41,205
40
Federal Revenue
125,672 178,167 (52,495) 447,195 417,254 29,941 321,522
41
Private Grants and Donations
29,823 373,239 (343,417) 73,089 404,070 (330,981) 43,266
42
Earned Fees
15,215 72,612 (57,396) 18,804 124,611 (105,807) 3,589
43
Donated Revenue
- - - - - - -
44
Total Revenue
3,836,814 4,106,052 (269,238) 6,699,877 6,855,728 (155,851) 2,863,063
45
46
Expenses
47
Salaries
1,665,950 1,861,947 195,997 3,259,819 3,445,167 185,348 1,593,870
48
Benefits and Taxes
278,570 267,325 (11,245) 494,214 481,374 (12,839) 215,644
49
Contracted Staff
44,078 11,111 (32,966) 92,000 20,000 (72,000) 47,923
50
Staff-Related Costs
9,210 20,618 11,408 35,124 35,124 0 25,915
51
Rent 430,391 323,350 (107,041) 960,049 1,075,047 114,998 529,658
52
Occupancy Service
220,750 189,297 (31,453) 383,137 324,509 (58,628) 162,387
53
Direct Student Expense
300,189 317,307 17,119 671,132 540,897 (130,234) 370,943
54
Office & Business Expense
512,482 415,946 (96,537) 765,124 720,586 (44,538) 252,641
55
Donated Expense
- - - - - - -
56
Contingency
- 21,466 21,466 30,000 36,799 6,799 30,000
57
Interest
17,674 12,333 (5,341) 33,155 24,000 (9,155) 15,481
58
Depreciation and Amortization
162,438 146,155 (16,283) 279,249 250,552 (28,697) 116,811
59
Total Ordinary Expenses
3,641,730 3,586,856 (54,874) 7,003,003 6,954,056 (48,947) 3,361,273
60
Net Ordinary Income
195,084 519,196 (324,112) (303,126) (98,328) (204,798) (498,210)
61
62
Extraordinary Expenses
63
Unknown Expense
64
Total Extraordinary Expenses
- - - - - - -
65
Total Expenses
3,641,730 3,586,856 (54,874) 7,003,003 6,954,056 (48,947) 3,361,273
66
Net Income
195,084 519,196 (324,112) (303,126) (98,328) (204,798) (498,210)
67
Cash Flow Adjustments
1,381,541 1,133,808 247,733 310,557 275,820 34,737 (1,070,984)
68
Change in Cash
1,576,625 1,653,004 (76,379) 7,431 177,492 (170,061) (1,569,193)
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
101
102
103