This book will teach and
test you on the skills necessary to successfully utilise financial modelling for project
finance.
The size and complexity of a
project's financing requires highly accurate financial analysis. Financial modelling plays
a vital role in charting a project's cash flows. This book takes a practical approach to
what a model should do, how it should be structured, what it should contain and how to
check for problems and deal with any that arise.
Model design, use of data
and layout tips are presented in an easy-to-read format.
Download a worked example to
help you practice your skills.
Four modules discuss:
the project finance
model;
model sections;
debugging, checking and presenting;
sample data, examples and exercises.
Table of Contents:
Workbook One
Introduction
The Need for the Model
Purpose and Uses of the Model
Development over the Project Life
The Need for Flexibility and Clarity
How to Start (and Where to Stop)
Model Design to Maximise Flexibility
Layout
Timeline
Timescale
Consistent Signs
Currency Treatment
Circular and Iterative Calculations
Control/ Identification of Sensitivities
Workbook Two
Data
Worklines, Masks, Factors and Counters
Capital Costs
Finance
Operation
Tariff
Tax
Profit and Loss
Returns
Cover Factors
Cash Balances
Balance Sheet
Cash Flow Summary
Key Inputs and Results Summary
Investment Period Sources and Uses
Annual Summaries, etc
Workbook Three
Introduction
Debugging While Developing the Model
Checking the 'Completed' Model
Presentation
Workbook Four
Introduction
Feasibility
Development
Alternative Deal Examples
5 workbooks