Financial Modelling

Emma Burrows
Mind Map by Emma Burrows, updated more than 1 year ago
Emma Burrows
Created by Emma Burrows over 5 years ago


Information Management

Resource summary

Financial Modelling
1 Feasibility
1.1 Benefits
1.1.1 Clarify modelobjectives Identify boundaries- what it will and will not do Estimate time and resources understand main risks broad data requirements confirm whether model should be built
1.2 Problems Avoided
1.2.1 Expectations differ model is rushed model does not mitigate risks solution is suboptimal model gets abandoned
1.3 Should include
1.3.1 Purpose and objectives users of the model initail thoughts on how the model will work level of risk time and resources needed signed agreement Payback period
2 Analyse
2.1 Benefits
2.1.1 Ensures Model Solves correct problem Forces developer and sponsor to think through problem common understanding makes testing easier and effective new undertanding of problem and more valuable outcome
2.2 Problems Avoided
2.2.1 Building takes much longer frequent chnges introduce errors design may be haphazard other stages take longer model is discarded
2.3 Occam's Razor
2.4 Define Model Relationships and Reports
2.4.1 Bubble Diagrams Non descriptive
2.4.2 Who will use reports
2.4.3 Calculation Tables Useful Descriptive Take a long time to make
3 Design
3.1 Benefits
3.1.1 Built in Correct software Calculations are easy to understand Appearance is usser friendly and professional
3.2 Problems Avoided
3.2.1 Difficult to use Difficult to navigate Difficult to develop or amend Likey to contain errors Hard to test
3.3 Choosing the Software
3.3.1 Spreadsheets lots of numerical manipulation user interface copmplex report structures
3.3.2 databases data validation lots of data little calculation
3.4 Golden Rules of Design
3.4.1 One formula per row (column) Refer to left and above Use multiple worksheets appropirately Separate inputs, calculations, results Consistent use of columns Include documentation sheet
4 Maintain
4.1 Model Must stand alone
4.1.1 Developer may change jobs Model is not misused
4.2 Back Up procedures
4.2.1 Copy saved off site
4.3 Control Change
4.3.1 Change request forms Only one person makes changes Version number naming rules
5 Implement
5.1 User manuals and training
5.1.1 Communicates how to use model
5.2 Sensitivity analaysis
5.2.1 Fluctuations in inputs affect outputs Monte Carlo 95% degree of certainty Include Exec. summary Recommendations and next steps
5.3 Scenarios
5.3.1 Different Stories Possible Inputs Run trees Branches of changs with a summary report Comparator Run A, Run B, Run A-Run B
6 Test
6.1 Analysis
6.1.1 Review Model reports Review calculation Tables Examine data inputs
6.2 Unique Formulae
6.2.1 Identify Unique Formulae Check unique formulae analysis Check referencing
6.3 Numeric
6.3.1 Check results to analysis example Idenpendently calculate results for seecond time Reconcile against exsisting report
6.4 Robustness
6.4.1 Perform boundary test with sensible inputs Check zero, negative and large inputs
6.5 Macro
6.5.1 check macro buttons and hyperlinks try to brak macros with reasonable tests macros have error traps?

Media attachments

Show full summary Hide full summary


Managing resources
Time for Business sample
Exercise 2
Eco OnTheGo
Chapter 4
Angelica Vannarath
Natasha James
Sale and Purchase of Gold
Ayesha Basheer
Sale & Purchase of Mixed Dates
Ayesha Basheer
Modelling in Applied Mathematics
Influences in the Business Environment
Anatomy of FIX Protocol (Intro)
Thiago Pavesi
Language Identification and Modelling in Specialized hardware
Ivan Zapreev
Chapter 5
Angelica Vannarath