DEMONSTRATION - ILLUSTRATIVE DATA - BI Consulting Services

Carol Woods · Article 64A Quarterly Filing Board

Prepared for Marianne, October 2026 · The Chapel Hill Residential Retirement Center, Inc., d/b/a Carol Woods · 750 Weaver Dairy Road, Chapel Hill, NC

Design concept: the committee floor

Carol Woods is governed by more than 95 resident-run committees, and three residents sit on the board. So this is not built as a CFO console. Every statutory ratio carries one plain English line underneath saying what it means, so a resident on the Finance or Health Services committee can read the quarterly filing pack without a finance background, and ask a better question because of it.

Scope
Living units
Quarter

The eight statutory ratios, in plain English

G.S. 58-64A-150(a)(39) requires all eight for the past three fiscal years and the next three forecast years, for the provider alone and for the obligated group, with a narrative for any material change. This board carries them quarterly so the narrative is never written from memory.

G.S. 58-64A-150(a)(39)
1

Liquidity and coverage, eight quarters

Days cash on hand against debt service coverage. Quarters after the one selected are drawn faint, because they are not yet in a filed pack.

G.S. 58-64A-205
Days cash on hand (left) Debt service coverage (right) Not yet filed
2

Occupancy by living unit type

The 12-month daily average occupancy rate by living unit type, which is the exact form the statute asks for. The dark tick on each bar is the plan rate the board set for FY2026.

G.S. 58-64A-205(2)
3

The committee floor: 120 acres, 464 living units, and who advises each one

A schematic of the Carol Woods campus using the community's own building names. Each node is sized by living units and tinted by its 12-month daily average occupancy. Underneath each one is the resident committee that advises on it, because at Carol Woods the occupancy number and the people who discuss it are in the same room.

Signature view
96 percent and above 93 to 96 90 to 93 Below 90 Outside the selected unit group
4

What has to be in the pack

The four items G.S. 58-64A-205 requires within 45 days of each fiscal quarter end, plus the cadences that sit around them.

Article 64A cadences
    5

    Ask the data

    A plain question, answered against the same numbers the panels above are drawn from. Written so a committee member gets an answer, not a query builder.

    Natural language
    >
    This panel runs on your own server. The question, the numbers and the answer never leave Carol Woods infrastructure.
    6

    Three things that should not be assembled by hand again

    Each of these replaces a specific recurring assembly task. Hours shown are illustrative, based on what comparable single-campus continuum finance and compliance teams report.

    Automation
    Quarterly, day 1 after close

    The 45-day pack, assembled on close

    On the morning after each fiscal quarter end, the unaudited statements, the eight ratios for provider and obligated group, and occupancy by living unit type are pulled, reconciled and written into the NCDOI pack format, with the material-change narrative pre-drafted from the quarter's own movements.

    Replaces: the spreadsheet rebuild and the cross-checking of ratio definitions against Appendix F, four times a year, under a deadline.
    about 22 hours per quarter
    Monthly, and on any change

    Board, officer and document change watch

    The statute requires notice of any change to the board, the president, the CEO, the CFO or the organizational documents. A watch on the board roster, the senior officer list and the bylaws repository raises the notice itself, pre-filled, the week the change happens rather than the week the pack is due.

    Replaces: remembering. With three resident directors rotating through the Residents Association presidency, this is the item most likely to be noticed late.
    about 5 hours per month
    Twice a year, before the meeting

    The resident meeting brief

    Before each semiannual in-person resident meeting with an independent board member, a short brief is generated: the quarter's ratios in the plain English form shown above, occupancy by unit type, what moved and why, and the three questions the numbers most invite.

    Replaces: preparing the same explanation from scratch for a room that is unusually well informed and entitled to be.
    about 14 hours per cycle
    7