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, ...
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.
Media Enquiries
If you'd like to get in touch with the author for interview or comment,
or you'd like a review copy of this product, please contact us at
pr@harriman-house.com or call +44 (0)1730 269809.
Discounts for bulk purchases and there are premium editions available.
Please contact specialsales@harriman-house.com for a quote.
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.
Enter your email address to receive your free eBook.
Harriman House Ltd will use the information you provide on this form to keep in touch with you and to provide updates and marketing.
Are you happy to receive:
Emails from Harriman House with Harriman House offers
By ticking the box above, you agree to let us email you about future Harriman House offers and offers from carefully selected third parties. We will not pass your details to any other third parties and you can un-subscribe from the emails at any time. A valid email is required for us to send you the download link.
Mailing Permissions
You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at newsletter@harriman-house.com. We will treat your information with respect. For more information about our privacy practices please visit our website. By clicking below, you agree that we may process your information in accordance with these terms.
We use MailChimp as our marketing automation platform. By clicking below to submit this form, you acknowledge that the information you provide will be transferred to MailChimp for processing in accordance with their Privacy Policy and Terms.