## What you’ll learn

• Introduction to Excel Functions for Financial Analysis and Modelling
• Understanding Financial Modelling worst and best practices
• Understanding types of Financial Models used in Corporate Finance and Investment banking
• Financial Analysis using Microsoft Excel
• Building Financial Statements from raw data
• Understanding Cost of Capital Calculation
• Understand Business and Financial Forecasting
• Capital Budgeting Techniques using Linear and Integer Programming Tools
• Project Evaluation Techniques using NPV, IRR, Profitability index, Pay Back Period, MIRR and XIRR methods
• Understanding Financial Ratio Analysis
• Calculating Return on Equity using the Du Pont Analysis method
• Introducing the 3- Financial Statements use in Modelling and Forecasting to Non-Accountants
• Modelling and Forecasting the Income Statement, Balance Sheet, and Cash Flow Statement using Forecast assumptions, drivers and schedules (Depreciation and Debt – Interest Schedules)

Introduction

Course Introduction – Welcome
Introduction to Excel Function for Financial Modelling
Excel Functions for Financial Modelling
Introduction to Financial Modelling
Financial Modelling Best and Worst Practice
Understanding Financial Modelling Types

BREAKEVEN ANALYSIS

Understanding Breakeven Analysis and purpose – Presentation
Breakeven Analysis – Practical (exercise file included)
Break Even Analysis:

SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)

Understanding Sensitivity Analysis – Presentation
Sensitivity Test using Goal Seek
Sensitivity Test using Data Input Table
Sensitivity Analysis using Solver Tools
Performing Scenarios Analysis using Scenario Manager
SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)

Understanding Forecasting Functions – Presentation
Working with FORECAST Function
Working with FORECAST.LINEAR Function
Understanding GROWTH Function – Presentation
Working with the GROWTH Function
Understanding the TREND Function – Presentation
Working with the TREND Function
Understanding the Coefficient of Determination (R^2) – Presentation
Calculating the Coefficient of Determination in a Regression Analysis

UNDERSTANDING COST OF CAPITAL CALCULATIONS

Understanding Cost of Capital and Calculations – Presentation
Understanding the Cost of Equity Calculation – Presentation
Cost of Equity Calculation – Practical session
Capital Asset Pricing Model – Risk F-Rate, Beta, & Estimated Market Risk – Calc
Understanding the Cost of Debt – Presentation
Cost of Debt Calculation
Understanding Weighted Average Cost of Capital (WACC) – Presentation
Weighted Average Cost of Capital Calculation
Cost of Capital calculation

CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD

Understanding Capital Budgeting Techniques using Linear Program – Presentation
Solving Investment Problem – Linear programming Method
Solving Multi-Period, multi-Investment Cash flow Problem
Solving Capital Rationing Problem – Using Integer Programming
Cost Minimization using Integer programming approach
Solving Product mix and profit Maximization Problem
CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD

PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)

Project Evaluation Techniques – Presentation
Calculating Time Value of Money – Future Value – Using Formulas
Estimating Time Value of Money – Present Value – using Formulas
Using the PV Function for Present Value Calculation
Using the FV Function for Future Value Calculation
Using Pay Back Period Method for Project Evaluation
Evaluating Project using NPV, IRR Function
Using XIRR Function Method for Internal Rate of Return estimation
Calculating NPV for mutually Exclusive project
Using MIRR Function Method for Internal Rate of Return
Investment Criteria using PBP, IRR etc
PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)

PERFORMING RATIO ANALYSIS USING MICROSOFT EXCEL

Understanding Financial Ratios Analysis – Presentation
Financial Ratios calculations in Excel
Common Size Statements (Analysis) – Presentation
Common Size Statements Analysis in Excel
Understanding Du Pont Analysis – Presentation
Du Pont Analysis – Return on Equity Calculations
FINANCIAL RATIOS ANALYSIS

UNDERSTANDING FINANCIAL STATEMENTS – FOR NON-ACCOUNTANTS

Financial Statements for Non-Accountants
The Balance Sheet Statement
The Income Statement
The Cash Flow Statement
The 3-Financial Statements Related
Building Income Statement from Scratch
Building Balance Sheet from Scratch
FINANCIAL STATEMENTS FOR NON-ACCOUNTANTS

THE THREE (3) STATEMENTS FINANCIAL MODELLING AND FORECASTING

Building 3-Statement model and forecasting – Part 1
Building 3-Statement model and forecasting – Part 2
Building 3-Statement model and forecasting – Part 3
Building 3-Statement model and forecasting – Part 4
Building 3-Statement model and forecasting – Part 5
Building 3-Statement model and forecasting – Part 6
Building 3-Statement model and forecasting – Part 7
FINANCIAL STATEMENT FORECAST