Companion files · The Private Markets Career Guides
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 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.
Chapters 1, 2, 3, 9 and 16
Revenue by source and each source’s share, restricted pools, releases from restriction, the roll-forward of both classes of net assets, and donor retention. Sheets: Sources, Restricted Pools, Releases, Roll-Forward, Donors. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 123 KBChapters 5, 6, 7 and 11
Allocation keys, expenses by nature and by function, and the cost per student, per camper-week and per family. Sheets: Keys, Nature by Function, Unit Costs. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 224 KBChapters 8, 10 and 16
The organization’s own indirect rate, a funder’s cap and the gap unrestricted money must cover, and the break-even rate of an offer. Sheets: Rate, Cap, Break-Even. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 316 KBChapters 4 and 12
The budget the board voted, the actual figures line by line, each variance with its direction and a comment, and the operating result beside the change in cash. Sheets: Budget, Actual, Variance. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 416 KBChapters 10, 13 and 14
Month-end cash over two years, the line of credit drawn to a floor, days of county revenue, months of reserve, liquidity and the board’s target. Sheets: Month-End Cash, Line of Credit, Receivable, Reserve. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 522 KBChapter 16
The hole a large funder leaves, a larger government contract at the cap, a development director, and a shared services quote, all projections. Sheets: Option A, Option B, Shared Services. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 616 KBAppendix B
The first ninety days in the numbers; Accepting a grant or a contract; The monthly close and the finance committee report; The annual budget and the board’s vote; The reserve policy; Preparing the audit and the annual return; Gifts and acknowledgments; A continuity plan if a large funder leaves.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| 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.