Duncan McKeen – CFI Education – Operational Modeling

Description

Duncan McKeen – CFI Education – Operational Modeling download, Duncan McKeen – CFI Education – Operational Modeling review, Duncan McKeen – CFI Education – Operational Modeling free
Duncan McKeen – CFI Education – Operational Modeling
Operational Modeling

Learn Operational Financial Modeling in this course using a proven framework and become a more effective financial analyst.
Overview

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.
Operational Modeling Learning Objectives

Upon completing this course, you will be able to:

Explore a framework and guidelines for effective financial modeling.
Analyze a company’s operations and organize a financial model into several schedules.
Approach each schedule with a consistent workflow.
Calculate key outputs within the model schedules.
Finalize and review the financial model using best practices and automation, ensuring integrity.
Create and maintain a library of schedules.

What’s included in the Operational Modeling course?

The Operational Modeling course includes all of the following:
Operational Modeling Template, comprising of the following schedules:

Revenue Schedule
Cost Schedule
Income Statement
Working Capital Schedule
Depreciation Schedule
Asset Schedule
Income Tax Schedule

Discussions on financial modeling best practices, a framework for effective modeling, model review, and building out your own library schedule.
4+ hours of detailed video instruction.
Recommended Prep Courses
These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:

Accounting Fundamentals
Reading Financial Statements
Excel Crash Course

Who Should Take This Course?

This Operational Modeling course is perfect for investment professionals, management consultants, financial analysts of all walks, as well as investor relations teams and senior managers at both private and public companies.
What you’ll learn

Introduction

Course Introduction

Learning Objectives

Download Course Files
Model Overview

Download Chapter Slides

Model Overview

Interactive Exercise 1
Revenue Schedule

Download Chapter Slides

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

Interactive Exercise 2
Cost Schedule

Download Chapter Slides

Fixed and Variable Costs

Operational Leverage and Amplification

Costs Schedule Summary

Costs Schedule Model Overview

Variable Costs

Fixed Costs

Summary of Costs

Interactive Exercise 3
Income Statement

Download Chapter Slides

Income Statement Concepts

Income Statement Model Overview

Income Statement Model Build

Interactive Exercise 4
Working Capital Schedule

Download Chapter Slides

Working Capital Schedule

Working Capital Formulas

Working Capital Schedule Model Overview

Working Capital Historic Calculations

Working Capital Forward Calculations

Working Capital Schedule Model Movements

Interactive Exercise 5
Depreciation Schedule

Download Chapter Slides

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

Interactive Exercise 6
Asset Schedule

Download Chapter Slides

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

Interactive Exercise 7
Income Tax Schedule

Download Chapter Slides

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

Interactive Exercise 8
Model Review

Download Chapter Slides

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

[Optional] Using Prepare to Share in Macabacus

Interactive Exercise 9
[Optional] Schedule Library

Download Chapter Slides

Schedule Library Concepts

Storing and Assessing Schedules

Checking Schedule Precedents

Paste Column Widths and Paste Duplicate

Using the Macabacus Library

Linking Schedules and Shared Libraries
Conclusion

Course Summary
Download Complete Model

Qualified Assessment

Qualitied Assessment

This Course is Part of the Following Programs
Financial Modeling & Valuation Analyst (FMVA)®

Operational Modeling is part of the Financial Modeling & Valuation Analyst (FMVA), which includes 41 courses.

Skills Learned

Financial modeling and valuation, sensitivity analysis, strategy
Career Prep

Investment banking and equity research, FP&A, corporate development

Commercial Banking & Credit Analyst (CBCA)®

Operational Modeling is part of the Commercial Banking & Credit Analyst (CBCA)®, which includes 58 courses.

Skills Learned

Financial Analysis, Credit Structuring, Risk Management
Career Prep

Commercial Banking, Credit Analyst, Private Lending