When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Financial Modeling Fundamentals

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues.

Financial Modeling Fundamentals

Ce cours fait partie de Spécialisation "Accounting and Financial Modelling Bootcamp"

Instructeurs : Michael McDonald

Inclus avec

3 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Expérience recommandée

7 heures à compléter

Planning flexible

Apprenez à votre propre rythme

3 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Expérience recommandée

7 heures à compléter

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

Apply Excel modeling best practices to structure financial models for accuracy and usability.
Forecast revenues, expenses, and working capital using assumption-driven logic.
Build an integrated three-statement model and perform scenario/sensitivity analysis.

Compétences que vous acquerrez

Catégorie : Financial Modeling
Catégorie : Financial Statements
Catégorie : Working Capital
Catégorie : Business Modeling
Catégorie : Cash Flow Forecasting
Catégorie : Financial Accounting
Catégorie : Financial Forecasting
Catégorie : Balance Sheet
Catégorie : Excel Formulas
Catégorie : Accounting
Catégorie : Forecasting
Catégorie : Capital Expenditure
Catégorie : Financial Statement Analysis
Catégorie : Operational Excellence
Catégorie : Financial Analysis
Catégorie : Revenue Forecasting
Catégorie : Cash Flows
Catégorie : Data Validation

Outils que vous découvrirez

Catégorie : Microsoft Excel

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

mars 2026

Évaluations

3 affectations¹

Noté par l'IA voir l'avis de non-responsabilité

Enseigné en Anglais

91%

of learners achieved a positive career outcome

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise du sujet

Ce cours fait partie de la Spécialisation "Accounting and Financial Modelling Bootcamp"

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable

Il y a 3 modules dans ce cours

This course introduces the principles and practice of building structured, assumption-driven financial models in Microsoft Excel. You will apply Excel modeling best practices to design clear input, calculation, and output sections; write robust formulas; and document assumptions for transparency and auditability.

Starting with model layout and dynamic functions such as INDEX/MATCH and IFERROR, you will develop driver-based forecasts for revenue, expenses, capital expenditures, and working capital. You will then integrate these projections into a fully linked three-statement financial model—connecting the income statement, balance sheet, and cash flow statement with automated logic and validation checks. The course also covers scenario analysis, sensitivity testing using data tables, and model error-checking to support sound financial decision-making. By the end, you will be able to build dynamic, assumption-driven Excel models suitable for business planning, valuation, and performance analysis.

Détails du module

This module covers foundational skills in building structured Excel models. Learners will be introduced to proper layout principles, naming conventions, formula design, and basic troubleshooting tools. The module also focuses on model usability and documentation — essential skills for professional modelers.

Inclus

11 vidéos2 lectures1 devoir1 évaluation par les pairs1 sujet de discussion

11 vidéosTotal 45 minutes

Intro Video to Course 2 minutes
Module Introduction 1 minute
Inputs, Calculations, Outputs: The Golden Rule 6 minutes
Layout, Labeling, and Color-Coding Standards4 minutes
Navigating and Designing for User-Friendliness5 minutes
Absolute vs. Relative References4 minutes
Lookup Functions: INDEX/MATCH vs. VLOOKUP5 minutes
Error-Checking with IFERROR and Conditional Logic4 minutes
Creating an Assumptions Dashboard5 minutes
Tracking Model Changes and Version Control 4 minutes
Sourcing Data and Referencing External Inputs4 minutes

2 lecturesTotal 10 minutes

Welcome to the Course: Course Overview5 minutes
Modeling in Excel and Its Importance 5 minutes

1 devoirTotal 20 minutes

Excel Modeling Techniques and Best Practices 20 minutes

1 évaluation par les pairsTotal 25 minutes

Hands-On-Learning: Building a Clean, Structured Financial Model Template25 minutes

1 sujet de discussionTotal 10 minutes

The Golden Rule of Modeling 10 minutes

This module focuses on building forward-looking forecasts for a company’s operations. Learners will develop revenue and cost projections using driver-based assumptions. Lessons will include forecasting techniques for SG&A, cost of goods sold (COGS), depreciation, and working capital. The goal is to build a dynamic, assumption-driven operating model that feeds directly into financial statements and scenario analysis.

Inclus

10 vidéos1 lecture1 devoir1 évaluation par les pairs1 sujet de discussion

10 vidéosTotal 52 minutes

Module Introduction 2 minutes
Top-Down vs. Bottom-Up Forecasting 4 minutes
Unit Economics and Pricing Strategies5 minutes
Market Size, Growth Rates, and Penetration Scenarios5 minutes
Fixed vs. Variable Costs5 minutes
Operating Leverage and Break-Even Analysis6 minutes
Driver-Based Cost Allocation6 minutes
Maintenance vs. Growth Capex6 minutes
Modeling Depreciation and Asset Schedules7 minutes
Forecasting Working Capital (DSO, DPO, Inventory Turns) 7 minutes

1 lectureTotal 5 minutes

7 Financial Forecasting Methods to Predict Business Performance5 minutes

1 devoirTotal 20 minutes

Operating Model Forecasting 20 minutes

1 évaluation par les pairsTotal 30 minutes

Hands-On-Learning: Forecasting Revenues, Costs, and Working Capital Drivers30 minutes

1 sujet de discussionTotal 10 minutes

Balancing Simplicity and Realism in Forecasts 10 minutes

This module teaches students how to link the income statement, balance sheet, and cash flow statement into an integrated three-statement model. Learners will create dynamic linking logic using forecasted assumptions and formulas, build checks and balances to validate model accuracy, and then explore scenario and sensitivity analysis. The goal is to create a fully functional model capable of supporting real-world decision-making.

Inclus

11 vidéos1 lecture1 devoir2 évaluations par les pairs1 sujet de discussion

11 vidéosTotal 64 minutes

Module Introduction 1 minute
Connecting Income Statement and Balance Sheet4 minutes
Automating the Cash Flow Statement6 minutes
Handling Circular References and Iterative Calculations8 minutes
Calculating Operating and Free Cash Flow7 minutes
Building a Debt Schedule with Interest Expense5 minutes
Modeling Equity Raises and Dilution6 minutes
Setting Up Sensitivity Tables (Data Tables)8 minutes
Scenario Planning and Toggle Controls8 minutes
Validating and Stress-Testing Your Model7 minutes
Course Wrap-Up3 minutes

1 lectureTotal 5 minutes

Scenario Analysis: Definition, Process, and Benefits5 minutes

1 devoirTotal 20 minutes

Three-Statement Model Construction and Scenarios 20 minutes

2 évaluations par les pairsTotal 95 minutes

Hands-On-Learning: Integrating the Income Statement, Balance Sheet, and Cash Flow35 minutes
Project: Designing and Building a Dynamic Three-Statement Financial Model 60 minutes

1 sujet de discussionTotal 10 minutes

The Value of Transparency in Complex Models 10 minutes

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.