Teaching
Asset Pricing and Allocation
An introduction to investments
A first course in investments and financial markets, built chapter by chapter on Bodie, Kane & Marcus and taught entirely through live spreadsheet modeling: every model is rebuilt in Excel during class. From asset classes and market organization to CAPM, market efficiency, fixed income, equity valuation, derivatives, and performance evaluation.
Topics
- Asset classes, markets, and investment funds
- Risk, return, and capital allocation
- Diversification and the efficient frontier
- CAPM, APT, and market efficiency vs. behavioral finance
- Fixed income: prices, yields, duration and convexity
- Equity valuation: dividend discount models and multiples
- Options and futures: markets, strategies, no-arbitrage valuation
- Portfolio performance evaluation
Audience
Executive program participants; spreadsheet-centric, no calculus or programming prerequisite.
Materials
Full slide set for 16 chapters, a 78-page course mini-book, exercise sets, quizzes, and 14 classroom Excel workbooks.
Chapters 1–4 of the textbook are self-study verified by an entry quiz, so class time starts where the interesting decisions do. Assessment combines a final exam with spreadsheet mini-projects, and short true/false quizzes act as a bonus on the exam grade.