Financial Modeling and Its business applications
This course covers the fundamentals and concepts of building a financial model from scratch
Finance and Accounting,Financial Modeling and Analysis,
Lectures -82
Resources -19
Quizzes -1
Duration -5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course adopted a practical and hand-holding approach to understanding and applying financial modeling concepts to business. The concepts covered in this course will serve as a base for building any financial model. This course has been developed using tested materials, and practical techniques used in real-world business applications.
You'll learn in this course:
- Understanding how the business operates and how it flows into financial modeling concepts.
- Understanding business & accounting cycle in business and financial modeling.
- Getting information/data needed to build a financial model with the use of an Information Request List document (using a client-based practical case study).
- Building a professional model template.
- Extracting and structuring of inputs using FAST Standard.
- Building the calculations and schedules.
- Creating the projected financial statement (profit or loss, balance sheet, cash flow statement).
Goals
Understanding how the business operates and how it flows into financial modeling concepts.
Understanding business & accounting cycle in business and financial modeling.
Getting Information/data needed to build a financial model with the use of an Information Request List document (using a client-based practical case study).
Building a professional model template.
Extracting and structuring of Inputs using FAST Standard.
Building the calculations and schedules.
Creating the projected financial statement (profit or loss, balance sheet, cash flow statement).
Prerequisites
Knowledge of Accounting, Microsoft Excel, and Finance.
Curriculum
Check out the detailed breakdown of what’s inside the course
Welcome to the Course
4 Lectures
-
Welcome to the Course 03:14 03:14
-
About the Trainer 02:22 02:22
-
Watching this Course 00:47 00:47
-
Model Walk-Through (Client Real Life Case Study) 03:45 03:45
Overview of Financial Modeling Concepts
7 Lectures

Components of a Model
5 Lectures

Building Schedules in Financial Modeling
6 Lectures

Understanding and Interpretation of Financial Statement
5 Lectures

Creating a Professional Financial Model Template
14 Lectures

Creating an Information Request List Document
6 Lectures

Extracting Assumptions or Inputs in Financial Modeling
13 Lectures

Building the Calculation Schedules
13 Lectures

Building the Forecasted Financial Statement
7 Lectures

Capstone Project and Practice
2 Lectures

Instructor Details

Victor Ogundele
An experienced certified Financial Modeler, Financial Analyst, Project Finance Modeler, Microsoft MVP, and Corporate Finance Trainer who has worked on over 200+ financial modeling projects across industries globally and trained more than 3000 personnel on financial modeling.
Graduate of Obafemi Awolowo University (OAU) with BSc. in accounting. I am an experienced certified financial modeler by financial modeling institute (FMI), Financial modeling & valuation analyst (FMVA) by corporate finance institute (CFI), a member of institute of Chartered Accountants of Nigeria (ICAN), and Financial Professional Network (FPN) in Nigeria.
Experience:
· Senior Financial Analyst at Deloitte, Nigeria
· Senior Investment Banking Analyst (project finance modeler) at FBNQuest, Nigeria.
· Team Lead Financial Modeling Analyst and Corporate Trainer at dbrownconsulting, Nigeria.
· Interned at KPMG virtual program on Data Analytics
· Interned at JP Morgan virtual program on commercial banking
· Associate Financial Advisor at BPI Advisory, Lagos
· Financial Modeler & Analyst at Sam & Wright Consulting, Nigeria.
· Head of Finance at Grand Valley Hotel, Abuja.
Participations & Achievement:
· Financial Modeling Trainer of the year by Financial Modeling Submit 2022.
· Microsoft® Most Valuable Professional (MVP) in office apps & services (Microsoft Excel) 2021.
· Top 16 Microsoft Excel users’ competition by financial modeling world cup 2021.
· Ranked 6th best financial modeler in Africa for the 2021 financial modeling world cup.
· Webinar speaker, facilitators, coordinator, and Time-out with Victor on financial modeling Bootcamp program 2021, 2022.
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now