Financial Planning & Analysis Masterclass

Learn the fundamentals of Financial Planning & Analysis (FP&A), including budgeting, forecasting, financial analysis, cash flow management, and performance monitoring, and understand how these functions support strategic business decisions. This introductory lesson explains the role of FP&A professionals in helping organizations improve financial stability, manage risks, and drive long-term growth.

Learn the first two components of the FP&A framework by understanding how historical financial data is transformed into future plans and how financial insights support strategic decision-making. This lesson explains how forecasting, budgeting, market analysis, and actionable insights help organizations align financial strategies with long-term business objectives.

Learn the remaining components of the FP&A framework, including aligning financial plans with strategic goals, conducting scenario analysis and risk management, and monitoring financial performance. This lesson explains how these interconnected processes help organizations adapt to changing business conditions, optimize resources, and achieve long-term strategic success.

Learn the complete Financial Planning & Analysis (FP&A) cycle, covering budgeting, forecasting, financial analysis, variance analysis, scenario planning, performance reporting, strategic planning support, and cost management. This lesson explains how these interconnected stages help organizations improve financial performance, support strategic decisions, and drive sustainable business growth.

Learn the key differences between Financial Accounting and Financial Planning & Analysis (FP&A) by comparing their purpose, scope, reporting, methodologies, compliance requirements, and stakeholder interactions. This lesson explains how accountants focus on historical financial reporting and regulatory compliance, while FP&A professionals use financial insights and forecasting to support strategic business decisions.

Learn about the career progression in Financial Planning & Analysis (FP&A), including the roles, responsibilities, skills, and qualifications required for entry-level analysts and mid-level FP&A managers. This lesson explains how professionals advance from data analysis and budgeting to leading financial planning, forecasting, business partnering, and strategic decision-making.

Learn about senior-level and executive FP&A career paths, including the responsibilities, skills, and qualifications required for FP&A Directors, CFOs, and Vice Presidents of Finance. This lesson explains how finance leaders drive strategic planning, oversee financial operations, manage stakeholder relationships, and support long-term business growth through effective financial leadership.

Learn how the FP&A and finance governance structure operates within a global financial institution through a case study of JPMorgan, covering key committees, leadership roles, risk management, compliance, and internal controls. This lesson demonstrates how finance teams collaborate across functions to support strategic decision-making, regulatory compliance, and effective financial governance.

Learn the fundamentals of budgeting, including its purpose, key components, and role in planning, organizing, and managing business operations. This lesson explains how budgets help organizations allocate resources, measure performance, and align financial plans with strategic objectives to achieve long-term goals.

Learn the key differences between budgeting and forecasting by understanding their purpose, flexibility, and role in the financial planning process. This lesson explains how forecasts help predict future outcomes, while budgets provide a structured financial plan to achieve organizational goals.

Learn the key objectives of budgeting and the complete budgeting process, from setting objectives and goals to preparing budgets, monitoring performance, analyzing variances, and taking corrective actions. This lesson explains how an effective budgeting process helps organizations allocate resources efficiently, improve financial control, and achieve strategic objectives.

Learn the different types of budgets used in Financial Planning & Analysis (FP&A), including fixed, flexible, functional, master, and period-wise budgets, along with key operational budgets such as sales, production, cash, inventory, and cost budgets. This lesson explains how each budget supports planning, resource allocation, cost control, and effective financial decision-making across an organization.

Learn what a fixed budget is, how it is prepared, and when it is most suitable for business planning through a practical budgeting example. This lesson explains the advantages and limitations of fixed budgets, showing why they are effective in stable environments but less adaptable to changing business conditions.

Learn how a flexible budget adapts to changes in business activity and addresses the limitations of a fixed budget through practical concepts and numerical examples. This lesson explains how flexible budgeting enhances cost control, performance evaluation, and decision-making by adjusting to different production levels and changing business conditions.

Learn how to prepare a cash budget by estimating future cash receipts and payments using a step-by-step numerical example. This lesson explains how cash budgets help organizations forecast liquidity, identify cash surpluses or shortages, and plan funding requirements for effective cash flow management.

