Financial Modelling and Forecast Techniques using Excel Tool
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
- Preview07:59
- Preview13:52
- 1 questionExcel Functions for Financial Modelling
- Preview14:05
- 1 questionFinancial Modelling Best and Worst Practice
- Preview11:48
Instructor
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.