Financial Modelling and Forecast Techniques using Excel Tool

Name: Financial Modelling and Forecast Techniques using Excel Tool
Rating: 3.9 (8 reviews)

Understanding Financial Analysis and Forecasting Techniques

(8 ratings)

42 students

Created by Abraham Eninla

Last updated 9/2020

English

English [Auto]

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

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.

Abraham Eninla

CEO at Lead Vision Concepts

4.2 Instructor Rating
77 Reviews
1,244 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.