Learn how a master budget consolidates individual budgets into a comprehensive financial plan through a practical budgeting example. This lesson explains how organizations combine sales, production, cost, and operating budgets to prepare budgeted financial statements and evaluate overall financial performance.

Learn the principles of Zero-Based Budgeting (ZBB) and how every expense must be justified from scratch rather than carried forward from previous budgets. This lesson explains the ZBB process through a practical example, demonstrating how it improves cost control, resource allocation, and alignment with organizational goals.

Bring together everything you've learned in Module 2 by preparing a complete master budget from scratch. This hands-on case study demonstrates how to integrate sales, production, fixed cost, flexible cost, and cash budgets into a single consolidated financial plan, giving you a comprehensive view of business performance and financial planning.

Learn the fundamentals of forecasting and discover how businesses predict future trends, demand, and performance to support better planning and decision-making. This lesson introduces qualitative forecasting techniques, including the Delphi Method and Market Research, explaining when each approach is most effective, especially in situations with limited historical data or new business scenarios.

Explore the fundamentals of quantitative forecasting and learn how businesses use historical data and mathematical models to make accurate predictions. This lesson introduces Time Series Analysis and Regression Analysis, explains the difference between Simple and Weighted Moving Averages, and demonstrates how these techniques help identify trends, forecast future performance, and support data-driven financial planning.

Learn how to choose the most appropriate forecasting method based on data availability, business objectives, and forecasting horizon. This lesson explains when to use qualitative techniques such as the Delphi Method and Market Research versus quantitative approaches like Time Series and Regression Analysis, helping you select the right forecasting model for different business scenarios.

Learn how Time Series Analysis helps forecast future business performance using historical data. In this practical lesson, you'll use Coca-Cola's quarterly sales data to calculate Simple Moving Average (SMA) and Weighted Moving Average (WMA), visualize trends with Excel charts, compare forecasting approaches, and understand the strengths and limitations of moving average models for short-term financial forecasting.

Learn how regression analysis uses statistical modeling to forecast future business performance by identifying relationships between variables. In this practical Excel lesson, you'll build a simple linear regression model using Coca-Cola sales and gross profit data, interpret regression outputs, create scatter plots with trendlines, evaluate model accuracy using R², and use the regression equation to generate long-term financial forecasts.

Build a strong foundation in financial statement analysis by understanding the purpose, structure, and role of the three core financial statements. This lesson explains how financial statements support profitability analysis, financial planning, budgeting, forecasting, performance evaluation, risk management, capital raising, and strategic decision-making. You'll also learn why financial statements are essential for FP&A professionals, investors, lenders, and business leaders in assessing a company's financial health and long-term performance.

Learn how to read and analyze an Income Statement, one of the most important financial statements used in FP&A and financial analysis. This lesson explains the complete structure of an income statement, including Revenue, Cost of Goods Sold (COGS), Gross Profit, Operating Expenses, EBIT, Profit Before Tax (PBT), and Net Income. You'll also understand the difference between direct and operating costs, how profitability is measured, and how to interpret a real-world company income statement to evaluate financial performance and business profitability.

Learn how to read and understand a Balance Sheet, one of the three core financial statements used in financial analysis and FP&A. This lesson explains the structure of a balance sheet, including current and non-current assets, liabilities, and shareholders' equity, along with the fundamental accounting equation: Assets = Liabilities + Equity. You'll also learn how companies finance their assets, interpret key balance sheet items such as cash, inventory, accounts receivable, long-term debt, retained earnings, and goodwill, and analyze a real-world balance sheet to assess a company's financial position and long-term stability.

Understand how a Cash Flow Statement tracks the movement of cash into and out of a business and why it is one of the most important financial statements for evaluating a company's financial health. This lesson explains the three sections of the cash flow statement—Operating, Investing, and Financing Activities—and demonstrates how cash inflows and outflows differ from accrual accounting. You'll also learn how companies generate, invest, and finance cash, understand the indirect method of preparing a cash flow statement, and interpret a real-world example to assess liquidity, cash generation, and financial sustainability.

Get introduced to Ratio Analysis, one of the most important tools for evaluating a company's financial performance and health. This lesson explains how financial ratios are derived from the Income Statement, Balance Sheet, and Cash Flow Statement to assess liquidity, profitability, efficiency, and solvency. You'll also learn why ratios should always be interpreted through comparisons with historical performance, competitors, and industry benchmarks, making them a critical part of financial analysis and FP&A decision-making.

