Companion files · The Private Markets Career Guides
A Practitioner's Guide to Corporate Governance: Running the Board and Its Committees, Minutes and Resolutions, the Proxy Statement, the Annual Meeting and the Governance Calendar.
These are the companion files of the book. Five workbooks follow Halverstone Corporation, the fictional listed company of the case, across two calendar years: the governance calendar and the office’s hours, board books and minutes, the count of the 2025 vote, the cost of the annual meeting, and the office’s choice of how to staff itself. Each keeps the case’s figures beside an empty cell for yours, and opens on a Read me tab that records when the inputs were last replaced, by whom and from which source. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the five 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.
Chapter 2
The calendar grid by body and by month, the office’s hours by month against capacity, and the office hours per meeting held. Tabs: Read me, Calendar, Hours, Capacity, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 119 KBChapters 3 and 5
The posting date of every regular board book and the date every draft went to the chair, against the office’s own rules, and the hours saved by short-form minutes. Tabs: Read me, Books, Minutes, Method, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 220 KBChapters 11 and 12
The record date, quorum and the full ballot check, then every matter read under the standard chosen for it and under every standard. Tabs: Read me, Record, Ballot, Standards, Outputs. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 322 KBChapter 9
Notice and access against a full set on one base of accounts, with the intermediary line and the fixed lines, and the difference. Tabs: Read me, Accounts, Unit costs, Fixed lines, Comparison. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 418 KBChapter 16
No change, hire, outsource or equip over 2026 to 2028: the three-year cost and the hours above capacity each leaves, all projections. Tabs: Read me, Baseline, Option 1, hire, Option 2, outsource, Option 3, equip, Comparison. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 522 KBAppendix B
The first 90 days in the job; Preparing a board meeting, from 30 days before to 10 days after; Minutes and resolutions; The annual governance calendar; Questionnaires and independence; The proxy statement and the annual meeting, working backward; Publishing the vote results; Subsidiaries and the registers.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| Office hours per meeting held | 1,707 / 31 = 55.1 in 2025: the hours of meeting work over the meetings of the calendar grid |
| Share represented | 40,026,000 / 47,650,000 = 84.0 percent at the 2025 annual meeting: shares represented over shares outstanding at the record date |
| One count, two readings | 21,560,000 / (21,560,000 + 14,602,000) = 59.6 percent of votes cast for the 2025 say-on-pay, and 21,560,000 / 47,650,000 = 45.2 percent of shares outstanding |
The files are provided as they are, without warranty of any kind. The model is illustrative: Halverstone Corporation, the city of Lyndover, the directors, officers and staff, the law firm, the auditor, the acquired company and its sponsor are fictional; the counts, hours, rates, costs and votes are the book’s assumptions, not market terms or the practice of any real company. Nothing here predicts how a vote will turn out. Which standard governs a matter at a real company is a question for its counsel and its own charter and bylaws.