Using Excel for business analysis: a guide to financial modelling fundamentals
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Buch |
Sprache: | English |
Veröffentlicht: |
Singapore
Wiley
2012
|
Schlagworte: | |
Online-Zugang: | Inhaltsverzeichnis |
Beschreibung: | XII, 324 S. Ill. |
ISBN: | 9781118132845 |
Internformat
MARC
LEADER | 00000nam a2200000 c 4500 | ||
---|---|---|---|
001 | BV040447534 | ||
003 | DE-604 | ||
005 | 00000000000000.0 | ||
007 | t | ||
008 | 120928s2012 a||| |||| 00||| eng d | ||
020 | |a 9781118132845 |9 978-1-118-13284-5 | ||
035 | |a (OCoLC)815937037 | ||
035 | |a (DE-599)BVBBV040447534 | ||
040 | |a DE-604 |b ger |e rakwb | ||
041 | 0 | |a eng | |
049 | |a DE-1050 | ||
084 | |a ST 610 |0 (DE-625)143683: |2 rvk | ||
100 | 1 | |a Stein Fairhurst, Danielle |e Verfasser |4 aut | |
245 | 1 | 0 | |a Using Excel for business analysis |b a guide to financial modelling fundamentals |c Danielle Stein Fairhurst |
264 | 1 | |a Singapore |b Wiley |c 2012 | |
300 | |a XII, 324 S. |b Ill. | ||
336 | |b txt |2 rdacontent | ||
337 | |b n |2 rdamedia | ||
338 | |b nc |2 rdacarrier | ||
650 | 0 | 7 | |a Programm |0 (DE-588)4047394-6 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Unternehmen |0 (DE-588)4061963-1 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Finanzierung |0 (DE-588)4017182-6 |2 gnd |9 rswk-swf |
689 | 0 | 0 | |a Unternehmen |0 (DE-588)4061963-1 |D s |
689 | 0 | 1 | |a Finanzierung |0 (DE-588)4017182-6 |D s |
689 | 0 | 2 | |a Programm |0 (DE-588)4047394-6 |D s |
689 | 0 | |8 1\p |5 DE-604 | |
856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025295248&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
999 | |a oai:aleph.bib-bvb.de:BVB01-025295248 | ||
883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk |
Datensatz im Suchindex
_version_ | 1804149506839674880 |
---|---|
adam_text | Titel: Using Excel for business analysis
Autor: Stein Fairhurst, Danielle
Jahr: 2012
Contents
Preface xi
CHAPTER 1
What Is Financial Modelling? 1
What s the Difference between a Spreadsheet and a
Financial Model? 3
Types and Purposes of Financial Models 4
Tool Selection 5
What Skills Do You Need to Be a Good Financial Modeller? 10
The Ideal Financial Modeller 16
Summary 19
CHAPTER 2
Building a Model 21
Model Design 21
The Golden Rules for Model Design 22
Design Issues 24
The Workbook Anatomy of a Model 25
Project Planning Your Model 27
Model Layout Flow Charting 28
Steps to Building a Model 28
Information Requests 35
Version-Control Documentation 36
Summary 37
CHAPTER 3
Best Practice Principles of Modelling 39
Document Your Assumptions 39
Linking, Not Hard Coding 39
Only Enter Data Once 40
Avoid Bad Habits 41
Use Consistent Formulas 41
Format and Label Clearly 41
Methods and Tools of Assumptions Documentation 42
Linked Dynamic Text Assumptions Documentation 48
What Makes a Good Model? 51
Summary 52
CHAPTER 4
Financial Modelling Techrtques 53
The Problem with Excel -53
Error Avoidance Strategies -54
How Long Should a Formula Be? 59
Linking to External Files 61
Building Error Checks 63
Avoid Error Displays in Formulas 66
Circular References 67
Summary 70
CHAPTER 5
Using Excel in Financial Modelling 71
Formulas and Functions in Excel 71
Excel Versions 73
Handy Excel Shortcuts 74
Basic Excel Functions 76
Logical Functions 82
Nesting: Combining Simple Functions to Create Complex Formulas 84
Cell Referencing Best Practices 86
Named Ranges 89
Summary 92
CHAPTER 6
Functions for Financial Modelling 93
Aggregation Functions 93
LOOKUP Formulas 100
Other Useful Functions 106
Working with Dates 115
Financial Project Evaluation Functions 121
Loan Calculations 126
Summary 131
CHAPTER 7
Tools for Model Display 133
Basic Formatting 133
Custom Formatting 133
Conditional Formatting 139
Sparklines 143
Bulletproofing Your Model 147
Customising the Display Settings 151
Form Controls 157
Summary 171
CHAPTER 8
Tools for financial Modeling 173
Hiding Sections of a Model 173
Grouping 178
Array Formulas 179
Goal Seeking 184
Pivot Tables 186
Macros 190
User-Defined Functions (UDFs) 198
Summary 200
CHAPTER 9
Common Uses of Tools in Financial Modelling 291
Escalation Methods for Modelling 201
Understanding Nominal and Effective (Real) Rates 206
Calculating Cumulative Totals 209
How to Calculate a Payback Period 210
Weighted Average Cost of Capital (WACC) 214
Building a Tiering Table 216
Modelling Depreciation Methods 219
Break-Even Analysis 227
Summary 233
CHAPTER 10
Model Review 235
Rebuilding an Inherited Model 235
Auditing a Financial Model 245
Appendix 10.1: QA Log 250
Summary 250
CHAPTER 11
Stress-Testing, Scenarios, and Sensitivity Analysis in Financial ModeMng 251
What s the Difference between Scenario, Sensitivity,
and What-If Analysis? 252
Overview of Scenario Analysis Tools and Methods 253
Advanced Conditional Formatting 261
Comparing Scenario Methods 264
Summary 273
CHAPTER 12
Presenting Model Output 275
Preparing an Oral Presentation for Model Results 275
Preparing a Graphic or Written Presentation for Model Results 276
Chart Types 279
Working with Charts 291
Handy Charting Hints 295
Dynamic Range Names 297
Charting with Two Different Axes and Chart Types 300
Bubble Charts 302
Waterfall Charts 307
Summary 316
About the Author 317
About the Website 319
Index 321
|
any_adam_object | 1 |
author | Stein Fairhurst, Danielle |
author_facet | Stein Fairhurst, Danielle |
author_role | aut |
author_sort | Stein Fairhurst, Danielle |
author_variant | f d s fd fds |
building | Verbundindex |
bvnumber | BV040447534 |
classification_rvk | ST 610 |
ctrlnum | (OCoLC)815937037 (DE-599)BVBBV040447534 |
discipline | Informatik |
format | Book |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01497nam a2200373 c 4500</leader><controlfield tag="001">BV040447534</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">120928s2012 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781118132845</subfield><subfield code="9">978-1-118-13284-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)815937037</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV040447534</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 610</subfield><subfield code="0">(DE-625)143683:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Stein Fairhurst, Danielle</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Using Excel for business analysis</subfield><subfield code="b">a guide to financial modelling fundamentals</subfield><subfield code="c">Danielle Stein Fairhurst</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Singapore</subfield><subfield code="b">Wiley</subfield><subfield code="c">2012</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XII, 324 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Programm</subfield><subfield code="0">(DE-588)4047394-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Unternehmen</subfield><subfield code="0">(DE-588)4061963-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Finanzierung</subfield><subfield code="0">(DE-588)4017182-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Unternehmen</subfield><subfield code="0">(DE-588)4061963-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Finanzierung</subfield><subfield code="0">(DE-588)4017182-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Programm</subfield><subfield code="0">(DE-588)4047394-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025295248&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-025295248</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
id | DE-604.BV040447534 |
illustrated | Illustrated |
indexdate | 2024-07-10T00:24:07Z |
institution | BVB |
isbn | 9781118132845 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-025295248 |
oclc_num | 815937037 |
open_access_boolean | |
owner | DE-1050 |
owner_facet | DE-1050 |
physical | XII, 324 S. Ill. |
publishDate | 2012 |
publishDateSearch | 2012 |
publishDateSort | 2012 |
publisher | Wiley |
record_format | marc |
spelling | Stein Fairhurst, Danielle Verfasser aut Using Excel for business analysis a guide to financial modelling fundamentals Danielle Stein Fairhurst Singapore Wiley 2012 XII, 324 S. Ill. txt rdacontent n rdamedia nc rdacarrier Programm (DE-588)4047394-6 gnd rswk-swf Unternehmen (DE-588)4061963-1 gnd rswk-swf Finanzierung (DE-588)4017182-6 gnd rswk-swf Unternehmen (DE-588)4061963-1 s Finanzierung (DE-588)4017182-6 s Programm (DE-588)4047394-6 s 1\p DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025295248&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
spellingShingle | Stein Fairhurst, Danielle Using Excel for business analysis a guide to financial modelling fundamentals Programm (DE-588)4047394-6 gnd Unternehmen (DE-588)4061963-1 gnd Finanzierung (DE-588)4017182-6 gnd |
subject_GND | (DE-588)4047394-6 (DE-588)4061963-1 (DE-588)4017182-6 |
title | Using Excel for business analysis a guide to financial modelling fundamentals |
title_auth | Using Excel for business analysis a guide to financial modelling fundamentals |
title_exact_search | Using Excel for business analysis a guide to financial modelling fundamentals |
title_full | Using Excel for business analysis a guide to financial modelling fundamentals Danielle Stein Fairhurst |
title_fullStr | Using Excel for business analysis a guide to financial modelling fundamentals Danielle Stein Fairhurst |
title_full_unstemmed | Using Excel for business analysis a guide to financial modelling fundamentals Danielle Stein Fairhurst |
title_short | Using Excel for business analysis |
title_sort | using excel for business analysis a guide to financial modelling fundamentals |
title_sub | a guide to financial modelling fundamentals |
topic | Programm (DE-588)4047394-6 gnd Unternehmen (DE-588)4061963-1 gnd Finanzierung (DE-588)4017182-6 gnd |
topic_facet | Programm Unternehmen Finanzierung |
url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025295248&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
work_keys_str_mv | AT steinfairhurstdanielle usingexcelforbusinessanalysisaguidetofinancialmodellingfundamentals |