Learn how to evaluate a company's short-term financial health using Liquidity Ratios. This lesson explains the Current Ratio and Quick (Acid-Test) Ratio, their formulas, interpretation, and practical applications. Through a hands-on numerical example, you'll understand how current assets and current liabilities are used to assess a company's ability to meet short-term obligations, why inventory can distort liquidity analysis, and why the Quick Ratio often provides a more reliable measure of financial strength.

Learn how to analyze a company's earning power using Profitability Ratios, one of the most important topics in financial statement analysis and FP&A. In this lesson, you'll understand how profitability ratios measure a company's ability to generate profits relative to its revenue, assets, equity, and other financial metrics. You'll also learn how these ratios help financial analysts, investors, lenders, and management evaluate business performance, prepare accurate forecasts, and make informed strategic decisions. This video lays the foundation for understanding key profitability metrics such as Gross Profit Margin, Operating Margin, Net Profit Margin, Return on Assets (ROA), and Return on Equity (ROE), which are covered in the following lessons.

Learn how Efficiency Ratios (Activity Ratios) help measure how effectively a company utilizes its assets and manages working capital. In this lesson, you'll understand key metrics such as Inventory Turnover Ratio, Days Inventory on Hand (DOH), Receivables Turnover Ratio, and Days Sales Outstanding (DSO). Through practical examples, you'll learn how these ratios evaluate inventory management, credit collection efficiency, and cash recovery cycles. You'll also discover why efficiency ratios should always be compared with industry peers and historical trends to assess a company's operational performance and overall financial health.

Continue your understanding of Efficiency Ratios (Activity Ratios) by learning how companies manage assets, suppliers, and working capital. In this lesson, you'll explore Asset Turnover Ratio, Accounts Payable Turnover, Days Payables Outstanding (DPO), and the Cash Conversion Cycle (CCC). You'll learn how these metrics measure asset utilization, supplier payment efficiency, and the time it takes to convert inventory investments back into cash. The video also explains how to interpret these ratios in context by comparing them with industry benchmarks and competitors, helping you assess a company's operational efficiency and cash management more effectively.

This video demonstrates how to calculate and interpret key Efficiency Ratios using a practical case study, including Inventory Turnover, Days Inventory on Hand (DOH), Receivables Turnover, Days Sales Outstanding (DSO), Asset Turnover, Accounts Payable Turnover, Days Payables Outstanding (DPO), and the Cash Conversion Cycle (CCC). By applying these formulas to real financial data, you'll learn how to evaluate a company's operational efficiency, working capital management, and cash conversion process.

Learn the fundamentals of Solvency Ratios and understand how they measure a company's long-term financial stability, debt capacity, and ability to meet long-term obligations. This lesson explains key metrics including Debt-to-Equity, Debt-to-Assets, Interest Coverage, and Equity Ratio, along with their interpretation and importance in FP&A and financial analysis.

This video applies Solvency Ratio concepts to a practical example, demonstrating how to calculate and interpret Debt-to-Equity, Debt-to-Assets, Interest Coverage, and Equity Ratio. You'll also learn how to evaluate a company's long-term financial health by comparing these ratios with industry benchmarks and competitors.

Apply everything you've learned in Financial Statement Analysis by performing a complete Ratio Analysis of The Coca-Cola Company using its consolidated financial statements. This case study covers liquidity, profitability, efficiency, and solvency ratios, demonstrating how FP&A professionals interpret financial performance and draw meaningful business insights from real-world data.

Learn the fundamentals of Cost Management by understanding cost classifications, cost behavior, and the key cost drivers that influence business expenses. This lesson also explains volume-based, activity-based, structural, and executional cost drivers with practical examples from manufacturing, services, and retail to help FP&A professionals make better cost management decisions.

Apply the concept of Cost Drivers through a practical manufacturing case study and learn how to calculate cost per setup, cost per kilogram of material handled, and cost per quality inspection. This lesson demonstrates how identifying cost drivers helps businesses optimize operations, reduce costs, and improve overall cost efficiency for better FP&A decision-making.

