Financial Modeling
Building a Financial Model of a Company
Design and create a dynamic financial model of a company that adheres to the highest industry standards
Gain the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. The course material includes model design, logic, construction, financial concepts and accounting treatment. During the course, participants will build a model that includes a forecast of a company’s income statement, cash flow statement and balance sheet.
Includes all content from our live sessions and incorporates Marquee’s teaching approach honed by 20 years in the classroom
55 expert videos. Pause, fast forward, and rewind to suit your individual pace
7+ Hours of Interactive Content
A Certificate will be provided upon course completion
Practice assignments with step-by-step instructions and full answer key
Presentation book of key concepts (50 pages of key finance resources and Excel formulas)
Dedicated course support
Video Closed Captions for user accessibility
Outstanding, like everything the Marquee Group does.
John S. (Toronto, Canada)
An all-encompassing, elaborate course, with in-depth examples, challenging questions, and a great comprehensive model building process. Highly recommended!
Yuvraj S.L. (Massachusetts, USA)
I was blown away by the quality and detail of the course, taking away an enormous amount of knowledge and most importantly the technical skills that I am sure will help with my career goals.
Justin C. (Toronto, Canada)
Completely satisfied. The course will prepare you to forecast a company's Financial Statement and build the F/S with ease; simple formula in excel without compromising any quality.
Riyad M. (Dhaka, Bangladesh)
The financial modeling course is amazing! Without question, this course is the best I have ever seen. I learned a lot in the MBA program. However, this course is the missing piece that completes my financial competence.
Jesus J. (Texas, USA)
from the Financial Modeling Institute (FMI)
Welcome and Course Objectives
FREE PREVIEWFAQs: Maximizing Your Success in this Course
FREE PREVIEWCourse Materials and Technology Requirements
Learning Objectives
2a - Modeling as a Discipline
FREE PREVIEW2b - Modeling Fundamentals
2c - Precision Moldings Case Study
2d - Planning the Model
2e - Completed Model Review
2f - Incorporating Scenarios
2g - Model Structure
Learning Objectives
3a - Centre Across Selection
3b - Custom Formatting - Introduction
3c - Custom Formatting - 0 vs #
3d - Custom Formatting - Four Ways
3e - Custom Formatting Colors and Spacing
3f - CONCATENATE Function
3g - CONCATENATE and Formatting
3h - Scenarios Page Construction
3i - Scenarios CHOOSE Function
3j - Scenarios Page Drop Down Menus
3k - Assignment
Learning Objectives
4a - The Engine
4b - Revenue Schedule
4c - Revenue Constraint
4d - Assignment
Learning Objectives
5a - Operating Costs Overview
5b - Operating Costs Schedule
5c - Modeling Operating Leverage
5d - Assignment