All Categories
This book demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street equity research analysts. The accompanying Excel files demonstrate the key concepts and can be used as templates to create an earning model for nearly any company. Readers without prior financial analysis experience will gain a fundamental understanding of exactly what modeling entails, and will learn how to create a basic form of an earnings model. Advanced readers will be introduced to more complex topics such as linking the financial statements, future period calibration, and incorporating macroeconomic variables into discounted valuation analysis through the equity risk premium and application of the capital asset pricing model. Your purchase includes the following Excel templates which can be downloaded for free when you register your book:File 1 - Blank Model Template: Use this template to create your own earnings model. File 2 - Apple Inc Back of the Envelope Model: This beginner model features a basic Income Statement projection methodology, and is perfect for those who have not had prior modeling experience.File 3 - Apple Inc Tier 2 Earnings Model: This version of the model is more sophisticated and includes a breakdown of the company's products, which is used to project future earnings. File 4 - Apple Inc Tier 1 Earnings Model: The Tier 1 model is geared toward advanced analysts and includes financial statement integration, as well as a discounted cash flow valuation. File 5 - Equity Risk Premium (ERP) Model: Using this simple model you can quickly estimate the market ERP based on volatility, changes in interest rates, and market return expectations. You can then derive a discount rate using your ERP estimate, and the Capital Asset Pricing Model (CAPM). File 6 - Apple Inc Beta Calculation: This file