Companion files · The Private Markets Career Guides

The Corporate Secretary

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 five workbooks, the toolkit and the read-me, in one archive135 KB

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.

The files

Three numbers to reproduce first

Office hours per meeting held1,707 / 31 = 55.1 in 2025: the hours of meeting work over the meetings of the calendar grid
Share represented40,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 readings21,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.