About the Website

Welcome to the website to accompany Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, Third Edition by Danielle Stein Fairhurst, located at www.wiley.com/go/steinfairhurst.

The content of the website consists of several documents that supplement the information in the book, including additional instructions, materials, downloads, and models. Each chapter (except Chapter 1) has its own Excel file(s), which contain a soft copy of the many screenshots shown throughout the book and their applicable page numbers. Using these files, you'll be able to recreate many of the modelling situations, tools, and functions described in the book. Several Excel model exercises and sample models have also been included. These accompanying files have been made freely available by the author, but they might not make sense without the book.

For updated model templates and additional supplementary downloads, please check the author's website, www.plumsolutions.com.au/book. Please also visit www.plumsolutions.com.au/elearning if you would like to register for the author's online courses that correspond to the book.

The supplementary content available on the website includes:

DOWNLOADABLE RESOURCES

These downloadable PDFs contain additional explanations and content we didn't have room for in the book:

  • How to create a break-even chart (Chapter 9).
  • Excel versions (Chapter 5) contains an overview of the history and key differences among the versions of Excel in use and how they impact model building.
  • Online resources (Chapter 1) includes a list of websites, blogs, and tutorials for Excel and financial modelling.
  • Shortcuts (Chapter 5) is a printable three-page cheat sheet of the most useful shortcuts for financial modelling in Excel.
  • QA log template (Chapter 10, Appendix 10.1) is a sample template that can be used during the model QA process.
  • Creating a waterfall chart in previous versions of Excel

Models

These fully functioning models have been referred to in the book:

  • Model assessment checklist (Chapter 3).
  • Lender repayment calculator (Chapter 7).
  • Scenario comparison (including both exercise and completed versions) (Chapter 11).

Technical Exercise Files

These files contain the examples from the screenshots exactly as they appear in the book. You can use them to work through the examples and follow the instructions in the book to master each tool and technique.

Chapter 3

  • Assumptions documentation methods

Chapter 4

  • Internal and external links
  • Circular references

Chapter 5

  • Cell referencing
  • Named ranges
  • Nesting logical functions; IF and AND

Chapter 6

  • Aggregation functions
  • LOOKUP functions
  • Nesting INDEX and MATCH
  • OFFSET Function
  • Regression analysis
  • Date functions
  • Investment return functions; NPV, IRR
  • Loan calculations; PMT, IPMT & PPMT

Chapter 7

  • Conditional formatting
  • Sparklines
  • Protection
  • Form controls

Chapter 8

  • Array formulas
  • Dynamic arrays
  • Goal seeking
  • Structured Reference Tables
  • PivotTables
  • Macros

Chapter 9

  • Growth and Escalation formulas
  • Nominal and effective rates
  • Calculating a cumulative sum (running totals)
  • Payback periods
  • Weighted average cost of capital (WACC)
  • Tiering (volume break) tables
  • Depreciation
  • Break-Even analysis

Chapter 11

  • Scenarios using drop-down boxes
  • Sensitivities with data tables

Chapter 12

  • Combo charts
  • Map charts
  • Bubble charts
  • Using Dynamic named ranges in charts
  • Dynamic charts
  • Waterfall charts
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.221.165.115