Project Finance Modelling

* Claim back your VAT
Find out more

Request a different date or location for this course (we regularly add courses following requests).


* Claim back your VAT
Find out more


FTS Eligible - Financial Training Scheme for Singaporean citizens and PRs only (more information)

Course objectives

This course will review lessons on valuation, risk assessment and forecasting that can be derived from the financial crisis. Participants will discuss mistakes made in valuing sub-prime loans and other famous valuation errors. This provides context for other subjects in the course.

Summary of course content

  • Valuation lessons from the current financial crisis
  • How structured financial models can be created that clearly define risks and value without being overly complex
  • The fundamental factors that underlie valuation and how can they be used in practice
  • What lies behind multiples such as the P/E and the EV/EBITDA ratios and how these multiples can be used in valuation
  • How to effectively present risk analysis in valuation analysis models
  • Whether Monte Carlo simulation and mathematical techniques can realistically be used to assess risk and compute value
  • The valuation of debt and measurement of debt capacity to provide alternative ways to value investments
  • The creation of models specifically used to evaluate LBOs, project finance and M&A


Case studies, hands-on analysis and template models will be used as the primary teaching tools in the programme. If you are interested in practical mechanics of excel (macros, combo boxes, offset and indirect functions etc.) these can also be discussed after the course.

Other than the instruction in how to build, use and analyse financial models, you will receive a comprehensive suite of financial modeling software on CD that includes a number of template models and Excel add-ins.

The software consists of corporate models that accept historic financial data and generate alternative valuation measures; M&A models that consolidate two companies using alternative financing assumptions and produce accretion and dilution estimates; project finance models that measure the effect of alternative elements in a cash flow waterfall including debt service reserves, junior debt, covenants, defaults and pre-payments; LBO models that measure the debt capacity of a transaction; option pricing models that account for alternative structures; and debt valuation spreadsheets, Monte Carlo simulation models, tornado diagram and sensitivity analysis.

Computer-based exercises

This course will make extensive use of modelling exercises in Excel®
All delegates should bring their own laptops loaded with Microsoft Excel® 2010 or later to facilitate inclass
studies and exercises.

Free CD to take-away

Delegates will receive a comprehensive suite of financial modelling software on a CD that includes a number of template models and excel add-ins.

Pre-course survey

Book early and fill in our pre-course survey to ensure your specific needs are met in the course by the trainer.

FTS Eligible

This programme is approved for listing on the Financial Training Scheme (FTS) Programme Directory and is eligible for FTS claims subject to all eligibility criteria being met.

Please note that in no way does this represent an endorsement of the quality of the training provider and programme. Participants are advised to assess the suitability of the programme and its relevance to participants’ business activities or job roles.

The FTS is available to eligible entities, at a 50% funding level of programme fees, subject to a cap of $2,000/participant/programme and all eligibility criteria being met. FTS claims may only be made for programmes listed on the FTS Programme Directory with specified validity period. Please refer to for more information.

Who should attend

  • Corporate Finance/Corporate Treasury
  • Capital Markets
  • Audit/Product Control/Risk Management/ALM
  • Research and Analysis
  • Sales and Trading
  • Investment Management
  • Origination
  • Securitisation/Syndication
  • Structured Finance
  • Money Markets/Repo
  • Systems Programming
  • Funding
  • Government/Agency Funding and Investment
  • Regulation/Compliance/Documentation
  • Related Courses



    Do you have five or more people interested in attending this course? Do you want to tailor it to meet your company's exact requirements? If you'd like to do either of these, we can bring this course to your company's office. You could even save up to 50% on the cost of sending delegates to a public course.

    To find out more about running this course in-house:

    Our Tailored Learning Offering

    If you want to run this course at a location convenient to you or if you want a completely customised learning solution, we can help.

    We produce learning solutions that are completely unique to your business. We'll guide you through the whole process, from the initial consultancy to evaluating the success of the full learning experience. Our learning specialists ensure you get the maximum return on your training investment.


    We can offer any of our public courses delivered at your office or we can devise completely tailored solutions:

    Read more about our offering or complete a call back request to speak to a learning specialist.


    Why us

    We have a combined experience of over 60 years providing learning solutions to the world’s major organisations and are privileged to have contributed to their success. We view our clients as partners and focus on understanding the needs of each organisation we work with to tailor learning solutions to specific requirements.

    We are proud of our record of customer satisfaction. Here is why you should choose us to help you achieve your goals and accelerate your career:

    • Quality – our clients consistently rate our performance ‘excellent’ or ‘outstanding’. Our average overall score awarded to us by our clients is nine out of ten.
    • Track record – we have delivered training solutions for 95% of worlds’ top 100 banks and have trained over 250,000 professionals.
    • Knowledge – our 150 strong team of industry specialist trainers are world leading financial leaders and commentators, ensuring our knowledge base is second to none.
    • Reliability – if we promise it, we deliver it. We have delivered over 20,000 events both in person and online, using simultaneous translation to delegates from over 180 countries.
    • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 96% on service and 95% on product