Financial Modelling for Project Finance
December 2024
Being Positive About Funding
Buy Now »- 440 pages
- Publisher: Holy Macro! Books
- ISBN: 978-1-61547-086-0
- PDF ISBN: 978-1-61547-172-0
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. It 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.
It’s intended to be practical, providing 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. Apologies if you were after a dull read.
- CHAPTER 0: INTRODUCTION
- CHAPTER 0.1: FILE LOCATION
- CHAPTER 1: WHAT IS PROJECT FINANCE?
- CHAPTER 2: KEY EXCEL FUNCTIONS
- CHAPTER 3: KEY EXCEL FUNCTIONALITIES
- CHAPTER 4: OTHER EXCEL POINTERS
- CHAPTER 5: BEST PRACTICE METHODOLOGY
- CHAPTER 6: LAYOUT TIPS
- CHAPTER 7: TIME SERIES ANALYSIS
- CHAPTER 8: ERROR CHECKS
- CHAPTER 9: MODEL TEMPLATE EXAMPLE
- CHAPTER 10: FINANCIAL STATEMENT THEORY
- CHAPTER 11: CONTROL ACCOUNTS
- CHAPTER 12: EXAMPLE PROJECT FINANCE MODEL BUILD
- CHAPTER 13: FURTHER RATIO ANALYSIS
- CHAPTER 14: SOURCES AND USES OF FUNDS
- CHAPTER 15: VALUATION
- CHAPTER 16: SCENARIO MANAGER
- CHAPTER 17: AND FINALLY...
- INDEX