Chapter 5
Cash flow forecasting of
project finance
In the previous section we looked at how to build projected financial
statements based on historical financial statements, and in turn use the
cash flow statement generated by the spreadsheet to undertake an
analysis about the borrowers future ability to repay credit facilities. This
exercise in turn entailed mastering various supporting component tech-
niques such as net sales projections, historical averages of ratios, manip-
ulating ratios, constructing debt runoff schedules, and making assumptions
about allocation of new money needs. All this is useful when looking at
a company with a historical track record.
There are other scenarios, however, that require cash flow projection
techniques – for example, a merger of two companies, or the case of cre-
ating a special purpose vehicle to build a large-scale construction pro-
ject such as a metro system, airport, road or dam. Here we are also
interested in the use of projections, for example in understanding the
future condition of an entity that a lender may be presently considering
extending finance to. In this case, the key importance in preparing pro-
jections is not only to assess the inherent credit risk but also how to
enhance that risk due to judicious structuring of the financing facility
and identification of negotiating points to enhance that security further.
The underlying data and focus of this analysis will therefore be quite
unlike that in the preceding chapter, and the analytical and construction
techniques will be significantly different.
H6136-Ch05.qxd 9/8/05 10:42 AM Page 160

Get Cash Flow Forecasting now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.