Financial Modelling and Valuation

Course overview

Investment decisions, loan applications, privatisations and project approvals across the region increasingly rely on financial models. Poorly built models hide errors, confuse decision-makers and lead to costly mistakes. This financial modelling course teaches finance professionals to build clear, integrated models in Excel and to use them to value businesses and projects.

Participants start with good modelling practice: structure, layout, assumptions and error checks. They then build an integrated model that links the income statement, balance sheet and cash flow statement, including debt schedules, revolving credit and circularity. The valuation part covers enterprise and equity value, comparable company and precedent transaction analysis, unlevered free cash flow, terminal value and the weighted average cost of capital, with attention to estimating the cost of equity in frontier markets. The week closes with sensitivity analysis, stress testing and presenting conclusions.

Participants leave with a fully working integrated model and valuation that they can adapt to their own work.

What you will be able to do

• Apply good practice in model structure, layout and error checking
• Build an integrated three-statement financial model
• Model debt schedules, revolving credit and circular references
• Value businesses using comparable companies and precedent transactions
• Perform discounted cash flow valuation with appropriate terminal values
• Estimate the weighted average cost of capital in frontier markets
• Stress-test models and present valuation conclusions

Who should attend

For finance professionals who build or review financial models and valuations. Good Excel skills and accounting knowledge are expected.

• Financial analysts
• Investment officers
• Accountants
• Corporate finance staff
• Credit analysts in banks
• Business development managers
• Public-private partnership units

Course outline

Fees are per participant in US dollars and cover tuition, course materials and your certificate. Travel and accommodation are not included.