Using Excel for business analysis a guide to financial modelling fundamentals
Utilize Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance a...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Singapore :
Wiley
[2015]
|
| Edición: | Revised edition |
| Colección: | Wiley finance series.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009849069306719 |
Tabla de Contenidos:
- Intro
- Series
- Title Page
- Copyright
- Preface
- Book Overview
- Acknowledgments
- 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
- Notes
- 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 Modelling
- Document Your Assumptions
- Linking, Not Hard Coding
- Enter Data Only 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
- Note
- 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
- Summary
- Notes
- Chapter 5 Using Excel In Financial Modelling
- Formulas 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
- Nesting Index And Match
- Offset Function
- Regression Analysis
- Choose Function
- 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 Model
- Customising The Display Settings
- Form Controls
- Summary
- Chapter 8 Tools For Financial Modelling
- Hiding Sections Of A Model
- Grouping
- Array Formulas
- Goal Seeking
- Structured Reference Tables
- Pivottables
- Macros
- 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 Review
- Rebuilding An Inherited Model
- Improving Model Performance
- Auditing A Financial Model
- Summary
- Appendix 10.1: Qa Log
- Chapter 11 Stress-Testing, Scenarios, And Sensitivity Analysis In Financial Modelling
- What Are The Differences Between Scenario, Sensitivity, And What-If Analyses?
- 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
- Handy Charting Hints
- Dynamic Named Ranges
- Charting With Two Different Axes And Chart Types
- Bubble Charts
- Creating A Dynamic Chart
- Waterfall Charts
- Summary
- About The Author
- About The Website
- Index
- Eula.
