Financial Modelling for Project Finance


December 2024

Financial Modelling for Project Finance

Being Positive About Funding

Buy Now »

covers: Microsoft 365

Product Details
  • 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

Where to Buy

MrExcel Bookstore

Print book from IPG.

Amazon

eBook from Amazon.


Related Products


Introduction to Financial Modelling

October 2019

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.


Continuing Financial Modelling

November 2020

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.