Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. qFinancial Modelingq bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial problems with spreadsheets. The CD-ROM contains Excel* worksheets and solutions to end-of-chapter exercises. 634 illustrations.10.1 Overview In this chapter we look at some typical capital-market data and replicate a simple test of the CAPM. ... 500 returns) Here Average, Covar, and Varp are Excel functions on the column vectors of returns.1 Calculating these statisticsanbsp;...
|Author||:||Simon Benninga, Benjamin Czaczkes|
|Publisher||:||MIT Press - 2000|