Title Statements
- Full title :Practical financial modelling : a guide to current practice / Jonathan Swan.
Edition Statements
- Publication Date:2005.
Publication Statements
Notes
"Contains demonstration files and worked examples to accompany the material in the book"--CD-ROM.
Includes index.
The Physical Object
- Description:1 online resource (xviii, 173 pages) : : illustrations
Edition Identifiers
- ISBN:0080455727, 9780080455723
- oclc:ocm76416330
- LC Classification:HG4012
- Dewey Decimal:658.150151
Table of Contents
Cover -- Contents -- Preface -- About the Author -- Context -- 1 Model structure -- Introduction -- Two approaches -- Purpose -- Structure -- Workbook structure -- Inputs -- Workings -- Outputs -- Variations -- Documentation -- Reporting -- Reports -- Model development -- Navigation -- 2 Quality control -- Introduction -- Taxonomies of error -- Audit tools -- Error values -- Audit sheet -- Structural checks -- Arithmetical checks -- Financial checks -- Model map -- 3 Mainly formulae -- Introduction -- Range names -- Additional name functionality -- BODMAS -- Timing -- Changing time periods -- Circularities and iteration -- Array formulae -- Coercion -- 4 Mainly functions -- Introduction -- Logical -- Lookup -- Financial -- Dates -- Other useful functions -- 5 Model use -- Introduction -- Grouping and outlining -- Data inputs -- Conditional formatting -- Custom formatting -- Protection -- 6 Sensitivity analysis and scenarios -- Introduction -- Goal Seek -- Data tables -- Scenarios -- Solver -- Risk -- Monte Carlo simulation -- 7 Automation -- Introduction -- Recorded macros -- Iteration macro -- Assigning macros -- Written macros -- Branching macros -- Quarterly/annual macro -- Err…
Read More ↓Subjects
Writers
No reviews yet. Be the first to rate this work.
Related Works
more →
Files & Downloads
-
Practical Financial Modelling: A Guide to Current…
PDF · 10.8 MB · updated -
Practical Financial Modelling: A Guide to Current…
PDF · 10.8 MB · updated
Rate & Review