Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Finance & Accounting Financial Modeling & Analysis Financial Modeling

Financial Modelling and Forecast Techniques using Excel Tool

Understanding Financial Analysis and Forecasting Techniques
Rating: 5.0 out of 55.0 (1 rating)
11 students
Created by Abraham Eninla
Last updated 9/2020
English
English [Auto]
30-Day Money-Back Guarantee

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)
  • Break Even Analysis and Profit determination using Excel Table and Charts

Requirements

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

Description

The Financial Modelling and Forecasting Techniques is designed to help accountants and finance people to understand how they can use the Microsoft Excel application to analyze and forecast financial statements, understand how to calculate cost of capital, make business decisions, use financial functions, evaluate projects or business, understanding capital budgeting techniques, compute financial ratios, apply ratios to financial statement and derive accurate answers from their analysis that would aid their business decision making process.  The course is developed with the Microsoft Excel, Version 2016.

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.

Course content

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

  • Preview07:59
  • Preview13:52
  • Excel Functions for Financial Modelling
    1 question
  • Preview14:05
  • Financial Modelling Best and Worst Practice
    1 question
  • Preview11:48

  • Understanding Breakeven Analysis and purpose - Presentation
    06:30
  • Breakeven Analysis - Practical (exercise file included)
    11:09
  • Break Even Analysis:
    2 questions

  • Understanding Sensitivity Analysis - Presentation
    05:45
  • Sensitivity Test using Goal Seek
    13:23
  • Sensitivity Test using Data Input Table
    17:17
  • Sensitivity Analysis using Solver Tools
    09:17
  • Performing Scenarios Analysis using Scenario Manager
    11:09
  • SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)
    2 questions

  • Understanding Forecasting Functions - Presentation
    04:34
  • Working with FORECAST Function
    11:53
  • Working with FORECAST.LINEAR Function
    09:30
  • Understanding GROWTH Function - Presentation
    04:42
  • Working with the GROWTH Function
    05:03
  • Understanding the TREND Function - Presentation
    05:43
  • Working with the TREND Function
    03:40
  • Understanding the Coefficient of Determination (R^2) - Presentation
    05:01
  • Calculating the Coefficient of Determination in a Regression Analysis
    12:08
  • BUSINESS AND FINANCIAL FORECASTING TECHNIQUES
    2 questions

  • Understanding Cost of Capital and Calculations - Presentation
    04:44
  • Understanding the Cost of Equity Calculation - Presentation
    06:05
  • Cost of Equity Calculation - Practical session
    08:11
  • Capital Asset Pricing Model - Risk F-Rate, Beta, & Estimated Market Risk - Calc
    27:53
  • Understanding the Cost of Debt - Presentation
    02:43
  • Cost of Debt Calculation
    07:30
  • Understanding Weighted Average Cost of Capital (WACC) - Presentation
    16:14
  • Weighted Average Cost of Capital Calculation
    09:19
  • Cost of Capital calculation
    2 questions

  • Understanding Capital Budgeting Techniques using Linear Program - Presentation
    11:35
  • Solving Investment Problem - Linear programming Method
    19:47
  • Solving Multi-Period, multi-Investment Cash flow Problem
    29:40
  • Solving Capital Rationing Problem - Using Integer Programming
    24:05
  • Cost Minimization using Integer programming approach
    17:26
  • Solving Product mix and profit Maximization Problem
    12:06
  • CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD
    2 questions

  • Project Evaluation Techniques - Presentation
    17:10
  • Calculating Time Value of Money - Future Value - Using Formulas
    08:08
  • Estimating Time Value of Money - Present Value - using Formulas
    06:55
  • Using the PV Function for Present Value Calculation
    03:53
  • Using the FV Function for Future Value Calculation
    09:58
  • Using Pay Back Period Method for Project Evaluation
    08:10
  • Evaluating Project using NPV, IRR Function
    10:28
  • Using XIRR Function Method for Internal Rate of Return estimation
    02:20
  • Calculating NPV for mutually Exclusive project
    14:42
  • Using MIRR Function Method for Internal Rate of Return
    04:16
  • Investment Criteria using PBP, IRR etc
    08:45
  • PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)
    3 questions

  • Understanding Financial Ratios Analysis - Presentation
    13:36
  • Financial Ratios calculations in Excel
    16:18
  • Common Size Statements (Analysis) - Presentation
    09:48
  • Common Size Statements Analysis in Excel
    07:20
  • Understanding Du Pont Analysis - Presentation
    11:15
  • Du Pont Analysis - Return on Equity Calculations
    03:15
  • FINANCIAL RATIOS ANALYSIS
    3 questions

  • Financial Statements for Non-Accountants
    14:48
  • The Balance Sheet Statement
    04:10
  • The Income Statement
    03:47
  • The Cash Flow Statement
    05:06
  • The 3-Financial Statements Related
    11:21
  • Building Income Statement from Scratch
    20:55
  • Building Balance Sheet from Scratch
    10:34
  • FINANCIAL STATEMENTS FOR NON-ACCOUNTANTS
    3 questions

  • Building 3-Statement model and forecasting - Part 1
    10:54
  • Building 3-Statement model and forecasting - Part 2
    16:30
  • Building 3-Statement model and forecasting - Part 3
    05:27
  • Building 3-Statement model and forecasting - Part 4
    14:31
  • Building 3-Statement model and forecasting - Part 5
    16:15
  • Building 3-Statement model and forecasting - Part 6
    11:03
  • Building 3-Statement model and forecasting - Part 7
    17:04
  • FINANCIAL STATEMENT FORECAST
    2 questions

Instructor

Abraham Eninla
CEO at Lead Vision Concepts
Abraham Eninla
  • 4.3 Instructor Rating
  • 14 Reviews
  • 62 Students
  • 4 Courses

Abraham Eninla is a Certified Microsoft Office Specialist, with expert-level knowledge and experience in Microsoft Excel. For over 18 years, the lecturer has been an active IT Solution Provider and Financial Analyst, He also trains students in Web Development. As a specialized Training Providers and Consultant, he uses Microsoft Office Application and other specialized software to engage corporate personnel in productivity tasks and Training, He also handles regularly Sage 50,  QuickBooks Accounting, Project Management Training, Abraham Eninla is currently the CEO of Lead Vision Concepts, the Founder of Wisdom Bank Motivation for Living and Executive Director of Abraham Eninla International. He is also a Public Speaker, Motivator, writer, and the regular Voice Broadcaster of 2 Minutes Motivations.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.