ISBN 9788126555390,Using Excel for Business Anaysis : A Guide to Financial Modelling Fundamentals

Using Excel for Business Anaysis : A Guide to Financial Modelling Fundamentals



Wiley India Pvt Ltd

Publication Year 2015

ISBN 9788126555390

ISBN-10 8126555394


Number of Pages 440 Pages
Language (English)


Utilise 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 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 modeling, 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 modeling, 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 modeling 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 modeling 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.

About the Author

Danielle Stein Fairhurst is the Principal of Plum Solutions, a Sydney-based consultancy specializing in financial modelling and analysis. She is the author of 'Using Excel for Business Analysis, a Fundamental Approach to Financial Modelling', published by Wiley Finance 2012. With over fourteen years' experience as a financial analyst, she helps her clients create meaningful financial models in the form of business cases, pricing models and management reports. She has hands-on experience in a number of industry sectors, including telecoms, information systems, manufacturing and financial services. Danielle has regular engagements around Australia and globally as a speaker, course facilitator, financial modelling consultant and analyst. She holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management (MGSM) and has taught management accounting subjects at Sydney University.
Table of contents -:

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

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 53
Chapter 3 : Best Practice Principles of Modeling

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?
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
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
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
Chapter 7 : Tools for Model Display

Basic Formatting
Custom Formatting
Conditional Formatting
Bulletproofing Your Model
Customising the Display Settings
Form Controls
Chapter 8 : Tools for Financial Modelling

Hiding Sections of a Model
Array Formulas
Goal Seeking
Structured Reference Tables
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
Chapter 10 : Model Review

Rebuilding an Inherited Model
Improving Model Performance
Auditing a Financial Model
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
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
About the Author
About the Website