Financial Modelling and Forecast Techniques using Excel Tool

Name: Financial Modelling and Forecast Techniques using Excel Tool
Rating: 3.6 (13 reviews)

Understanding Financial Analysis and Forecasting Techniques

Created byAbraham Eninla

Last updated 9/2020

English

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
Forecasting Income Statement, Balance Sheet, Cash Flow Statement using Forecast assumptions, drivers and schedules (Depreciation and Debt - Interest Schedules)
Break Even Analysis and Profit determination using Excel Table and Charts

Course content

10 sections • 65 lectures • 11h 40m total length

Course Introduction - Welcome7:59
Introduction to Excel Function for Financial Modelling13:52
Excel Functions for Financial Modelling
Introduction to Financial Modelling14:05
Financial Modelling Best and Worst Practice
Understanding Financial Modelling Types11:48

Understanding Sensitivity Analysis - Presentation5:45
Explore sensitivity analysis to see how changes in independent variables affect dependent outcomes within Excel, using scenarios and data tables to forecast, assess risk, and inform decision making.
Sensitivity Test using Goal Seek13:23
Sensitivity Test using Data Input Table17:17
Sensitivity Analysis using Solver Tools9:17
Performing Scenarios Analysis using Scenario Manager11:09
SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)

Understanding Forecasting Functions - Presentation4:34
Explore business and financial forecasting using the Excel forecast function to predict future values from past revenue and expenses, and learn its syntax with x values and known (independent) values.
Working with FORECAST Function11:53
Working with FORECAST.LINEAR Function9:30
Learn to use the forecast.linear function to extrapolate the balance sheet from historic values, with absolute and relative references for fast, statistically driven forecasts.
Understanding GROWTH Function - Presentation4:42
Working with the GROWTH Function5:03
Explore how to use the growth function in Excel to forecast exponential revenue growth, create charts, and add a trend line for the line of best fit.
Understanding the TREND Function - Presentation5:43
Working with the TREND Function3:40
Understanding the Coefficient of Determination (R^2) - Presentation5:01
Calculating the Coefficient of Determination in a Regression Analysis12:08
BUSINESS AND FINANCIAL FORECASTING TECHNIQUES

Understanding Cost of Capital and Calculations - Presentation4:44
Understanding the Cost of Equity Calculation - Presentation6:05
Cost of Equity Calculation - Practical session8:11
Capital Asset Pricing Model - Risk F-Rate, Beta, & Estimated Market Risk - Calc27:53
Understanding the Cost of Debt - Presentation2:43
Cost of Debt Calculation7:30
Understanding Weighted Average Cost of Capital (WACC) - Presentation16:14
Weighted Average Cost of Capital Calculation9:19
Cost of Capital calculation

Understanding Capital Budgeting Techniques using Linear Program - Presentation11:35
Solving Investment Problem - Linear programming Method19:47
Solving Multi-Period, multi-Investment Cash flow Problem29:40
Demonstrates solving a four-year, multi-investment cash flow problem with linear programming in Excel, allocating funds across investments B, C, D, E and CDs to maximize final-year cash while respecting limits.
Solving Capital Rationing Problem - Using Integer Programming24:05
Cost Minimization using Integer programming approach17:26
Solving Product mix and profit Maximization Problem12:06
CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD

Project Evaluation Techniques - Presentation17:10
Calculating Time Value of Money - Future Value - Using Formulas8:08
Estimating Time Value of Money - Present Value - using Formulas6:55
Using the PV Function for Present Value Calculation3:53
Using the FV Function for Future Value Calculation9:58
Using Pay Back Period Method for Project Evaluation8:10
Evaluating Project using NPV, IRR Function10:28
Using XIRR Function Method for Internal Rate of Return estimation2:20
Calculating NPV for mutually Exclusive project14:42
Using MIRR Function Method for Internal Rate of Return4:16
Investment Criteria using PBP, IRR etc8:45
PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)

Understanding Financial Ratios Analysis - Presentation13:36
Financial Ratios calculations in Excel16:18
Common Size Statements (Analysis) - Presentation9:48
Common size statements express income statement and balance sheet items as percentages of base values, enabling vertical and horizontal analysis for cross period comparisons of margins, debt, and assets.
Common Size Statements Analysis in Excel7:20
Understanding Du Pont Analysis - Presentation11:15
Du Pont Analysis - Return on Equity Calculations3:15
FINANCIAL RATIOS ANALYSIS

