Math for Business Operations

Applied Accounting with Excel

UNIT03 - Lesson 3

Application Practice: Income Statement Independent Build

45 minutes
Lesson Overview

Lesson Focus

Students independently build Income Statement with peer debugging support

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: Independent Construction Challenge
25 minutes

Students build complete Income Statement from TechStart Unit 1 data

Details:

  • Teams use provided trial balance to construct Income Statement independently
  • Apply INDEX/MATCH techniques learned yesterday with proper error handling
  • Focus on professional formatting and clear section organization
  • Include all relevant accounts: Service Revenue, Operating Expenses, Other Income/Expenses
Milestone 1 Assessment Focus

Students must demonstrate technical mastery and professional presentation

  • Formula Accuracy: All INDEX/MATCH formulas pull correct data
  • Complete Coverage: All revenue and expense accounts properly included
  • Professional Format: Clear headers, appropriate alignment, consistent styling
  • Dynamic Function: Formulas update correctly when source data changes
Activity 2: Peer Debugging Session
15 minutes

Structured peer review focusing on formula accuracy and formatting

Details:

  • Teams exchange workbooks with another team for technical review
  • Use checklist to verify: formula syntax, account coverage, formatting standards
  • Test each other's models by making small changes to source data
  • Provide specific, actionable feedback for formula improvements
Activity 3: Milestone 1 Validation
5 minutes

Final check against success criteria before moving to Balance Sheet

Details:

  • Students self-assess their Income Statement against Milestone 1 criteria
  • Quick instructor check: Do formulas work correctly? Is formatting professional?
  • Mark Milestone 1 as achieved for students meeting all criteria
  • Preview Days 4-5: Balance Sheet construction and Retained Earnings reconciliation
Required Materials
  • Complete TechStart Unit 1 trial balance dataset
  • Peer debugging checklist with specific formula requirements
  • Milestone 1 assessment criteria rubric
  • Professional Income Statement examples for reference
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