courseraБизнес

Operational Modeling

Курс от Corporate Finance Institute

Средний≈ 6.9 чАнглийский

О курсе

Operational Modeling Course Overview Financial models play a critical role in supporting business decisions. Learning to model the right way using a proven framework will help you become a more effective financial analyst. Join us as we build out several fundamental schedules, which will serve as a solid foundation for more complex analysis throughout the FMVA and your career. This course will guide you through building structured, driver-based models that reflect real-world business operations. You will learn how to translate raw financial and operational data into meaningful projections, ensuring your models are both flexible and easy to update as assumptions change. Emphasis is placed on clarity, accuracy, and scalability so that your work can be confidently used by stakeholders for decision-making. In addition to technical modeling skills, the course also strengthens your ability to think critically about business performance drivers. You will develop an understanding of how operational inputs such as revenue drivers, cost behavior, and working capital dynamics interact within a financial model. By the end of the course, you will be able to build robust schedules that integrate seamlessly into larger financial statements and support advanced valuation and strategic analysis.

Навыки, которые вы освоите

Income Statement Financial Data Financial Modeling Financial Analysis Financial Statement Analysis Financial Forecasting Accounts Payable Operational Analysis Forecasting Working Capital Accounts Receivable Operating Cost Revenue Forecasting Business Modeling Performance Measurement

Программа курса

12 модулей · 93 учебных материалов

01Introduction3 материалов

Module Content

Learning ObjectivesЧтение Download Course FilesЧтение

Course Introduction

Course IntroductionВидео

02Model Overview3 материалов

Model Overview

Учитесь у экспертов

CFI (Corporate Finance Institute)

Преподаватель курса

Operational Modeling

О курсе

Навыки, которые вы освоите

Программа курса

Module Content

Course Introduction

Model Overview

Учитесь у экспертов

CFI (Corporate Finance Institute)

Interactive Exercise 1

Revenue Schedule Overview

Model Alerts and Smaller Business Lines

Model Features and Guidelines

Revenue Schedule Model Overview

Model the Operations

Model the Volume

Model the Pricing

Model the Revenue

Check Capacity

Custom Format

Conditional Format

Revenue Schedule Summary

Fixed and Variable Costs

Operational Leverage and Amplification

Costs Schedule Summary

Costs Schedule Model Overview

Variable Costs

Fixed Costs

Summary of Costs

Income Statement Concepts

Income Statement Model Overview

Income Statement Model Build

Working Capital Schedule

Working Capital Formulas

Working Capital Schedule Model Overview

Working Capital Historic Calculations

Working Capital Forward Calculations

Working Capital Schedule Model Movements

Depreciation Expense

Depreciation Modeling

Depreciation Schedule

Depreciation Schedule Model Overview

Capex Using XLOOKUP

Capex Using SUMIF

Existing Assets - Percent of Full Year

New Assets - Percent of Full Year

Waterfall Schedule - Percentages

Waterfall Schedule - Amounts

Schedule Design and Layout

Schedule Movements and Testing

Accounting Basis and Tax Basis

Asset Value Corkscrews

Asset Schedule Model Overview

Asset Schedule Model Build

Accounting versus Tax Depreciation

Accelerated Depreciation for Tax Purposes

Current and Deferred Income Taxes

Accounting versus Taxable Income

Accelerated Depreciation and Loss Carryforwards

Income Tax Calculations

Income Tax Schedule Model Overview

EBT After Adjustment

Adding New Tax Losses

Using Tax Losses

Check Profitable Before Tax

Taxable Income

Tax Totals

Check Losses Remaining

Year-Over-Year Explanation

Conditional Formatting for Alert

Locating Constants or Hardcodes

Checking Row and Column Differences

[Optional] Macabacus Model Audit Tools

Marking Constants or Hardcodes

Finding Row Differences

Finding Partial Inputs

Toggling Gridlines

Course Summary

Module Content

Qualified Assessment