Financial Modelling and Forecasting Techniques

Name: Financial Modelling and Forecasting Techniques
Price: 9.99 USD
Rating: 4.5 (2 reviews)
Author: Abraham Eninla

Modelling Financial Data

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Abraham Eninla

architecture icon Financial Modeling & Analysis,Finance & Accounting

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course 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 Microsoft Excel, Version 2016.

Goals

What will you learn in this course:

Introduction to Excel Functions for Financial Analysis and Modelling
Understanding Financial Modelling worst and best practices
Understanding the 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
Understanding 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

Prerequisites

What are the prerequisites for this course?

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

Financial Modelling and Forecasting Techniques

Curriculum

Check out the detailed breakdown of what’s inside the course

INTRODUCTION
8 Lectures

Course Introduction - Welcome 07:59 07:59
Introduction to Excel Function for Financial Modelling 14:38 14:38
Introduction to Financial Modelling 14:33 14:33
Understanding Financial Modelling Types 03:04 03:04
Understanding Financial Modelling Types - Merger and Acquisition 03:27 03:27
Financial Modelling Types - Discounted Cashflow Model 02:51 02:51
Financial Modelling Types - Credit Analysis 03:13 03:13
Financial Modelling Types - Startup Valuation 02:57 02:57

BREAK EVEN ANALYSIS
2 Lectures

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

BUSINESS AND FINANCIAL FORECASTING TECHNIQUES
9 Lectures

UNDERSTANDING COST OF CAPITAL CALCULATIONS
8 Lectures

CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD
6 Lectures

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

PERFORMING RATIO ANALYSIS USING MICROSOFT EXCEL
6 Lectures

UNDERSTANDING FINANCIAL STATEMENTS - FOR NON-ACCOUNTANTS
7 Lectures

THE THREE (3) STATEMENTS FINANCIAL MODELLING AND FORECASTING
7 Lectures

Instructor Details

Abraham Eninla

leadvisionconcepts

I am a Certified Microsoft Office Specialist, with expert-level knowledge and experience in Microsoft Excel. For over 18 years, I have been an active IT Solution Provider and Financial Analyst for about two decades, I have expert skills in the following IT Courses:

- Financial Modelling and Forecasting Techniques

- Microsoft Excel (Beginner to Advanced Level)

- Microsoft PowerPoint

- Microsoft SQL Server

- MySQL, PostgreSQL,

- Python Automation and Data Analysis

- VBA for Excel

- Microsoft Power BI

- Web Development (HTML, CSS, JavaScript and PHP)

- and lot more...

As a specialized Training Provider and Consultant, I use Microsoft Office Application and other specialized software to engage corporate personnel in productivity tasks and Training, I also handle regularly Sage 50, QuickBooks Accounting, and Project Management Training, I am currently the CEO of Lead Vision Concepts and the Founder of Wisdom Bank Motivation for Living and Executive Director of Abraham Eninla International. I am a Public Speaker, Motivator, writer, and the regular Voice Broadcaster of 2 Minutes Motivations.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

Our students work
with the Best

Feedbacks

Yogendra Dhungana

It was a great experience to be a part of this course despite being unclarity of sound. Thanks for providing such valuable course which was beneficial for spending time and effort.