Financial Modelling and Forecast Techniques using Excel Tool

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction – Welcome

Lecture 2: Introduction to Excel Function for Financial Modelling

Lecture 3: Introduction to Financial Modelling

Lecture 4: Understanding Financial Modelling Types

Chapter 2: BREAKEVEN ANALYSIS

Lecture 1: Understanding Breakeven Analysis and purpose – Presentation

Lecture 2: Breakeven Analysis – Practical (exercise file included)

Chapter 3: SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)

Lecture 1: Understanding Sensitivity Analysis – Presentation

Lecture 2: Sensitivity Test using Goal Seek

Lecture 3: Sensitivity Test using Data Input Table

Lecture 4: Sensitivity Analysis using Solver Tools

Lecture 5: Performing Scenarios Analysis using Scenario Manager

Chapter 4: BUSINESS AND FINANCIAL FORECASTING TECHNIQUES

Lecture 1: Understanding Forecasting Functions – Presentation

Lecture 2: Working with FORECAST Function

Lecture 3: Working with FORECAST.LINEAR Function

Lecture 4: Understanding GROWTH Function – Presentation

Lecture 5: Working with the GROWTH Function

Lecture 6: Understanding the TREND Function – Presentation

Lecture 7: Working with the TREND Function

Lecture 8: Understanding the Coefficient of Determination (R^2) – Presentation

Lecture 9: Calculating the Coefficient of Determination in a Regression Analysis

Chapter 5: UNDERSTANDING COST OF CAPITAL CALCULATIONS

Lecture 1: Understanding Cost of Capital and Calculations – Presentation

Lecture 2: Understanding the Cost of Equity Calculation – Presentation

Lecture 3: Cost of Equity Calculation – Practical session

Lecture 4: Capital Asset Pricing Model – Risk F-Rate, Beta, & Estimated Market Risk – Calc

Lecture 5: Understanding the Cost of Debt – Presentation

Lecture 6: Cost of Debt Calculation

Lecture 7: Understanding Weighted Average Cost of Capital (WACC) – Presentation

Lecture 8: Weighted Average Cost of Capital Calculation

Chapter 6: CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD

Lecture 1: Understanding Capital Budgeting Techniques using Linear Program – Presentation

Lecture 2: Solving Investment Problem – Linear programming Method

Lecture 3: Solving Multi-Period, multi-Investment Cash flow Problem

Lecture 4: Solving Capital Rationing Problem – Using Integer Programming

Lecture 5: Cost Minimization using Integer programming approach

Lecture 6: Solving Product mix and profit Maximization Problem

Chapter 7: PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)

Lecture 1: Project Evaluation Techniques – Presentation

Lecture 2: Calculating Time Value of Money – Future Value – Using Formulas

Lecture 3: Estimating Time Value of Money – Present Value – using Formulas

Lecture 4: Using the PV Function for Present Value Calculation

Lecture 5: Using the FV Function for Future Value Calculation

Lecture 6: Using Pay Back Period Method for Project Evaluation

Lecture 7: Evaluating Project using NPV, IRR Function

Lecture 8: Using XIRR Function Method for Internal Rate of Return estimation

Lecture 9: Calculating NPV for mutually Exclusive project

Lecture 10: Using MIRR Function Method for Internal Rate of Return

Lecture 11: Investment Criteria using PBP, IRR etc

Chapter 8: PERFORMING RATIO ANALYSIS USING MICROSOFT EXCEL

Lecture 1: Understanding Financial Ratios Analysis – Presentation

Lecture 2: Financial Ratios calculations in Excel

Lecture 3: Common Size Statements (Analysis) – Presentation

Lecture 4: Common Size Statements Analysis in Excel

Lecture 5: Understanding Du Pont Analysis – Presentation

Lecture 6: Du Pont Analysis – Return on Equity Calculations

Chapter 9: UNDERSTANDING FINANCIAL STATEMENTS – FOR NON-ACCOUNTANTS

Lecture 1: Financial Statements for Non-Accountants

Lecture 2: The Balance Sheet Statement

Lecture 3: The Income Statement

Lecture 4: The Cash Flow Statement

Lecture 5: The 3-Financial Statements Related

Lecture 6: Building Income Statement from Scratch

Lecture 7: Building Balance Sheet from Scratch

Chapter 10: THE THREE (3) STATEMENTS FINANCIAL MODELLING AND FORECASTING

Lecture 1: Building 3-Statement model and forecasting – Part 1

Lecture 2: Building 3-Statement model and forecasting – Part 2

Lecture 3: Building 3-Statement model and forecasting – Part 3

Lecture 4: Building 3-Statement model and forecasting – Part 4

Lecture 5: Building 3-Statement model and forecasting – Part 5

Lecture 6: Building 3-Statement model and forecasting – Part 6

Lecture 7: Building 3-Statement model and forecasting – Part 7