6
Portfolio Analysis and Cash Flows

6.1 INTRODUCTION

This chapter briefly defines portfolio analysis and outlines portfolio construction, strategy and the concept of bundling projects. Models used in financial markets are then examined. Cash flows and cash flow principles are also outlined and an example of portfolio modelling and its benefits is discussed.

6.2 SELECTING A PORTFOLIO STRATEGY

Ghasemzadeh and Archer (2000) define portfolio selection as the periodic activity involved in selecting a portfolio of projects which meets an organisation’s stated objectives without exceeding the available resources or violating other constraints. The present authors suggest that a corporate body can consider its SBU as part of a portfolio of businesses and similarly an SBU can consider its projects as a portfolio of investments.
Given the investment objectives and the investment policy, the investor must develop a ‘portfolio strategy’. Portfolio strategies can be classified as either a passive or active portfolio.
An active portfolio strategy uses available information and forecasting techniques to seek a better performance than if the portfolio was simply diversified broadly. Essential to all active strategies are expectations about the factors that influence the performance of the class of assets. For example, equity forecasts may include earnings, dividends or price- earnings ratios (Fabozzi 2002).
A passive portfolio involves a minimum expectational input and instead relies on diversification to match the performance of some index. In effect a passive strategy assumes that the marketplace will reflect all available information in the price paid for securities.
Whether an active or passive strategy is chosen depends on the investors’ view as to how ‘price efficient’ the market is and the investors’ risk tolerance.
Figure 6.1 Typical risk/return profile
031
In today’s volatile business environment, it is essential to have an understanding of individual project risk. The notion of ‘no risk, no return’ is widely accepted in the business world. All projects have risk – the zero risk project is not worth pursuing. It is commonly acknowledged that investment projects/programmes that are likely to yield the greatest returns on capital employed are fundamentally likely to be more risky as shown in Figure 6.1.
Therefore achieving the goal of maximising return on capital employed (ROCE) requires an element of risk taking in an environment where risk/return outcomes are increasingly more uncertain. Therefore, successful businesses, portfolios are likely to have effective risk management processes and practices in place that ensure an optimal balance between risk and return as shown in Figure 6.2.
A company in Zone 1 is not taking sufficient risk, and its capital is being underutilised. The company would be advised to increase risk through growth or acquisition or to bring capital down by increasing dividends. In Zone 3, the company is taking too much risk. The level is above and beyond its risk absorption capability in terms of capital and/or risk management capability. In Zone 2, the company has found its optimal portfolio – the ‘sweet spot’ that optimises risk and ROCE.

6.3 CONSTRUCTING THE PORTFOLIO

An efficient portfolio is one that provides the greatest expected return for a given level of risk, or, equivalently, the lowest risk for a given expected return (Fabozzi and Markowitz 2002).
Figure 6.2 Risk adjusted return/risk profile (Pressinger 2005)
032
Indexing projects is a popular passive strategy. A portfolio is assembled that attempts to match the performance of an index. The amount a particular project is worth should be equal to the index it is being compared with.
Cash flow modelling is also a popular method to assess portfolio strategy. Discounting cash flow models begins by projecting cash flows of a project or security over their expected concessional period or life. Then the discounted value (or present value) of each cash flow is obtained by using the appropriate discount rate. The sum of all expected cash flows is the theoretical value of the project or security. It is the theoretical value, or aggregate, that is then compared with the market price or expected value. It can then be decided whether securities are fairly priced or not. In the case of projects the NPV or IRR can be analysed before and during the project’s life to determine the commercial viability of the project or portfolio.
Discounted cash flows can be used to calculate the expected value rather than the theoretical value. This is done by starting with the market price and the expected cash flows. The expected return is then based on the interest rate that will make the present value of the expected cash flow equal to the market price. A more commonly used name for the expected return is IRR. The procedure for computing the IRR involves reiterating different interest rates until one is found that makes the present value of the expected cash flows equal to the market price.
Many organisations have difficulty in assessing the strategic performance of each of their business units and allocating their resources selectively. De Wit and Meyer (1994) believe diversified industries need a formal tool such as portfolio planning.
The following data from the Meta Group’s research (2002) show that a very small proportion of organisations practise effective portfolio risk management:
• 89% of organisations are flying blind with virtually no metrics in place except for finance
• 84% of organisations do not carry out business cases for any of their projects or do them on a ‘select only’ principle (key projects)
• 84% of organisations are unable to adjust and align their budgets with business needs more than twice a year.

6.4 PORTFOLIO OF CASH FLOWS