Financial Statements for Non-Accountants14:48
The Balance Sheet Statement4:10
The Income Statement3:47
The Cash Flow Statement5:06
The 3-Financial Statements Related11:21
Building Income Statement from Scratch20:55
Building Balance Sheet from Scratch10:34
Create a balance sheet summary across years by using lookup to pull inventory, plant and equipment, cash, other assets, and equity and liabilities, with careful formatting.
FINANCIAL STATEMENTS FOR NON-ACCOUNTANTS

Building 3-Statement model and forecasting - Part 110:54
Building 3-Statement model and forecasting - Part 216:30
Building 3-Statement model and forecasting - Part 35:27
Learn to build a 3-statement forecast by projecting revenue with a 5% growth, applying COGS and OpEx as revenue percentages, and analyzing depreciation, interest, taxes, and scenarios.
Building 3-Statement model and forecasting - Part 414:31
Building 3-Statement model and forecasting - Part 516:15
Building 3-Statement model and forecasting - Part 611:03
Building 3-Statement model and forecasting - Part 717:04
FINANCIAL STATEMENT FORECAST

Requirements

The basic requirements for this Course are Basic Knowledge of Microsoft Excel and Basic knowledge of Accounting and Finance (Financial Statements)

Description

This course is designed to equip accountants, finance professionals, and business analysts with the skills needed to use Microsoft Excel for financial modeling and forecasting. It provides a comprehensive understanding of how to analyze financial statements, forecast trends, and make data-driven business decisions using Excel’s powerful features.

Participants will learn how to calculate the cost of capital, assess investment opportunities, and evaluate business performance using financial modeling techniques. The course covers capital budgeting methods, project evaluation, and the application of key financial ratios. Understanding and applying these ratios to financial statements will enable participants to derive meaningful insights and make informed strategic decisions.

One of the key areas covered in this training is the use of Excel’s built-in financial functions to simplify complex calculations. Attendees will explore how to use functions for net present value (NPV), internal rate of return (IRR), loan amortization, and discounted cash flow (DCF) analysis. These techniques will help professionals in assessing project feasibility, investment returns, and financial health.

Additionally, the course will cover scenario analysis, sensitivity analysis, and stress testing, allowing participants to model different financial outcomes based on various assumptions. This is crucial for effective risk management and strategic planning. Participants will also gain hands-on experience in using Excel tools such as Scenario manager, Data Tables, and Goal Seek to enhance financial analysis and forecasting accuracy.

By the end of the training, attendees will have the confidence to build financial models that aid in budgeting, forecasting, and overall financial decision-making. They will be able to apply best practices in financial analysis, ensuring precise and reliable results.

The course is structured around Microsoft Excel 2016, ensuring that participants use a widely adopted version of Excel with relevant financial modeling applications. Whether working in corporate finance, investment analysis, or business planning, this course provides essential skills for making data-driven financial decisions.

Who this course is for:

Accountants, Data Analyst, Financial Analyst, Corporate Finance manager, Investment Bankers and anyone who is interested in building financial statement and forecasting them.

Financial Modelling and Forecast Techniques using Excel Tool

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 48min

BREAKEVEN ANALYSIS2 lectures • 18min

SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)5 lectures • 57min

BUSINESS AND FINANCIAL FORECASTING TECHNIQUES9 lectures • 1hr 2min

UNDERSTANDING COST OF CAPITAL CALCULATIONS8 lectures • 1hr 23min

CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD6 lectures • 1hr 55min

PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)11 lectures • 1hr 35min

PERFORMING RATIO ANALYSIS USING MICROSOFT EXCEL6 lectures • 1hr 2min

UNDERSTANDING FINANCIAL STATEMENTS - FOR NON-ACCOUNTANTS7 lectures • 1hr 11min

THE THREE (3) STATEMENTS FINANCIAL MODELLING AND FORECASTING7 lectures • 1hr 32min

Requirements

Description

Who this course is for: