Hosted by
Carl Seidman CPA | Microsoft MVP
The person Fortune 500s use for their financial leadership development programs

NEW · 12-Month Membership
Hosted by
Carl Seidman CPA | Microsoft MVP
Partial List of Current & Former Clients





Program Overview
FP&A mastery is the ability to make good, defensible judgments about finance-related decisions, even in the face of high stakes and ambiguity. Leaders who exemplify FP&A mastery skills work at amazing corporations and rapidly-growing entrepreneurial companies.
A common misconception around these finance skills is that they’re something you either have or you don’t and they take many years to attain.
…but that’s not true.
In reality, you can significantly improve your financial planning & analysis (FP&A) influence + critical and strategic thinking ability by reframing your mindset and mastering a handful of core skills: business modeling, financial analysis, empathy and partnership, and effective communication.
The best FP&A professionals don’t think like analysts. They think like advisors. They’re higher-level thinkers. They understand how their insights connect to what others care about. And they’re masterful communicators. They don’t refer to themselves as masters, but they’re always in pursuit of mastery.
People who level up their FP&A technical and non-technical ability tend to get selected for better projects that are more interesting and challenging than those their peers get assigned to. Directors know these exceptional people can handle it and shine. When they succeed, they’re more likely to get promotions, higher pay, and even more exciting opportunities. Work is far more enjoyable and less frustrating because they’re now more capable, confident, and positive. This leads to a more inspiring career and a fulfilling life.
Influence through finance is a skill that can be rapidly developed by changing how you think through learning, application, practice, and ongoing support. This isn’t wishful thinking. This is reality for those who are committed to their own growth.
This year-long membership gives you full access to weekly live, virtual courses and the complete library of module recordings, immersing you in the frameworks and techniques used by high-performing corporate finance practitioners. Through real-world examples, exercises, templates, models, discussions, and hands-on implementation, you’ll evaluate financial models, Excel techniques, analyses, reports, and dashboards to understand what makes them exceptional (or not). Each session challenges you to think more deeply about finance, modeling, influence, and communication—helping you elevate not just your technical skill set, but the way you think about and approach your work all year long.
* Each series is also available as a standalone course. If you are interested in an individual course, click the button below.
Choose the level of access that aligns with your goals.
Core Access delivers 12 months of on-demand recordings for all 8 series, plus downloadable templates and future updates—ideal for independent, self-paced learners or those with conflicting calendars or time zones.
Professional Access includes everything in Core, plus guaranteed seats in live virtual classes, extended Q&A sessions, networking events, and CPE credits for live participation.
Inner Circle Access for those seeking direct support and implementation. This level provides our most comprehensive experience—adding 1:1 coaching, proprietary tools and models, priority referrals, a LinkedIn credential + digital badge, and a capstone case or company-specific project review with written feedback.
Individual courses will immerse you in the content of that single learning experience. The Signature Program gives you access to EVERYTHING across the full learning ecosystem:
*Benefits are dependent on membership level. See pricing tiers for details.
If you are eligible, tap into this community of like-minded high-achievers committed to your success. Immerse yourself in technical and non-technical development designed to change how you think and support you in reaching your next level of growth.
For companies with multiple attendees, group rate waivers are available.
It’s vital to understand the finances of your business, the causes of cash bleeding, and remedies for improving working capital. In this program, discover the various causes of cash flow constraints and how to address them, learn the step-by-step process for building a direct approach 13-week cash flow forecast model, and integrate it with a longer-term financial forecast.
It’s vital to understand the finances of your business, the causes of cash bleeding, and remedies for improving working capital. In this program, discover the various causes of cash flow constraints and how to address them, learn the step-by-step process for building a direct approach 13-week cash flow forecast model, and integrate it with a longer-term financial forecast.
Strong budgeting and forecasting processes are essential for turning financial plans into practical business decisions. In this program, discover why static budgeting often falls short, learn how to build top-down, bottom-up, and driver-based budget models, and improve your approach to planning overhead and SG&A expenses. You’ll also explore how to partner more effectively with operations and use rolling forecasts to keep plans forward-looking, flexible, and aligned with changing business needs.
Power Query is a powerful tool for extracting, transforming, and preparing data for analysis in Excel and Power BI. In this program, participants will learn how to connect to multiple data sources, clean and manipulate data, create custom calculations, and automate data preparation steps to support more efficient analysis, forecasting, and financial decision-making.
Power Query is a powerful tool for extracting, transforming, and preparing data for analysis in Excel and Power BI. In this program, participants will learn how to connect to multiple data sources, clean and manipulate data, create custom calculations, and automate data preparation steps to support more efficient analysis, forecasting, and financial decision-making.
Financial and operational data should do more than report results. In this program, discover how to interpret the signals within a business model, use modeling to connect finance and operations, analyze performance through key metrics and variance analysis, and turn insights into actions that improve decision-making and business results.
Financial and operational data should do more than report results. In this program, discover how to interpret the signals within a business model, use modeling to connect finance and operations, analyze performance through key metrics and variance analysis, and turn insights into actions that improve decision-making and business results.
Build upon the foundational skills from Level 1, deep diving into advanced techniques and processes necessary for maintaining a comprehensive cash flow management process. deepen expertise and tackle the complexities of cash flow forecasting and comprehensive model management.
In this exceptionally interactive, roll-up-your-sleeves program, you will transition from a traditional financial analyst to a strategic financial modeler and advisor, capable of building complex and dynamic integrated Excel models that capture the intricacies of business operations. You will walk through the step-by-step methods for data acquisition, model structuring, and building integrated 3-statement financial and operating models.
Many people working in finance and accounting are masters of the analysis, but they fail at the delivery. They overwhelm their audiences with complex content, leaving them confused. In this program, audiences will learn from an FP&A practitioner, Second City- and Improv Olympic trained performer and award-winning speaker, blending professional delivery with cognitive science, data-rich content, and executive presence.
Many people working in finance and accounting are masters of the analysis, but they fail at the delivery. They overwhelm their audiences with complex content, leaving them confused. In this program, audiences will learn from an FP&A practitioner, Second City- and Improv Olympic trained performer and award-winning speaker, blending professional delivery with cognitive science, data-rich content, and executive presence.
In this exceptionally interactive, roll-up-your-sleeves program, you will transition from a traditional financial analyst to a strategic financial modeler and advisor, capable of building complex and dynamic integrated Excel models that capture the intricacies of business operations. You will walk through the step-by-step methods for data acquisition, model structuring, and building integrated 3-statement financial and operating models.
Enduring business growth comes from strong financial strategy and execution. This course makes the complexity of FP&A remarkably simple. In this series, learn the technical skills and mindset that make the greatest difference in landing a job in FP&A, getting promoted, and pursuing the internal opportunities you’re looking for.
Enduring business growth comes from strong financial strategy and execution. This course makes the complexity of FP&A remarkably simple. In this series, learn the technical skills and mindset that make the greatest difference in landing a job in FP&A, getting promoted, and pursuing the internal opportunities you’re looking for.