Projects in general and more specifically construction projects have a cash flow ranging over a period of time from 5 to 25 years. This is known as the life cycle.
Establishing and attaching risks cannot be carried out using modern portfolio techniques. A project is deemed long term relative to securities and future costs and revenues are forecast on the basis of the current economic climate and demand. Project time and cost data can be modelled and future cash flows simulated. Current risk management software packages can attach risks through probabilities or ranges. Such software is widely available; however, the choice of software depends on the economic inputs and outputs used to assess the commercial viability of the project. Cooper et al. (1998) suggest that financial analysis in terms of portfolios is widely undeveloped.
In order to assess a portfolio of projects, specifically through the project’s cash flows, the present authors suggest that a software package capable of assessing the worst, base and best case scenarios is required. It is of paramount importance that the same software is used to assess individual projects as a combination of individual project cash flows.
Software can be used to generate the worst, base and best case cash flows for individual projects. By assigning risks to each project a combination of all the cash flows can be computed as a portfolio cumulative cash flow through the application of a spreadsheet. There is no limit to how many projects the analyst can add to a portfolio. Outputs can include a portfolio cash flow with the identified risks attached for the base, worst and best case scenarios. Economic parameters such as the IRR, NPV, CLU and PB period can be generated. The result is a flexible package which can take into account various changes in the micro- and macro-economic climate. An example of this is shown later in this chapter.

6.5 THE BOSTON MATRIX

The Boston matrix is a management tool developed to assist in portfolio planning. It has two controlling aspects, namely market share (meaning relative to the competition) and the rate of market growth. Each individual product or project in a portfolio is placed into the matrix to determine relative market share. This is simplistic in many ways and the matrix has some understandable problems, but the authors consider that the balanced mix described by Johnson and Scholes (1999) below can be assessed within a portfolio:
• A star is a project where costs are reducing over time.
• The question mark (or problem child) is a project where cost reductions are unlikely.
• The cash cow is a project which is a cash provider.
• The dog may be a project that is a drain on company finances and resources.
In many cases, only projects with robust revenue streams are likely to be financed through the private sector. However, investors with highearning /low-risk infrastructure stock may be willing to accept less attractive stock (piggybacking) which may offer rewards in the long term (Merna and Smith 1999).

6.6 SCENARIO ANALYSIS

Scenario analysis is a derivative of sensitivity analysis, which tests alternative scenarios as options. When undertaking a scenario analysis the key variables are identified together with their values (Flanagan and Norman 1993). The present authors suggest that a financial engineer may wish to assess a number of different financial instruments in a portfolio of projects. If the instrument of choice is debt then the scenarios will be based on the most likely, optimistic and pessimistic forecasts of three possible interest rates. The results will represent the range of possible outcomes. The effects of these changes in one project can then be assessed with changes in the portfolio of projects.

6.7 DIVERSIFICATION

Pollio (1999) states that diversification is used to minimise the risk of the overall loan portfolio and thus stabilise interest income. Diversification is the key to the management of portfolio risk because it allows investors to lower portfolio risk significantly without adversely effecting return.
The authors believe both the above statements to be relevant when defining diversification.
Depending on an organisation’s current financial position and future needs, the organisation would most probably hold money in a number of investments, which together form a portfolio. Some funds would go into low-risk, fixed interest, easily liquidated savings accounts or securities, and the remainder might go into high-income capital growth securities according to need. The attraction of sinking all funds into one security is that it may realise a high return on the investment; however, there is also a danger that all the investment could be lost if the security is risky. Investing in more than one security, therefore, does not necessarily reduce the risk.
Correlation is the glue that allows investors to aggregate returns on individual assets into a return for the portfolio. This is the process of identifying how the risks in the portfolio are related to each other. If two risks behave similarly – they increase for the same reasons or by the same amount – they would be considered highly correlated. The greater the correlation of identified risks in the portfolio, the higher the risk. Correlation is a key concept in risk diversification. Correlation can range from −1.00 to 1.00. For example, a portfolio with a correlation of 1.00 means that its returns move in the same direction as the index, whereas a correlation of −1.00 means that it moves in totally the opposite direction to the index. Ideally, a company should look to select portfolios that have varying degrees of correlation amongst themselves.
If several investments are in the same related industry, and their cash flows react in a manner similar to changes in the general economy, the investments are said to be positively correlated. Figure 6.3 illustrates that changes in cash flow ‘A’ are reflected closely by cash flow ‘B’. Clearly, there is no reduction in risk from combining such investments.
When the cash flows of two investments behave in exactly opposite ways within the same economic climate, the correlation between the two is said to be negative. Risk is reduced by this combination in a portfolio. Figure 6.4 illustrates that equivalent amounts are invested in ‘A’ and ‘D’. The result is that rising and falling cash flows are combined to yield the smoothed-out return ‘C’ over time.
Figure 6.3 Positively correlated cash flows
033
Most securities and business projects are nearer to positive than negative correlation, although they are very rarely perfectly correlated. Therefore there will always be some benefit in combining projects of an unlike nature in terms of risk diversification.

6.7.1 Diversification of Risk

Portfolio managers need to be concerned with the different stages in maturity of the portfolio, which varies according to the sizes of the projects, the geographical location of the projects, the different stages each project is at within the portfolio, the operational track record of each project, and the experience and creditworthiness of sponsors and counterparts (Silk et al. 2002).
It is clear that the diversification of risk profiles between the projects within a portfolio allow sponsors to finance more economically. Projects with strong revenues may offset and diversify the risk on those that have less robust cash flows. In terms of addressing individual risks of projects, lenders demand a higher level of interest to protect their investment. In some cases higher DSCRs are required and enhanced sponsor support, especially where construction risk is identified.
Figure 6.4 Negatively correlated cash flows
034
Figure 6.5 Interdependencies of projects within a portfolio
035
Figure 6.5 illustrates how a portfolio can, through cross-collateralisation, support a project in the event of a negative impact or a number of projects in the portfolio. Cross-collateralisation is discussed further in this chapter.
However, contracts binding the portfolios should contain clauses allowing projects to maintain some degree of independence, so in extreme cases external influences do not affect the whole portfolio.

