Math for Business Operations

Applied Accounting with Excel

UNIT03 - Lesson 1

Launch & Explore: Financial Statement Detective Work

45 minutes
Lesson Overview

Lesson Focus

Entry event using real 10-Q filing to understand integrated financial statements

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: Tesla 10-Q Dissection
15 minutes

Teams analyze Tesla's (or local firm's) latest 10-Q filing to identify narrative threads

Details:

  • Each team receives 2-3 pages from Tesla's latest quarterly report
  • Students map specific narrative statements to corresponding line items in financial statements
  • Identify how Income Statement performance connects to Balance Sheet changes
  • Trace cash flow implications from both operational and strategic decisions
Real-World Financial Storytelling

Professional investors read between the lines of financial statements

  • Income Statement: Shows profitability and operational efficiency trends
  • Balance Sheet: Reveals financial strength, liquidity, and capital structure
  • Cash Flow: Demonstrates actual cash generation and usage patterns
  • Integration: How these three statements tell one coherent business story
Activity 2: Unit 1 Data Connection
10 minutes

Connect to familiar TechStart data as foundation for statement construction

Details:

  • Review Unit 1 trial balance and journal entries from TechStart Solutions
  • Teams identify which accounts will appear on each financial statement
  • Preview the challenge: Transform journal entries into investor-ready statements
  • Assign team roles for the three-statement construction project
Activity 3: Statement Relationship Mapping
15 minutes

Visual mapping exercise showing how the three statements interconnect

Details:

  • Teams create visual map showing data flows between statements
  • Identify key connection points: Net Income, Retained Earnings, Cash accounts
  • Discuss why investors need all three statements for complete business picture
  • Establish success criteria: integrated statements that tell coherent story
Activity 4: Challenge Setup & Planning
5 minutes

Introduce essential question and establish project timeline

Details:

  • Present essential question: How do journal entries flow into trustworthy narrative?
  • Overview of 10-day journey from raw data to investor presentation
  • Teams select their industry focus (maintaining TechStart context)
  • Quick planning: What story does Sarah's business data need to tell?
Required Materials
  • Tesla 10-Q excerpt (or local business annual report)
  • Unit 1 TechStart trial balance and journal entries
  • Statement relationship mapping worksheets
  • Project timeline and success criteria overview
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