Introduction to Financial Modelling

If you have had little formal training in developing financial forecasts in Excel or have ever burnt the midnight oil trying to get a Balance Sheet to balance, then this book is for you. A simple walkthrough of the common perils and pitfalls of financial modelling, this book constructs a solid foundation to build upon (pun most definitely intended). Taking little for granted, Liam examines the common Excel functions and functionalities necessary, emphasises the importance of a standardised and functional layout, explains accounting concepts simply and reinforces the four key concepts of a “Best Practice” model: Consistency, Robustness, Flexibility and Transparency – CraFT. With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a “hands on” book, focused on working with Excel more efficiently and effectively. A simple process, this methodology has been adopted by many seasoned professionals without resorting to balancing figures, circulars and macros.