6.8 PORTFOLIO RISK MANAGEMENT

There are two reasons for adopting portfolio risk management:
1. Risks inherent in projects cannot be separated from the aspects of general business management.
2. All projects are unique, therefore risk and uncertainty belong to a significant part of project business. Whether or not these risks are brought through to the portfolio is a different matter.
As far as the risk management associated with project portfolios is concerned, there may be several aspects in analysis and making strategic choices associated with the projects at the strategic business level. For example, for an organisation operating in international markets, country and area and specific local risk need to be taken into account. The country risks may not affect a project alone, but may affect the whole portfolio indirectly (Ariani 2001). Country risks are discussed in Chapter 4.
Particular geographical regions, customers, product types, lines of business and other important aspects can serve as criteria against which project portfolio risk should be considered, such as the local creditworthiness of different project portfolio areas of an organisation.
The process of portfolio risk management is very similar to project risk management. It consists of the following stages:
• risk identification
• risk classification
• risk analysis
• risk response.
Portfolio risk management can have the following benefits:
• Reduces the cost of capital by managing portfolio risk rather than individual project risks.
• Reduces the risk of projects from developing their own inertia and boundary definition.
• Increases the awareness of the critical risks by senior managers.
• Reduces project overrun and overspend.
• Identifies which risks exploit competitive advantage.
• Protects and enhances shareholder value.
The authors suggest that portfolio risk management should first consider the risks associated with the economic parameters of each project within the portfolio and project interdependencies before assessing the portfolio of projects as one entity.

6.8.1 Bundling Projects

Dybvig (1988) first used the term bundling to represent the particular consumption of a bundle of similar commodities, in this case electricity, purchased from different electricity generating organi-sations. The distribution price of the bundle is determined by setting a margin above the purchase price(s) and then developing an average sale price that the market will bear for sale to consumers. The word ‘bundling’ is used today throughout the business world and in particular in private finance initiative (PFI) projects.
Bundling is the grouping of projects or services within one project structure in a manner which enables the group to be financed as one project. Porter (1987) suggests that projects with similar characteristics and interdependencies can be aggregated as a bundle of projects rather than disaggregated stand-alone projects. The key benefits are that this allows small projects to be financed by increasing the overall debt within the bundle to an economic level and allows various projects to cross-collateralise each other. Key issues are that cash flows from the single project are robust (a single cash flow is often preferred) and the liabilities of each party, particularly those of the public sector partners, are adequately addressed in the event of, for example, partial or full termination (Frank and Merna 2003).
Many possibilities of bundling are being considered. Some initiatives involve the construction, refurbishment and operation of projects into manageable bundles; these are often described as batches (Public Private Partnership-Initiative NRW 2003). However, bundling can also involve bringing together pre-existing projects and refinancing/restructuring them by using financial resources more efficiently. Examples include providing lower interest rates than those currently in place and extending the term of original debt (Foster 2002).
In September 2004, the Irish-based bank Depfa bundled £394 million of PFI loans relating to 25 PFI schemes into a specially created financial entity. Floating rate notes will be issued against £31.75 million worth of this debt, while £358 million of it will be matched by a credit default swap, a financial derivative that provides what amounts to insurance cover for the credit risk. The floating rate notes will be issued in six trenches with preliminary ratings by credit rating agency S&P, ranging from AAA to BB (Financial Times 2004).
The private sector should be more willing to invest in schemes with greater than critical mass, as such schemes bring greater scope to offer innovation and deliver more cost-effective solutions in terms of finance, capital, life cycle and operational costs. Bid costs per project reduce as the number of projects increase (McDowall 2001, Lamb and Merna 2004a).
Projects can also be considered for refinancing. This is particularly true of projects where construction has been completed and certain risks have passed. A more favourable rate of financing can then be negotiated.
Loan refinancing, bond refinancing, leasing, and debt to equity swap are identified by Merna and Njiru (2002) as ways of finance restructuring. Refinancing is defined as repaying existing debt and entering into a new loan, typically to meet some corporate objective such as the lengthening of maturity or lowering the interest rate. In other words, refinancing involves paying off an existing loan with proceeds from a new loan, using the same property as collateral. Similarly, in some cases, corporate bonds with a long maturity and identifiable coupon payments can be issued to refinance short-term loans.
There are two situations where the project needs to be refinanced or restructured. First of all, if the current interest rate is lower than the rate on the debt, refinancing may be considered so that short loans can be rolled over into longer-term maturity loans. Secondly, if a project is having difficulties in generating sufficient revenues the promoter has to restructure its financing techniques to maintain its project financial viability. When the project is facing difficulties but has great potential for growth the debt to equity swap technique can be employed. The benefit of debt to equity swap is reducing the level of debt payment so the project can be given sufficient time to overcome such difficulties.
The authors believe, in the capital-incentive refinery industry for example, that when the final financial package has been determined, the borrower can look at the prospects of refinancing a particular facility after the completion of the project; similarly; the promoter also needs to consider the refinancing risk if the project risks such as delay or cost overrun occur. This can be assessed by the cash flow modelling which is discussed later.
Consideration could be given to bundling projects for refinancing to provide larger debt. This allows alternative methods of financing to be considered. Construction companies could refinance to provide them with an exit strategy once the project is up and running (PFI Fact Sheet 2003).
Although there are many advantages of bundling projects, if the projects are not managed properly costs will be a lot higher than expected because of the multiplier effect (Munro 2001). Paddington Hospital, the government’s largest PFI hospital scheme which involved bundling three hospital schemes, was estimated to cost £360 million, but because of redesign, inflation and mismanagement, the costs are expected to exceed £1 billion (Leftly 2003).
Capital markets’ funding will tend to concentrate on larger projects and is therefore not available as an option for smaller projects. The transaction costs on projects with a capital value of around £10 million can be disproportionately high and severely affect returns and value for money (VFM) (McDowall 2001, Spackman 2002).
Bundling projects can provide cash flows sufficient to produce a reasonable return after operating and debt service costs are addressed. It can also spread the risk for funders between different projects and locations. Smaller projects that would not be economically viable individually may be economically viable when in bundles (Frank and Merna 2003). The present authors suggest that bundling projects can allow ethical, non-commercially viable projects to be procured through cross-collateralisation of funds.
Benefits of bundling to the public sector include:
• single contract for construction
• simplified monitoring
• simplified payment.
Benefits of bundling to project management according to Frank and Merna (2003) and Lamb and Merna (2004a) are:
• effective use of resources, one project team, one set of advisers
• simplified chain of reporting/command
• improved VFM
• economies of scale
• replicability
• economies through innovative finance, such as the use of bond financing with larger deals
• spread procurement and transaction costs.
Bundling projects consolidates operational, financial and strategic activities into one package. This is an option governments are now considering in order to sanction smaller PFI projects. However, the task can be difficult. Public-private partnerships (PPPs) often involve the private sector partner providing a bundle of services such as the design, construction, operation and maintenance, and both soft and hard services. Bundling thus differs from traditional contracting out whereby separate contracts are let for each service. Bundling can provide VFM which cannot be obtained by contracting services separately. Integration of design, operation and maintenance over the life of an asset, within a single-project finance package, improves performance and reduces project life costs (McDowall 2001).
When considering bundling a group of projects the opportunity cost of capital should be taken into account. This is ‘the highest price or rate of return an alternative course of action would provide’.

