Expected asset return measures are needed to construct portfolios, plan for retirement, value equities and options, and forecast corporate cash flows. In this lecture, students will: Compute historical returns for stocks and market indexes; estimate expected asset returns using the Capital Asset Pricing Model (CAPM), Global CAPM (GCAPM), the Fama-French 3 Factor Model (FF3F), and fundamental analysis; use excel styles and formats; create modules and write simple VBA programs. | Lecture Financial modeling - Topic 1: Asset expected return and user-defined function
