Muutke küpsiste eelistusi

Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals plus Website [Pehme köide]

4.13/5 (46 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 336 pages, kõrgus x laius x paksus: 254x182x17 mm, kaal: 654 g, Illustrations
  • Ilmumisaeg: 19-Sep-2012
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 111813284X
  • ISBN-13: 9781118132845
Teised raamatud teemal:
Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals plus WebsiteSuurem pilt
  • Formaat: Paperback / softback, 336 pages, kõrgus x laius x paksus: 254x182x17 mm, kaal: 654 g, Illustrations
  • Ilmumisaeg: 19-Sep-2012
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 111813284X
  • ISBN-13: 9781118132845
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781118132845.html
Märksõnad:
A clear, concise, and easy-to-use guide to financial modelling suitable for practitioners at every level

Using a fundamental approach to financial modelling that's accessible to both new and experienced professionals, Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website offers practical guidance for anyone looking to build financial models for business proposals, to evaluate opportunities, or to craft financial reports. Comprehensive in nature, the book covers the principles and best practices of financial modelling, including the Excel tools, formulas, and functions to master, and the techniques and strategies necessary to eliminate errors.

As well as explaining the essentials of financial modelling, Using Excel for Business Analysis is packed with exercises and case studies to help you practice and test your comprehension, and includes additional resources online.

  • Provides comprehensive coverage of the principles and best practices of financial modeling, including planning, how to structure a model, layout, the anatomy of a good model, rebuilding an inherited model, and much more
  • Demonstrates the technical Excel tools and techniques needed to build a good model successfully
  • Outlines the skills you need to learn in order to be a good financial modeller, such as technical, design, and business and industry knowledge
  • Illustrates successful best practice modeling techniques such as linking, formula consistency, formatting, and labeling
  • Describes strategies for reducing errors and how to build error checks and other methods to ensure accurate and robust models

A practical guide for professionals, including those who do not come from a financial background, Using Excel for Business Analysis is a fundamentals-rich approach to financial modeling.

Preface xi
Chapter 1 What Is Financial Modelling?
1(20)
What's the Difference between a Spreadsheet and a Financial Model?
3(1)
Types and Purposes of Financial Models
4(1)
Tool Selection
5(5)
What Skills Do You Need to Be a Good Financial Modeller?
10(6)
The Ideal Financial Modeller
16(3)
Summary
19(2)
Chapter 2 Building a Model
21(18)
Model Design
21(1)
The Golden Rules for Model Design
22(2)
Design Issues
24(1)
The Workbook Anatomy of a Model
25(2)
Project Planning Your Model
27(1)
Model Layout Flow Charting
28(1)
Steps to Building a Model
28(7)
Information Requests
35(1)
Version-Control Documentation
36(1)
Summary
37(2)
Chapter 3 Best Practice Principles of Modelling
39(14)
Document Your Assumptions
39(1)
Linking, Not Hard Coding
39(1)
Only Enter Data Once
40(1)
Avoid Bad Habits
41(1)
Use Consistent Formulas
41(1)
Format and Label Clearly
41(1)
Methods and Tools of Assumptions Documentation
42(6)
Linked Dynamic Text Assumptions Documentation
48(3)
What Makes a Good Model?
51(1)
Summary
52(1)
Chapter 4 Financial Modelling Techniques
53(18)
The Problem with Excel
53(1)
Error Avoidance Strategies
54(5)
How Long Should a Formula Be?
59(2)
Linking to External Files
61(2)
Building Error Checks
63(3)
Avoid Error Displays in Formulas
66(1)
Circular References
67(3)
Summary
70(1)
Chapter 5 Using Excel in Financial Modelling
71(22)
Formulas and Functions in Excel
71(2)
Excel Versions
73(1)
Handy Excel Shortcuts
74(2)
Basic Excel Functions
76(6)
Logical Functions
82(2)
Nesting: Combining Simple Functions to Create Complex Formulas
84(2)
Cell Referencing Best Practices
86(3)
Named Ranges
89(3)
Summary
92(1)
Chapter 6 Functions for Financial Modelling
93(40)
Aggregation Functions
93(7)
LOOKUP Formulas
100(6)
Other Useful Functions
106(9)
Working with Dates
115(6)
Financial Project Evaluation Functions
121(5)
Loan Calculations
126(5)
Summary
131(2)
Chapter 7 Tools for Model Display
133(40)
Basic Formatting
133(1)
Custom Formatting
133(6)
Conditional Formatting
139(4)
Sparklines
143(4)
Bulletproofing Your Model
147(4)
Customising the Display Settings
151(6)
Form Controls
157(14)
Summary
171(2)
Chapter 8 Tools for Financial Modelling
173(28)
Hiding Sections of a Model
173(5)
Grouping
178(1)
Array Formulas
179(5)
Goal Seeking
184(2)
Pivot Tables
186(4)
Macros
190(8)
User-Defined Functions (UDFs)
198(2)
Summary
200(1)
Chapter 9 Common Uses of Tools in Financial Modelling
201(34)
Escalation Methods for Modelling
201(5)
Understanding Nominal and Effective (Real) Rates
206(3)
Calculating Cumulative Totals
209(1)
How to Calculate a Payback Period
210(4)
Weighted Average Cost of Capital (WACC)
214(2)
Building a Tiering Table
216(3)
Modelling Depreciation Methods
219(8)
Break-Even Analysis
227(6)
Summary
233(2)
Chapter 10 Model Review
235(16)
Rebuilding an Inherited Model
235(10)
Auditing a Financial Model
245(5)
Appendix 10.1 QA Log
250(1)
Summary
250(1)
Chapter 11 Stress-Testing, Scenarios, and Sensitivity Analysis in Financial Modelling
251(24)
What's the Difference between Scenario, Sensitivity, and What-If Analysis?
252(1)
Overview of Scenario Analysis Tools and Methods
253(8)
Advanced Conditional Formatting
261(3)
Comparing Scenario Methods
264(9)
Summary
273(2)
Chapter 12 Presenting Model Output
275(42)
Preparing an Oral Presentation for Model Results
275(1)
Preparing a Graphic or Written Presentation for Model Results
276(3)
Chart Types
279(12)
Working with Charts
291(4)
Handy Charting Hints
295(2)
Dynamic Range Names
297(3)
Charting with Two Different Axes and Chart Types
300(2)
Bubble Charts
302(5)
Waterfall Charts
307(9)
Summary
316(1)
About the Author 317(2)
About the Website 319(2)
Index 321
DANIELLE STEIN FAIRHURST is the Principal of Plum Solutions, a Sydney-based consultancy specialising in financial modelling and analysis. With many years' experience as a financial analyst, she helps her clients create meaningful financial models. She has hands-on experience in a number of industry sectors, including telecommunications, information systems, manufacturing, and financial services. Stein Fairhurst is regularly engaged as a speaker, course facilitator, financial modelling consultant, and analyst around the world, and has taught management accounting subjects at Sydney University.