Free Financial Modelling Courses Online

Unit

Contents

Intermediate Excel for Financial Modelling

• Financial Modelling in Excel for Beginners
• Formatting of Excel Sheets
• Use of Excel Formula Function
• Advanced Modeling Techniques: Extrapolation and Histogram
• Data Filter and Sort
• Charts and Graphs
• Table formula and Scenario building
• Lookups: Vlookup Match & offset, pivot tables

Analysis of Financial Statements

• Introduction to Financial Statement Analysis
• Financial Reporting Mechanics
• Income Statement
• Balance Sheet
• Cash Flow Statement
• Financial Analysis Techniques
• Inventories, Long Lived Assets
• Non-Current Liabilities
• Financial Statement Application

Financial Ratios

• Ratio analysis of industries
• Du pont Analysis
• Peer to peer analysis
• Preparation of Financial Analysis report on an industry

Business Finance

• Time value of money
• Long term financing
• Cost of capital
• Measure of Leverage Project Finance
• Project evaluation; construction & development phase
• Costs during investment phase
• Life of project
• Decision making
• Cash flow waterfall & resolve circular reference problem

Equity Research Modeling

• Preparing financial statements (Income Statement, Balance Sheet, Cash Flow)
• Geographic & Segment Revenue analysis
• Forecasting revenues and costs
• Performing adjustments and computing margins
• Valuation techniques (DCF, Relative Valuation)
• Creating presentation materials and company overviews

Course

About the Course

Business and Financial Modeling Specialization

This course introduces learners to spreadsheet models, financial modelling techniques, and common applications of investment analysis, company valuation, and forecasting. Through this free financial modelling course, students will learn to create their own quantitative models, use spreadsheets to map and predict data, structure decision-making for optimal results, and understand the measurement and management of risk.

Discounted Cash Flow Modeling 

​This course introduces discounted cash flow (DCF) modelling, which is a fundamental valuation technique in finance. The free financial modelling course is suitable for professionals such as investment bankers, financial analysts, CFOs, and corporate development experts who will learn about forecasting a company's financials, discounting cash flows to present value, and calculating enterprise and equity values to determine fair share prices. The curriculum includes topics like historical financial analysis, five-year forecasting, exit multiples, free cash flow computation, and enterprise value assessment.

Job Profile

About this Role

Investment Banking

Financial modelling is an important concept in investment banking. Analysts and associates have to complex models to value companies for mergers, acquisitions as well as initial public offerings. Professionals in investment banking with knowledge of financial modelling are paid really well.

Equity Research

Financial models help in making buy, sell, and hold recommendations that influence investment decisions. Equity research analysts use their modelling skills to forecast company performance and determine fair valuations for stocks.

Corporate Finance

Companies use financial models for budgeting, capital allocation, and strategic planning. Financial analysts build models to evaluate new projects, assess acquisition targets, and optimize capital structures.

Private Equity and Venture Capital

These investors use financial modelling to evaluate potential investments and monitor portfolio company performance. Associates in these fields can build detailed leveraged buyout (LBO) models and growth projections.

Financial Planning & Analysis (FP&A)

FP&A professionals develop budgets and forecasts that guide company decision-making. Their financial modelling work combines strategic initiatives with financial outcomes.

Consulting

Management and financial consultants build models to solve client problems and justify recommendations. These roles combine financial modelling with strategic thinking.

Startups and Entrepreneurship

Entrepreneurs use financial models to secure funding, plan cash flow, and demonstrate business viability. Strong modelling skills allow founders to make data-driven decisions and communicate effectively with investors.