Math for Business Operations

Applied Accounting with Excel

UNIT03 - Lesson 7

Model Completion: Cash Flow Statement Construction

45 minutes
Lesson Overview

Lesson Focus

Build Indirect Cash Flow Statement and complete three-statement integration

Key Unit Objectives

Enduring Understandings:

  • Financial statements tell the complete story of business performance and position
  • Integrated financial statements reveal connections between profit, balance sheet strength, and cash flow
  • Dynamic dashboards transform raw financial data into actionable business insights
  • Professional financial communication builds investor confidence and trust

Lesson Activities

Activity 1: Balance Sheet Completion Check
10 minutes

Verify Balance Sheet construction and Retained Earnings reconciliation

Details:

  • Teams complete their Balance Sheet construction from Day 6
  • Verify all cross-sheet links function correctly
  • Check Balance Sheet equation: Assets = Liabilities + Equity validates to zero
  • Confirm Retained Earnings properly reconciles with Income Statement Net Income
Milestone 2 Validation

Balance Sheet must be complete and accurate before proceeding to Cash Flow

  • All Asset accounts properly categorized and linked to trial balance
  • All Liability accounts correctly classified and totaled
  • Retained Earnings links to Income Statement and reconciles properly
  • Balance Sheet equation validates (difference equals zero)
Activity 2: Indirect Cash Flow Method Introduction
15 minutes

Direct instruction on Indirect Cash Flow Statement construction

Details:

  • Explain indirect method: starts with Net Income, adjusts for non-cash items
  • Demonstrate Operating Activities: Net Income + Depreciation - Changes in Working Capital
  • Show Investing Activities: Capital expenditures, asset purchases/sales
  • Cover Financing Activities: Debt changes, equity contributions, dividends paid
Activity 3: TechStart Cash Flow Construction
15 minutes

Guided practice building Cash Flow Statement for TechStart business

Details:

  • Students build Operating Activities section starting with Net Income from Income Statement
  • Add adjustments for non-cash expenses (depreciation, etc.)
  • Include changes in working capital accounts (Accounts Receivable, Accounts Payable)
  • Build Investing and Financing sections based on Balance Sheet account changes
Activity 4: Three-Statement Integration Check
5 minutes

Verify all three statements properly integrate and reconcile

Details:

  • Check: Net Income flows from Income Statement to Balance Sheet Retained Earnings
  • Verify: Cash Flow Statement ending cash balance matches Balance Sheet cash account
  • Validate: All cross-sheet links function correctly
  • Mark Milestone 3 complete for teams with fully integrated statements
Required Materials
  • Indirect Cash Flow Statement template
  • Three-statement integration checklist
  • Working capital change calculation guide
  • Milestone 3 assessment criteria
Differentiation Strategies

For Struggling Students

  • • Formula Templates: Provide INDEX/MATCH syntax with specific cell references pre-filled
  • • Step-by-Step Guides: Visual walkthroughs for each statement construction process
  • • Simplified KPIs: Focus on 2-3 basic ratios rather than complex dashboard features
  • • Peer Support: Pair with students strong in Excel for collaborative construction

For Advanced Students

  • • Advanced Features: Implement dropdown menus, scenario analysis, and dynamic charting
  • • Industry Customization: Research industry-specific KPIs and benchmarking data
  • • Teaching Roles: Support struggling classmates with formula construction and troubleshooting
  • • Extension Projects: Create automated reporting features or basic VBA functionality

For English Language Learners

  • • Financial Vocabulary Support: Glossary with visual definitions of key accounting terms
  • • Template Scaffolding: Pre-structured templates with clear headings and organization
  • • Visual Learning Aids: Flowcharts showing statement relationships and data flow
  • • Collaborative Support: Mixed-language team structures for peer translation and explanation