Practical financial modelling: a guide to current practice
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Amsterdam [u.a.]
Elsevier, CIMA Publ.
2008
|
| Edition: | 2. ed. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XXVII, 282 S. Ill., graph. Darst. 1 CD-ROM |
| ISBN: | 9780750686471 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV035004566 | ||
| 003 | DE-604 | ||
| 005 | 20080912 | ||
| 007 | t | ||
| 008 | 080813s2008 ad|| |||| 00||| eng d | ||
| 020 | |a 9780750686471 |9 978-0-7506-8647-1 | ||
| 035 | |a (OCoLC)634734681 | ||
| 035 | |a (DE-599)HBZHT015556707 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-945 | ||
| 084 | |a QP 700 |0 (DE-625)141926: |2 rvk | ||
| 100 | 1 | |a Swan, Jonathan |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Practical financial modelling |b a guide to current practice |c Jonathan Swan |
| 250 | |a 2. ed. | ||
| 264 | 1 | |a Amsterdam [u.a.] |b Elsevier, CIMA Publ. |c 2008 | |
| 300 | |a XXVII, 282 S. |b Ill., graph. Darst. |e 1 CD-ROM | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Mathematisches Modell | |
| 650 | 4 | |a Unternehmen | |
| 650 | 4 | |a Business enterprises |x Finance |x Mathematical models | |
| 650 | 4 | |a Corporations |x Finance |x Mathematical models | |
| 650 | 0 | 7 | |a Unternehmen |0 (DE-588)4061963-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Mathematisches Modell |0 (DE-588)4114528-8 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Finanzierung |0 (DE-588)4017182-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Excel 2007 |0 (DE-588)7558101-2 |2 gnd |9 rswk-swf |
| 653 | |a Unternehmen | ||
| 653 | |a Finanzierung | ||
| 653 | |a Mathematisches Modell | ||
| 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 Mathematisches Modell |0 (DE-588)4114528-8 |D s |
| 689 | 0 | 3 | |a Excel 2007 |0 (DE-588)7558101-2 |D s |
| 689 | 0 | |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=016673907&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-016673907 | ||
Record in the Search Index
| _version_ | 1804137922254864384 |
|---|---|
| adam_text | Contents
Preface to the First Edition xi
Preface to the Second Edition xiii
About the Author xv
Introduction xvii
1 Model Structure 1
Introduction 1
Risk assessment and risk controls 2
The model developer 4
Two approaches 5
Purpose 6
Structure 7
Workbook structure 10
Inputs 11
Workings 12
Outputs 14
Variations 16
Documentation 18
Reporting 21
Reports 26
Model development 27
Navigation 32
Exercises 37
2 Quality Control 39
Introduction 39
Taxonomies of error 40
Audit tools 43
Error values 47
Audit sheet 51
Structural checks 53
viii Contents
Arithmetical checks 66
Financial checks 68
Model map 73
Excel 2007 workbook tests 75
Third party model audit tools 76
Exercises 76
3 Mainly Formulas 79
Introduction 79
Range names 80
Define names 87
Additional name functionality 98
BODMAS or PEMDAS 112
Timing 112
Changing time periods 119
Circularities and iteration 123
Coercion 135
Array formulas 136
R1C1 139
Exercises 140
4 Mainly Functions 143
Introduction 143
Logical 144
Revolving credit and the cash cascade 154
Lookup 157
Financial 169
Dates 172
Other useful functions 174
Exercises 179
5 Model Use 181
Introduction 181
Risk controls 182
Grouping and outlining 182
Data inputs 185
Conditional formatting 191
Custom formatting 198
Protection 205
Contents ix
Charting 209
Exercises 211
6 Sensitivity Analysis and Scenarios 213
Introduction 213
Best practice 214
Goal Seek 215
Data tables 216
Scenarios 219
Solver 231
Risk 231
Monte Carlo simulation 233
Exercises 234
7 Automation 237
Introduction 237
Macro security settings 238
Recorded macros 239
Iteration macro 240
Assigning macros 244
Written macros 247
Branching macros 249
Quarterly/annual macro 251
Error handling 252
User-defined functions 253
Deleting macros 256
Exercises 257
Appendix 1: Keyboard Shortcuts 259
Appendix 2: Good Modelling Practice 263
Appendix 3: Case Study 269
Index 271
|
| adam_txt |
Contents
Preface to the First Edition xi
Preface to the Second Edition xiii
About the Author xv
Introduction xvii
1 Model Structure 1
Introduction 1
Risk assessment and risk controls 2
The model developer 4
Two approaches 5
Purpose 6
Structure 7
Workbook structure 10
Inputs 11
Workings 12
Outputs 14
Variations 16
Documentation 18
Reporting 21
Reports 26
Model development 27
Navigation 32
Exercises 37
2 Quality Control 39
Introduction 39
Taxonomies of error 40
Audit tools 43
Error values 47
Audit sheet 51
Structural checks 53
viii Contents
Arithmetical checks 66
Financial checks 68
Model map 73
Excel 2007 workbook tests 75
Third party model audit tools 76
Exercises 76
3 Mainly Formulas 79
Introduction 79
Range names 80
Define names 87
Additional name functionality 98
BODMAS or PEMDAS 112
Timing 112
Changing time periods 119
Circularities and iteration 123
Coercion 135
Array formulas 136
R1C1 139
Exercises 140
4 Mainly Functions 143
Introduction 143
Logical 144
Revolving credit and the cash cascade 154
Lookup 157
Financial 169
Dates 172
Other useful functions 174
Exercises 179
5 Model Use 181
Introduction 181
Risk controls 182
Grouping and outlining 182
Data inputs 185
Conditional formatting 191
Custom formatting 198
Protection 205
Contents ix
Charting 209
Exercises 211
6 Sensitivity Analysis and Scenarios 213
Introduction 213
Best practice 214
Goal Seek 215
Data tables 216
Scenarios 219
Solver 231
Risk 231
Monte Carlo simulation 233
Exercises 234
7 Automation 237
Introduction 237
Macro security settings 238
Recorded macros 239
Iteration macro 240
Assigning macros 244
Written macros 247
Branching macros 249
Quarterly/annual macro 251
Error handling 252
User-defined functions 253
Deleting macros 256
Exercises 257
Appendix 1: Keyboard Shortcuts 259
Appendix 2: Good Modelling Practice 263
Appendix 3: Case Study 269
Index 271 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Swan, Jonathan |
| author_facet | Swan, Jonathan |
| author_role | aut |
| author_sort | Swan, Jonathan |
| author_variant | j s js |
| building | Verbundindex |
| bvnumber | BV035004566 |
| classification_rvk | QP 700 |
| ctrlnum | (OCoLC)634734681 (DE-599)HBZHT015556707 |
| discipline | Wirtschaftswissenschaften |
| discipline_str_mv | Wirtschaftswissenschaften |
| edition | 2. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01857nam a2200481 c 4500</leader><controlfield tag="001">BV035004566</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20080912 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">080813s2008 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780750686471</subfield><subfield code="9">978-0-7506-8647-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)634734681</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)HBZHT015556707</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-945</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 700</subfield><subfield code="0">(DE-625)141926:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Swan, Jonathan</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Practical financial modelling</subfield><subfield code="b">a guide to current practice</subfield><subfield code="c">Jonathan Swan</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam [u.a.]</subfield><subfield code="b">Elsevier, CIMA Publ.</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXVII, 282 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield><subfield code="e">1 CD-ROM</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=" " ind2="4"><subfield code="a">Mathematisches Modell</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Unternehmen</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business enterprises</subfield><subfield code="x">Finance</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield><subfield code="x">Mathematical models</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">Mathematisches Modell</subfield><subfield code="0">(DE-588)4114528-8</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="650" ind1="0" ind2="7"><subfield code="a">Excel 2007</subfield><subfield code="0">(DE-588)7558101-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Unternehmen</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Finanzierung</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Mathematisches Modell</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">Mathematisches Modell</subfield><subfield code="0">(DE-588)4114528-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="3"><subfield code="a">Excel 2007</subfield><subfield code="0">(DE-588)7558101-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><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=016673907&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-016673907</subfield></datafield></record></collection> |
| id | DE-604.BV035004566 |
| illustrated | Illustrated |
| index_date | 2024-07-02T21:41:38Z |
| indexdate | 2024-07-09T21:19:59Z |
| institution | BVB |
| isbn | 9780750686471 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016673907 |
| oclc_num | 634734681 |
| open_access_boolean | |
| owner | DE-945 |
| owner_facet | DE-945 |
| physical | XXVII, 282 S. Ill., graph. Darst. 1 CD-ROM |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Elsevier, CIMA Publ. |
| record_format | marc |
| spelling | Swan, Jonathan Verfasser aut Practical financial modelling a guide to current practice Jonathan Swan 2. ed. Amsterdam [u.a.] Elsevier, CIMA Publ. 2008 XXVII, 282 S. Ill., graph. Darst. 1 CD-ROM txt rdacontent n rdamedia nc rdacarrier Mathematisches Modell Unternehmen Business enterprises Finance Mathematical models Corporations Finance Mathematical models Unternehmen (DE-588)4061963-1 gnd rswk-swf Mathematisches Modell (DE-588)4114528-8 gnd rswk-swf Finanzierung (DE-588)4017182-6 gnd rswk-swf Excel 2007 (DE-588)7558101-2 gnd rswk-swf Finanzierung Unternehmen (DE-588)4061963-1 s Finanzierung (DE-588)4017182-6 s Mathematisches Modell (DE-588)4114528-8 s Excel 2007 (DE-588)7558101-2 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016673907&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Swan, Jonathan Practical financial modelling a guide to current practice Mathematisches Modell Unternehmen Business enterprises Finance Mathematical models Corporations Finance Mathematical models Unternehmen (DE-588)4061963-1 gnd Mathematisches Modell (DE-588)4114528-8 gnd Finanzierung (DE-588)4017182-6 gnd Excel 2007 (DE-588)7558101-2 gnd |
| subject_GND | (DE-588)4061963-1 (DE-588)4114528-8 (DE-588)4017182-6 (DE-588)7558101-2 |
| title | Practical financial modelling a guide to current practice |
| title_auth | Practical financial modelling a guide to current practice |
| title_exact_search | Practical financial modelling a guide to current practice |
| title_exact_search_txtP | Practical financial modelling a guide to current practice |
| title_full | Practical financial modelling a guide to current practice Jonathan Swan |
| title_fullStr | Practical financial modelling a guide to current practice Jonathan Swan |
| title_full_unstemmed | Practical financial modelling a guide to current practice Jonathan Swan |
| title_short | Practical financial modelling |
| title_sort | practical financial modelling a guide to current practice |
| title_sub | a guide to current practice |
| topic | Mathematisches Modell Unternehmen Business enterprises Finance Mathematical models Corporations Finance Mathematical models Unternehmen (DE-588)4061963-1 gnd Mathematisches Modell (DE-588)4114528-8 gnd Finanzierung (DE-588)4017182-6 gnd Excel 2007 (DE-588)7558101-2 gnd |
| topic_facet | Mathematisches Modell Unternehmen Business enterprises Finance Mathematical models Corporations Finance Mathematical models Finanzierung Excel 2007 |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016673907&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT swanjonathan practicalfinancialmodellingaguidetocurrentpractice |