The Arbitrage Pricing Model: A Pedagogic Derivation and a Spreadsheet-Based Illustration

Abstract

This paper derives, from a pedagogic perspective, the Arbitrage Pricing Model, which is an important asset pricing model in modern finance. The derivation is based on the idea that, if a self-financed investment has no risk exposures, the payoff from the investment can only be zero. Microsoft Excel plays an important pedagogic role in this paper. The Excel illustration not only helps students recognize more fully the various nuances in the model derivation, but also serves as a good starting point for students to explore on their own the relevance of the noise issue in the model derivation.