Using Excel for business analysis : a guide to financial modelling fundamentals / Danielle Stein Fairhurst.

Format:

Book

Author/Creator:

Fairhurst, Danielle Stein, author.

Series:

Wiley finance series.

Wiley finance series

Language:

English

Subjects (All):

Corporations--Finance.

Corporations.

Corporations--Finance--Computer programs.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (443 p.)

Edition:

Revised edition.

Place of Publication:

Singapore : Wiley, [2015]

Language Note:

English

Summary:

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 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. Fina

Contents:

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

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?

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

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

Sparklines

Bulletproofing Your Model

Customising The Display Settings

Form Controls

Chapter 8 Tools For Financial Modelling

Hiding Sections Of A Model

Grouping

Array Formulas

Goal Seeking

Structured Reference Tables

Pivottables

Macros

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

Index

Eula.

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed April 6, 2015).

ISBN:

9781119070016

1119070015

9781119062455

1119062454

9781119062448

1119062446

OCLC:

905989910