6.8.2 Considerations

Bringing projects together for financing, however, must consider the following issues (Frank and Merna 2003):
Different commencement times. If projects have staggered commencement times the project company will not want to borrow until funding is needed. This could happen when planning permission is delayed on one of the sites of the project.
Partial completion. If one part of the project is completed before the others then the project company will want services to start in that area first before the other areas are completed.
Partial termination. The project may falter in one area. This does not necessarily mean the whole project is not viable – the viable parts could still go ahead. The project company would need to ensure that the funders were in agreement and that the financial viability of the overall project was not affected.
Variations. Bundled projects may be more prone to variations or changes and additional debt may need to be raised to cover this.
Each of these complexities needs to be addressed in both the project and financial documentation.

6.8.3 Bundling Projects into a Portfolio

Figure 6.6 illustrates how a project or bundle of projects transpires from an idea by the principle through to the financing of the venture.
The bundle could be funded by one ‘lead bank’. However, depending on the risks and the size of the bundle, the loan could be syndicated through a number of banks, therefore reducing the risk to the lead bank (Frank and Merna 2003).
Figure 6.6 The lending ladder
036
Projects 1 − n must have cash outflows and generate revenue streams over defined concessional periods. Different financial instruments will be used depending on the project size and the prevailing economic climate (Frank and Merna 2003, Merna and Young 2005).

6.9 CROSS-COLLATERALISATION

Most projects are traditionally procured on a standalone or stranded basis, their commercial success being dependent on the revenues generated by the project’s assets, although projects procured using corporate finance often receive financial assistance from the corporate body when they suffer short-term liquidity problems. In standalone projects it is prohibited to offset gains and losses from one project to another. When projects are bundled together in a portfolio, cross-collateralisation can take place by combining project cash flows over the length of the concession or by one project’s revenues cross-collateralising with another project’s over a specified duration before combining cumulative cash flow in a portfolio.
A typical definition of cross-collateralisation is when collateral for one loan also serves as collateral for other loans. For example, in real estate situations cross-collateralisation can occur when a person already owns a house, and wants to buy another one.
The authors define cross-collateralisation as:
The use of funds generated by one project with strong cash flows within a portfolio, to fund another project within the same portfolio, which may be experiencing cash flow difficulties and defaulting on debt repayments.
Cross-collateralisation is a relatively new expression. It is basically the use of collateral generated from one project to fund another project that may be experiencing cash flow deficiencies, and thus unable to service debt payments, in terms of principal and interest. These deficiencies may arise from the numerous risks a project is susceptible to over its life cycle.

6.10 CASH FLOWS

