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
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)
Follow these steps to claim your 40% off code:
Marqueepedia Getting Started Guide
FREE PREVIEWWelcome 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
Learning Objectives
6a - Income Statement
6b - Cash Flow Statement
6c - Balance Sheet
Learning Objectives
7a - Introduction to Depreciation
7b - Depreciation Schedule
7c - HLOOKUP Function
7d - Automating the HLOOKUP
7e - Transposing Data
7f - Depreciation Waterfall
7g - Fully Depreciating Assets
7h - Assignment
Learning Objectives
8a - Introduction to Income Taxes
8b - Current vs. Deferred Taxes
8c - Deferred Tax Example
8d - Deferred Tax Assets
8e - Tax Schedule - Overview
8f - Tax Schedule - Adjustment 1
8g - Tax Schedule - Adjustment 2
8h - Determining the Tax Assumptions
8i - Assignment
Learning Objectives
9a - Introduction to Working Capital
9b - Working Capital Schedule
9c - Working Capital Calculations
9d - Automating the Days per Year
9e - Other Working Capital Issues
9f - Assignment
Learning Objectives
10a - Modeling Debt and Equity
10b - Debt Schedule
10c - Revolving Credit Facility
10d - Revolver MIN Function
10e - Equity Schedule
10f - Assignment
Learning Objectives
11a - Finishing the Financial Statements
11b - Calculating Output Ratios
11c - Course Takeaways
11d - Assignment
In-Person and Webinar-Based Marquee Courses