Wiley India Pvt Ltd
|Number of Pages
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
What Skills Do You Need to Be a Good Financial Modeller?
The Ideal Financial Modeller
Chapter 2 : Building a Model
The Golden Rules for Model Design
The Workbook Anatomy of a Model
Project Planning Your Model
Model Layout Flow Charting
Steps to Building a Model
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
Handy Excel Shortcuts
Basic Excel Functions
Nesting: Combining Simple Functions to
Create Complex Formulas
Cell Referencing Best Practices
Chapter 6 : Functions for Financial Modelling
Nesting INDEX and MATCH
Working with Dates
Financial Project Evaluation Functions
Chapter 7 : Tools for Model Display
Bulletproofing Your Model
Customising the Display Settings
Chapter 8 : Tools for Financial Modelling
Hiding Sections of a Model
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
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
Working with Charts
Handy Charting Hints
Dynamic Named Ranges
Charting with Two Different Axes and Chart Types
Creating a Dynamic Chart
About the Author
About the Website