# The Corporate Secretary: companion files

Julian R. Sterling

## What is here

- CSEC_1_Governance_Calendar_and_Hours.xlsx (Chapter 2; Governance Calendar and Hours workbook of Appendix A): tabs Read me, Calendar, Hours, Capacity, Outputs, then Checks. The calendar grid by body and by month (25 meetings in 2024, 31 in 2025), the office's hours by month (5,031 then 6,312), the hours above a capacity of 5,400 (912 in 2025) and the office hours per meeting held (55.1 in 2025).
- CSEC_2_Board_Books_and_Minutes.xlsx (Chapters 3 and 5; Board Books and Minutes workbook): tabs Read me, Books, Minutes, Method, Outputs, then Checks. The posting date of every regular board book (7.8 days before the meeting on average in 2025), the date every draft went to the chair (18.5 days in 2024, 10.3 in 2025) and the hours the short-form minutes saved (60).
- CSEC_3_Vote_Count.xlsx (Chapters 11 and 12; Vote Count workbook): tabs Read me, Record, Ballot, Standards, Outputs, then Checks. The record date, quorum and share represented (84.0 percent in 2025), the full ballot check on every matter, a drop-down standard for each matter and every matter read under every standard, with the votes a two-thirds charter amendment would need (31,766,667 shares).
- CSEC_4_Annual_Meeting_Cost.xlsx (Chapter 9; Annual Meeting Cost workbook): tabs Read me, Accounts, Unit costs, Fixed lines, Comparison, then Checks. Notice and access against a full set on one base of accounts: $324,287 against $727,871 in 2025, a difference of $403,584.
- CSEC_5_Office_Options.xlsx (Chapter 16; Office Options workbook): tabs Read me, Baseline, Option 1, hire, Option 2, outsource, Option 3, equip, Comparison, then Checks. No change, hire, outsource the subsidiaries or equip the office, 2026 to 2028: $835,200, $704,250, $869,400 and $313,600 over three years, with the hours above capacity each leaves. All projections, never results.
- CSEC_Corporate_Secretary_Toolkit.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

Each workbook opens on a Read me tab that names the chapters it serves, lists its tabs in reading order and keeps the date the inputs were last replaced, who replaced them and the source of each block. The office's rule in the book: a workbook without a dated Read me is not used for a board paper. Single inputs show the case's figure in blue on a light blue background, an empty yellow cell for yours, and a Used column that takes your figure when you type one and the case figure otherwise; every formula reads the Used column. Where the case figures sit in a grid (months, meetings, matters, years), they are typed in place: overwrite them with your own. Black type is a formula, green type a link to another tab. Every cell that divides stays empty, never an error, until its divisor is entered. Rebuild the case first: the Checks tab of each workbook compares the live cells with the figures printed in the book, then runs the structural checks of Appendix A, and reads ALL CHECKS OK while the case figures are in place. Each of the 17 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 tab says how, and which chapter explains it.

Two inputs to try first:

1. In CSEC_3_Vote_Count.xlsx, on Standards, change the drop-down of the say-on-pay to "Majority of shares outstanding": the result on Outputs turns from PASSES to FAILS on the same count.
2. In CSEC_1_Governance_Calendar_and_Hours.xlsx, on Capacity, type your own capacity in the yellow cell: the hours above capacity on Outputs move at once, and they disappear when the capacity is cleared, because an empty capacity never reads as zero.

To use a workbook on your own company, fill the inputs from the board calendar, the minute book, the inspector of election's final report, the transfer agent's invoice and the office's time records, in the order Appendix A gives, and keep a copy with the case for comparison. Date every input on the Read me tab. The workbooks are separate files with no link between them.

## A word of caution

Halverstone Corporation, the city of Lyndover, the company's directors, officers and staff, Drummelow LLP, Kestleby LLP, Tarnhollow Fluid Systems and Quenford Capital are fictional. Counts, hours, rates, costs, share numbers, votes and terms are teaching assumptions, not market norms, targets or recommendations, and nothing here predicts how any vote will turn out. Which rule or which voting standard applies to a real company is a question for its counsel and its own charter and bylaws. No real exchange, transfer agent, intermediary, proxy solicitor, proxy advisory firm, software vendor, law firm or audit firm is described or recommended. Nothing here is legal, tax or accounting advice.
