| |
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 application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features, and functions are covered in detail from a practical perspective, and put in context with application to real-world examples. Each chapter focuses on a different aspect of Excel modelling, including step-by-step instructions that walk you through each feature, and the companion website provides live model worksheets that give you the real hands-on practice you need to start doing your job faster, more efficiently, and with fewer errors.
Financial modelling is an invaluable business tool, and Excel 2013 is capable of supporting the most common and useful models most businesses need. This book shows you how to dig deeper into Excel`s functionality to craft effective financial models and provide important information that informs good decision-making.
Learn financial modelling techniques and best practice
Master the formulas and functions that bring your model to life
Apply stress testing and sensitivity analysis with advanced conditionals
Present your results effectively, whether graphically, orally, or written
A deceptively powerful application, Excel supports many hundreds of tools, features, and functions; Using Excel for Business Analysis eliminates the irrelevant to focus on those that are most useful to business finance users, with detailed guidance toward utilisation and best practice.
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 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
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
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 :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 ISBN - 9788126555390
|
| |
Pages : 440
|