Cash flows are a measure of a project’s health. They are simply cash receipts minus cash payments, over a given period of time. It is the cycle of cash inflows and outflows that determines business solvency (Turner 1994).
Cash flow management is the process of monitoring, analysing and adjusting business cash flows. The most important issue of cash flow management is to avoid extended cash shortages, specifically lack of liquidity at any given time over the project life cycle. To avoid these shortages cash flow management needs to be performed on a regular basis. Cash flow forecasting can be used to head off cash flow problems. Most project accounting programmes have built-in features to make forecasting quicker and easier. Cash flow management requires the development and use of strategies that will maintain adequate cash flow within a project (Hwee and Tiong 2001).
Cash flows are generated from a cycle of business cash inflows and outflows, with the purpose of maintaining adequate cash for a project, and to provide the basis for cash flow analysis. This involves examining the components of a business that affect cash flow, such as accounts receivable and payable (counter-party risk), credit terms and finance payments. By performing a cash flow analysis on these separate components, cash flows can be managed. Smith (2002) suggests that the success of a venture is largely dependent on the effort expended during the appraisal stage preceding sanction. The authors concur with Smith and suggest that cash flows and their associated risks are paramount to the appraisal stage.
Figure 6.7 Cumulative cash flow curves of a typical base case for discounted and non-discounted inflows and outflows of cash
037
The authors describe a cash flow as a financial model of the project. In its simplest form a cumulative cash flow can provide vital information to a manager. It is concerned with the flow of money in and out of the account per unit of time. The net cash flow is the difference between cash in and cash out. In its cumulative form it is described as the net cumulative cash flow (Ye and Tiong 2000). A cumulative cash flow curve is a graphic presentation of the flows of money mentioned above. The cumulative net cash flow curve depicts net project cash outflows as a negative function and net project cash inflows as a positive function. This represents the true nature of project cash flow: an outflow results in a negative cash position and an inflow results in a positive cash position.
Figure 6.7 illustrates the cumulative cash flow of a typical base case for discounted and non-discounted inflows and outflows of cash from the following economic parameters which can be computed:
• NPV
• IRR
• IRR
• PB
• maximum CLU
• discounted net return
• discounted PB period
• discounted CLU.
The base case cumulative cash flow is defined by Esty (2004) as the cash flow projection with variables measured at their expected values; that is, a cash flow that is not subjected to any risks over its life cycle.

6.10.1 Cash Flow Definition for Portfolios

The authors define a cash flow as an external flow of cash and/or securities (capital additions or withdrawals) that is client initiated. Transfers of assets between asset classes within a portfolio or manager-initiated flows must not be used to move portfolios out of composites on a temporary basis. The cash flow may be defined by the organisation as a single flow or an aggregate of a number of flows within a stated period of time. In cases of multiple cash flows over an extended period of time, organisations should refer to the discretion section of the guidance statement on the definition of composites and consider whether the portfolio should be classified as non-discretionary.
Figure 6.8 illustrates the effects of combining base case cumulative cash flows. Figure 6.8(c) illustrates the cumulative base case cash flow of combining the base case cash flows of Project 1 and Project 2 illustrated by Figures 6.8(a) and (b) respectively. New economic parameters can now be computed for the combined base case cumulative cash flows which can be described as a portfolio of two projects.
Many organisations use this method of combining base case cash flows to assess the economic parameters of a combination of project cash flows. This method does not, however, take into account risks associated with individual projects and only provides a basic approximation for decision making.
Currently many organisations use the red line method for assessing the commercial viability of the portfolio. This typically involves computing a worst case scenario for the portfolio cash flows by assuming a risk range, for example 10% negative risk, illustrated by a red line below the base case cumulative cash flow of the portfolio.
Figure 6.9 illustrates the base case cumulative cash flow of a portfolio and the red line case below it. The area between the two curves is deemed to be robust in terms of meeting a minimum acceptable rate of return. Should the base case cumulative cash flow fall below the red line, decisions can be made to reassess individual projects as part of the portfolio.
Dealing with large, external cash flows in a portfolio is a common struggle for most investment managers. These large flows, of cash and/or securities, can have a significant impact on investment strategy implementation and, thus, on a portfolio’s and composite’s performance.
Figure 6.8 Cumulative combined base case cash flow for (a) Project 1, (b) Project 2 and (c) Projects 1 and 2
038
Figure 6.9 Comparison of the red line (lower curve) cumulative cash flow
039

6.10.2 Reasons for Choosing Cash Flow Curves

A project or portfolio is a commercial venture. All the important parties associated with a project, such as the promoter, the contractor and the providers of capital, invest in the project with the aim of achieving some desired benefits or returns. Normally the most important financial objective is always profitability and liquidity. Smith (1975) suggests that profitability implies making an adequate return on the capital and assets employed in the enterprise, whereas liquidity implies an adequacy of cash flows to enable the unit to pay its way and ensure continuation of the operation. Financial management in a business hinges on the management of cash flows. Whether or not a business survives is a matter of suitable cash flows, rather than profitability, which is realised at a later stage in any project. Profitability is dependent on the cash flow. Good management of a project is, therefore, not only dependent on achieving the triple constraints of specification, budget and schedule but is also dependent on being able to manage the liquidity (cash flow) of a project. Cash flow curves are highly sensitive to changes in project conditions and therefore can act as an early warning system, in case of problems, to help initiate proper rectification measures, for example, a change in the design of the project which increases or decreases the project cost, delays leading to cost overruns, fluctuations in the interest rate affecting the cost of capital used and fluctuations in the input and output costs can be easily depicted on a cash flow curve.

