Companion files · The Private Markets Career Guides
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 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.
Chapters 4 to 14
One Inputs sheet holds every assumption: the releases and consensus, the non-GAAP adjustments, the guidance ranges, the ratings, the register by style, the targeting counts, the peer multiples, the investor day targets, the budget lines and the votes. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook29 KBAppendix B
Disclosure Policy Checklist, Earnings Calendar Template, Earnings Release Checklist, Call Script and Q&A Preparation Checklist, Guidance Change Checklist, Shareholder Base Review Template, Targeting and Meeting Log Template, Investor Day Checklist, Proxy Season Calendar, Activism Preparedness Checklist and crisis and rumor response checklist.
Download the toolkit41 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Earnings | Second 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 |
| Valuation | A 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 |
| Votes | 65.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.
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.