Learn directly from Carl Seidman CPA | Microsoft MVP in a real-time, interactive format.

Go back to course content and recordings whenever you need to.

Download practical templates, reports, models, and work files you can use right away.

Stay accountable and share insights with like-minded professionals.

Share your new skills with your employer or on LinkedIn.
Click on the program title below to view the syllabus
Carl is a go-to FP&A development facilitator for Fortune 500s, mid-market companies, and entrepreneurial businesses. He is a Microsoft MVP (1 of just 35 US-based Excel MVPs) and 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, Dominium, Express Scripts, EY, FS Investments, EVRAZ, Genentech, Healthpeak, Heartland Financial, Hewlett Packard Enterprise, Hostess, IGT, KPMG, Marsh & McLennan, Michelin, NerdWallet, Radisson, Rapid7, Sol Petroleum, Spotify, Triple-S, Telus, Santander, United Technologies (RTX), UBT, Verizon, Walmart, and Workday.
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 7 of the top global financial training companies.
Carl serves as an Adjunct Professor in data analytics at the Jones School of Business at Rice University. He 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.
Contact: info@seidmanfinancial.com
Every live session is recorded so you can access it after it takes place.
Want to access to a live session and group discussion before it runs again? Get on-demand access to prior live cohort sessions any time you want.
Everything is at your fingertips.
Capstone cases or project reviews may be completed at the end of each course after the conclusion of the final learning session.
Attendees may attend office hours and are given 1 week to complete the project. Upon submission, attendees will receive coaching and written feedback.
*Benefits dependent on membership level. See pricing tiers for details.
This course builds on live workshops and hands-on projects
No problem. While you are encouraged to attend live sessions — as a great part of the experience is both the live-reveals and the participant interaction — all sessions are recorded and may be accessed on your own time.
Based on client feedback, we’ve added more breathing room to the schedule.
The experience is intentionally spaced out — each series is run 1 session per week for 2 hours.
Periodically, two courses will run concurrently, but they will take place on different days of the week.
Courses vary in length from 6 sessions to 10 sessions. See the program calendar above for more details.
There may be occasional pre-work and post-session work but it is minimal.
Because all sessions are recorded, you can revisit topics and discussions on your own schedule.
It is not customary for us to receive requests for refunds. However, if you are dissatisfied with your experience, please reach out to our customer service team so we can ensure you receive the value you expect.
We offer more than a dozen training programs and immersive development experiences across a wide range of finance and accounting topics.
Here are the standalone Seidman Financial program options.
This membership provides a huge cost savings vs purchasing courses a la carte.
In addition, the membership gives you the complete FP&A skill stack — not just one topic — with 8 live courses, full recording access, CPE credits, and ongoing development over 12 months. Instead of solving a single skills gap, it builds the technical, strategic, and communication capabilities needed to operate at a high-performing finance leader level.
Each course will meet live on Zoom for 2 hours, 1x per week.
Periodically, two courses will run concurrently, but they will take place on different days of the week.
Each session covers 1-2 learning topics. And classes do build on each other. Each session ties into prior and future sessions, so it is important to try to avoid missing classes or watched recordings.
The structure of the session begins with an intro, a tie-in to a real example, exercises, discussion, and reflections.
Prerequisites for the course include the following:
No, but I will offer you my promises.
Everyone who attends this experience will have different backgrounds and aspirations which means they have different business models or jobs.
My promise is to share with you my techniques, tools, and processes that will accelerate your finance career and make you far more confident in what you do
Yes. Professional or Inner Circle Access includes many bonuses including:
– Networking events, bonus sessions
– Extended Q&A live and recorded sessions
– 1:1 office hour or coaching session
– Additional Tools – access to proprietary business models
– Priority client referrals
– LinkedIn Credential + Digital Badge
– Capstone case or company-specific project review + written feedback
Yes, it qualifies for 114.0 CPE credits.
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.
Yes! We offer installment payments through Affirm*. If you prefer a payment plan, Affirm allows you to select the payment structure (monthly, quarterly, etc.). You can review and apply for monthly terms at checkout.
*Subject to eligibility. Terms apply.
Most on-demand courses teach steps for plugging numbers into basic models. They don’t teach the nuances that you’re likely to encounter across a wide range of instances. And most course trainers don’t come from FP&A and CFO backgrounds.
According to alumni, this is the best FP&A course curriculum available.
While students can enroll in any course individually, the FP&A Mastery Signature Program™ is designed as the most comprehensive, high-value, learning experience in the FP&A space.
Students are encouraged to get the most complete experience versus enrolling in each course one at a time.
Discount Applied Successfully!
Your savings have been added to the cart.
📄 Cash Flow Modeling Best Practices | Structure
📄 Direct vs. Indirect Cash Flows
📄 Cash Flow Modeling Best Practices | Contents and Formulas
📄 Cash Flow Modeling Best Practices | Quality Review and Presentation
📄 Structuring the Cash Flow Forecast Model
📄 Getting the Timing Right: Accrual vs. Cash
📄 How the Financial Statements Connect and Relate
📄 Introduction to the Business Case
📄 Sourcing information from reports, statements and data
📄 Modeling Sales and Cash Collections
✍️ Build Your Own Sales and Collections Forecast
📄 Modeling Payroll, Benefits, Payroll Taxes, and Layoffs
📄 Modeling Direct Costs and Payments
📄 Modeling Inventory Categories
📄 Advanced Inventory Modeling (Raw Material | Work in Progress | Finished Goods)
📄 Modeling Direct Costs and Accounts Payable (A/P)
📄 Modeling Prepaid and Accrued Expenses
📄 Modeling Indirect Operating Expenses
📄 Modeling Debt and Equity
📄 Modeling Capex / Fixed Assets
📄 Modeling Professional Fees
📄 Modeling Financing Strategy with Excess Cash and Cash Flow Surpluses
📄 Modeling Financing Strategy with Cash Constraints and Cash Flow Deficits
📄 Modeling the Borrowing Base and Available Collateral for Short-Debt Financing
📄 Modeling the Revolving Line of Credit (LOC), Cash Needs, and Borrowing Base
📄 The Completed Cash Flow Model
📄 Modeling Operating Improvements and Changes to Working Capital
📄 Reorganizing and Revitalizing the Business
📄 Reconciling Profitability to Cash (EBITDA-to-Cash Bridge)
📄 Integrations and Nuances in the Timing of Cash Flows
📄 13-Week Cash Flows, DIP Budgets, and Bankruptcy
✍️ Capstone Business Case – Cash Flow Forecasting and Modeling (Submit by Nov. 14)
📄 Problems with traditional budgeting (rigidity, political sandbagging, time lag)
📄 Annual budgets versus rolling forecasts
📄 Changing business rhythms and why dynamic forecasting wins
📄 How FP&A can lead the planning shift without alienating leadership
📄 Structuring assumptions in Excel for transparency and flexibility
📄 Identifying high-impact business drivers (volume, price, conversion, churn)
📄 Linking assumptions to revenue and expense line items
📄 Building budgeting and forecasts for the enablement of scenario analysis
📄 How sales and gross profit impact decisions about SG&A
📄 Budgeting and forecasting overhead expenses
📄 Why forecasts break down: lack of ownership and engagement
📄 Structuring cross-functional forecasting conversations
📄 Making models understandable and relatable to non-finance teams
📄 Collaborative planning tools and tips (without needing expensive software)
📄 Disaggregate SG&A into actionable components
📄 Distinguish between fixed, variable, and step-function costs
📄 Use driver-based techniques where possible
📄 Incorporate controllability and accountability
📄 How to set the forecast horizon (3-month, 6-month, 12-month, hybrid)
📄 Design choices: overwrite vs. layer on vs. rebuild
📄 Inputs and workflows: who provides what, and when
📄 Handling “actuals + forecast” views and continuous reforecasting
📄 Break for Capstone Business Case Completion
📄 What is Microsoft Power Query and Why Does it Matter to Finance
📄 Dynamic Data Modeling Process Flow
📄 How Power Query and Financial Systems Interact
📄 When to Use Power Query vs. Excel
📄 Data Acquisition Sources for Power Query
📄 Data Conversion Through Power Query
📄 Editing Power Query Parameters
📄 Power Query Editor – Intro to the Ribbons
📄 Power Query Editor – Home Ribbon
📄 Power Query Editor – Transform Ribbon
📄 Power Query Editor – Add Column Ribbon
📄 Data Connections via Power Query
📄 Introduction to Dynamic Tables
📄 Integration of Dynamic Tables with Power Query
📄 Financial and Business Modeling with Power Query and Data Tables
📄 Intro to Data Modeling with Power Query
📄 Data Modeling – Establishing Tabular Relationships
📄 Data Modeling – Establishing Data Hierarchies
📄 Data Modeling – Data Relationship Directions
📄 Data Modeling – Cascading Data Flows
📄 Data Modeling – Viewing and Hiding Tabular Relationships
📄 Data Modeling Rules
📄 Introduction to Data Analysis Expressions (DAX)
📄 Data Analysis Expressions (DAX) – Syntax and Rules
📄 Data Analysis Expressions (DAX) – Syntax and Rules
📄 Data Analysis Expressions (DAX) – Calculated Columns
📄 Data Analysis Expressions (DAX) – Measures
📄 Introduction to Power Pivot
📄 How Power Pivot Compares/Contrasts with Traditional Pivot Tables
📄 Activating and Accessing Power Pivot
📄 Creating a Power Pivot Report
📄 Overlap Between Power Excel and Power BI
📄 How Power Query Integrates with Power BI
📄 Break for Capstone Business Case Completion
📄 Overview of the income statement, balance sheet, and cash flow story
📄 Identify financial signals in growth, margin, working capital, and CapEx
📄 Where is the business succeeding and where is it failing?
📄 Analyzing sales by channel, customer, SKU, and other criterion
📄 Model capacity, throughput, and utilization across production lines
📄 Structure COGS assumptions and analyze potential issues
📄 Bridge operations with financial outcomes using Excel-linked drivers
📄 Defining the purpose of FP&A in business partnering
📄 Linking strategy > KPIs > metrics > decision making
📄 Building summaries and dashboards for financial and non-financial performance
📄 How to select the right KPIs and objectives for business functions
📄 Financial vs. leading operational indicators (lagging vs. forward-looking)
📄 Techniques to track and update data and operating performance
📄 Structuring variance reports that tell the story
📄 Techniques for drilling down into sales, marketing ROI, hiring plans, etc.
📄 Communicating insights and recommendations to non-financial business partners
📄 Synthesize the model into 3–5 high-impact recommendations
📄 Structure analysis for presentation to ops or executive teams
📄 Distill complexity into clear visuals and decision points
📄 Move from reactive finance to forward-operating business partner
📄 Break for Capstone Business Case Completion
📄 The accounts receivable accounting equation
📄 Analyzing the accounts receivable aging report
📄 Analyzing historical trends, terms, and anticipated receipts
📄 Data automation and rolling the receivables forecast
📄 Analyzing payroll schedules
📄 Analyzing the impact of different payroll cycles
📄 Contemplating raises and COLA adjustments
📄 Restructuring compensation
📄 Analyzing layoffs, severance, and related contingencies
📄 Integrating payroll into comprehensive cash flow models
📄 The accounts payable accounting equation
📄 Analyzing the accounts payable aging report
📄 Analyzing terms, critical relationships, and payment strategies
📄 Contemplating early-pay discounts and tradeoffs
📄 Data automation and rolling the payables forecast
📄 Updating the Cash Flow Model for New Data
📄 Connecting Back-End Financial Data into the Cash Flow Model
📄 Overview of Data Mapping
📄 Introduction to Microsoft Power Query
📄 How a Long-Term Planning Model Differs from a Near-Term Cash Flow Model
📄 Excel Functionality for Seamless Integration Between Weekly and Monthly Forecast
📄 Connecting the Weekly Forecast to the Monthly Forecast
📄 Analyzing historical maintenance capex
📄 Planning for investment capex and major projects
📄 Scenario analysis for capex decisions and contingency planning
📄 Credit agreements and terms
📄 Integrating financing and amortization schedules
📄 Automating debt service
📄 Comprehensive scenario management
📄 Advanced concepts in cash flow forecasting and liquidity management
📄 Forecast-to-actual variances
📄 Forecast version to forecast version variances
📄 Interpreting variances and rolling the forecast
📄 Introduction to 3-Statement Financial Modeling and Integrated Business Modeling
📄 3-Statement Financial Modeling (Corporate Finance vs. Investment Banking)
📄 Context is Key: Understanding Business/Client Objectives
📄 Understanding the Dynamics of the Business and its Industry
📄 🎯 INTRODUCTION TO THE BUSINESS CASE
📄 Modeling Skills Inventory: The Skills you Need and Those You Don’t
📄 Introduction to 3-Statement Financial Modeling and Integrated Business Modeling
📄 3-Statement Financial Modeling (Corporate Finance vs. Investment Banking)
📄 Context is Key: Understanding Business/Client Objectives
📄 Understanding the Dynamics of the Business and its Industry
📄 🎯 INTRODUCTION TO THE BUSINESS CASE
📄 Modeling Skills Inventory: The Skills you Need and Those You Don’t
📄 Designing and Developing the Model at the Outset of the Project
📄 Model Formats and Layouts: Vertical Structure vs. Horizontal Structure
📄 Model Hygiene and Common Font Color Schemes
📄 Other Modeling Best Practices to Consider
📄 Error Check Schedules and Conducting Quality Reviews
📄 Overview of the Financial Statements
📄 The Income Statement
📄 The Balance Sheet
📄 The Statement of Cash Flows – Indirect
📄 The Statement of Cash Flows – Direct
📄 Understanding the Key Connection Across the Financial Statements
📄 Accrual vs. Cash Impact
📄 Identifying Risks and Uncertainty Inherent in the Business and Model
📄 Overview of the Integrated Financial Statement Modeling Process
📄 Overview of the Income Statement | Profit & Loss
📄 Review of the Historical Financials and What They Mean for the Forecast Model
📄 Identifying Revenue Drivers and Segmenting the Sales Forecast
📄 Driver-Based Forecasting: Industry Examples
✍️ Exercise: Forecasting Revenue (Submit by Aug 20)
📄 Identifying Cost Types and Drivers | Forecasting Direct Costs
✍️ Exercise: Forecasting Direct Costs (Submit by Aug 20)
📄 Forecasting General Overhead Expenses (SG&A)
✍️ Exercise: Forecasting Key SG&A Line Items (Submit by Aug 20)
📄 Overview of the Balance Sheet
📄 Key Balance Sheet Roll-Forwards
📄 Accounts Receivable (A/R) Roll-Forward
📄 Days Sales Outstanding (DSO) and A/R Aging Analysis
✍️ Exercise: Accounts Receivable Roll-Forward (Submit by Aug 20)
📄 Inventory Roll-Forward
📄 Days Inventory Outstanding (DIO) | Days Inventory On Hand (DOH) Analysis
✍️ Exercise: Inventory Roll-Forward (Submit by Aug 20)
📄 Prepaid Expense Roll-Forward
📄 Accrued Payroll Roll-Forward
✍️ Exercise: Accrued Payroll Roll-Forward (Submit by Aug 20)
📄 Accrued Professional Expenses and Fees Roll-Forward
✍️ Exercise: Accrued Professional Fees Roll-Forward (Submit by Aug 20)
📄 Taxes Payable Roll-Forward
✍️ Exercise: Taxes Roll-Forward (Submit by Aug 20)
📄 Accounts Payable | Accrued Expenses Roll-Forward
📄 Days Payable Outstanding (DPO) Analysis
✍️ Exercise: A/P and Accrued Expenses Roll-Forward (Submit by Aug 20)
📄 Review of the Key Working Capital (WC) Accounts and Roll-Forwards
📄 Capital Expenditures (CapEx) and Fixed Assets Roll-Forward
📄 Intangible Assets Roll-Forward
✍️ Exercise: Fixed Assets and Intangible Assets Roll-Forward (Submit by Aug 20)
📄 Long-Term Debt Roll-Forward
✍️ Exercise: Long-Term Debt Roll-Forward (Submit by Aug 20)
📄 Revisiting the 3-Statement Modeling Process
📄 Building the Statement of Cash Flows
✍️ Exercise: Building the Statement of Cash Flows (Submit by Aug 20)
📄 Connecting the Financial Statements
📄 Modeling Plugs and Unknowns — Revolving Lines of Credit, Cash, Accrued Expenses
✍️ Exercise: Revolving Line of Credit Roll-Forward Submit by Aug 8
📄 Interest Expense Roll-Forward
✍️ Exercise: Interest Expense Roll-Forward Submit by Aug 8
📄 Completing the Integrated Financial and Business Model
📄 Advanced Concepts in Integrated Financial and Business Modeling
📄 Borrowing Base Roll-Forward
✍️ Exercise: Borrowing Base Roll-Forward (Submit by Aug 20)
📄 The EBITDA-to-Cash Bridge: Reconciling Profitability with Liquidity
✍️ Exercise: EBITDA-to-Cash Bridge (Submit by Aug 20)
📄 Explaining Hits and Misses: Illustrating With Variances and Waterfalls
📄 Organizing the Model for Presentations
📄 Updating Operating Assumptions and Running Business Scenarios
✍️ Exercise: Actively Manage Costs and Expenses (Submit by Aug 20)
📄 Summary and Final Thoughts
✍️ Capstone Business Case: Advanced Financial and Business Modeling
📄 The misguided focus of finance professionals
📄 Human intelligence versus artificial intelligence
📄 What does effective communication in finance look like
📄 Effective vs. ineffective business communication
📄 Why financial presentations fall flat
📄 The flow of business communication
📄 Identifying the mandate and needs of the audience
📄 Gap analysis and bridging the gap
📄 Financial presentations begin before the presention
✍️ Business Case – Evaluating Communication Styles (Submit by Jan 25)
📄 Managing the message and the presentation
📄 Building rapport and credibility with financial and non-financial audiences
📄 Leveraging information flow and delivery methods to establish credibility
📄 Flow and intentional engagement of limited cognitive attention
📄 Simplicity, clarity and assessing what’s in it for them
📄 Managing the message and the presentation
📄 Visual overload, lack of clarity and purpose
📄 Managing time, conflicting agendas, and focal points
📄 Credibility versus relevance
📄 Connecting with financial and non-financial audiences through relevance
📄 6 elements of trust and rapport
📄 Characteristics of a strong PowerPoint presentation
📄 Visual consumption and cognitive synthesis
📄 Balancing visual with verbal deliveries
📄 Multitasking and audience distraction
📄 Memory retention
📄 Differences between in-person and virtual presentations
📄 Effective room management for in-person and virtual settings
📄 Common mistakes in virtual meetings and presentations
📄 Informative versus emotive visuals
📄 What makes visual displays confusing
📄 Dishonest and deceptive presentations
📄 Preparing support schedules and backup
📄 Managing audience personalities and politics
📄 Presenting reports versus delivering presentations
📄 FP&A Business Modeling and Financial Modeling Best Practices
📄 FP&A Business Model Structure and Layout
📄 FP&A Modeling and the P.E.A.C.E. Framework
📄 FP&A Formula Auditing, Error-Checking, and Evaluation
📄 Monitoring and Tracking Updates and Changes
📄 Introduction to Dynamic FP&A Business Modeling
📄 Dynamic Functionality in Enterprise Performance Management and Excel
📄 Dynamic Data Sets and Tables
📄 Dynamic Data Ranges and Formulas
📄 Dynamic Data, Pivot Tables and Slicers
📄 Dynamic Sparklines
📄 Dynamic FP&A Models in Practice
📄 Introduction to Dynamic FP&A Business Modeling
📄 Dynamic Functionality in Enterprise Performance Management and Excel
📄 Dynamic Data Sets and Tables
📄 Dynamic Data Ranges and Formulas
📄 Dynamic Data, Pivot Tables and Slicers
📄 Dynamic Sparklines
📄 Dynamic FP&A Models in Practice
📄 Resonating with the Intended Audience
📄 Managing Aesthetics, Presentation, and FP&A Model Components
📄 Enhancing User-Interface with Form Controls
📄 Presenting Dashboards, Waterfall Charts, and Executive Summaries
📄 Sum of Worksheets Approach to Scenario Management (Excel)
📄 Multi-Dimensional Modeling Approach to Scenario Management (Excel)
📄 Scenario Manager Tool (Excel)
📄 Employing Sensitivity Analysis for Variable Inputs and Drivers
📄 Methods in Forecasting, Budgeting, and Projection
📄 Forecasting, Budgeting, and Projections for SMBs
📄 Techniques for Improving Forecast Accuracy
📄 Integrating Rolling Forecasts
📄 Modeling Risk, Uncertainty, Probability, and Impact
📄 Quantifying the Value of Major Projects
📄 Determinations for Appropriate Investment and Maintenance Capex
📄 Measuring Cash Flow, Revenue Recognition, and Cost Allocations
📄 FP&A Strategic Planning and Gap Analysis
📄 The Income Statement and Underlying Reporting
📄 Revenue and Cost Analysis
📄 The Balance Sheet and Underlying Reporting
📄 Working Capital Forecasting and Planning
📄 Cash Flows and Underlying Reporting
📄 Common-Sizing and Period-Over-Period Trend Analysis
📄 Liquidity Planning and Debt-Sizing
📄 Performance Optimization, Metrics, and Ratio Analysis
📄 Strategic Growth Planning and Profitability Enhancement
📄 Appraising the Business and Enhancing Value
📄 Course summary, reflections, wrap up, and next steps