Learn Financial Analysis and Financial Modelling from Scratch

About Course

Become an industry-ready Financial Analyst by mastering Financial Analysis, Financial Modeling, Business Valuation, Budgeting, Forecasting, Investment Analysis, Corporate Finance, Risk Management, and Microsoft Excel for Finance. This comprehensive Financial Analysis & Financial Modeling Programme equips learners with practical skills to analyze financial statements, build dynamic financial models, perform valuation techniques, evaluate investment opportunities, and support strategic business decisions across banking, investment firms, consulting, multinational corporations, fintech, and financial institutions. Through real-world case studies and hands-on financial modeling projects, learners will develop professional financial models and analytical reports that meet global finance and corporate reporting standards.

Understand financial statements and accounting principles
Apply advanced Excel functions for financial modeling
Analyze income statements, balance sheets, and cash flow
Build three-statement financial models and forecasts
Apply business valuation: DCF, comparable company, precedent transactions
Develop budgets, forecasts, and variance analysis
Conduct investment appraisal, capital budgeting, and risk analysis
Apply corporate finance concepts: capital structure, cost of capital
Build a comprehensive financial model capstone project

Course Content

Module 1: Introduction to Financial Analysis
• Fundamentals of Financial Analysis • Financial Statements • Accounting Principles • Financial Performance Evaluation

Module 2: Microsoft Excel for Financial Modeling
• Advanced Excel Functions • Financial Formulas • Data Analysis Tools • Spreadsheet Best Practices

Module 3: Financial Statement Analysis
• Income Statement Analysis • Balance Sheet Analysis • Cash Flow Statement Analysis • Financial Ratio Analysis

Module 4: Financial Modeling
• Three-Statement Financial Model • Forecasting Techniques • Scenario & Sensitivity Analysis • Dynamic Financial Models

Module 5: Business Valuation
• Discounted Cash Flow (DCF) • Comparable Company Analysis • Precedent Transaction Analysis • Enterprise Valuation

Module 6: Budgeting & Forecasting
• Budget Planning • Financial Forecasting • Variance Analysis • Financial Planning

Module 7: Investment & Risk Analysis
• Investment Appraisal • Capital Budgeting • Portfolio Analysis • Financial Risk Management

Module 8: Corporate Finance & Decision-Making
• Working Capital Management • Capital Structure • Cost of Capital • Financial Strategy

Module 9: Capstone Project
Build a comprehensive financial model for a real-world business, including financial statement analysis, forecasting, business valuation, investment appraisal, budgeting, and executive financial reporting to support strategic decision-making.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Module 1: Introduction to Financial Analysis • Fundamentals of Financial Analysis • Financial Statements • Accounting Principles • Financial Performance Evaluation

Module 2: Microsoft Excel for Financial Modeling • Advanced Excel Functions • Financial Formulas • Data Analysis Tools • Spreadsheet Best Practices

Module 3: Financial Statement Analysis • Income Statement Analysis • Balance Sheet Analysis • Cash Flow Statement Analysis • Financial Ratio Analysis

Module 4: Financial Modeling • Three-Statement Financial Model • Forecasting Techniques • Scenario & Sensitivity Analysis • Dynamic Financial Models

Module 5: Business Valuation • Discounted Cash Flow (DCF) • Comparable Company Analysis • Precedent Transaction Analysis • Enterprise Valuation

Module 6: Budgeting & Forecasting • Budget Planning • Financial Forecasting • Variance Analysis • Financial Planning

Module 7: Investment & Risk Analysis • Investment Appraisal • Capital Budgeting • Portfolio Analysis • Financial Risk Management

Module 8: Corporate Finance & Decision-Making • Working Capital Management • Capital Structure • Cost of Capital • Financial Strategy

Module 9: Capstone Project Build a comprehensive financial model for a real-world business, including financial statement analysis, forecasting, business valuation, investment appraisal, budgeting, and executive financial reporting to support strategic decision-making.