Cargando…
Using Excel for business analysis : a guide to financial modelling fundamentals /
"A clear, concise, and easy-to-use guide to financial modelling suitable for practitioners at every level. Using a fundamental approach to financial modelling that's accessible to both new and experienced professionals, Using Excel for Business Analysis: A Guide to Financial Modelling Fund...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Singapore ; Hoboken, NJ :
John Wiley & Sons,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Intro; Contents; Title; Copyright; Dedication; Preface; Chapter 1: What is Financial Modelling?; What's the Difference between a Spreadsheet and a Financial Model?; Types and Purposes of Financial Models; Tool Selection; What Skills Do you Need to Be a Good Financial Modeller?; The Ideal Financial Modeller; Summary; Chapter 2: Building a Model; Model Design; The Golden Rules for Model Design; Design Issues; The Workbook Anatomy of a Model; Project Planning Your Model; Model Layout Flow Charting; Steps to Building a Model; Information Requests; Version-Control Documentation; Summary.
- Chapter 3: Best Practice Principles of ModellingDocument Your Assumptions; Linking, Not Hard Coding; Only Enter Data Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation; Linked Dynamic Text Assumptions Documentation; What Makes a Good Model?; Summary; Chapter 4: Financial Modelling Techniques; The Problem with Excel; Error Avoidance Strategies; How Long Should a Formula Be?; Linking to External Files; Building Error Checks; Avoid Error Displays in Formulas; Circular References; Summary.
- Chapter 5: Using Excel in Financial ModellingFormulas and Functions in Excel; Excel Versions; Handy Excel Shortcuts; Basic Excel Functions; Logical Functions; Nesting: Combining Simple Functions to Create Complex Formulas; Cell Referencing Best Practices; Named Ranges; Summary; Chapter 6: Functions for Financial Modelling; Aggregation Functions; LOOKUP Formulas; Other Useful Functions; Working with Dates; Financial Project Evaluation Functions; Loan Calculations; Summary; Chapter 7: Tools for Model Display; Basic Formatting; Custom Formatting; Conditional Formatting; Sparklines.
- Bulletproofing Your ModelCustomising the Display Settings; Form Controls; Summary; Chapter 8: Tools for Financial Modelling; Hiding Sections of a Model; Grouping; Array Formulas; Goal Seeking; Pivot Tables; Macros; User-Defined Functions (UDFs); Summary; Chapter 9: Common Uses of Tools in Financial Modelling; Escalation Methods for Modelling; Understanding Nominal and Effective (Real) Rates; Calculating Cumulative Totals; How to Calculate a Payback Period; Weighted Average Cost of Capital (WACC); Building a Tiering Table; Modelling Depreciation Methods; Break-Even Analysis; Summary.
- Chapter 10: Model ReviewRebuilding an Inherited Model; Auditing a Financial Model; Appendix 10.1: QA Log; Summary; Chapter 11: Stress-Testing, Scenarios, and Sensitivity Analysis in Financial Modelling; What's the Difference between Scenario, Sensitivity, and What-If Analysis?; Overview of Scenario Analysis Tools and Methods; Advanced Conditional Formatting; Comparing Scenario Methods; Summary; Chapter 12: Presenting Model Output; Preparing an Oral Presentation for Model Results; Preparing a Graphic or Written Presentation for Model Results; Chart Types; Working with Charts.