# The Hedge Fund Analyst: companion files

Julian R. Sterling

## What is here

- **Hedge_Fund_Analyst_Model.xlsx**: the workbook that rebuilds the Ostrander Capital case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Long, Short, Quarter, Checks.
- **Hedge_Fund_Analyst_Toolkit.docx**: the checklists and templates of Appendix B (idea screen, first-week research plan, model checklist, one-page pitch, short checklist, position review, earnings preview, expert call compliance), in editable form.

## Which sheet answers which chapter

- Chapters 5 to 8: Long (Brayford Industries: valuation, target, scenarios, size)
- Chapters 9 and 10: Short (Velmont Home: scenarios, borrow cost, size, crowding)
- Chapters 3 and 11: Quarter (fees, attribution, beta and alpha, net return)

## Two inputs to change first

1. On Inputs, raise the Brayford bear price from 38.00 to 42.00: see the loss in the bear case shrink and the position size grow.
2. On Inputs, raise the borrow cost from 2.5% to 15%: watch the net expected return of the Velmont short fall. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light yellow background is an input, black type a formula. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Ostrander Capital, Brayford Industries and Velmont Home are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not prices, recommendations or forecasts. Provided as is, without warranty. Not investment, legal or tax advice.
