Companion files · The Private Markets Career Guides

The Investor Relations Officer

How a Listed Company Talks to Wall Street: Earnings, Guidance, Regulation FD, Consensus, Targeting, Proxy Season, Activism and the Career in Investor Relations at a US Public Company.

These are the companion files of the book. One workbook rebuilds the Veltrane case: three earnings releases against consensus and the bridge from GAAP to adjusted EPS, three versions of guidance, the analysts’ ratings, the shareholder base and the targeting funnel, valuation against the peer group, the investor day targets, the IR budget, say-on-pay and the universal proxy count of an activist fight. A toolkit holds the checklists and templates of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive67 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

EarningsSecond quarter of 2026: adjusted EPS of $0.94 against a consensus of $0.88; GAAP EPS of $0.71, bridged by $0.23 a share of after-tax adjustments
ValuationA discount to the peer group of 24.9 percent on 30 September 2025 and 16.2 percent on 30 September 2026, with the share price from $44.00 to $55.00
Votes65.6 million shares voted; Quillmont nominee A at 52.4 percent against company nominee 11 at 49.6 percent: one seat won out of three sought

The files are provided as they are, without warranty of any kind. The models are illustrative: Veltrane Technologies, Quillmont Partners and the other names are fictional, the models are simplified, and the figures are the book’s assumptions, not prices, recommendations or market benchmarks. Nothing here is investment, legal or tax advice.

Also by Julian R. Sterling

More in fund operations, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.