Hands-On Financial Modeling with Microsoft Excel 2019 : Build Practical Models for Forecasting, Valuation, Trading, and Growth Analysis Using Excel 2019.

Mostrar otras versiones (2)

This book aims to provide a gateway to financial modeling through easy to follow examples in Excel 2019. It will explore the process of modeling starting from a thorough understanding of the project to gathering historical information and arriving at assumptions. Good modeling practices are emphasiz...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Oluwa, Shmuel
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, Limited, 2019.
Temas:
Microsoft Excel (Computer file)
Corporations > Finance > Mathematical models.
Corporations > Finance > Data processing.
Corporations > Finance > Data processing
Corporations > Finance > Mathematical models
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Cover; Title Page; Copyright and Credits; Dedication; About Packt; Contributors; Table of Contents; Preface; Section 1: Financial Modeling
  • Overview; Chapter 1: Introduction to Financial Modeling and Excel; The main ingredients of a financial model; Investment; Financing; Dividends; Understanding mathematical models; Definitions of financial models; Types of financial models; The 3 statement model; The discounted cash flow model; The comparative companies model; The merger and acquisition model; The leveraged buyout model; Loan repayment schedule; The budget model
  • Alternative tools for financial modelingAdvantages of Excel; Excel
  • the ideal tool; Summary; Chapter 2: Steps for Building a Financial Model; Discussions with management; Gauging management expectations; Knowing your client's business; Department heads; Building assumptions; Building a template for your model; Historical financial data; Projecting the balance sheet and profit and loss account; Additional schedules and projections; Cash flow statement; Preparing ratio analysis; Valuation; Summary; Section 2: The Use of Excel
  • Features and Functions for Financial Modeling
  • Chapter 3: Formulas and Functions
  • Completing Modeling Tasks with a Single FormulaUnderstanding functions and formulas; Working with lookup functions; The VLOOKUP function; The INDEX function; The MATCH function; The CHOOSE function; Implementing the CHOOSE function; Utility functions; The IF function; The MAX and MIN functions; Implementing the functions; Pivot tables and charts; Implementing pivot tables; Pitfalls to avoid; Protect sheets; Summary; Chapter 4: Applying the Referencing Framework in Excel; Introduction to the framework; Relative referencing; Absolute referencing
  • Mixed referencingImplementing the referencing framework; Summary; Section 3: Building an Integrated Financial Model; Chapter 5: Understanding Project and Building Assumptions; Understanding the nature and purpose of a project; Conducting interviews; Historical data; Building assumptions; General assumptions; Profit and loss and balance sheet assumptions; Profit and loss account growth drivers; Year-on-year growth; Compound annual growth rate; Balance sheet growth drivers; Days of inventory; Debtor days; Creditor days; Summary; Chapter 6: Asset and Debt Schedules
  • Understanding the BASE and corkscrew conceptsAsset schedule; The straight line method; The reducing balance method; Approaches to modeling assets; The detailed approach; Asset and depreciation schedule; The simple approach; Debt schedule; The complex approach; The simple approach; Creating a loan amortization schedule; Creating the template; Creating the formulas; Using the schedule; Summary; Chapter 7: Cash Flow Statement; Introduction to the cash flow statement; Items not involving the movement of cash; Net change in working capital; Cash flow from investment activities

Ejemplares similares