Math for Business Operations

Applied Accounting with Excel

UNIT03 - Lesson 2

Skill Introduction: Income Statement Construction

45 minutes
Lesson Overview

Lesson Focus

Direct instruction on building Income Statement from trial balance data

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: Income Statement Architecture
10 minutes

Understanding the structure and purpose of the Income Statement

Details:

  • Review Income Statement sections: Revenue, Cost of Goods Sold, Operating Expenses, Other Income/Expenses
  • Connect to TechStart context: How Sarah's service revenue and business expenses are categorized
  • Explain why proper categorization matters for investor analysis
  • Preview Excel techniques for dynamic statement construction
Activity 2: INDEX/MATCH Formula Introduction
20 minutes

Hands-on instruction for dynamic cross-sheet data retrieval

Details:

  • Demonstrate INDEX/MATCH syntax for retrieving trial balance data
  • Show advantages over VLOOKUP for professional financial models
  • Practice with TechStart data: pulling revenue accounts into Income Statement
  • Build error-handling with IFERROR to manage missing data gracefully
INDEX/MATCH for Professional Models

INDEX/MATCH creates flexible, maintainable financial models

  • INDEX/MATCH: More flexible than VLOOKUP, works left or right
  • Named Ranges: Use descriptive names like 'TrialBalance' for clarity
  • Error Handling: IFERROR prevents #N/A errors in presentations
  • Dynamic Updates: Formulas automatically adjust when source data changes
Activity 3: TechStart Income Statement Build
12 minutes

Guided practice constructing Income Statement from Unit 1 data

Details:

  • Students follow along building Revenue section using INDEX/MATCH
  • Add Operating Expenses section with proper account categorization
  • Calculate Gross Profit and Operating Income with clear formulas
  • Verify Net Income calculation and format for professional presentation
Activity 4: Quality Check & Preview
3 minutes

Validate constructed Income Statement and preview next steps

Details:

  • Students verify their Income Statement totals match expected results
  • Quick check: Do formulas update when trial balance data changes?
  • Preview Day 3: Independent construction with peer review process
Required Materials
  • Income Statement template with formula examples
  • INDEX/MATCH tutorial screencast links
  • TechStart trial balance dataset (Excel format)
  • Professional formatting standards guide
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