basket 0 items @ £
View Basket

See-Through Modelling

The Technical Blueprint to Financial Modelling Using Lessons Learned from PFI

By Dominic Robertson

Free eBook with every Print Edition

Claim your free eBook now

Product Information

Format(s): -

ISBN(s): -

Published:

Edition:

Author:

No. of pages:

SKU(s): -

About the Author

Dominic Robertson

Dominic Robertson has been modelling since the mid-nineties and is the founding director of Lazuli Solutions, a firm specialised in building financial models that are accessible to both modellers and finance directors.

Lazuli Solutions provides see-through modelling solutions to existing and new infrastructure projects in the UK and Europe, the UK regulated energy distribution market, ... Read more on Dominic Robertson

Contents Listing

About the author
Preface
Introduction

PART 1 - THEORY
1. Modelling theory
2. Finance theory
3. The language of modelling theory
4. Excel theory
5. Computer theory

PART 2 - PRACTICE
6. Building the model
7. Practical modelling techniques
8. Maintaining the investment

PART 3 - FURTHER LESSONS
9. Lessons from PFI

APPENDICES
Appendix 1 - Links and references
Appendix 2 - Dictionary of terminology, units & abbreviations
Appendix 3 - Keyboard shortcuts
Appendix 4 - Excel functions
Appendix 5 - Business map or quick start sheet
Appendix 6 - The tree analogy

Lazuli Solutions
Index
About the author
Preface
Introduction

PART 1 - THEORY
1. Modelling theory
2. Finance theory
3. The language of modelling theory
4. Excel theory
5. Computer theory

PART 2 - PRACTICE
6. Building the model
7. Practical modelling techniques
8. Maintaining the investment

PART 3 - FURTHER LESSONS
9. Lessons from PFI

APPENDICES
Appendix 1 - Links and references
Appendix 2 - Dictionary of terminology, ...

Jacket Text

Building and maintaining effective financial models

See-Through Modelling provides a solid theoretical and practical basis for becoming an advanced financial modeller in Excel. It gives the theory and practical detail necessary to build and maintain a financial model yourself. This is done with particular reference to project finance and by drawing upon the lessons learned from UK PFI.

In this book Dominic Robertson covers the key aspects of financial modelling, including:

- Financial theory
- Modelling theory
- Excel theory and techniques
- A step-by-step practical guide to building a project finance operating model
- Computer set-up and efficient use
- Keyboard skills
- Macro-economic data collection

He also includes key practical techniques such as how to:

- Greater strategic vision due to vast forecast flexibility
- Lower risk of modelling errors due to standardised modelling
- Decrease reliance on individual analysts due to increased ease of model interchange
- Clear, detailed and holistic modelling function training outline

Learning to build a UK PFI project finance model is an extremely good place to start to learn financial modelling. UK PFI is like the world in miniature with simplified operations and simplified finance but containing all the accounting and cash elements that make for a wide-ranging experience.

See-Through Modelling is for finance directors who are looking for a deeper understanding of the dynamics of their enterprise and those who want to understand the benefits of adopting a see-through modelling strategy within their enterprise. It is also an invaluable resource for aspiring financial modellers in general and project finance modellers in particular.

Enter your email address to receive your free ebook

By requesting this free eBook, you agree to let us email you
about future Harriman House offers. We will not sell your details
to a third party and you can un-subscribe at any time.
A valid email address is required to receive your download link.