Get introduced to Cost Accounting by understanding its purpose, key objectives, and role in budgeting, cost control, profitability analysis, and strategic decision-making. This lesson also provides an overview of the four major Cost Accounting methods—Job Order Costing, Process Costing, Activity-Based Costing (ABC), and Standard Costing, setting the foundation for the upcoming modules.

Learn Job Order Costing by understanding how businesses track material, labor, and overhead costs for individual projects or customer orders. Through a practical furniture manufacturing example, you'll calculate total job cost, profit, and selling price to see how project-specific costing supports accurate pricing and profitability.

Learn how Process Costing allocates material, labor, and overhead costs across multiple production stages to determine the cost of manufacturing continuous products. Through a practical example, you'll calculate process-wise costs, prepare a cost sheet, and understand how costs flow from one production stage to the next.

Learn the fundamentals of Activity-Based Costing (ABC) and discover how it allocates overhead costs based on the activities that actually consume resources. This lesson explains key concepts such as activities, cost drivers, and cost allocation, showing why ABC provides more accurate product costing than traditional costing methods.

Understand how Activity-Based Costing (ABC) allocates overhead costs using activity drivers such as machine setups, quality inspections, and material handling. Through a practical example, you'll calculate activity-wise costs for multiple products and see why ABC provides a more accurate view of product costs than traditional costing methods.

Learn the fundamentals of Standard Costing by understanding how businesses set cost benchmarks for materials, labor, and overhead, then compare them with actual costs. This lesson also explains variance analysis, helping you identify favorable and unfavorable variances to improve cost control and operational performance.

Apply the concepts of Standard Costing through a practical example by comparing standard and actual production costs for materials, labor, and overheads. You'll also learn how to calculate cost variances, identify favorable or unfavorable outcomes, and use variance analysis to improve cost control and operational efficiency.

Learn the key Cost Control Techniques used to manage material, labor, and overhead costs while improving profitability and operational efficiency. This lesson covers inventory and supplier management, workforce planning, budgeting, activity-based costing, and energy management strategies that help businesses reduce costs without compromising performance.

Learn how Cost-Volume-Profit (CVP) Analysis helps businesses understand the relationship between costs, sales volume, and profitability. This lesson covers contribution margin, break-even analysis, target profit calculations, and practical applications of CVP for pricing, cost control, sales planning, and product mix decisions.

Learn how to prepare and validate historical financial data for financial modeling by linking the income statement, balance sheet, and cash flow statement. This lesson explains key financial calculations, cash flow adjustments, balance sheet checks, and how historical trends are converted into assumptions for accurate financial projections.

Learn how to build a financial modeling assumption sheet by linking historical financial statement data and calculating key forecasting drivers. This lesson covers gross margin, working capital ratios (DSO, DIO, DPO), long-term assets and liabilities, depreciation, deferred taxes, dividends, and other assumptions that form the foundation for projecting future financial statements.

Learn how to project a company's Income Statement using a financial model built from historical data and key assumptions. This lesson explains how to forecast revenue, cost of goods sold (COGS), operating expenses, operating profit, taxes, and net income by linking the assumption sheet to the financial statements, creating a structured and dynamic financial forecast for future years.

Learn how to project the Balance Sheet in a financial model by forecasting current assets, non-current assets, and current liabilities using historical trends and assumption-driven formulas. This lesson covers projecting cash, accounts receivable, inventory, PP&E, goodwill, intangible assets, accounts payable, accrued expenses, and other balance sheet items while maintaining proper links between the assumption sheet and financial statements.

Continue building a complete Balance Sheet projection by forecasting non-current liabilities and shareholders' equity in a financial model. This lesson covers projecting long-term debt, interest expense, deferred tax liabilities, other long-term liabilities, retained earnings, equity adjustments, and linking these projections with the income statement and cash flow statement to create an integrated three-statement financial model.

Complete the Cash Flow Statement projection and finalize an integrated three-statement financial model. This lesson covers forecasting operating, investing, and financing cash flows, calculating changes in working capital, linking depreciation, capex, dividends, debt repayments, foreign exchange effects, and ending cash balances. You'll also see how the completed cash flow statement automatically updates the income statement and balance sheet, ensuring the model balances correctly.