Lesson Plan (Grades 9-12): Financial Modeling & Simulation

Lesson Title: Financial Modeling & Simulation

Grade Levels: 9–12

Subject Area: Mathematics (Finance) & Computer Science

1. Introduction

In Financial Modeling & Simulation, students become quantitative analysts and portfolio managers as they harness spreadsheet software to forecast investment outcomes, evaluate interest schemes, and quantify risk. Across four immersive sessions, teams will:

• Develop simple interest and compound interest calculators, comparing growth under varying rates, compounding frequencies, and time horizons.
• Import real or simulated historical market data (stocks, bonds, or indices), clean and preprocess it, and compute return series.
• Build forecasting models that project future portfolio values under deterministic and stochastic scenarios.
• Implement Monte Carlo simulations, generating thousands of randomized investment paths to analyze the probability distribution of returns and risk metrics like Value at Risk (VaR).
• Synthesize quantitative findings into data-driven recommendations, crafting portfolio allocation proposals that balance expected return and volatility.

By integrating mathematical rigor, programming logic, and financial reasoning, this unit prepares Grades 9–12 students for advanced studies in economics, finance, engineering, and data science, while cultivating real‐world skills in critical analysis and decision-making under uncertainty.

2. Learning Targets

By the end of this lesson, every student will be able to:

• Model Interest Growth
  • Write and apply spreadsheet formulas for simple interest and compound interest .
• Import & Clean Market Data
  • Load CSV files containing historical price data; remove missing entries; calculate daily, weekly, or monthly returns via .
• Build Forecast Models
  • Construct a deterministic projection worksheet using historical average return and volatility inputs, allowing scenario analysis via changeable parameters.
• Run Monte Carlo Simulations
  • Use random‐number generation functions (e.g., RAND(), NORM.INV()) to simulate asset return distributions; generate at least 1,000 simulated portfolio-ending-value scenarios based on Geometric Brownian Motion assumptions or log-normal returns.
• Analyze Risk vs. Return
  • Compute and interpret summary statistics—mean, standard deviation, percentiles, and VaR—for simulation outputs; visualize distributions with histograms and box plots.
• Present Data-Driven Recommendations
  • Prepare a professional report or dashboard summarizing model structure, key metrics, trade-offs between return and risk, and a recommended asset allocation strategy with clear justifications.

Each student will actively engage in at least one of the following roles: formula architect, data engineer, simulation specialist, or presentation designer, ensuring an equitable division of labor and skill development.

3. Standards Alignment

This lesson addresses core mathematics and computational standards:

• CCSS.MATH.CONTENT.HSF‐IF.C.7 Graph functions and interpret features—applied to interest growth curves and probability distribution histograms.
• CCSS.MATH.CONTENT.HSS‐IC.B.5 Use simulation to generate numerical summaries of data, modeling the distribution of portfolio outcomes with Monte Carlo methods.
• CCSS.MATH.PRACTICE.MP4 (Model with Mathematics) Employ spreadsheets to represent real-world financial scenarios, and refine models based on outcome comparisons.
• ISTE Standard 5 (Computational Thinker) Decompose complex simulation problems into algorithmic spreadsheet formulas and iterative calculations.
• MP.6 (Attend to Precision) Ensure formula syntax, cell referencing, and chart labeling are exact to maintain model integrity.

By meeting these standards, students practice rigorous quantitative reasoning and computational fluency essential for STEM careers.