6.10.3 Projects Generating Multiple IRRs

Some project cash flows can generate NPV = 0 at two different discount rates (Brealey and Myers 2000). An investment project in which the summary cash flow numbers are characterised by alternating cash inflows and outflows can have more than one, or multiple, IRRs. Projects can be denoted by (− +, −) or (+, − +) where the signs correspond to the sequence of the cash flows. There can be as many IRRs as there are reversals in the direction of cash flow (Werner and Stoner 2002). In projects procured by project finance an existing revenue, followed by a cash outflow and a further revenue, may form part of a concession contract (Merna and Smith 1996). Figure 6.10 illustrates the cumulative cash flow of such a project.
Figure 6.10 Cumulative cash flow-generating multiple IRRs
040
Typically a project generating two positive IRRs and a positive NPV is considered to be commercially viable.

6.10.4 Model Cash Flow

The following five stages to build a model cash flow curve are recommended by the present authors:
1. Compile the base case cash flow simply by adding the costs and revenue over the entire life cycle of the project or contract.
2. Refine the base case cash flow to take account of delays between incurring a commitment and paying or receiving the money.
3. Calculate the resulting cost and benefit together with the investment required.
4. Consider the risk and uncertainty.
5. If necessary, examine the implications of inflation.
The model cash flow curve depicts the forecasted pattern of money inflows and money outflows, in money terms or real terms, of the accounts of the project during its life. However, it is not realistic to expect a very high degree of accuracy in any financial prediction based on this cash flow because it uses certain assumptions and estimates. In order to overcome this problem, normally a range of possible changes in the cash flow, both beneficial as well as adverse, as a result of risks and uncertainty, are built into the model. This provides a band around the model cash flow.
Figure 6.11 Risk envelope for project or portfolio
041
Cumulative cash flows can be developed to show the worst, base and best case cumulative cash flows of projects or portfolios. Figure 6.11 illustrates the envelope bound by the worst and best case cumulative cash flows. The closer the curves of these worst and best case cumulative cash flows, the less risk or uncertainty is assumed in the project or portfolio. A robust finance package is one that will service principal, interest, dividends and coupon payments for any economic outcome that may occur within the risk envelope.

6.11 AN EXAMPLE OF PORTFOLIO MODELLING

The following example uses a risk management software package based on Monte Carlo simulation to generate worst and best case scenarios from risks identified by the techniques discussed in Chapter 4.
Figure 6.12 illustrates the probability of a project’s/portfolio’s cash flow over a certain period of time.
The trend line of the cash flow can be produced as follows:
1. Set each year’s cash flow as a forecast.
2. After completing a simulation of cash flow forecasts for each year a trend chart illustrating the certainty ranges of all the forecasts can be prepared as shown in Figure 6.12.
3. The choice of certainty bands can be determined to suit requirements. Trend charts display certainty ranges for multiple forecasts in a series of bands. Each band represents the certainty ranges into which the actual values of forecasts fall. For example, the 50% band shows that the cash flow has a 50% chance of being in this range.
Figure 6.12 Trend chart of probabilities in terms of cumulative cash flow over time
042
Analysing projects on a project-by-project basis is a relatively simple operation. Many software packages exist which can accommodate the financial appraisal in terms of economic parameters and carry out sensitivity and risk analysis, using Monte Carlo simulation. The financial analysis of these bundled projects can be considered as a portfolio of projects. Each individual project will have different cost and revenue implications and be subjected to different risk scenarios. When projects are considered individually some may be commercially viable as standalone projects and others may not be commercially viable on a standalone basis. However, when the projects are bundled together the overall portfolio of projects may meet a promoter’s MARR (minimum acceptable rate of return) and be deemed commercially viable. These non-commercially viable projects can, however, be financed by cross-collateralisation of funds to make them viable as part of a portfolio of projects.
Traditionally the commercial viability of a portfolio of projects has been assessed on the correlations between returns when calculating the portfolio standard deviation (Cuthbertson and Nitzsche 2001) or on a project-by-project basis. The present authors, however, have developed a financial risk mechanism to provide economic parameters based on risk ranges for a portfolio of projects by combining an existing risk management program with spreadsheets. The outputs from the program and spreadsheets indicate the economic parameters of the base, worst and best case scenarios of the portfolio of projects in terms of economic parameters illustrated by cumulative cash flows as one project.

6.11.1 Financial Instruments

