Days Cash on Hand

Three-School Matrix / BELIEVE / FY2024-25 / Days Cash on Hand

BELIEVE Circle City High School · FY2024-25 · Annual Audited · Calculation level: School

Days of operations covered by unrestricted cash.

Formula: Unrestricted Cash / ((Total Expenses − Depreciation) / 365)

Meets Standard: ≥60 days MS · 30–59 AS · <30 DNMS

result

Published OEIresult

Status

EXACT MATCH

From Data To Decisions

Formula — MSCS Performance Framework 2025-26

Unrestricted Cash / ((Total Expenses − Depreciation) / 365)

Rating threshold: ≥ 45 days = Meets Standard (30–44 = Approaching)

Source inputs

Cash and cash equivalents

Normalized field: cash_gross

$1,121,221

26520A.pdf · Consolidated Statements of Financial Position · PDF page 7 (printed page 4) · Cash and cash equivalents — $1,121,221 at June 30, 2025

Confidence: High · OCR (scanned statement page) — analyst verified · Approved

View source Open file

Total expenses

Normalized field: total_expenses

$6,411,473

26520A.pdf · Consolidated Statements of Activities / Functional Expenses · PDF page 8 (printed page 5) · Total expenses — $6,411,473

Confidence: High · OCR (scanned statement page) — analyst verified · Approved

View source Open file

Depreciation

Normalized field: depreciation

$223,470

26520A.pdf · Consolidated Statements of Functional Expenses · PDF page 9 (printed page 6) · Depreciation — $223,470

Confidence: High · OCR (scanned statement page) — analyst verified · Approved

View source Open file

Calculation

Cash and cash equivalents (consolidated) = $1,121,221
Total expenses = $6,411,473
Less depreciation = −$223,470
OEIOEI — Office of Education InnovationThe City of Indianapolis Mayor's Office division that authorizes and oversees mayor-sponsored charter schools. OEI publishes the performance framework and the annual accountability reports this platform independently replicates. expense base = $6,188,003
Daily expense = $6,188,003 / 365 = $16,953.43
$1,121,221 / $16,953.43 = 66.14
Rounded = 66

OEI rating test

≥ 45 days = Meets Standard (30–44 = Approaching)

Insights rating:MS

Comparison

66 / MS

Salesforce / CAP66.14

Published OEI66 / MS

Variance0.00 vs published · 0.00 vs CAP

StatusEXACT MATCH

CAP note: Salesforce/CAP 'OEI FY25 Raw Data from SF', BELIEVE 'Audit 24-25' row: cash $1,121,221, expenses $6,411,473, depreciation $223,470 → 66.14 days. Exact agreement.

Reconciliation — Nsites vs OEI

66 days (as published) vs 61 days under the restricted-cash treatment

Difference: 5 days · $92,400 of trustee-held cash · Likely cause: Definition of unrestricted cash — restricted vs gross balance-sheet cash

Nsites calculation

Nsites calculation — restricted-cash treatment (JQ-002 recommendation)

Cash and cash equivalents (26520A.pdf p. 7): $1,121,221
Less trustee-held debt-service reserve (Note 6, p. 12): ($92,400)
Unrestricted cash used in the formula: $1,028,821
Total expenses (p. 8): $6,411,473
Less depreciation (p. 9): ($223,470)
OEI expense base: $6,188,003
Daily expense = $6,188,003 / 365: $16,953.43
$1,028,821 / $16,953.43: 60.69 days

Result

61 days (60.69)

MS — Meets Standard

OEI published methodology

OEI / CAP calculation — gross cash treatment

Cash and cash equivalents (full balance-sheet line): $1,121,221
Total expenses: $6,411,473
Less depreciation: ($223,470)
OEI expense base: $6,188,003
Daily expense: $16,953.43
$1,121,221 / $16,953.43: 66.14 days

Result

66 days (66.14)

MS — Meets Standard

Bridge between the two results

Reconciling item	Effect	Why the two calculations differ
Trustee-held debt-service reserve	$92,400 → 5.45 days	The only reconciling item. OEIOEI — Office of Education InnovationThe City of Indianapolis Mayor's Office division that authorizes and oversees mayor-sponsored charter schools. OEI publishes the performance framework and the annual accountability reports this platform independently replicates. and CAPCAP — Charter Accountability Portal / Corrective Action data setThe intermediate financial data set maintained in Salesforce that OEI and its accountants use when producing published ratings. In this platform CAP values are a validation target for comparison only — they are never used as inputs to a Nsites calculation. include the reserve in cash; the Nsites restricted-cash reading excludes it. $92,400 / $16,953.43 = 5.45 days, bridging 60.69 to 66.14.

Conclusion: The platform currently publishes 66 days so the replication matches OEIOEI — Office of Education InnovationThe City of Indianapolis Mayor's Office division that authorizes and oversees mayor-sponsored charter schools. OEI publishes the performance framework and the annual accountability reports this platform independently replicates. exactly. The alternative restricted-cash treatment recommended in JQJQ — Judgment Queue itemThe identifier prefix (JQ-001, JQ-002, …) for each accounting-judgment or methodology exception listed on the Exceptions - Review Needed page.-002 would produce 61 days and re-open the difference. Either way the rating is Meets Standard. Resolution requires OEI/Donovan to confirm in writing whether trustee-held reserves count as unrestricted cash.

Sequencing proof

1. Source documents ingested and classified.
2. Raw values extracted with page/cell coordinates.
3. OEI mapping and accounting treatment applied.
4. Formula executed — targets not in engine memory.
5. Nsites result locked 18:15:09 UTC.
6. Salesforce/CAP and published CQ2 revealed 18:15:42 UTC.

View full audit log →