Financial Modelling for Project Finance

Overview

PROJECTING PROJECT FINANCE MODELLING. If you have a beginner’s grasp in accounting, finance and Excel, you might be tempted to explore the quantitative, decision-centric world of Project Finance, ring-fencing funding for profitable projects. This book seeks to demystify the area and show how the basic principles of financial modelling, first heralded in An Introduction to Financial Modelling, may be applied and modified here. The book explains “Project Finance” and how it differs from “project finance” at the outset. It then provides various Excel pointers on Excel’s key functions and features, before crafting together the salient points of “Best Practice” modelling. This book is practical: it provides numerous examples including a full case study showing how to model Project Finance, separating the concepts (and modelling) of construction and operations, including delivering a Cash Flow Waterfall, Sources and Uses of Funds, various valuation techniques, plus demonstrating how to create scenario, sensitivity and ratio analyses. A standalone tome where you need not have read the previous volumes, this book includes the usual humour too.

Author Biography

Liam Bastick has over 30 years’ experience in financial model development / auditing. With over 2,000 articles written for the accounting profession, he is a regular contributor to the AICPA, Microsoft’s Excel Blog and various LinkedIn specialist discussion groups. A frequent public speaker, Liam attends Excel and Power BI conferences around the globe and has been a central organiser for the Excel Summit South and Excel Virtually Global. He still follows Derby County and the England cricket team. Poor soul. Oscar Hagan is an experienced model builder and auditor, specialising in Project Finance. He’s built bespoke modelling solutions across a range of industries and sectors for clients throughout the UK, Europe, and Australia. He’s provided clients with in-depth analysis, using a combination of Excel,
VBA, Power BI, and various database analytics. Oscar provides training and produces courses in Financial Modelling and other areas of Excel, which are used by professional accounting bodies around the world.