As discussed in Chapter 5, individual projects are typically financed by a combination of financial instruments that often include debt, mezzanine finance (bonds) and equity. Merna and Khu (2003) state that the types of financial instruments available for project financings have always been of concern to investors and promoters. In many infrastructure projects the debt-equity ratio is seen to be a measure of the risk in a project, the greater the risk the greater the equity contribution. In effect equity, particularly ordinary equity, can be described as risk capital in project financings.
The modelled portfolio of projects will identify the economic parameters based on individual project financing. The financing of individual projects can be reassessed by substituting debt for equity to determine the effect on the portfolio of projects. Economic parameters of the amended portfolio will reflect such changes in individual project financings. For example, an individual project may be deemed to be sufficiently risky to require equity in its financing, but when considered as part of a portfolio of projects cross-collateralisation can be used to service debt rather than a potentially more expensive equity contribution. Clearly the financial instruments used in individual projects can be reassessed once the economic parameters of the portfolio and associated risks have been identified.

6.11.2 Development of the Mechanism

The mechanism depends on the identification of the following outputs:
• CLU
• NPV
• IRR
• PB.
Each project P1 to Pn is assessed on the basis of an individual project. Typically these are based on a network of project activities which are time and cost related. The software is used to assess the economic parameters of the base case without risks being considered. Ranges representing risks are then attached to activities in the network to determine the sensitivity of each activity to risk and a probability distribution is computed. Each project is assessed in a similar way (Merna and Khu 2003).
The outputs in terms of worst, best and base case can be combined to determine the overall economic parameters of the portfolio of projects. The economic parameters can then be assessed to determine the commercial viability of the portfolio rather than of the individual project.

6.11.3 Spreadsheets

6.11.3.1 Financial Modelling in Excel

With advances in technology and improvements in Excel itself, Excel has become the preferred tool for creating all but the largest and most computationally intensive financial models. The advantages of Excel for financial modelling are numerous and are discussed in Chapter 5. Excel’s application for business management and analytical requirements has several benefits which are useful within a business environment, these include:
Familiarity – Most business professionals are already familiar with the Microsoft Excel application. This translates into a faster acceptance and shorter learning curve to users presented with an Excel-based solution disseminated within an organisation.
Customisation – The flexible nature of Excel makes applications developed with it relatively easy to customise to specific end user requirements. Such customisation may be accomplished within the applications themselves or, where application is protected or locked, through separate workbooks and modules that interact with the main application.
Scalability – The abilities to link formulas and call compiled modules from separate workbooks in Excel make developed solutions scalable to meet growing demands of analytical (especially banking) requirements. As business needs evolve over time, additional functionality can be developed and integrated with the original application.
Interoperability – With the proliferation of Microsoft Office as the choice of operating software for many organisations worldwide, Excel-based solutions can interoperate with other Office applications both within and between organisations.
Figure 6.13 Straight-line interpolation of base case cumulative cash flow
043
However, despite its power, Excel has many limitations, and there are many financial models – some even relatively simple ones – that either cannot be created in Excel or will be overly complex or cumbersome to create in Excel. What’s more, when you create a highly complex model in Excel, it can be difficult to understand, debug and maintain (Sengupta 2004).
In this case study portfolio the development of spreadsheets is based on an approximation of the cumulative cash flow curves. The risk simulation output data form the basis of the model. Through a straight-line interpolation between the four points – Start, CLU, PB period and NPV – each project is represented by three activities as illustrated in Figure 6.13. The cumulative cash flow for the worst, base and best cases are developed stochastically.
The outputs from a portfolio of projects can then be illustrated on a spreadsheet. The economic parameters for the base, worst and best case are then computed. The output shows the commercial viability of the portfolio rather than of individual projects. The envelope created within the best and worst case cash flows indicates the riskiness of the portfolio compared with the base case cash flow.
It is possible to create different scenarios by changing project start dates, or to assess interdependencies by reprogramming individual projects and adding or subtracting individual projects to determine the effect on the portfolio. The complexity of the spreadsheet is dependent on the risk practitioner’s experience.
Figure 6.14 summarises the bundling mechanism stages.
Figure 6.14 Mechanism for portfolio assessment
044

6.11.4 A Portfolio of Oil and Gas Projects

