Companion files · The Private Markets Career Guides

The Nonprofit Executive Director

How to Run a Small Nonprofit's Finances: Restricted Grants, Program Costs, Indirect Rates, Government Contracts, Reserves, Cash Flow and the Board.

These are the companion files of the book. Six workbooks follow Ostravelle Literacy Project, the fictional nonprofit of the case, across two fiscal years: revenue and restrictions, functional expenses, the indirect rate, the budget and its variances, cash and reserves, and the decisions that follow a large funder’s exit. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.

The six workbooks, the toolkit and the read-me, in one archive153 KB

The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

The indirect rate$215,891 / $800,265 = 27.0 percent of program expenses in FY2026, against a county cap of 10 percent
The gap the cap leaves$49,750 - $18,426 = $31,324 of indirect costs paid by unrestricted money
Months of reserve$58,474 / $100,620.50 = 0.58 months of expenses at 30 June 2026

The files are provided as they are, without warranty of any kind. The model is illustrative: Ostravelle Literacy Project, Lanterbrook, the director, the board, the staff, the foundation, the camp funder, the county agency, the bank and every party are fictional, and the grants, gifts, salaries, ceilings, rates, rents and costs are the book’s assumptions, not market terms or the practice of any real organization. Nothing here promises a grant, a gift or a result. How a restriction, a promise or a contract is recorded, and what an audit or an annual return requires, are questions for your auditor and counsel.