Financial Modelling Using Excel Training Course

Course Overview

Learning Objectives

• Analyze historical financial statements and identify the key inputs and business drivers required to build a financial model using Excel during the first day of the course.
• Develop a structured financial model using Excel that connects operational assumptions with financial results by the end of the program.
• Apply practical techniques to forecast revenue, operating costs, profitability, working capital, capital expenditure, and cash flow.
• Design a clear financial model structure that separates inputs, assumptions, calculations, outputs, and controls.
• Build integrated linkages between the income statement, balance sheet, and cash flow statement using Excel.
• Apply appropriate Excel financial and analytical functions to improve the efficiency and accuracy of financial modelling.
• Develop base, upside, and downside scenarios and assess their impact on financial performance.
• Perform sensitivity analysis and stress testing to evaluate the impact of changes in key assumptions on financial results.
• Improve model integrity by validating formulas, checking linkages, identifying errors, and testing model consistency.
• Prepare and present a complete Excel-based financial model that supports financial planning, forecasting, investment analysis, and management decision-making during the final workshop.

Who Should Attend

Learning Outcomes

• Explain the principles and applications of financial modelling using Excel in corporate and institutional environments.
• Organize and analyze historical financial and operational data and identify key performance drivers.
• Build a structured Excel financial model containing inputs, assumptions, calculations, outputs, and control mechanisms.
• Develop forecasts for revenue, operating costs, profitability, working capital, capital expenditure, and cash flow.
• Build an integrated financial model linking the income statement, balance sheet, and cash flow statement.
• Use appropriate Excel financial and analytical functions to support financial calculations, forecasting, and analysis.
• Develop debt, financing, and cash flow models based on defined financial assumptions.
• Create multiple scenarios and perform sensitivity analysis to evaluate alternative financial and operational outcomes.
• Identify formula errors, broken linkages, inconsistent assumptions, and structural weaknesses within a financial model.
• Prepare and present a professional Excel-based financial model that clearly communicates assumptions, results, risks, scenarios, and recommendations to management.

Course Outline