The example used involves the construction of seven new projects and the refurbishment and operation of eight existing facilities. The projects are to be procured using project finance. The cost of constructing seven new projects is estimated at £956 484 900 and the cost of the refurbishment of the eight existing facilities is estimated at £290 000 000.
Table 6.1 shows the individual and total construction, finance, operation costs and revenues (£ × 10) of the 15 projects. The debt to equity ratio for all 15 projects in the portfolio is approximately 89:11. This would not be considered a risky portfolio due to the small equity, risk capital contribution. Projects 9, 11 and 15 are seen to have no equity contribution at all and thus perceived to have minimum risk. Projects 4 to 7 inclusive have a debt to equity ratio of 90:10, implying there is a small amount of risk in these projects. Projects 10, 12, 13 and 14 have debt to equity ratios of 80:20 meaning that they are perceived to be the riskiest projects in the portfolio. If these latter projects sought finance individually they may not be financed due to their individual risk. Under a portfolio, however, risk in these projects is diluted due to the strength of the less risky projects, particularly in their ability to generate revenues.
The 15 projects were individually modelled in a program based on Monte Carlo simulation to determine their economic parameters and associated upstream and downstream risks. The economic parameters are then assessed using the bundling mechanism developed by the authors.
Forecasting is an essential part of the preparation of any economic evaluation as it is based upon the best information available at any given time. It is often necessary to alter the forecast from time to time as information or conditions change. These changes can be simulated to determine the optimistic and pessimistic scenarios.
The authors developed two batches of projects, these being the seven new projects and the refurbishment and operation of eight existing facilities. Table 6.2 gives the economic parameters for the seven new projects procured as a batch.
The eight refurbished facilities were also developed as a batch. The economic parameters of this batch are given in Table 6.3.
The batch of new projects is commercially viable having worst and best case IRRs of 20.65% and 26.10% respectively as shown in Table 6.2.
In the refurbished batch of projects the IRRs of the worst and best cases, that is 5.82% and 11.73% respectively as shown in Table 6.3, are not commercially viable since a promoter would expect an MARR of at least 15% IRR.
Table 6.1 Individual and total project costs and revenues
045
Table 6.2 Worst, base and best case economic parameters for a batch of seven new projects
046
However, by procuring the 15 projects in a portfolio as given in Table 6.4, the relative strengths of combining the batch of the seven new projects with the batch of eight refurbished projects, a commercially viable portfolio can be achieved.
By combining the two batches of projects into a portfolio it can be seen from Table 6.4 that the worst case IRR is 18.07% and the best case IRR is 23.28%. Clearly the combination of the batches results in a commercially viable portfolio in terms of meeting a higher MARR.
Figure 6.15 illustrates the cumulative cash flows of the portfolio. The cash burn rate of the base case is approximately £316.0 million/year and the PB period is 7.02 years. The steepness of the cumulative cash flow line from the 3-year CLU point to the 7.02-year PB point shows that there is very little chance of liquidity risk in this portfolio as revenue generation can meet operational costs and service debt.
Table 6.3 Worst, base and best case economic parameters for a batch of eight refurbished facilities
047
Figure 6.15 Cumulative cash flow for a portfolio of projects (worst, base, and best cases)
048
The portfolio can now be expressed in terms of a project of three activities, namely cash expenditure, revenue generated to PB, and PB to NPV as shown in Figure 6.11. Once the projects have been combined to make a portfolio they can be assessed using sensitivity and probability analyses. Figure 6.16 illustrates the sensitivity of the portfolio’s economic parameters of PB, CLU and NPV in relation to the IRR. Figure 6.17 illustrates the portfolio ‘S’ curve in relation to the portfolio IRR. Sensitivities and probabilities can also be carried out in relation to the NPV, CLU and PB. In both cases the more inelastic (steeper) the curves, the less sensitive the variables are to perceived risks.
Figure 6.16 Sensitivity analyses for portfolio shown in Table 6.4 for economic parameters CLU, PB and NPV in relation to IRR
049
Figure 6.17 Probability analyses for portfolio shown in Table 6.4 for economic parameters for mean, best and worst cases in relation to IRR
050
Figure 6.17 illustrates an approximation of the risks associated with the outcome of the IRR. In this case the worst case gives an IRR of approximately 18% and a best case of 23% as given in Table 6.4.
The mechanism developed by the authors clearly illustrates the best, worst and base case economic parameters and cumulative cash flows of a portfolio of 15 small oil and gas projects. The authors have shown how the mechanism in conjunction with a risk management program combined with spreadsheets can be used to combine individual projects or batches of projects to produce a portfolio.
Table 6.4 Worst, base and best case economic parameters for a portfolio of 15 projects
051
The eight refurbished facilities are considered unviable both in terms of individual projects and as a batch of projects. However, when combined with a commercially viable batch of projects, the overall viability of the portfolio is shown to be commercially viable as it exceeds the MARR desired.
The output mechanism depends solely on the NPV, CLU, PB period and relative start date of individual projects. The mechanism can be used by stakeholders such as lenders, insurers, constructors or promoters to assess their returns from the portfolio. Promoters and constructors will find the mechanism extremely useful when deciding whether to bid for a portfolio of projects.
The mechanism, in its simplest form, provides an effective method for assessing portfolios or programmes of projects that have a project period followed by a revenue generation period. The mechanism allows the user to add or subtract costs or revenues during any period over the portfolio project and thus provides a strategic project tool. The start date of any individual project or number of projects can be changed to determine the effect on the portfolio’s economic parameters. If, for example, the start date of one individual project is moved forward by two years then the CLU may be reduced.
Sensitivity analysis can be used to identify the most sensitive projects or activities prior to probability analysis. It is also possible to consider a portfolio of projects with no financing element attached to any individual project and then assume financing the portfolio as one project and thus to determine the base, best and worst case scenarios based on this financial package.

6.12 SUMMARY

Within any portfolio the potential for uncertainty increases with the breadth of the portfolio and the range of the projects or investments. The level of interdependencies and interrelationships will also affect the potential for positive or negative risks.
Portfolio selection and strategy, scenario analysis and diversification, and portfolio risk management were discussed in this chapter.
Considerations of bundling projects and financing bundles were also examined. The benefits of cross-collateralising projects within portfolios were discussed and how cross-collateralisation can be used in portfolios of projects to improve economic parameters.
Cumulative cash flows, how they are developed and how economic parameters are computed were also discussed. A number of examples of how cumulative cash flows are combined to assess a portfolio’s base case were discussed and suggestions for modelling portfolio cumulative cash flows presented.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.190.217.139