When the Money Runs Out: Cash Flow & Liquidity at a Housing Nonprofit
The Liquidity Trap
Harborview Community Development Corporation (HCDC) is a fictional Baltimore nonprofit providing affordable housing counseling, tenant advocacy, and small-scale home repair assistance in East Baltimore neighborhoods. Like most CDCs, HCDC does important work — and is almost always one bad month away from a cash crisis.
HCDC receives funding from five sources: a HUD Community Development Block GrantFederal pass-through grants distributed by Baltimore City; paid quarterly, a Maryland DHCD operating grant, two private foundation grants (paid annually), individual donations concentrated in December, and program fee revenue from workshops. These revenue streams arrive at different times, often with large gaps between them.
Meanwhile, expenses — salaries, rent, utilities, insurance — flow out steadily every month. This mismatch between lumpy revenue and steady expenses creates the core challenge you'll analyze in this exercise.
A nonprofit can be financially healthy on paper (surplus at year-end, adequate reserves) while still experiencing months where it cannot make payroll. This exercise shows you why annual financial statements tell only part of the story — and why cash flow management is a board-level governance responsibility.
Your Dataset: 24 Months of HCDC Financials
The starter spreadsheet contains 24 months of data (Oct 2023 – Sep 2025). Each row is one month with:
- Column A: Month label
- Column B: Total Revenue Received (actual cash in)
- Column C: Total Operating Expenses (actual cash out)
- Columns D, E, F: You will build these
The organization begins October 2023 with a $48,500 opening cash balance — about 6 weeks of reserves.
Monthly Net Cash Flow
The most fundamental question in cash management: did more money come in than go out this month? Net cash flowRevenue received minus expenses paid in a given period. Positive = surplus; negative = deficit. answers that question for each period.
Worked Example — October 2023 (Row 4)
What to Do in Excel
=B4-C4=B4-C4. No absolute references needed. Copy straight down.=B4-C4Cell D4 should show . Copy through D27.
Enter the dollar values from these cells (no $ sign needed).
Cumulative Cash Position
Knowing whether a single month was positive or negative is useful — but what really matters for organizational survival is the cumulative cash positionThe running total of cash available, starting from the opening balance. If this hits zero, the organization cannot pay bills.: how much cash does HCDC actually have on hand as each month ends?
Opening Balance + Running Sum
The first month's ending balance is the opening balance plus that month's net cash flow. Every subsequent month's balance is the prior month's ending balance plus the current month's net cash flow.
- E4 (first month): Opening Balance + Net Cash Flow = $48,500 + D4
- E5 onward: Prior month ending balance + current net cash flow = E4 + D5
What to Do in Excel
=48500+D4=E4+D5E4: =48500+D4E5: =E4+D5 (copy through E27)E4 should show . Look for months where E goes negative — those are cash crisis points.
Enter the ending cash balance from these cells.
Months of Liquidity
The cash position tells you the dollar balance. But finance officers think in terms of time: how many months could HCDC continue operating if revenue stopped entirely? This is the months of liquidityCash on hand divided by average monthly expenses. Industry standard: nonprofits should maintain 3+ months; 6+ months is considered healthy. ratio — the gold standard of nonprofit financial health assessment.
Worked Example — October 2023 (Row 4)
The nonprofit sector benchmark: 3 months = minimum safe threshold. 6 months = healthy. Watch how this ratio moves across HCDC's two fiscal years.
What to Do in Excel
=E4/AVERAGE($C$4:$C$27)$ signs in $C$4:$C$27 prevent the range from shifting when you copy the formula down. Without them, F5 would calculate =E5/AVERAGE(C5:C28) — wrong. With them, every row divides by the same average expense figure.=E4/AVERAGE($C$4:$C$27)F4 should show approximately months. Copy through F27. Look for months where this drops below 1.0 — those are acute danger zones for the organization.
Enter the months-of-liquidity values (1 decimal is fine).
Scenario Analysis: What Could Go Wrong?
Now that your model is built, use it to stress-test HCDC's financial position. Real nonprofit finance work isn't just recording what happened — it's anticipating what might happen and ensuring the organization can survive it.
The scenario analysis below is browser-based. You'll also replicate the first scenario in Excel as your deliverable.
Three Scenarios to Test
- Scenario A — Grant Delay: HCDC's largest grant ($85,000 from the Maryland DHCD) is delayed by 3 months due to a state budget freeze. How does this shift the cash position profile?
- Scenario B — Expense Spike: HCDC's building HVAC fails in February. Emergency repairs add $22,000 in unexpected costs. What happens to months of liquidity?
- Scenario C — Your Choice: Design and model your own stress scenario. Write a 2-sentence justification for why this scenario is realistic for a Baltimore CDC.
Interactive Scenario Explorer
What to Do in Excel — Scenario A
Answer based on your Scenario A sheet.
Tip: Use =MIN(F4:F27) in your Scenario A sheet.
Discussion Questions
Click each question to reveal a model response framework. These questions are designed for in-class discussion or written assignment.
Model Response Framework
Strong answers will identify the specific months (likely late summer in each fiscal year — August or September) when the cumulative drain from steady expenses has depleted reserves before the next major grant cycle arrives. Look for the pattern: large infusions in Oct/Nov, a March or April mid-year grant, and then a long dry stretch.
The Structural Insight
Grant-dependent nonprofits face a structural mismatch that is entirely predictable: their revenue arrives in discrete events (grant awards, foundation disbursements, year-end campaigns) while their expenses are continuous. The risk isn't that the organization will be insolvent over the year — it's that it will be illiquid in specific windows, even if the annual budget is balanced.
Model Response Framework
Answers should engage with real nonprofit financial tools, not just generic advice. Two strong directions:
- Operating reserve policy: The board should adopt a formal policy requiring 3–6 months of operating expenses in an unrestricted reserve fund, replenished annually. This creates a buffer that can absorb exactly this kind of delay.
- Line of credit: Many nonprofits establish a bank line of credit specifically for cash flow bridging — not for deficit spending, but to cover the gap between when a grant is awarded and when it is disbursed. The line is drawn down in lean months and repaid when funds arrive.
Governance Connection
This is a board-level decision, not a staff decision. The board's finance committee should be reviewing a cash flow forecast (like the one you built) at least quarterly — not just the income statement and balance sheet.
The "Technically True, Practically Misleading" Problem
The ED is not wrong — year-end surpluses are real and meaningful. But they are also a lagging indicator. A nonprofit can post a surplus in September and have been unable to pay suppliers in July. The annual financial statements smooth over intra-year volatility.
What the Board Needs
- Monthly cash flow actuals vs. projections (the model you built)
- Months-of-liquidity trend over the year, not just at year-end
- A 12-month forward-looking cash flow projection updated quarterly
- Clear board-adopted thresholds: what triggers an emergency finance committee meeting?
Financial health is a function of both solvency (do assets exceed liabilities?) and liquidity (can we pay our bills right now?). Both matter.
Answer Key
Use this to spot-check individual values after you have attempted each task. Click to reveal.