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:

1. Accounting Fundamentals
2. Reading Financial Statements
3. 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

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.