5.0
(5 ratings)
4 Weeks
·Cohort-based Course
Build sophisticated financial models that enable you to make strategic business decisions and optimize business outcomes.
Partial List of Current & Former Clients
Course overview
In this exceptionally interactive, roll-up-your-sleeves program, you will transition from a traditional financial analyst to a strategic financial modeler, capable of building complex and dynamic integrated Excel models that capture the intricacies of business operations.
This training will walk you through, step-by-step, how to build an integrated 3-statement financial model. It will be focused on modeling for performing and underperforming businesses, not exclusively for investment banking transactions.
While other financial modeling training mostly focuses on model-building and how financial statements connect, this program will walk you through the strategic financial considerations you'll be making as a financial analyst, Controller, Director of FP&A, or CFO.
Because the program is live and cohort-based, it provides a hands-on and immersive experience with a 20-year finance practitioner and a group of smart, driven professionals just like you.
The modeling techniques learned are the same techniques and methods employed in small entrepreneurial businesses, mid-market companies, and Fortune 1000s.
The ability to build powerful financial models is no longer just for investment bankers and Excel gurus. It's a necessity for corporate finance and FP&A professionals too.
-----------------------------------------------------------
Seidman Financial is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.
Seidman Financial is a division of Seidman Global LLC.
-----------------------------------------------------------
📆 FEBRUARY COHORT:
-----------------------------------------------------------
Feb 1 | Feb 8 | Feb 15 | Feb 22 | Feb 29 | 2024
9am - 1pm CST
-----------------------------------------------------------
Total Time Commitment: 20.0 hours
Total CPE: 20.0 credits
-----------------------------------------------------------
01
Aspiring financial analysts seeking to develop advanced modeling skills for career growth in finance, investments, and banking.
02
Corporate finance professionals seeking to build robust financial models to support strategic planning, capital raises and allocations.
03
CFOs and finance leaders looking to elevate their team's capabilities in financial modeling for strategic planning and value creation.
04
Financial managers aiming to optimize business performance through data-driven decision-making using advanced financial models.
05
Private equity analysts seeking expertise in advanced financial modeling to assess potential acquisitions and improve portfolio performance.
06
Accountants looking to expand their skillset by mastering advanced financial modeling techniques beyond core accounting and Controllership.
A key obstacle for financial modelers is evolving models without adding unnecessary complexity. You'll gain a deep understanding of key financial concepts and model-building principles that will allow your financial models to grow seamlessly without breaking or getting clunky.
You will learn how to incorporate various aspects of finance -- including accounting, corporate finance, and investment analysis -- into your financial models. This comprehensive approach will allow you to analyze and interpret financial data from multiple end-user perspectives.
You'll learn the foundations of finance and accounting that you need to understand the connections across the 3 core financial statements. You'll get comfortable with how the changes in certain business drivers hit the financials and what the company can do to manage them.
Microsoft Excel continues to be the gold standard for most financial modeling. While it's not always the perfect tool, learning how to perform in Excel will allow you to leverage your model for use in other platforms.
The goal of financial modeling isn't to build a financial model. The goal is to develop financial intelligence to support business decisions. The development of your financial models will allow you to better understand the drivers and nuances of the business and what can be done.
You'll be exposed to real-world financial scenarios and business cases, which will enable you to develop strong problem-solving skills. You'll learn to analyze complex financial data, identify trends and patterns, and derive insights that can inform quicker business decisions.
Financial models are only as good as the underlying data and assumptions. Increase your confidence in front of your peers and leadership by development a thorough understanding of the context behind the assumptions.
Crafting the financial model is one thing, but being able to manage it and communicate what is say is something entirely different. You'll learn to identify what's most important to leadership, third-parties, and business partners to present your models effectively.
You'll be in a cohort-based group of smart people just like you. You'll discover their backstories, what they do for work, how they've gotten to where they are today, and what they can bring to the learning community. You'll be expected to share the same.
Advanced Financial and Business Modeling
Week 1
Week 1
Feb 1—Feb 4
Modules
• Understanding the basic functionality and relationships between financial statements
• Explanation of the supporting accounting transactions
• Building assumptions and generalizations about the layout of the models
• Review of basic-to-advanced Excel functions used in integrated statement modeling
• Introduction to the building process of the integrated statement model
• Understanding the nature of the objective/engagement and why we were retained
• Determining the work product required by the company, firm and end-users
• Interviewing team leaders and managing document requests
• Reviewing documents pertaining to organizational structure, business activities, legal and HR
• Reviewing relevant data, financial information, process documentation, etc.
• Assessing information corresponding to analysis and modeling needs
• Organizing the model, document requests, and data received
• Developing the overall model structure and crafting supporting schedules
• Following commonly-recognized best practices for ease of use and collaboration
• Horizontal vs. vertical arrangements
Week 2
Week 2
Feb 5—Feb 11
Modules
• Importing historical information
• Building baseline forecasts with roll-forwards and streamlined assumptions
• Forecasting assumptions and key drivers for major line items
• Developing the revenue and expense forecast with top-down and bottoms-up approaches
• Analyze fixed vs. variable vs. mixed costs in the build-up of the expense budget
• Building balance sheet roll-forwards for key accounts (receivables, payables, inventory, fixed assets, debt, equity)
• Understanding the drivers of revenue, pricing, and volume
• Building the revenue forecast
• Profiling drivers of costs and the material, labor, and OH forecasts
• Forecasting general overheads (SG&A)
Week 3
Week 3
Feb 12—Feb 18
Modules
• Identifying key balance sheet account roll-forwards, reconciling beginning/ending balances
• Building out the roll-forward forecasts for all key accounts
• Reviewing common anomalies and nuances within the accounts
Week 4
Week 4
Feb 19—Feb 25
Modules
• Connecting the financial statements with plugs and ensuring its integrity
• Finalizing the statement of cash flows
• Building “checks” into models to reconcile indirect cash flow and direct cash flows
• Performing quality review, assessing model mechanics and accounting/operating assumptions
Week 5
Week 5
Feb 26—Feb 29
Modules
• Establishing the connections and performing a QC on the integration
• Considering which line items to serve as plugs
• Modeling the revolving line of credit, cash, and other accrued expenses
• Completing the integration
• Understanding the limitations of the integrated model
• Considering possible scenarios and sensitivities
• Rolling the model forward for future periods and updating information seamlessly
• Updating the model for actual results
• Incorporating a borrowing base forecast of advanced on A/R and inventory
• Building an EBITDA-to-cash bridge forwards and backwards
• Organizing the model for presentations
• Reviewing variances and waterfalls
• Updating the model for operating assumptions
• Reconciling the integrated long-term model with a 13-week cash flow
5.0
(5 ratings)
I liked the structure -- a folder full of files with each file having another layer completed. It made it easy to get up to speed if you missed a section. The combination of qualitative information / insight and actual Excel work was great.
-- Tim Ahlberg, Restructuring Director
Principal, Seidman Financial
Carl serves as a fractional CFO, FP&A advisor, and management consultant to entrepreneurial businesses throughout North America and Europe and assists them with strategic financial planning, value enhancement, and revitalization.
He's one of the preeminent trainers and facilitators in strategic finance and FP&A, with more than 13,000 participants attending his financial training programs, seminars, workshops, and masterminds. Notable clients include:
ABM Industries, Accordion, AlixPartners, Allscripts, Broadridge, CHEP, Choice Hotels, CIBC, Cigna, Cox Enterprises, Crawford & Company, Deloitte, Dexcom, Discover Financial Services, Dominium, Express Scripts, EY, FS Investments, EVRAZ, Genentech, HCP, Inc., Heartland Financial, Hewlett Packard Enterprise, IGT, KPMG, Marsh & McClennan, Michelin, NerdWallet, Radisson, Rapid7, Sol Petroleum, Spotify, Triple-S, Telus, Santander, United Technologies, Universal Business Team, Verizon, and Walmart.
Carl is masterful at making the complex amazingly simple, engaging his audiences, building confidence, and facilitating a welcoming and transformative group experience. His content is rich and relatable, used in financial leadership development programs (FLDPs) at Fortune 500 companies, and is utilized or licensed by 6 of the top global financial training companies.
Carl is a Certified Public Accountant (CPA) has earned other professional credentials including the CIRA, CFF, CFE, CGMA, AM (Accredited Member in Business Valuation), CSP (Certified Speaking Professional), Certified Anaplan Model Builder, and was a National Association of Certified Valuators and Analysts (NACVA) 40 Under Forty honoree. He holds a BA in finance and economics and an MS in managerial accounting.
He's been where you want to be and does the work you want to do.
John Christian
Rachael Kuehn
Harry Bramson
Conor Flynn
Christy Roper
Raphael Di Napoli
9am - 1pm CST
Feb 2024
$1,999 USD
Dates
Feb 1—29, 2024
Payment Deadline
Jan 31, 2024
This program was much better than the previous modeling course I attended due to the call for thinking critically as well as the granularity covered. I've already recommended this course to others.
-- Eric Armenteros, Turnaround and Restructuring Advisor
The Fractional CFO Power Skills Mastermind
Dynamic Excel for Finance
Advanced Financial and Business Modeling
Cash Flow Forecasting and Modeling
Managing Data for Finance with Power Query
Financial Planning & Analysis (FP&A) Technical and Strategic Mastery
Delivering Financial Presentations with Executive Presence
Forecasting and Valuing Major Capex Projects
Coming soon
Data Visualization and Power BI for Finance
Coming soon
Feb 2024
$1,999 USD
Dates
Feb 1—29, 2024
Payment Deadline
Jan 31, 2024
Submit your information and we'll be in touch.