Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Balance Financial Statements: The Flow is an intensive intermediate course for aspiring financial analysts and business professionals who need to master how a company’s financial story is told through data. This course moves beyond theoretical accounting to teach you how to build a dynamic, interconnected three-statement financial model from scratch. You will master the critical mechanics of linking the Income Statement, Balance Sheet, and Cash Flow Statement, ensuring your model functions as a coherent, self-balancing system rather than a collection of static numbers. Central to this course is the concept of "the flow"—understanding exactly how Net Income acts as the primary bridge between operational profitability and changes in company value. Through hands-on exercises, you will apply professional cell-referencing techniques to create models that are both accurate and scalable for complex corporate environments. By analyzing real-world examples, such as Microsoft’s 10-K filings and cautionary tales like the JPMorgan "London Whale" error, you will see why a perfectly balanced model is the non-negotiable bedrock of credible financial analysis. By the end of this course, you will be equipped to construct a professional-grade financial model that proves its own integrity. You will leave with a robust, interconnected framework ready for real-world forecasting, valuation, and strategic decision-making.

Syllabus

The Foundation: Connecting the Three Statements

This foundational module lays the critical groundwork for financial modeling by answering the essential "why" and "what." We begin by exploring the catastrophic consequences of a simple modeling error through the real-world case of the JPMorgan "London Whale," establishing why a perfectly balanced model is non-negotiable in professional finance. From that cautionary tale, we move to the core theory, systematically mapping the "golden triangle" of connections between the Income Statement, Balance Sheet, and Cash Flow Statement. You will learn precisely how Net Income fuels Retained Earnings and serves as the starting point for cash flow, and how non-cash charges like depreciation are treated. The module is designed to build a strong conceptual framework before you even open Excel, ensuring you understand the logic behind the numbers. It culminates in a hands-on activity where you will articulate these connections, followed by a formative quiz to solidify your understanding.

The 'How': Building a Dynamic Model in Excel

This module transitions from conceptual understanding to practical application, focusing on the specific Excel techniques required to bring a three-statement model to life. You will learn why dynamic, formula-driven models are superior to static, hard-coded ones, and how to build a robust and auditable spreadsheet. Through a carefully sequenced series of illustrated readings and "follow-along" screencast videos, you will perform the essential linking procedures step by step. You will learn to connect Net Income to the Retained Earnings schedule and the Cash Flow Statement, trace depreciation from the income statement to its impact on assets and cash, and perform the final, crucial link of the ending cash balance back to the Balance Sheet. The module reinforces these procedural skills with an AI-powered coaching dialogue and a hands-on exercise before testing your ability to apply them in a practical, scenario-based assessment.

Validation, Troubleshooting, and Application

In this final module, you will learn the skills that separate an amateur from a professional modeler: validation and troubleshooting. The focus is on achieving the "moment of truth"—a perfectly balancing Balance Sheet—which serves as the ultimate proof of your model's integrity. We will equip you with a systematic process for "auditing" your own work and diagnosing common errors, such as flipped signs, broken links, or incorrect ranges. You will learn how to troubleshoot like an expert through a practical screencast and a guided coaching scenario. To bridge theory with real-world practice, you will also be guided on how to navigate a real company's 10-K report to see how these statements are presented and connected. The course culminates in a final graded assessment that validates your ability to not only build but also verify a balanced, reliable financial model from start to finish.