Building financial models with Microsoft Excel a guide for business professionals

A proven guide to building financial models from scratch The Second Edition of Building Financial Models with Microsoft Excel + CD-ROM provides beginning and intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel 2007-the most popular spr...

Descripción completa

Detalles Bibliográficos
Autor principal: Proctor, K. Scott (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Hoboken, NJ : Wiley 2010.
Edición:2nd ed
Colección:Wiley Finance
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627275206719
Tabla de Contenidos:
  • Building Financial Models with Microsoft® Excel®, Second Edition: A Guide for Business Professionals; Contents; Foreword; Preface; PURPOSE OF THIS BOOK; NEED FOR THIS BOOK; TARGET AUDIENCE FOR THIS BOOK; SUMMARY OF CONTENTS; A FINAL NOTE; Acknowledgments; Part One: The Master Budget; Chapter 1: Overview of Budgets and Financial Models; Chapter 2: Operating Budget-Assumptions, Sales, and Collections; Chapter 3: Operating Budget-Cost of Goods Sold, Inventory, and Purchases; Chapter 4: Operating Budget-Operating Expenses; Chapter 5: Operating Budget-Income Statement
  • Chapter 6: Financial Budget-Capital Budget and Cash BudgetChapter 7: Financial Budget-Balance Sheet; Part Two: Financial Statements and Free Cash Flows; Chapter 8: Consolidated Financial Statements; Chapter 9: Free Cash Flows and Dashboard; Part Three: Analysis of a Financial Model; Chapter 10: Sensitivity Analysis; Chapter 11: Contribution Margin Analysis; Chapter 12: Financial Ratios Analysis; Chapter 13: Valuation; Chapter 14: Capitalization Chart; Answers to Chapter Questions; Appendix: General Overview of Microsoft Excel 2007 Features and Functionality; BASIC FUNCTIONALITY; FORMATTING
  • FORMULAS AND FUNCTIONSADVANCED FEATURES; About the CD-ROM; About the Author; Index