Project Finance Modelling

2 - 3 June, 2008
London

By attending this practical two-day course delegates will understand and be able to apply the principles of good modelling practice and will be competent in preparing a simple cash flow model.

Concepts

• The principle of error reduction
• The top-down approach to developing models (“design the outputs first”)
• The separation of inputs from workings and outputs
• The avoidance of complex formulas
• The issues concerning the use of range names
• Use of left-to-right consistency in formulas
• The significance and use of the balance sheet.

• Copying formulas (Ctrl+R)
• Editing formulas (F2)
• Checking formulas
• Navigating around the model
• Creating, using and managing range names
• Saving files
• Sensitivity analysis