One of the most frustrating things about using other peoples' spreadsheets is that there is no obvious architecture or roadmap. How do you "drive" it and how does the logic get us from A to B? At our recent Sydney Modellers' Meetup session, guest speaker and financial modelling specialist Jennifer Harrison from TMT Partners addressed this issue in a presentation of industry standard guidelines for building models.
Jennifer covered financial modelling best practice principles and walked us through how to screen an unfamiliar model. She compared driving a financial model to driving a car, talked about good practices and many bad habits that modellers get into. We looked at some truly awful example of financial models that were very difficult to audit and validate, discussed some horrible circular references, and then we looked at an example of a very well-designed model.
See what Financial Modellers' meetup sessions are running in your area soon!