# The Nonprofit Executive Director: companion files

Julian R. Sterling

## What is here

- NPED_1_Revenue_and_Restrictions.xlsx (Chapters 1, 2, 3, 9 and 16; Revenue and Restrictions workbook of Appendix A): sheets Sources, Restricted Pools, Releases, Roll-Forward, Donors, then Checks. Revenue by source ($1,219,863 then $1,211,476), the Cardwick Family Foundation's share (32.8 percent then 33.0 percent), the restricted pools and their releases ($522,810 then $472,555), the roll-forward of both classes of net assets, and donor retention (45.5 percent in FY2026).
- NPED_2_Functional_Expenses.xlsx (Chapters 5, 6, 7 and 11; Functional Expenses workbook): sheets Keys, Nature by Function, Unit Costs, then Checks. Allocation keys that must add to 100 percent, the grid of expenses by nature and by function (program share 66.3 percent in FY2026), and the cost per student, per camper-week and per family, direct and full.
- NPED_3_Indirect_Rate.xlsx (Chapters 8, 10 and 16; Indirect Rate workbook): sheets Rate, Cap, Break-Even, then Checks. The organization's own indirect rate (26.3 then 27.0 percent), the county's cap of 10 percent and the gap it leaves ($31,324 in FY2026), and the break-even rate of an offer (12.45 percent for option A, a projection).
- NPED_4_Budget_and_Variance.xlsx (Chapters 4 and 12; Budget and Variance workbook): sheets Budget, Actual, Variance, then Checks. The FY2026 budget the board voted, the actual figures line by line, each variance with its direction and a comment column, and the operating result (-$5,000 budgeted, $36,585 actual) beside the change in cash.
- NPED_5_Cash_and_Reserves.xlsx (Chapters 10, 13 and 14; Cash and Reserves workbook): sheets Month-End Cash, Line of Credit, Receivable, Reserve, then Checks. Month-end cash over 24 months, the line of credit drawn only to keep cash at the floor (one draw, $31,272 at the end of June 2025), days of county revenue (82.2 then 105.2), months of reserve (0.22 then 0.58), liquidity, and the board's reserve target ($301,861.50).
- NPED_6_Decisions.xlsx (Chapter 16; Decisions workbook): sheets Option A, Option B, Shared Services, then Checks. The hole the foundation leaves ($250,000 to find), option A, the county's larger contract at the cap (-$11,567.27 a year), option B, a development director ($100,380.00 a year), and the shared services quote ($37,900.00 a year below the cost of the work as carried now). All projections, never results.
- NPED_Nonprofit_Executive_Director_Checklists.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

Each sheet that Appendix A describes holds its own inputs in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every formula reads the Used column. Where the case figures sit in a grid (allocation keys, restricted pools, releases, receipts and payments month by month), they are typed in place: overwrite them with your own. Black type is a formula, green type a link to another sheet. Every cell that divides stays empty, never an error, until its divisor is entered. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how, and which chapter explains it.

Two inputs to try first:

1. In NPED_2_Functional_Expenses.xlsx, on Keys, change the executive director's share of management and general: the grid, the indirect rate and every cost per participant move at once.
2. In NPED_5_Cash_and_Reserves.xlsx, on Month-End Cash, delay one month's receipts: the line of credit draws to hold the floor, and repays when cash comes back.

To use a workbook on your own organization, fill the yellow column from your accounting system, the grant letters, the donor database, the payroll register, the bank statements and the contracts, in the order Appendix A gives, and keep a copy with the case column for comparison. Keep the fiscal year aligned: the case runs from 1 July to 30 June. Date every input. The workbooks are separate files with no link between them.

## A word of caution

Ostravelle Literacy Project, the city of Lanterbrook, its director, board and staff, the Cardwick Family Foundation, the camp funder, the county agency and Ellsworthy Savings Bank are fictional. Grants, gifts, salaries, wages, ceilings, rates, rents and costs are teaching assumptions, not market norms, targets or recommendations, and nothing here promises any grant, gift or result. How a restriction, a promise, a contract or a donated good is recorded, and what an annual return or an audit requires, are questions for your auditor and counsel. No real foundation, agency, bank, auditor, software or donation platform is described or recommended. Nothing here is legal, tax or accounting advice.
